kpi-dashboard-design

Comprehensive patterns for designing effective KPI dashboards that drive business decisions.

- Covers three dashboard hierarchy levels (strategic, tactical, operational) with department-specific KPI templates for sales, marketing, product, and finance

- Includes three layout patterns: executive summary, SaaS metrics, and real-time operations dashboards with visual examples

- Provides SQL queries for common calculations (MRR, cohort retention, CAC) and Python/Streamlit implementation code for building dashboards

- Emphasizes best practices including limiting to 5-7 KPIs, showing context with trends and targets, and enabling drilldown from summary to detail views

KPI Dashboard Design

Comprehensive patterns for designing effective Key Performance Indicator (KPI) dashboards that drive business decisions.

When to Use This Skill

- Designing executive dashboards

- Selecting meaningful KPIs

- Building real-time monitoring displays

- Creating department-specific metrics views

- Improving existing dashboard layouts

- Establishing metric governance

Core Concepts

1. KPI Framework