skills.rest
Lyiu-10
Lyiu-10COMMUNITY
Explore all skills by this author →
GitHub

kpi-dashboard-design

Design structured KPI dashboards with layout patterns, SQL, and Streamlit code.

Updated May 6, 2026
Search Tags:#data visualization#business intelligence#streamlit#kpi#dashboard design#metrics selection
One-click install
npx skills add https://github.com/Lyiu-10/pepwebis --skill kpi-dashboard-design-lyiu-10
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kpi-dashboard-design
Source: https://github.com/Lyiu-10/pepwebis/tree/main/.agent/skills/kpi-dashboard-design
Command: npx skills add https://github.com/Lyiu-10/pepwebis --skill kpi-dashboard-design-lyiu-10

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill solves the common problem of building cluttered, unactionable dashboards that fail to communicate key business performance insights to stakeholders, leading to poor data-driven decision-making.

Core Features & Use Cases

  • KPI Selection Framework: Provides structured guidance to choose relevant, SMART KPIs aligned to strategic, tactical, and operational goals across sales, marketing, product, and finance departments.
  • Pre-built Layout Templates: Offers ready-to-use dashboard patterns for executive summaries, SaaS metrics tracking, and real-time operations monitoring.
  • Implementation Support: Includes sample SQL queries for KPI calculations and Streamlit code for building interactive, production-ready dashboards.
  • Real-World Use Case: A product manager can use this Skill to design a SaaS metrics dashboard that tracks MRR, churn rate, and cohort retention to monitor product health and identify growth opportunities.

Quick Start

Use the kpi-dashboard-design skill to build an executive summary dashboard with 4-6 headline KPIs, trend indicators, and key alerts for your business.

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 KPI dashboard that actually drives business decisions?▼

To design a KPI dashboard that drives decisions, use a structured KPI selection framework to align metrics with strategic goals, apply pre-built layout patterns for clear visual hierarchy, and implement interactive elements to highlight actionable business performance insights.

What is the best way to choose relevant KPIs for an executive summary dashboard?▼

The best way to choose KPIs for an executive summary dashboard is applying a SMART KPI selection framework that aligns 4-6 headline metrics with high-level strategic goals, ensuring stakeholders can immediately grasp critical business performance without visual clutter.

Can I use Streamlit to build an interactive real-time operational monitoring display?▼

Yes, you can use Streamlit to build an interactive operational monitoring display. The skill provides production-ready Streamlit code alongside pre-built layout templates specifically designed for real-time tracking and executive dashboard implementation.

How do I calculate SaaS metrics like MRR and churn rate for a product health dashboard?▼

To calculate SaaS metrics like MRR and churn rate for a product health dashboard, the skill provides sample SQL queries for metric calculations, enabling you to accurately compute cohort retention and track growth opportunities within your existing data infrastructure.

Does this approach support KPI selection for specific departments like sales and marketing?▼

Yes, this approach supports KPI selection for specific departments. It delivers structured KPI frameworks tailored to align with tactical and operational goals across sales, marketing, product, and finance departments to ensure relevant performance tracking.

Related Skills

Explore More Data & Analytics Skills→
dy9759dy9759
1

data-visualization-expert

Design charts, dashboards, and interactive data applications for business analytics.

Community
Intermediate
LeandroBenjaminLLeandroBenjaminL

streamlit

Create interactive dashboards and web apps with Streamlit and Python.

Community
Intermediate
seanyofthedeadseanyofthedead

building-streamlit-dashboards

Automate Streamlit dashboard creation with KPI displays and data visualization.

Community
Intermediate
rahul-s-bhattrahul-s-bhatt

building-streamlit-dashboards

Compose Streamlit dashboards with metrics, charts, and responsive layouts.

Community
Intermediate