KPI Dashboard Design
Comprehensive patterns for designing effective Key Performance Indicator (KPI) dashboards that drive business decisions.
When to Use This Skill
- Designing executive, tactical, or operational dashboards.
- Selecting meaningful KPIs for Sales, Marketing, Product, or Finance.
- Building real-time monitoring displays.
- Visualizing data patterns (Cohorts, Trends).
Core Concepts
1. KPI Framework
| Level | Focus | Update Frequency | Audience |
|---|---|---|---|
| Strategic | Long-term goals | Monthly/Quarterly | Executives |
| Tactical | Department goals | Weekly/Monthly | Managers |
| Operational | Day-to-day | Real-time/Daily | Teams |
2. SMART KPIs
- Specific: Clear definition.
- Measurable: Quantifiable.
- Achievable: Realistic targets.
- Relevant: Aligned to goals.
- Time-bound: Defined period.
3. Dashboard Hierarchy
- Executive Summary: 4-6 Headline KPIs.
- Department Views: Specific dashboards (Sales, Ops).
- Drilldowns: Individual metrics & Root Cause Analysis.
Best Practices
- Do: Limit to 5-7 KPIs per view. Use consistent status colors (Red/Green).
- Don't: Use vanity metrics. Use 3D charts. Overcrowd the UI.
Resources
- Department KPI Library
- Dashboard Layout Patterns
- SQL Metrics Examples
- Streamlit Dashboard Code