kpi-dashboard-design

Designs effective KPI dashboards with proper metric selection, visual hierarchy, and data visualization best practices. Use when building executive dashboards, creating analytics views, or presenting business metrics.

⭐9stars🔀0forks📁View on GitHub🕐Updated Jan 1, 2026⬇️1downloads

When & Why to Use This Skill

The KPI Dashboard Design skill is a comprehensive framework for creating high-impact business dashboards. It provides expert guidance on metric selection, visual hierarchy, and data visualization best practices, enabling users to transform complex data into actionable insights for executive reporting and performance tracking.

Use Cases

  • Executive Leadership: Designing high-level strategic dashboards to monitor core business health, including MRR, ARR, and long-term growth trends.
  • Marketing & Growth: Creating performance views to track customer acquisition costs (CAC), conversion funnels, and campaign ROI.
  • Product Management: Building engagement and retention dashboards to analyze user behavior through metrics like DAU/MAU and churn rates.
  • Operational Excellence: Developing technical and efficiency reports to monitor system error rates, response times, and team burn rates.
  • Data Visualization Standards: Establishing consistent visual design principles and chart selection criteria for organization-wide reporting.
namekpi-dashboard-design
descriptionDesigns effective KPI dashboards with proper metric selection, visual hierarchy, and data visualization best practices. Use when building executive dashboards, creating analytics views, or presenting business metrics.
licenseMIT

KPI Dashboard Design

Design effective dashboards that communicate key metrics clearly.

KPI Selection Framework

Good KPIs are:

  • Relevant to business goals
  • Measurable and quantifiable
  • Influenced by the team
  • Updated frequently
  • Simple to understand

Common Business KPIs

Goal KPIs
Revenue MRR, ARR, Revenue Growth
Acquisition CAC, New Users, Conversion Rate
Retention Churn Rate, NPS, DAU/MAU
Efficiency LTV:CAC, Burn Rate
Quality Error Rate, Response Time

Dashboard Layout

┌─────────────────────────────────────────────────┐
│              Executive Summary                  │
│  [Revenue ▲12%]  [Users ▲8%]  [Churn ▼2%]      │
├─────────────────────┬───────────────────────────┤
│                     │                           │
│   Revenue Trend     │    User Acquisition      │
│   (Line Chart)      │    (Bar Chart)           │
│                     │                           │
├─────────────────────┼───────────────────────────┤
│                     │                           │
│   Retention Funnel  │    Top Products          │
│   (Funnel Chart)    │    (Table)               │
│                     │                           │
└─────────────────────┴───────────────────────────┘

Visual Design Principles

/* Traffic light colors for status */
.metric-good { color: #22c55e; }    /* Green */
.metric-warning { color: #f59e0b; } /* Amber */
.metric-bad { color: #ef4444; }     /* Red */

/* Visual hierarchy */
.metric-primary {
  font-size: 2.5rem;
  font-weight: 700;
}

.metric-secondary {
  font-size: 1.5rem;
  font-weight: 500;
}

Chart Selection

Data Type Chart
Trend over time Line chart
Comparison Bar chart
Composition Pie/Donut
Distribution Histogram
Correlation Scatter plot
Funnel stages Funnel chart

Interactivity Features

  • Drill-down to detailed views
  • Date range selection
  • Filtering by segment
  • Export to CSV/PDF
  • Scheduled email reports

Best Practices

  • Limit to 5-7 KPIs per dashboard
  • Show trends, not just snapshots
  • Use consistent color coding
  • Include comparison periods (vs last month)
  • Update data in real-time or hourly
  • Review dashboard relevance quarterly

Common Mistakes

  • Too many metrics (information overload)
  • No clear visual hierarchy
  • Missing context (no comparisons)
  • Outdated or stale data
  • Metrics without ownership