A final assignment and rubric for demonstrating that dashboard data, KPIs, charts and interactions are defensible.
Final project
Use a CSV or Excel file that contains no sensitive data. Build a dashboard that clearly answers one decision question.
Project brief
- State the intended user and the decision they need to make.
- Document data-quality issues and their corrections.
- Define at least three performance indicators.
- Use no more than four visuals, each with a clear purpose.
- Add only filters that genuinely support analysis.
Project evaluation prompt
Evaluate the following dashboard specification and output.
Decision objective: [OBJECTIVE]
Target user: [USER]
Data summary: [SUMMARY]
Cleaning method: [METHOD]
KPIs and visuals: [LIST]
Score from 1–5 for:
- data accuracy,
- KPI suitability,
- chart selection,
- usability,
- decision clarity.
List the three most important improvements. Do not assume data that was not provided.Completion rubric
The project is complete when every transformation can be explained, headline figures can be checked against the source data, charts are not misleading and the user can identify the next action.