KPI Dashboard Builder

What this skill does

# KPI Dashboard Builder

Expert KPI and performance dashboard design system that helps you define meaningful metrics, build actionable dashboards, track progress, and drive data-driven decision-making. This skill provides structured workflows for metric selection, dashboard design, and performance management based on business intelligence and analytics best practices.

What gets measured gets managed. This skill helps you cut through vanity metrics to identify KPIs that truly drive business outcomes, design dashboards that provide actionable insights, and build a culture of data-driven execution. Whether you're tracking company-wide OKRs or department-specific metrics, this provides the framework for performance excellence.

Built on business intelligence principles and dashboard design best practices, this skill combines metric definition, visualization strategy, and performance monitoring to turn data into action.

## Core Workflows

### Workflow 1: KPI Selection & Definition
**Choose the right metrics that drive business outcomes**

1. **KPI Framework**
   - **Strategic KPIs**: Company-level goals (revenue, profit, market share)
   - **Operational KPIs**: Efficiency metrics (cost per unit, cycle time, uptime)
   - **Leading Indicators**: Predict future performance (pipeline, traffic, engagement)
   - **Lagging Indicators**: Measure results (revenue, customer count, profit)

2. **SMART KPI Criteria**
   Every KPI must be:
   - **Specific**: Clearly defined, no ambiguity
   - **Measurable**: Quantifiable with data
   - **Achievable**: Realistic targets based on resources
   - **Relevant**: Directly tied to business objectives
   - **Time-bound**: Defined measurement period

3. **KPI Selection Process**
   - Start with business objectives (what are we trying to achieve?)
   - Identify critical success factors (what must go right?)
   - Map KPIs to each success factor (what measures progress?)
   - Validate data availability (can we measure this?)
   - Prioritize (5-7 KPIs per dashboard max)

4. **KPI Documentation Template**
   For each KPI, document:
   - **Name**: Clear, descriptive title
   - **Definition**: Exact calculation formula
   - **Data Source**: Where the data comes from
   - **Owner**: Person responsible for this metric
   - **Target**: Goal value (with timeframe)
   - **Frequency**: How often measured (daily, weekly, monthly)
   - **Why It Matters**: Connection to business objective

### Workflow 2: KPI Categorization by Function
**Standard KPIs organized by business area**

**Financial KPIs:**
- Revenue (MRR, ARR, total revenue)
- Gross profit margin (%)
- Net profit margin (%)
- Operating cash flow
- Burn rate and runway
- Customer Acquisition Cost (CAC)
- Customer Lifetime Value (LTV)
- LTV:CAC ratio

**Sales KPIs:**
- Pipeline value
- Win rate (%)
- Average deal size
- Sales cycle length
- Quota attainment (%)
- Revenue per rep
- Pipeline coverage ratio

**Marketing KPIs:**
- Marketing Qualified Leads (MQLs)
- Lead-to-customer conversion rate
- Cost per lead (CPL)
- Return on Ad Spend (ROAS)
- Website traffic (sessions, users)
- Email open/click rates
- Brand awareness (surveys, search volume)

**Customer Success KPIs:**
- Net Revenue Retention (NRR)
- Gross Revenue Retention (GRR)
- Churn rate (logo, MRR)
- Net Promoter Score (NPS)
- Customer Health Score
- Time to value
- Support ticket volume/resolution time

**Product KPIs:**
- Daily/Monthly Active Users (DAU/MAU)
- Feature adoption rate
- Activation rate (% of users activated)
- Session duration
- User retention (Day 1, Day 7, Day 30)
- Product-qualified leads (PQLs)
- Bug/incident rate

**Operations KPIs:**
- Inventory turnover
- Order fulfillment time
- On-time delivery rate
- Defect/error rate
- Cycle time
- Capacity utilization (%)
- Operating expense ratio

**HR/People KPIs:**
- Employee headcount
- Turnover rate (voluntary/involuntary)
- Time to hire
- Offer acceptance rate
- Employee Net Promoter Score (eNPS)
- Revenue per employee
- Training completion rate

### Workflow 3: Dashboard Design & Visualization
**Create dashboards that drive action, not just display data**

1. **Dashboard Hierarchy**
   - **Executive Dashboard**: High-level KPIs, trends, alerts (CEO, board)
   - **Departmental Dashboard**: Function-specific metrics (sales, marketing, ops)
   - **Operational Dashboard**: Real-time monitoring, detailed drill-downs (team leads)
   - **Analytical Dashboard**: Deep-dive analysis, exploratory (analysts)

2. **Dashboard Design Principles**
   - **Clarity**: Easy to read at a glance
   - **Relevance**: Only show what matters to audience
   - **Actionability**: Make next steps obvious
   - **Consistency**: Standard layout, colors, formats
   - **Freshness**: Real-time or clearly dated data

3. **Visualization Selection**
   - **Numbers/KPIs**: Big number with trend arrow
     - Use for: Revenue, user count, conversion rate
   - **Line Charts**: Trends over time
     - Use for: Revenue growth, traffic trends, retention curves
   - **Bar Charts**: Comparisons between categories
     - Use for: Sales by region, channel performance
   - **Pie Charts**: Parts of a whole (use sparingly)
     - Use for: Revenue by product (max 5 slices)
   - **Tables**: Detailed data, rankings
     - Use for: Top customers, product leaderboard
   - **Gauges**: Progress to goal
     - Use for: Quota attainment, budget utilization
   - **Heatmaps**: Patterns across two dimensions
     - Use for: Usage by day/hour, cohort retention

4. **Dashboard Layout Best Practices**
   - **Top-left**: Most important metric (eye starts here)
   - **Top-row**: Primary KPIs (the "story")
   - **Middle**: Supporting metrics and trends
   - **Bottom**: Detailed breakdowns and tables
   - **Right sidebar**: Filters, date range, definitions
   - Use white space (don't cram everything)
   - Limit to 7-10 visualizations per dashboard
   - Group related metrics together

5. **Color Strategy**
   - **Green**: Positive, on track, good
   - **Red**: Negative, off track, alert
   - **Yellow/Orange**: Warning, attention needed
   - **Gray**: Neutral, benchmark, comparison
   - Use color consistently across all dashboards
   - Ensure accessibility (color-blind friendly)

### Workflow 4: KPI Tracking & Monitoring
**Establish rhythms for reviewing and acting on metrics**

1. **Data Collection & Automation**
   - Automate data pipelines (minimize manual entry)
   - Integrate source systems (CRM, analytics, finance)
   - Schedule data refreshes (daily, hourly, real-time)
   - Validate data quality (accuracy checks, anomaly detection)
   - Document data lineage (where numbers come from)

2. **Review Cadence**
   - **Daily Standup** (5-10 min):
     - Check operational metrics (sales, traffic, incidents)
     - Flag anomalies or blockers
     - Quick wins and urgent issues

   - **Weekly Business Review** (30-60 min):
     - Review key KPIs vs. targets
     - Analyze trends and drivers
     - Identify actions needed
     - Assign owners and deadlines

   - **Monthly Performance Review** (1-2 hours):
     - Deep-dive on KPI performance
     - Variance analysis (actual vs. plan)
     - Forecast updates
     - Strategic discussions

   - **Quarterly Business Review** (half-day):
     - Review OKR progress
     - Strategic pivots if needed
     - Set next quarter goals
     - Cross-functional alignment

3. **Alert & Notification Strategy**
   - Set thresholds for critical KPIs
   - Automate alerts (email, Slack, SMS)
   - Escalate based on severity
   - Avoid alert fatigue (tune thresholds)

4. **Variance Analysis**
   When a KPI misses target:
   - **Quantify the gap**: How far off are we?
   - **Diagnose root causes**: Why did this happen?
     - Market conditions changed?
     - Execution issues?
     - Bad assumptions in target?
   - **Develop action plan**: What will we do?
   - **Assign ownership**: Who drives the fix?
   - **Set timeline**: When will we see improvement?

### Workflow 5: Performance Management & Optimiza