kpi-dashboard-design

KPI Dashboard Design - Key Performance Indicator Dashboard Design

Skill Overview

Design an efficient KPI dashboard that provides a complete framework from KPI selection to visualization layout. Support multiple dashboard modes such as executive summaries, department views, and real-time monitoring.

Use Cases

1. Design an Executive Summary Dashboard

When you need a one-page business overview for leadership or executives, this skill offers a clear dashboard hierarchy. It includes 4–6 core KPIs, trend indicators, and key alerts to help decision-makers quickly understand the overall health of the business.

2. Build Department-Specific Metric Views

For departments such as Sales, Marketing, Product, and Finance, this skill provides commonly used KPI lists and calculation methods (e.g., MRR, ARR, CAC, LTV, NPS, etc.), helping tailor relevant metric views for different teams.

3. Create Real-Time Monitoring Dashboards

When you need to monitor operational status, system health, or service performance, this skill provides a real-time dashboard layout template. It includes monitoring elements such as request throughput, error rate, and service status, enabling quick detection and response to anomalies.

Core Features

1. KPI Framework and Hierarchical Structure

Provide a three-level KPI framework (strategic, tactical, operational) and a complete dashboard hierarchy—from executive summaries to department views and detailed drill-down analysis—ensuring users at different levels can access the insights they need.

2. Common KPI Library

Includes commonly used metrics for Sales (MRR, ARR, funnel conversion), Marketing (CAC, CPA, MQL), Product (DAU/MAU, NPS, retention rate), and Finance (gross margin, cash flow, operational efficiency), along with SQL calculation examples.

3. Dashboard Layout Templates and Code Implementation

Provide three core visualization layout templates (executive summary, SaaS metrics, real-time operations) and a complete Streamlit-based Python implementation. Support metric cards, trend charts, cohort heatmaps, and alert displays.

FAQ

How to choose the right KPI metrics?

Select KPIs following the SMART principle: specific, measurable, achievable, relevant, and time-bound. It’s recommended to limit each dashboard to 5–7 core metrics, prioritizing indicators that drive action rather than vanity metrics. Different levels focus on different metrics: executives look at strategic indicators (e.g., revenue growth), managers look at tactical indicators (e.g., conversion rate), and teams focus on operational indicators (e.g., daily active users).

What core elements should a KPI dashboard include?

A complete dashboard should include: 1) 4–6 key KPI cards showing current values and trend changes; 2) trend charts displaying historical data and direction; 3) comparative analysis, such as distributions by product or channel; 4) key alerts highlighting anomalies and threshold breaches; 5) support for drill-down analysis with a complete path from summary to details. In layout, leave enough whitespace to avoid information overload.

How should the dashboard update frequency be set?

The update frequency should match the nature of each metric: strategic metrics (e.g., MRR, annual targets) typically update monthly or quarterly; tactical metrics (e.g., conversion rate, customer acquisition cost) are suitable for weekly or monthly updates; operational metrics (e.g., request volume, error rate, system health) require real-time or daily updates. Updating too frequently may create noise, while data that’s too delayed loses decision value.