The organisation you choose to work for is entirely up to you, so take your time in selecting one of the following five options: Airbnb, Australia Airlines, Nike, NBA, and FantasticFilms. Enclosed within each data set will be a memo from your chosen organisation, outlining their goals for the project you’re undertaking. You will find your organisation’s data set attached to these Assignment 2 guidelines in myMurdoch Learning via the Unit Overview tab.
Once you have chosen your data set, you will need to complete the following tasks:
Task 1: Duplicate your data set in Microsoft Excel and clean the data in preparation for analysis. The purpose of duplicating the data set is so that when you submit your finished product, you will have two sets sitting side by side: one ‘dirty’ and one ‘clean’.
Task 2: In a Microsoft Word document, provide a dot-point summary of the data-cleaning strategies you employed in Task 1. This summary should be presented in Times New Roman font, size 11. It should be titled ‘Exploratory Analysis’ and contain a header and/or footer with information of your choosing.
Task 3: Once your data set is clean, create one Pivot Table that tells a visually descriptive story for your organisation and provide a 200-word summary of the story this data conveys. You may need to take your time sifting through the data here to ascertain what sort of insights could potentially be uncovered. This 200-word summary should be presented with the same formatting conventions as you employed for Task 2 (above)
Your case study analysis will be evaluated against the following criteria:
1. Shows the capacity to employ data-cleaning strategies using Microsoft Excel, preparing a data set for analysis
2. Shows an understanding of how to ‘read’ data and uncover insights for invested stakeholders
3. Displays a capacity to develop pivot tables using Microsoft Excel
4. Uses appropriate formatting and structure in delivering both visual and written components of data presentation to invested stakeholders
If you need more information please tell me thank you!
