Building a Sales Dashboard from Scratch

Inorder to build a Sales Dashboard I followed the following steps:

  1. Step 1: Get data. I got the data from the Data. world site.
  2. I loaded the data to excel
  3. Modeled the data
  4. Build the Pivot tables and charts
  5. Assemble the data on a dashboard in excel.

Included below is the image of the dashboard and the file.

Sales Dashboard