skills.rest
SanketAdlak
SanketAdlakCOMMUNITY
Explore all skills by this author →
Website𝕏@devsanket14GitHub

kpi-dashboard-design

Designs KPI dashboards with metric selection, layout patterns, and SQL calculation queries.

Updated Apr 23, 2026
Search Tags:#data visualization#metrics#dashboard#sql#streamlit#kpi#mrr
One-click install
npx skills add https://github.com/SanketAdlak/PDMProjectDesign --skill kpi-dashboard-design-sanketadlak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kpi-dashboard-design
Source: https://github.com/SanketAdlak/PDMProjectDesign/tree/main/.agents/skills/kpi-dashboard-design
Command: npx skills add https://github.com/SanketAdlak/PDMProjectDesign --skill kpi-dashboard-design-sanketadlak

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Teams struggle to build dashboards that drive decisions: they pick vanity metrics, overcrowd layouts, and ship numbers that contradict finance because calculation methodology is inconsistent. This Skill provides a structured framework for selecting KPIs, laying out dashboards, and implementing correct metric calculations. ## Core Features & Use Cases - KPI Frameworks and Catalogs: Strategic/tactical/operational KPI tiers, SMART criteria, and ready-made metric lists for Sales, Marketing, Product, and Finance departments. - Layout Patterns: ASCII blueprints for executive summaries, SaaS metrics dashboards (MRR, LTV/CAC, churn), and real-time operations centers with alerting. - Implementation Code: SQL queries for MRR, cohort retention, and CAC, plus a complete Streamlit dashboard example with Plotly charts and alert sections. - Troubleshooting Guides: Diagnoses common failures like MRR contradicting finance, flat retention cohorts, database load from live dashboards, and alert fatigue. - Use Case: A product team building an executive SaaS dashboard can copy the layout pattern, adapt the MRR and cohort SQL to their schema, and avoid the normalization bugs that cause metric disputes. ## Quick Start Design an executive SaaS dashboard tracking MRR, churn, and LTV/CAC with appropriate layout and calculation queries.

Frequently Asked Questions about kpi-dashboard-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a SaaS metrics dashboard?▼

Start with 4-6 headline KPIs like MRR, ARR, churn, and LTV/CAC ratio, then add trend charts and cohort retention views. Use the SaaS layout pattern with unit economics on one side and cohort retention bars on the other, plus a churn breakdown section.

How to calculate MRR in SQL for a dashboard?▼

Normalize all subscription intervals to monthly amounts: divide yearly plans by 12 and quarterly plans by 3, then sum active subscriptions grouped by month. Use LAG() window functions to compute month-over-month growth percentages.

What KPIs should an executive dashboard show?▼

Limit executive dashboards to 4-6 strategic KPIs updated monthly or quarterly, such as revenue, profit, customer count, and NPS. Include trend indicators and a small alerts section, with drilldowns available for detail.

Why does my dashboard MRR not match finance numbers?▼

The usual cause is inconsistent treatment of annual plans: finance may prorate daily while the dashboard normalizes monthly. Align on one formula, document it on the dashboard card, and apply it consistently in the SQL CASE expression.

How do I stop a real-time dashboard from overloading the database?▼

Separate OLAP reads from OLTP by writing pre-aggregated metrics to a summary table via a scheduled job every few minutes. Point the dashboard at the snapshot table instead of running complex cohort SQL on every refresh.

How do I reduce alert fatigue on monitoring dashboards?▼

Replace static thresholds with dynamic ones based on rolling statistics. Alert only when the current value deviates more than two standard deviations from its 30-day rolling mean, so alerts fire on genuine anomalies rather than noise.

Related Skills

Explore More Data & Analytics Skills→
Hassan-Ali-Mehdi-3024Hassan-Ali-Mehdi-3024

sql-generation

Generate SQL queries for product analytics from event-based schemas.

Community
Intermediate
ISAQQSAIISAQQSAI

data-storytelling

Transform raw analytics into structured narrative insights with actionable recommendations.

Community
Advanced
jose-compujose-compu

self-improving-analytics

Log analytics learnings, data issues, and feature requests to markdown files.

Community
Advanced
JaviMontanoJaviMontano

bi-architecture

Designs BI architectures covering KPI frameworks, semantic layers, dashboard hierarchies, and self-service analytics governance.

Community
Advanced