# Kpi Dashboard Design

> Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

- Skill: `mileycy516-stack/kpi-dashboard-design` (Agent Skill, multi-file: 5 files)
- Install (CLI): `npx skillmds@latest add mileycy516-stack/kpi-dashboard-design`
- Raw SKILL.md: https://api.skillmd.com/api/skills/mileycy516-stack/kpi-dashboard-design/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: mileycy516-stack (https://skillmd.com/u/mileycy516-stack)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/mileycy516-stack/kpi-dashboard-design

---


# KPI Dashboard Design

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

## When to Use This Skill
- Designing executive, tactical, or operational dashboards.
- Selecting meaningful KPIs for Sales, Marketing, Product, or Finance.
- Building real-time monitoring displays.
- Visualizing data patterns (Cohorts, Trends).

## Core Concepts

### 1. KPI Framework
| Level | Focus | Update Frequency | Audience |
| :--- | :--- | :--- | :--- |
| **Strategic** | Long-term goals | Monthly/Quarterly | Executives |
| **Tactical** | Department goals | Weekly/Monthly | Managers |
| **Operational** | Day-to-day | Real-time/Daily | Teams |

### 2. SMART KPIs
*   **Specific**: Clear definition.
*   **Measurable**: Quantifiable.
*   **Achievable**: Realistic targets.
*   **Relevant**: Aligned to goals.
*   **Time-bound**: Defined period.

### 3. Dashboard Hierarchy
1.  **Executive Summary**: 4-6 Headline KPIs.
2.  **Department Views**: Specific dashboards (Sales, Ops).
3.  **Drilldowns**: Individual metrics & Root Cause Analysis.

## Best Practices
*   **Do**: Limit to 5-7 KPIs per view. Use consistent status colors (Red/Green).
*   **Don't**: Use vanity metrics. Use 3D charts. Overcrowd the UI.

## Resources
- [Department KPI Library](references/department-kpis.md)
- [Dashboard Layout Patterns](references/layout-patterns.md)
- [SQL Metrics Examples](examples/kpi-queries.sql)
- [Streamlit Dashboard Code](examples/dashboard_app.py)