Excel · Final project
Sales Performance Dashboard
Final project: Sales Performance Dashboard. Using a sales dataset of at least 100 rows, clean the data, add lookup columns, calculate Sales and Profit, and build an interactive dashboard.
| Criterion | Points |
|---|---|
| Data is clean and documented in a cleaning log | 20 |
| Formulas and lookups are correct | 20 |
| PivotTables answer clear business questions | 20 |
| Dashboard is readable, interactive and well laid out | 25 |
| Three written insights supported by the data | 15 |