What business departments are covered by this skill?

The skill includes specific KPI frameworks and metrics for Sales, Marketing, Product, Finance, and DevOps/Operations.

Can this help with writing SQL queries for data analysis?

Yes, it provides pre-built SQL patterns for calculating complex metrics like Monthly Recurring Revenue (MRR), Cohort Retention, and Customer Acquisition Cost (CAC).

Is this skill compatible with Python for data science?

Yes, it includes specific implementation patterns for Python-based visualization tools like Streamlit, Plotly, and Pandas.

Does it include UI/UX advice for data visualization?

It provides structural layout patterns tailored for different audiences, ranging from high-level executive summaries to granular real-time operation centers.

KPI Dashboard Design

Name: KPI Dashboard Design
Author: Tahir-yamin

byTahir-yamin

•

Analytics & Monitoring

Design and implement effective business intelligence dashboards with optimized metric selection, visualization layouts, and real-time monitoring patterns.

This skill provides a comprehensive framework for building data-driven dashboards across various business functions, including Sales, Marketing, Product, and Finance. It offers standardized KPI definitions using the SMART framework, architectural layouts for executive and operational views, and practical implementation code in SQL and Python. Whether you are establishing metric governance or building real-time system monitoring displays, this skill guides you through selecting the right indicators and presenting them in a way that drives actionable business decisions and clear performance tracking.

Key Features

01Guidance on SMART metric selection and metric governance

02Multi-departmental KPI frameworks for Sales, Marketing, Product, and Finance

033 GitHub stars

04Python and Streamlit code snippets for interactive data visualization

05Standardized dashboard layout patterns for executive and operational views

06SQL implementation patterns for MRR, Churn, and Cohort analysis

Use Cases

01Implementing real-time operational monitoring for system health

02Building cohort retention and unit economics visualizations for SaaS

03Designing executive-level strategic dashboards for business growth

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add tahir-yamin/dev-engineering-playbook kpi-dashboard-design

For use in Claude.ai and ChatGPT

Download Skill