Task: Utilizing the assigned Sales Data file, perform a descriptive analysis over the data that provides a comprehensive overview of "what happened" / "What is happening". Utilize the extra information provided to provide management with solutions or additional insights based on the guidance received below Each dataset has its own specific information (see below). Tools: Students are expected to utilize Excel or Tableau or both in all cases, the data can be explored in multiple different ways. Your task is to be creative yet thorough. The tool you choose is entirely up to you... however you MUST include AT LEAST 3 visualizations (bar charts, pie charts, histograms, bubble charts, etc.) Deliverable: A PowerPoint file that highlights your findings and includes commentary as if you were presenting the PowerPoint in front of the class. Under each slide, insert comments as if you were presenting live to the class. Your PowerPoint should be roughly 8-9 slides with a max of 10 slides. It is recommended to stick close to the following this is only a suggestion. 1. Title Slide 2. Intro Slide 3. 2-3 Slides of descriptive analytics, breaking down the data by the information provided 4. 2-3 Slides devoted to specifically addressing Management's question 5. Conclusion slide A Grading: Please see the detailed rubric in the zip folder for more information about grading, Please read this document carefully so you know what is expected. Guidance: I created a video to provide you some guidance on how to work with datasets. It maps out a great strategy for working with any dataset. Sales Data Analyst File: Further Guidance You are the chief analyst that is responsible for monitoring sales at your company. The CEO has tasked you with providing the board of directors with some high-level insights regarding the sales trends of the company and its various locations. He has provided you with customer orders from various sales centers and other data that might be helpful in your analysis. He noted the following: Customer loyalty is important. Customers with a code of 2 receive a 5% discount code 3 customers receive a 15% discount, and code 4 customers receive a 20% discount. However, discounts are only received if the total purchase is greater than or equal to $2,000. If the total sale is less than $2,000 no discount is given. Order and processing dates are available to indicate speed of processing orders for customers. . Focus Task: Utilizing the assigned Sales Data file, perform a descriptive analysis over the data that provides a comprehensive overview of "what happened" / "What is happening". Utilize the extra information provided to provide management with solutions or additional insights based on the guidance received below Each dataset has its own specific information (see below). Tools: Students are expected to utilize Excel or Tableau or both in all cases, the data can be explored in multiple different ways. Your task is to be creative yet thorough. The tool you choose is entirely up to you... however you MUST include AT LEAST 3 visualizations (bar charts, pie charts, histograms, bubble charts, etc.) Deliverable: A PowerPoint file that highlights your findings and includes commentary as if you were presenting the PowerPoint in front of the class. Under each slide, insert comments as if you were presenting live to the class. Your PowerPoint should be roughly 8-9 slides with a max of 10 slides. It is recommended to stick close to the following this is only a suggestion. 1. Title Slide 2. Intro Slide 3. 2-3 Slides of descriptive analytics, breaking down the data by the information provided 4. 2-3 Slides devoted to specifically addressing Management's question 5. Conclusion slide A Grading: Please see the detailed rubric in the zip folder for more information about grading, Please read this document carefully so you know what is expected. Guidance: I created a video to provide you some guidance on how to work with datasets. It maps out a great strategy for working with any dataset. Sales Data Analyst File: Further Guidance You are the chief analyst that is responsible for monitoring sales at your company. The CEO has tasked you with providing the board of directors with some high-level insights regarding the sales trends of the company and its various locations. He has provided you with customer orders from various sales centers and other data that might be helpful in your analysis. He noted the following: Customer loyalty is important. Customers with a code of 2 receive a 5% discount code 3 customers receive a 15% discount, and code 4 customers receive a 20% discount. However, discounts are only received if the total purchase is greater than or equal to $2,000. If the total sale is less than $2,000 no discount is given. Order and processing dates are available to indicate speed of processing orders for customers. . Focus
