Design a KPI Dashboard Layout for Business Performance Tracking
Design a KPI dashboard with metric selection, layout wireframe, data hygiene checklist, and stakeholder adoption plan.
๐ The Prompt
Act as a business intelligence consultant and data visualization expert. Help me design a comprehensive KPI dashboard for my [BUSINESS_TYPE] business.
Business Context:
- Company Stage: [COMPANY_STAGE] (e.g., early-stage startup, growth-stage, enterprise)
- Industry: [INDUSTRY]
- Primary Revenue Model: [REVENUE_MODEL] (e.g., subscription, transactional, advertising)
- Key Departments to Track: [DEPARTMENTS] (e.g., Sales, Marketing, Product, Customer Success)
- Dashboard Audience: [AUDIENCE] (e.g., C-suite, department heads, board of directors)
- Reporting Cadence: [CADENCE] (e.g., real-time, daily, weekly, monthly)
- Preferred BI Tool: [BI_TOOL] (e.g., Tableau, Looker, Power BI, Google Sheets)
Please deliver the following:
**Section 1 โ KPI Selection**
For each department in [DEPARTMENTS], recommend 4-6 KPIs that align with [REVENUE_MODEL]. For each KPI, specify: the metric name, formula/calculation method, data source, benchmark range for [INDUSTRY], and why it matters at the [COMPANY_STAGE] stage.
**Section 2 โ Dashboard Layout**
Design a dashboard wireframe description with:
- Executive summary row (3-4 headline metrics with trend indicators)
- Department-specific sections with chart type recommendations (line, bar, funnel, gauge, etc.)
- A cohort or trend analysis panel for tracking month-over-month changes
- An alert/anomaly section highlighting metrics outside benchmark thresholds
**Section 3 โ Data Hygiene Checklist**
Provide a 10-point checklist for ensuring data accuracy, consistency, and freshness before the dashboard goes live.
**Section 4 โ Stakeholder Adoption**
Suggest a rollout plan including a weekly review ritual format, three questions the [AUDIENCE] should ask when reviewing the dashboard, and common pitfalls that cause dashboard abandonment.
๐ก Tips for Better Results
Limit the executive summary to no more than 4 headline metrics โ cognitive overload causes dashboard abandonment. Always pair each KPI with a benchmark or target so viewers instantly know if performance is good or bad. Schedule a recurring 15-minute dashboard review meeting to build the habit of data-driven decision-making.
๐ฏ Use Cases
Operations leaders, business analysts, and founders setting up performance dashboards to track company health and drive data-informed decisions.