Reference no: EM133560466
Business Analytics
Project - Business Analytics Environment for Decision Makers
In this project, you will work in a group to conduct analysis for a data set/case study. The groups will need to demonstrate their understanding of the business problem they are trying to solve and perform the necessary analyses using a relevant contemporary business analytics or intelligence tool (Tableau in this case). Each group will be required to create and submit a dashboard, a report and perform a presentation.
Learning Outcome 1: Analyse scenarios and case studies to identify appropriate analytics approaches in business decision making.
Learning Outcome 2: Demonstrate proficiency in the use of a range of relevant analytics tools and techniques.
Learning Outcome 3: Communicate findings of data analysis visually, in writing and orally.
Learning Outcome 4: Work collaboratively to apply analytics approaches to create a business analytics environment that will support decision making.
Learning Outcome 5: Critique business analytics outputs in terms of their relevance and effectiveness.
Background
Your BA consulting company has been approached by the Australian Government who have asked you to conduct an analysis of Covid-19 in Australia.
You have been asked to conduct several specific analyses:
1. Number of people infected in each Australian state or territory since the beginning of the pandemic and how those numbers have changed.
2. Death rates for each Australian state or territory since the beginning of the pandemic and how those numbers have changed.
3. Impacts on 1 & 2 of the imposition of various initiatives by the Western Australian Government.
You have also been asked to provide at least two other insights relevant to Covid-19 that you develop from your analysis.
These analyses should be presented as a Dashboard in Tableau.
If you have questions about the data, please post them to your group's discussion forum where the UC or teaching team will answer them as best as possible.
You will require a range of datasets in order to perform your analyses. You should attempt to procure the data for yourself. There is no limit as to what or how many data sources you use for this project. Whenever you do include a data source, you must ensure that you include the relevant metadata in the Appendix (see Section 1f of the Report Specification). You should also indicate the source of data used in any analyses or visualisations you create.
Please note that real world datasets might be poorly structured or formatted. Unfortunately, this is what working in BA is like!
Tableau Dashboard
The Tableau Dashboard that you submit is worth 20% of the marks for the project. It will be marked as follows:
- The Dashboard will need to address the five analyses presented above. Each visualisation will be allocated 3 marks based on its design and how well it addresses the requirement.
- The remaining 5 marks will be allocated to the overall design of the dashboard and will be awarded based on "best practice" for dashboard design.
Report Specification
The report is worth 60% of the marks for this project and will be allocated as below.
1. The report you create should include the following sections:
a. Executive Summary
b. Introduction
c. Primary Report Findings, including any supporting visualisations, to answer Questions 1-3 above
d. Secondary Report Findings, where you will report on any other insights into the dataset you have developed as a result of your analysis
e. Conclusion
f. Appendices that include design documentation; for example, data and database designs, detailed ETL processes and other metadata (5%)
2. Further details of each of the report sections are provided below.
Presentation Specification
The presentation is worth 20% of the mark for the project.
1. In the final week of the term, each group will make a 15-20-minute presentation to the class.