Does this skill provide actual code for dashboards?

Yes, it includes both SQL scripts for complex metric calculations and Python code using Streamlit for frontend visualization.

Can I use this for SaaS business metrics?

Absolutely. It features specific patterns for SaaS-specific metrics like MRR, ARR, LTV/CAC ratios, and cohort retention analysis.

What departments does this KPI skill cover?

It includes specialized KPI frameworks and metrics for Sales, Marketing, Product, and Finance departments.

How does it help with dashboard hierarchy?

It provides structural patterns for organizing data into Executive Summaries, Department Views, and Detailed Drilldowns to ensure information is relevant to the audience.

KPI Dashboard Design

Name: KPI Dashboard Design
Author: drgaciw

bydrgaciw

Analytics & Monitoring

Design professional KPI dashboards with optimized metrics selection, data visualization patterns, and real-time monitoring structures.

About

This skill provides a comprehensive framework for architecting business-critical dashboards, bridging the gap between raw data and actionable insights. It offers predefined patterns for Sales, Marketing, Product, and Finance metrics, alongside ready-to-use SQL snippets for complex calculations like MRR and cohort retention. Whether you are building executive-level summaries or real-time operational displays, this skill ensures your visualizations follow best practices for clarity, hierarchy, and decision-driven design.

Key Features

Optimized SQL snippets for calculating MRR, CAC, and Cohort Retention
0 GitHub stars
Standardized dashboard layout patterns for Executive and SaaS views
Metric governance guidance using the SMART KPI framework
Department-specific KPI frameworks for Sales, Marketing, Finance, and Product
Streamlit and Plotly implementation patterns for rapid dashboard prototyping

Use Cases

Building executive-level performance reporting tools for business stakeholders
Improving data visualization for department-specific monitoring such as SaaS health
Designing real-time operational status boards for system health and error tracking

About

Key Features

Optimized SQL snippets for calculating MRR, CAC, and Cohort Retention
0 GitHub stars
Standardized dashboard layout patterns for Executive and SaaS views
Metric governance guidance using the SMART KPI framework
Department-specific KPI frameworks for Sales, Marketing, Finance, and Product
Streamlit and Plotly implementation patterns for rapid dashboard prototyping

Use Cases

Building executive-level performance reporting tools for business stakeholders
Improving data visualization for department-specific monitoring such as SaaS health
Designing real-time operational status boards for system health and error tracking