Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Build a Dashboard Simpson's and Sons is a nationwide brick - and - mortar company selling technology, office supplies and furniture products in 5 0
Build a Dashboard
Simpson's and Sons is a nationwide brickandmortar company selling technology, office supplies and furniture products in states all over the US You are the assistant to the COO Chief Operations Officer of the company. The would like you to present a dashboard demonstrating the company's online sales performance from to using the attached Sales dataset darr.
In the dashboard, the wants you to demonstrate six figures for the following information:
The quarterly sales trend for each subcategory from to
Total sales vs profit for each subcategory,
Total profit in all states,
The percentage of profit by subcategory.
Add two additional figurestables showing the critical information from the dataset Use your imagination
Note that the did not give you direct information about the type of figure you need to demonstrate. You can use a map, bar chart, line chart, sparklines, tables, etc., as long as you create an appropriate figure or table for the requested information.
PS: The dataset includes sales information for different orders. The columns are selfexplanatory.
Guidelines:
There will be in total six figurestables on the dashboard
Create a new pivot table for each figure. Each pivot table should be in a separate spreadsheet.
There should be three slicers for Order Date yearly SubCategory, and State.
All the figures and tables should dynamically respond to the filterings in the slicers.
The dashboard should look professional with all the requested information. You should pay attention to:
Size of the figures,
Alignment of the figures.
Figure titles,
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