A monthly sales dashboard
The problem
Turn a raw sales export into a one-page dashboard that refreshes each month: totals by region and product, the trend, the top sellers and targets.
Requirements
- Power Query that cleans the export and loads a Table
- PivotTables with slicers for region and month
- Charts for the monthly trend and sales against target
- A top 5 list with SORT and FILTER or TAKE
Technologies
- Power Query
- PivotTables
- Slicers
- Charts
- Dynamic arrays
Step by step
- Import and clean the export with Power Query and load it as a Table.
- Build PivotTables and connect them to shared slicers.
- Add charts and a dynamic top 5 list.
- Lay out the dashboard sheet, print-ready on one page, and test a refresh with new data.
Expected result
A dashboard that updates from next month's export with one Refresh All.
How it is evaluated
- Refreshing with a new export needs no manual edits
- Numbers match the source totals
- Charts are clear and honestly scaled
- The dashboard prints on one page
Ways to improve it
- Add a what-if section for next month's target
- Share it through OneDrive with co-authoring
- Add LAMBDA functions for repeated calculations