What needed to be understood.
The dashboard needed to combine several analytical views without overwhelming the user, while still supporting interactive exploration and navigation.
How the analysis was built.
- Created headline KPI views for executive orientation.
- Built a geographic map, time trend, category bar chart, and highlight table.
- Added parameters and interactive controls to change the analysis.
- Used a navigation image/button to improve movement through the workbook.
What the evidence showed.
- The dashboard structure allowed users to begin with summary performance and drill into where and when results differed.
- Combining map, trend, category, and matrix views exposed several dimensions of performance without requiring separate reports.
- Interactive controls improved self-service analysis compared with a static slide.
What should happen next.
- Prioritize a small set of decision-linked KPIs and keep detailed views one interaction away.
- Add profit quality, discount impact, and customer segment comparisons to complement sales.
- Test the dashboard with intended users and measure whether they can answer target questions quickly.
What this project does—and does not—prove.
The project used the standard Superstore demonstration dataset and was not a production deployment.