Answered step by step
Verified Expert Solution
Link Copied!

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 brick-and-mortar company selling technology, office supplies and furniture products in 50 states all over the U.S. You are the assistant to the COO (Chief Operations Officer) of the company. The COO would like you to present a dashboard demonstrating the company's online sales performance from 2011 to 2014 using the attached Sales dataset darr.
In the dashboard, the COO wants you to demonstrate six figures for the following information:
The quarterly sales trend for each sub-category from 2011 to 2014,
Total sales vs. profit for each sub-category,
Total profit in all states,
The percentage of profit by sub-category.
Add two additional figures/tables showing the critical information from the dataset (Use your imagination)
Note that the COO 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 9994 different orders. The columns are self-explanatory.
Guidelines:
There will be in total six figures/tables 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), Sub-Category, 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,
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

More Books

Students also viewed these Databases questions