Metrics Dashboard

by LerianStudio

skill

|

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.

skill

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.

skill

Matplotlib

Foundational plotting library. Create line plots, scatter, bar, histograms, heatmaps, 3D, subplots, export PNG/PDF/SVG, for scientific visualization and publication figures.

skill

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.

skill

Seaborn

Statistical visualization. Scatter, box, violin, heatmaps, pair plots, regression, correlation matrices, KDE, faceted plots, for exploratory analysis and publication figures.

skill

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

skill

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.

skill

Query Writing

For writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregations

skill

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.

skill

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.

skill

Skill Information

Category:Skill
Last Updated:1/12/2026