Question
You are the Lead Data Analyst in the eCommerce division of GhostCo Wholesale. A new Chief Operating Officer, Mr. Scare has joined the company a
You are the Lead Data Analyst in the eCommerce division of GhostCo Wholesale. A new Chief Operating Officer, Mr. Scare has joined the company a few weeks back. He has asked you to analyze the latest sales data and provide a report on the top items he needs to know and act on.
Also, Mr. Scare wants to divide the entire operations into two new divisions Small Order and Big Order. He proposes to define an order as small if the number of units sold is less than 5000. He wants the analysis to be performed for the two proposed divisions independently.
Create visualizations in Tableau or Excel to tell the stories better. There can be more than one visualization per story, if needed. You might consider dividing the entire presentation(or report) into two sections, for the two divisions.
Remember, Mr. Scare should have 5*2=10different take-aways (i.e., action items) from your report. There should be at least one pivot table and at least one visualization created in each of Excel and Tableau.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started