Metrics Dashboard
by LerianStudio
|
Skill Details
Repository Files
1 file in this skill directory
name: metrics-dashboard description: | KPI and metrics dashboard workflow covering metric definition, data sourcing, visualization design, and anomaly detection. Delivers actionable dashboards.
trigger: |
- Defining KPIs and metrics
- Designing executive dashboards
- Implementing performance tracking
- Setting up anomaly detection
skip_when: |
- Detailed financial analysis → use financial-analysis
- Building models → use financial-modeling
- Preparing reports → use financial-reporting
related: similar: [financial-reporting, financial-analysis] uses: [metrics-analyst]
Metrics Dashboard Workflow
This skill provides a structured workflow for designing KPI dashboards using the metrics-analyst agent.
Workflow Overview
The metrics dashboard workflow follows 5 phases:
| Phase | Name | Description |
|---|---|---|
| 1 | Requirements | Define dashboard objectives and audience |
| 2 | KPI Design | Define metrics and methodology |
| 3 | Data Architecture | Map data sources and calculations |
| 4 | Visualization | Design visual presentation |
| 5 | Implementation | Build and validate |
Phase 1: Requirements
MANDATORY: Define dashboard objectives before building
Questions to Answer
| Question | Purpose |
|---|---|
| What decisions will this support? | Ensures relevance |
| Who is the primary audience? | Tailors complexity |
| What frequency of update? | Sets refresh requirements |
| What level of drill-down? | Scopes depth |
| What benchmark comparisons? | Defines targets |
Dashboard Types
| Type | Audience | Focus |
|---|---|---|
| Executive | C-Suite | High-level, strategic |
| Operational | Managers | Detailed, actionable |
| Departmental | Department heads | Function-specific |
| Board | Directors | Governance, strategic |
Blocker Check
If ANY of these are unclear, STOP and ask:
- Dashboard purpose
- Primary audience
- Key decisions supported
- Update frequency required
Phase 2: KPI Design
MANDATORY: Define all metrics with methodology
KPI Definition Standard
| Element | Requirement |
|---|---|
| Name | Clear, concise name |
| Definition | Precise description |
| Formula | Exact calculation |
| Unit | Measurement unit |
| Target | Performance target |
| Owner | Accountable person |
| Frequency | Update cadence |
KPI Categories
| Category | Example KPIs |
|---|---|
| Financial | Revenue, margin, EBITDA, cash flow |
| Operational | Throughput, cycle time, utilization |
| Customer | Retention, NPS, LTV, CAC |
| Growth | ARR growth, customer growth, expansion |
KPI Selection Principles
| Principle | Description |
|---|---|
| Relevance | Supports specific decisions |
| Measurable | Can be quantified objectively |
| Actionable | Drives specific actions |
| Timely | Available when needed |
| Owned | Clear accountability |
Phase 3: Data Architecture
MANDATORY: Document data lineage completely
Data Source Mapping
| Element | Documentation |
|---|---|
| Source system | Where data originates |
| Extraction method | How data is obtained |
| Transformation | Any calculations or adjustments |
| Refresh frequency | How often updated |
| Data quality | Validation checks |
Data Quality Requirements
| Check | Validation |
|---|---|
| Completeness | All required data present |
| Accuracy | Data matches source |
| Timeliness | Data is current |
| Consistency | Data consistent across sources |
Phase 4: Agent Dispatch
Dispatch to specialist with full context
Agent Dispatch
Task tool:
subagent_type: "ring:metrics-analyst"
model: "opus"
prompt: |
Design metrics dashboard per these specifications:
**Purpose**: [from Phase 1]
**Audience**: [from Phase 1]
**Update Frequency**: [from Phase 1]
**KPIs Required**:
[From Phase 2 - list with definitions]
**Data Sources**:
[From Phase 3 - source mapping]
**Required Output**:
- KPI definitions with formulas
- Data source documentation
- Calculation methodology
- Visualization specifications
- Anomaly thresholds
- Implementation guide
Required Output Elements
| Element | Requirement |
|---|---|
| Metrics Summary | Dashboard overview |
| KPI Definitions | Complete definitions |
| Data Sources | Source documentation |
| Calculation Methodology | Formula details |
| Dashboard Design | Visual specifications |
| Anomaly Analysis | Threshold definitions |
| Recommendations | Enhancement suggestions |
Phase 5: Implementation
MANDATORY: Validate before deployment
Implementation Checklist
| Check | Validation |
|---|---|
| Data feeds working | All sources connected |
| Calculations verified | Outputs match expected |
| Visuals rendering | Display correctly |
| Refresh working | Updates as expected |
| Access controlled | Right users have access |
Validation Tests
| Test | Description |
|---|---|
| Data reconciliation | Dashboard ties to source |
| Historical comparison | Trends make sense |
| Edge cases | Handles nulls, zeros |
| Performance | Loads in acceptable time |
Pressure Resistance
See shared-patterns/pressure-resistance.md for universal pressures.
Dashboard-Specific Pressures
| Pressure Type | Request | Agent Response |
|---|---|---|
| "Just show the numbers" | "Numbers without methodology cannot be trusted. I'll include documentation." | |
| "Pick the most important KPIs" | "KPI selection requires business input. Which decisions should these support?" | |
| "Skip the data quality checks" | "Unreliable data undermines dashboard value. I'll validate all sources." | |
| "Copy the existing dashboard" | "Each dashboard needs fresh design. I'll validate requirements." |
Anti-Rationalization Table
See shared-patterns/anti-rationalization.md for universal anti-rationalizations.
Dashboard-Specific Anti-Rationalizations
| Rationalization | Why It's WRONG | Required Action |
|---|---|---|
| "Everyone knows what revenue means" | Definitions vary | DEFINE specifically |
| "Data source is obvious" | Lineage needs documentation | DOCUMENT source |
| "Calculation is standard" | Standard still needs documentation | SHOW formula |
| "Refresh frequency doesn't matter" | Stale data causes bad decisions | SPECIFY frequency |
Execution Report
Upon completion, report:
| Metric | Value |
|---|---|
| Duration | Xm Ys |
| KPIs Defined | N |
| Data Sources Mapped | N |
| Visualizations Designed | N |
| Anomaly Thresholds | N |
| Result | COMPLETE/PARTIAL |
Quality Indicators
| Indicator | Status |
|---|---|
| All KPIs defined | YES/NO |
| All sources documented | YES/NO |
| All calculations shown | YES/NO |
| Data validated | YES/NO |
| Refresh tested | YES/NO |
Related Skills
Attack Tree Construction
Build comprehensive attack trees to visualize threat paths. Use when mapping attack scenarios, identifying defense gaps, or communicating security risks to stakeholders.
Grafana Dashboards
Create and manage production Grafana dashboards for real-time visualization of system and application metrics. Use when building monitoring dashboards, visualizing metrics, or creating operational observability interfaces.
Matplotlib
Foundational plotting library. Create line plots, scatter, bar, histograms, heatmaps, 3D, subplots, export PNG/PDF/SVG, for scientific visualization and publication figures.
Scientific Visualization
Create publication figures with matplotlib/seaborn/plotly. Multi-panel layouts, error bars, significance markers, colorblind-safe, export PDF/EPS/TIFF, for journal-ready scientific plots.
Seaborn
Statistical visualization. Scatter, box, violin, heatmaps, pair plots, regression, correlation matrices, KDE, faceted plots, for exploratory analysis and publication figures.
Shap
Model interpretability and explainability using SHAP (SHapley Additive exPlanations). Use this skill when explaining machine learning model predictions, computing feature importance, generating SHAP plots (waterfall, beeswarm, bar, scatter, force, heatmap), debugging models, analyzing model bias or fairness, comparing models, or implementing explainable AI. Works with tree-based models (XGBoost, LightGBM, Random Forest), deep learning (TensorFlow, PyTorch), linear models, and any black-box model
Pydeseq2
Differential gene expression analysis (Python DESeq2). Identify DE genes from bulk RNA-seq counts, Wald tests, FDR correction, volcano/MA plots, for RNA-seq analysis.
Query Writing
For writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregations
Pydeseq2
Differential gene expression analysis (Python DESeq2). Identify DE genes from bulk RNA-seq counts, Wald tests, FDR correction, volcano/MA plots, for RNA-seq analysis.
Scientific Visualization
Meta-skill for publication-ready figures. Use when creating journal submission figures requiring multi-panel layouts, significance annotations, error bars, colorblind-safe palettes, and specific journal formatting (Nature, Science, Cell). Orchestrates matplotlib/seaborn/plotly with publication styles. For quick exploration use seaborn or plotly directly.
