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

Technologies

Step by step

  1. Import and clean the export with Power Query and load it as a Table.
  2. Build PivotTables and connect them to shared slicers.
  3. Add charts and a dynamic top 5 list.
  4. 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

Ways to improve it