Does this skill provide technical implementation code?

Yes, it provides production-ready SQL queries for calculating complex KPIs like cohort retention and MRR, along with Python templates using Streamlit and Plotly.

Can I use this for real-time system monitoring?

Absolutely. It includes specific layout patterns for real-time operations centers, focusing on system health, request throughput, and error rate alerting.

What business departments are covered by the KPI frameworks?

The skill includes specialized KPI sets for Sales, Marketing, Product Management, and Finance departments, covering metrics like MRR, CAC, DAU/MAU, and EBITDA.

How does the skill help with metric selection?

It utilizes the SMART framework and provides a dashboard hierarchy that categorizes metrics into Strategic, Tactical, and Operational levels for different audiences.

KPI Dashboard Design

Name: KPI Dashboard Design
Author: Microck

byMicrock

•

分析と監視

Designs high-impact KPI dashboards with optimized metric selection frameworks, visualization best practices, and real-time monitoring patterns.

This skill provides comprehensive guidance for architecting professional business intelligence dashboards, ranging from high-level executive summaries to granular operational monitors. It equips users with domain-specific KPI frameworks for sales, marketing, product, and finance, paired with technical implementation patterns in SQL and Python. Whether you are building a SaaS metrics suite or a real-time system health display, this skill helps you define SMART metrics, establish clear visual hierarchies, and implement complex calculations like cohort retention and MRR growth with production-ready code.

主な機能

01SMART metric definition and dashboard hierarchy design patterns

02Streamlit and Python code for building interactive data visualizations

032 GitHub stars

04SQL implementation templates for complex metrics like Cohort Retention and MRR

05Department-specific KPI frameworks for Sales, Marketing, Product, and Finance

06Standardized layout patterns for executive summaries and real-time operations

ユースケース

01Designing real-time operational monitors for system health and service status

02Implementing SQL-based cohort analysis and customer acquisition cost (CAC) reporting

03Building executive-level SaaS business dashboards with MRR and Churn tracking

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/opendots-microck kpi-dashboard-design

For use in Claude.ai and ChatGPT

Download Skill