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 $\frac{C}{O}O$ 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 $\frac{C}{O}O$ 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 $\frac{C}{O}O$ 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,