metrics-dashboard-designer

Metrics Dashboard Designer

Overview

The Metrics Dashboard Designer skill provides specialized capabilities for designing comprehensive KPI dashboards and tracking mechanisms. This skill enables definition of meaningful metrics, creation of effective visualizations, and establishment of data collection and reporting processes for performance management.

Capabilities

KPI Definition with Specifications

• Define KPIs with complete measurement specifications
• Create metric definitions with formulas
• Establish data sources and owners
• Set baseline and target values

Dashboard Layout Design

• Create dashboard layouts and visualizations
• Apply dashboard design best practices
• Balance information density and clarity
• Design executive and operational views

Metric Calculation Formulas

• Generate metric calculation formulas
• Define aggregation methods
• Handle data quality issues
• Create derived metrics

Data Collection Mechanisms

• Design data collection mechanisms
• Specify collection frequency
• Define data validation rules
• Establish data flow processes

Reporting Templates

• Create reporting templates
• Design periodic report formats
• Build exception reports
• Generate management summaries

Targets and Thresholds

• Define targets and thresholds
• Set RAG (Red/Amber/Green) status rules
• Create escalation triggers
• Establish performance bands

Metric Trend Analysis

• Generate metric trend analysis
• Calculate period-over-period changes
• Identify patterns and anomalies
• Forecast future performance

Usage

Define KPIs

Define KPIs for measuring:
[Business objective or initiative]

Include specifications, formulas, targets, and data sources.

Design Dashboard

Design a dashboard for:
Audience: [Who will use it]
Purpose: [What decisions it supports]
KPIs: [List of metrics to display]

Create layout with visualization recommendations.

Create Reporting Process

Create a reporting process for these metrics:
[Metric list]

Define collection, calculation, and distribution.

Set Targets and Thresholds

Establish targets and thresholds for:
[KPI list]

Include RAG status rules and escalation triggers.

Process Integration

This skill integrates with the following business analysis processes:

• solution-performance-assessment.js - Solution metrics tracking
• change-adoption-tracking.js - Change metrics monitoring
• business-case-development.js - Success metrics definition
• consulting-engagement-planning.js - Engagement metrics

Dependencies

• Dashboard templates
• Visualization best practices
• KPI definition frameworks
• Reporting tools knowledge

Metrics Dashboard Reference

KPI Specification Template

KPI Name: [Metric name]
ID: KPI-XXX
Owner: [Accountable person]

DEFINITION:
Description: [What this metric measures]
Formula: [Calculation method]
Unit: [Unit of measure]

DATA SOURCE:
Source system: [Where data comes from]
Collection frequency: [How often]
Data owner: [Who provides data]

PERFORMANCE:
Baseline: [Starting value]
Target: [Goal value]
Threshold - Red: [Below X]
Threshold - Amber: [Between X and Y]
Threshold - Green: [Above Y]

REPORTING:
Report frequency: [How often reported]
Report audience: [Who receives]
Visualization: [Chart type]

Dashboard Design Principles

| Principle | Description |

|-----------|-------------|

| Focus | One dashboard, one purpose |

| Hierarchy | Most important metrics prominent |

| Context | Include comparisons and targets |

| Actionable | Enable decision-making |

| Real-time | Refresh frequency matches need |

| Clean | Minimize clutter and decoration |

Visualization Selection Guide

| Data Type | Best Visualizations |

|-----------|---------------------|

| Single value | Big number, gauge |

| Comparison | Bar chart, bullet chart |

| Trend over time | Line chart, sparkline |

| Part of whole | Pie chart, stacked bar |

| Distribution | Histogram, box plot |

| Relationship | Scatter plot |

| Geographic | Map |

RAG Status Framework

| Status | Color | Meaning | Action |

|--------|-------|---------|--------|

| On Track | Green | Meeting/exceeding target | Continue current approach |

| At Risk | Amber | Below target but recoverable | Investigate and adjust |

| Off Track | Red | Significantly below target | Escalate and intervene |

Common KPI Categories

| Category | Example KPIs |

|----------|-------------|

| Financial | Revenue, Cost, Margin, ROI |

| Customer | Satisfaction, NPS, Retention |

| Process | Cycle time, Error rate, Throughput |

| Quality | Defect rate, First-pass yield |

| Employee | Engagement, Turnover, Training |

| Project | On-time, On-budget, Scope changes |

Data Collection Checklist

• [ ] Data source identified
• [ ] Collection frequency defined
• [ ] Data owner assigned
• [ ] Validation rules specified
• [ ] Historical data available
• [ ] Refresh process documented
• [ ] Data quality acceptable

Reporting Frequency Guidelines

| Metric Type | Typical Frequency |

|-------------|-------------------|

| Operational | Daily/Real-time |

| Tactical | Weekly/Bi-weekly |

| Strategic | Monthly/Quarterly |

| Program/Project | As per milestones |

Dashboard Layout Template

┌─────────────────────────────────────────────┐
│              DASHBOARD TITLE                │
│         [Filters] [Date Range]              │
├──────────────┬──────────────┬──────────────┤
│   KPI 1      │   KPI 2      │   KPI 3      │
│   (Big #)    │   (Big #)    │   (Big #)    │
├──────────────┴──────────────┴──────────────┤
│            Trend Chart                      │
│        (Line/Area Chart)                    │
├─────────────────────┬──────────────────────┤
│   Comparison Chart  │  Status Table        │
│   (Bar Chart)       │  (Table with RAG)    │
├─────────────────────┴──────────────────────┤
│           Detail Table / List               │
└─────────────────────────────────────────────┘