Assignment Task
The students will be introduced to a fictional company that wants to analyse a management problem using data analytics. Students will analyse a dataset and visualise the current performance of the company. Each student will be issued with a unique variation of a simulated dataset.
Students are required to write a report to the Board of Directors demonstrating their ability to analyse, visualise, and evaluate a performance management problem. The report should propose a performance dashboard and include visualisations that lead to recommendations.
The report should be structured as follows:
- An executive summary- please review the structure of the executive summary on the unit’s Brightspace pages.
- An introduction of the background of the business question – you can use references here, but references are not required.
- A description of the data preparation, including:
- data restrictions – the rows you deleted,
- variable definition – adjustments to the columns or data transformations,
- a table with the variable definition of all variables used in the visualisations.
- Data visualisation and descriptive statistics: use figures and descriptive statistics tables to develop a data story.
- Recommendations for actions based on the analysis including:
- managerial consequences for customer dissatisfaction
- quality of the analysis
- An appendix with the performance dashboard including key descriptive numbers and key figures
Description of the data
You are commissioned to analyse the parcel orders of a prominent online retailer and derive recommendations for actions to improve a key performance target for the organisation. In addition, you should provide a dashboard based on your analysis. The dashboard should be calibrated on the provided historical data.