Design a KPI Dashboard Layout with Metrics and Data Visualization Strategy
Design a KPI dashboard with metric selection, layout structure, visualization best practices, and alert thresholds.
📝 The Prompt
Act as a business intelligence analyst and dashboard design expert. Help me design a comprehensive KPI dashboard for my organization.
Business Context:
- Company/Department: [COMPANY_OR_DEPARTMENT_NAME]
- Industry: [INDUSTRY]
- Dashboard Audience: [PRIMARY_VIEWERS_e.g._C-Suite_Department_Heads_Team_Leads]
- Business Model: [BUSINESS_MODEL_e.g._SaaS_E-commerce_Services_Marketplace]
- Reporting Cadence: [DAILY_WEEKLY_MONTHLY]
- Current Data Sources: [DATA_SOURCES_e.g._CRM_Google_Analytics_ERP_Stripe]
- Key Business Objectives: [TOP_3_BUSINESS_OBJECTIVES]
Please design the dashboard with the following structure:
1. **KPI Selection** — Recommend 8-12 KPIs organized by category (Revenue, Growth, Efficiency, Customer, Operations). For each KPI provide:
- Metric name and definition
- Formula/calculation method
- Recommended target or benchmark
- Data source
- Update frequency
2. **Dashboard Layout** — Describe a visual layout with:
- Top-level summary row (3-4 headline metrics with trend indicators)
- Primary section (2-3 charts showing the most critical trends)
- Secondary section (supporting metrics and breakdowns)
- Detail section (tables or drill-down views)
3. **Visualization Recommendations** — For each KPI, recommend the best chart type (line, bar, gauge, heatmap, scorecard, funnel, etc.) and explain why that visualization is optimal.
4. **Alert & Threshold Rules** — Define red/yellow/green thresholds for the top 5 KPIs with suggested automated alert triggers.
5. **Filtering & Interactivity** — Recommend filters (date range, segment, region, product) and drill-down paths that the audience would need.
6. **Tool Recommendation** — Suggest the best dashboard tool based on the data sources and audience (e.g., Looker, Tableau, Power BI, Metabase, Google Sheets).
💡 Tips for Better Results
Limit the top-level view to no more than 5 headline metrics — dashboard overload kills adoption. Always include trend comparisons (week-over-week or month-over-month) rather than showing standalone numbers. Test the dashboard with its intended audience before finalizing to ensure it answers their actual questions.
🎯 Use Cases
Business analysts, data teams, and department leaders use this when building or redesigning performance dashboards to track progress against strategic objectives.