MIS171-Analyse of Business Analytics - Business Assignment Help

Assignment Task

Task 

Description:
This is an individual assignment. It focuses on materials presented up to and including Week 4. To complete the assignment, you need to:
a) visualise the data set, and
b) create an interactive dashboard.

All your responses are to be presented in the Excel file which you are asked to submit. The data set is based on actual data provided by RACV Solar. For confidentiality and anonymity reasons actual data has been manipulated in the assessment task. Following is an introduction to this scenario and detailed guidelines. 

RACV Solar

RACV Solar is a wholly-owned subsidiary of the RACV (Royal Automobile Club of Victoria). While the RACV is best known as a provider of car and road-user services, the organisation has been active in expanding the range of services it offers to its members, including insurance and travel services.

RACV Solar is one of the biggest solar companies in Victoria. RACV Solar has designed and installed more than 10,000 solar installations, with over 50 MW (megawatts) of solar power across multiple sectors, including residential homes, businesses, and community projects. RACV Solar holds the record for the largest installations on a school and a hospital in Australia.

Stage 1: Data Analysis
You must analyse the data on the Assignment 1 Excel file. The file includes tabs for:

•  Data Description
•  RACV Solar Data Set
•  Interactive dashboard (see below)

The objective of your analysis is to identify key data and relationships which you can then include in your dashboard. For example, you have been advised that Conversion Period is key data for RACV Solar. Your analysis needs to identify how this is best displayed on your dashboard. Is the appropriate measure mean (average) Conversion Period, or median? Alternatively, will a quartile-based approach have greater information value? This analysis can then point you toward the most meaningful (and interactive) way to display the data. A graph or a table? Which type of graph? What data will be on the horizontal axis? Note, usually the key data measure (e.g., Conversion Period in the example above) is displayed on the vertical axis. Typically, a line graph is used to display trends over time, with bar graphs used for comparison. Pie graphs are good for displaying proportions. Box & Whiskers graphs are good for the spread of data.

You will not be marked on Stage 1. You will be marked for your work on Stage 2. However, we expect that your work on Stage 1 will be key to maximising the information value and interactivity for Stage 2 (your dashboard).

Stage 2: Interactive Dashboard

Include an interactive “dashboard” for James which will help him understand and visualise key data and allow him to drill down into the data.
Your interactive dashboard must be completed on the “Dashboard” sheet of the Excel file. You can add extra sheets for other purposes, such as pivot tables or extra analysis. However, these extra sheets will not be marked. YOUR DASHBOARD IS THE ONLY SHEET THAT WILL BE MARKED. The minimum requirement is a neat, functional, interactive dashboard. It is expected that the dashboard includes at least four (4) and up to six (6) interactive components.

The following questions will help guide you in designing an interactive dashboard.
1. What are the highest priority areas that should be included in the Dashboard?
2. What are the most appropriate visualisations for the dashboard?
3. What about colour choices?
4. How can I make the dashboard interactive?

Learning Outcomes
This task allows you to demonstrate achievement towards the unit learning outcomes (ULOs). The ULOs are aligned with specific graduate learning outcomes – that is, the skills and knowledge graduates are expected to have upon completion of their studies – and this assessment task is an important tool in determining achievement of those outcomes. If you do not demonstrate achievement of the unit learning outcomes, you will not be successful in this unit.
It is good practice to familiarise yourself with the ULOs and GLOs as they provide guidance on the knowledge, understanding and skills you are expected to demonstrate upon completion of the unit. In this way they can be used to guide your study.

Unit Learning Outcomes

ULO2: Create data-driven/fact-based solutions to complex business scenarios.

ULO3: Analyse business performance by implementing contemporary data analysis tools.

ULO4: Interpret findings and effectively communicate solutions to business problems

This MIS171-Business Assignment has been solved by our Business Expert at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.