Проектирование KPI-дашбордов для SaaS

★ 8.5 · design

kpi-dashboard-design is a Claude Code skill that guides the design of effective KPI dashboards, covering metric selection, visualization best practices, and real-time monitoring patterns. It structures dashboards across three levels — strategic, tactical, and operational — and provides concrete SQL examples for normalizing MRR across subscription intervals, building monthly retention cohorts with DATE_TRUNC, and writing pre-aggregated summary tables to prevent live dashboards from overloading production databases. Troubleshooting sections address common failures: MRR figures that contradict finance reports due to inconsistent proration, alert fatigue from static thresholds, and cohort queries that accidentally partition by day instead of month. The skill is built for product and engineering teams creating SaaS executive dashboards, operations monitoring centers, or user retention analysis views who need a consistent calculation methodology and clear anti-patterns to avoid.