Inorder to build a Sales Dashboard I followed the following steps:
- Step 1: Get data. I got the data from the Data. world site.
- I loaded the data to excel
- Modeled the data
- Build the Pivot tables and charts
- Assemble the data on a dashboard in excel.
Included below is the image of the dashboard and the file.