PlugWiki

kpi-dashboard-design Skill: Pick the Right KPIs and Lay Out the Dashboard

Helps your agent pick KPIs and design dashboards for executives, SaaS metrics and live operations, and debug numbers that disagree.

Installs
16.6K
on skills.sh
Stars
42.1K
on GitHub
Files
1
besides SKILL.md
Updated
Oct 2026
last repo commit

The agent uses a three-level KPI framework (strategic, tactical, operational), SMART criteria, and a dashboard hierarchy from an executive page down to drilldowns. It keeps to 5 to 7 KPIs per view, adds context such as trends and targets, and avoids vanity metrics and 3D charts.

A troubleshooting section covers five problems: MRR that disagrees with finance, green dashboards with unhappy users, flat retention cohorts, dashboards that overload the database, and alert fatigue. A reference file adds KPIs by department, three layout patterns, SQL, and Streamlit code.

Good for

  • Analysts and product managers designing a metrics dashboard
  • Founders building a SaaS metrics view of MRR, churn and LTV/CAC
  • Engineers fixing a dashboard whose numbers contradict each other

Install kpi-dashboard-design

Claude Code

  1. 1

    Copy this prompt.

    Install the kpi-dashboard-design skill in Claude Code. Run this command:

npx skills add https://github.com/wshobson/agents --skill kpi-dashboard-design

Then check that it loaded and tell me how to use it.
  2. 2

    Paste it into Claude Code. It shows the change and asks before running it.

Requires Node.js.

From its listing on skills.sh. Source.

What's in the skill

When it loads

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use this skill when building an executive SaaS metrics dashboard tracking MRR, churn, and LTV/CAC ratios; designing an operations center with live service health and request throughput; creating a cohort retention analysis view for a product team; or debugging a dashboard where metrics contradict each other due to inconsistent calculation methodology.

Sections in SKILL.md

  1. When to Use This Skill
  2. Core Concepts
  3. 1. KPI Framework
  4. 2. SMART KPIs
  5. 3. Dashboard Hierarchy
  6. Detailed worked examples and patterns
  7. Best Practices
  8. Do's
  9. Don'ts
  10. Troubleshooting
  11. MRR shown on dashboard contradicts finance's number
  12. Dashboard shows green but product team reports users complaining
  13. Retention cohort looks flat — no variation between cohorts
  14. Real-time dashboard hammers the database
  15. Alert thresholds fire constantly, team ignores them
  16. Related Skills

Key facts

Author
wshobson
Installs on skills.sh
16,631 (Nov 2, 2026)
GitHub stars
42,081 (Nov 2, 2026), whole repo
Files
2 files including SKILL.md
Last commit
Oct 30, 2026 (repo)
Part of
The business-analytics plugin in wshobson/agents
Related skill
data-storytelling, named in the SKILL.md

What it includes

  • Strategic, tactical, operational

    Maps each level to focus, update frequency and audience.

    KPI framework

  • Specific, measurable, achievable, relevant, time-bound

    A checklist for each metric.

    SMART KPIs

  • Executive summary, department views, drilldowns

    One page of 4 to 6 headline KPIs, then detail.

    Dashboard hierarchy

  • Sales, marketing, product and finance lists

    In references/details.md.

    KPIs by department

  • Executive summary, SaaS metrics, real-time operations

    Three layouts with example panels.

    Layout patterns

  • KPI queries and dashboard code

    Example SQL for KPI calculation, a Streamlit dashboard with cards, charts, a cohort heatmap and alerts.

    Write · SQL and Streamlit examples

  • Five common dashboard problems

    MRR mismatch, green-but-broken, flat cohorts, database load and alert fatigue, each with a fix.

    Troubleshooting

From the official docs

Permissions

Low risk

What it can do

  • Read your data
  • Create and change things
  • Delete things
  • Read-only mode

Watch out for

  • Example SQL and scheduled jobs touch your database

    The troubleshooting examples write a summary table on a schedule. Run examples on a replica and review before deploying. github.com

Questions

What does the kpi-dashboard-design skill do?

It helps your agent decide which KPIs to show and how to lay out a dashboard. It also helps debug dashboards where metrics contradict each other.

How do I install it?

Use the install box above. It is a SKILL.md plus one reference file, 2 files in all. It names data-storytelling as a related skill, which is optional.

How many KPIs should a dashboard show?

The skill says 5 to 7, with context like comparisons, trends and targets. An executive summary page gets 4 to 6 headline KPIs.

Does it connect to my data?

No. It bundles no scripts and SKILL.md names no data connection. It gives SQL and Streamlit examples (in references/details.md) that you or the agent adapt.

Is it safe?

It is text guidance with example SQL and Python. Run any SQL against a copy of production or a replica first, because the skill itself warns that live dashboards can hammer a database.

Why do my MRR numbers disagree with finance?

The skill's first suggestion is inconsistent handling of annual plans. Pick one formula, such as dividing yearly amounts by 12, and document it on the dashboard card.

Information

updated Nov 2, 2026

Repository
wshobson/agents
Folder
plugins/business-analytics/skills/kpi-dashboard-design

wshobson/agentsskills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 2
  1. kpi-dashboard-design SKILL.md · github.com
  2. kpi-dashboard-design details.md · github.com

Updated Nov 2, 2026.