Mini Data Analysis Project – Dashboard Debugging Task

Task Description:

In this project, the goal is to identify and fix nine specific issues in a sales dashboard built from a dataset (available in Excel/CSV format). The following problems must be addressed:

Filter Limitations (3 issues)
The dashboard filters do not allow selection of:

All 13 salesperson IDs

All 4 quarters

All 6 countries

Incorrect Online Sales Growth Calculation (1 issue)
Growth is not calculated accurately when the previous quarter's data is missing.
(1 error affecting 2 cells)

Inaccurate Total Sales Values (3 issues)
Total sales are incorrectly reported for salespeople with IDs: 276, 275, and 268.



KPI Error (1 issue)
The KPI for Total Sales during the selected period shows an error and must be corrected.

Evaluation Criteria:

All nine dashboard issues have been identified and corrected

Link: https://docs.google.com/spreadsheets/d/1qqw6JLQaN5Q7VSmYggTEPUkFogOGQkZlzWPafgmAh7k/copy?usp=drive_link
At least three insights were drawn from the cleaned and updated dashboard
The learner demonstrated independent thinking and didn’t rely too heavily on AI assistance
Specific examples were provided showing how AI tools contributed to the task