Sales Data Excel Dashboard

Description
Follow the instructions tab to understand how the dashboard works. The raw data and pivot table tabs have been hidden to show that the end user of a Dashboard can just see one tab with the final output.

The dashboard has been prepared in the following steps:
- raw data must be cleansed and dates or blank fields reformatted or replaced with new values
- raw data should be converted to a tabular form
- each chart in the dashboard is based on a pivot table which has been added from the raw data
- slicers can be added by clicking on any chart and going to 'insert'->'slicer'
When the dashboard is prepared and ready to use, the user can hide unnecessary tabs (i.e. tabs with pivot tables and workings) leaving just the final output to end users.

This dashboard can be applied to any dataset which is manageable in MS Excel (i.e. not larger than 100K rows).
New data can be added either by pasting data (corresponding to new month of sales or a new store opened in the region, etc.).
To fully automate new data input, Power Query can be used. This will allow data ingestion directly from the database.
The dataset has been downloaded from Kaggle.com (see references within the file).