Data & Analytics Skill
Airflow DAG Patterns
Build production Apache Airflow DAGs with best practices for operators, sensors, testing, and…
$15
KPI Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and…
A complete methodology for designing KPI dashboards that drive decisions, not just display numbers. It covers metric selection, a strategic-to-operational hierarchy, visualization best practices, and ready layouts for executive, SaaS, and real-time operations views, backed by SQL and Streamlit implementation code.
$15 one-time
Add to a kit → Prices include 20% VAT. · Forged on real agency work · one-time, no lock-in
- Type Skill
- Category Data & Analytics
- Delivery Email · instant
- License One-time
Inside the run · no black box
See the actual work before you buy it.
Out of dozens of available metrics, only 5 to 7 survive. Each one gets an audience, a target and a pyramid layer before any chart is drawn, and color always means position against the SLO.
- Maps every candidate metric into the KPI framework first: strategic (executives, monthly), tactical (managers, weekly) or operational (teams, real-time). Audience and update frequency are decided here, not after the fact.
- Applies Pareto selection: out of dozens of available metrics, 5 to 7 headline KPIs survive. Vanity metrics are rejected, and every surviving KPI gets an SLI to SLO to SLA chain so the number is judged against a target, never shown bare.
- Lays out per the Minto pyramid: 4 to 6 headline cards with trend arrow and percent delta on top, trend charts and breakdowns as the second layer, drilldowns capped at three clicks deep.
- Writes and documents the calculation layer: SQL for MRR with month-over-month growth, cohort retention heatmaps keyed by signup month, CAC from spend over acquired customers. Methodology is never hidden behind the widget.
- Builds operational sections on USE and RED: system health shows utilization plus saturation plus errors for each resource (utilization alone says nothing), service rows show rate, error percent and p50/p95/p99 latency with explicit thresholds.
- Wires alerting and color coding to the SLO targets: green, yellow and red are positions against the objective, an alerts section surfaces breaches, and each widget refreshes at the cadence its metric actually changes.
One power source. 6 lines out.
kpi-dashboard-design · core
core active · 6 lines
- ✓ designing an executive s…
Designing an executive summary dashboard with headline KPIs and trends
- ✓ building a saas metrics
Building a SaaS metrics view with MRR, unit economics, and cohort retention
- ✓ creating real-time opera…
Creating real-time operations dashboards with system health and service status
- ✓ selecting the right 5-to-7
Selecting the right 5-to-7 KPIs from dozens of candidate metrics
- ✓ writing sql for mrr, coh…
Writing SQL for MRR, cohort retention, and customer acquisition cost
- ✓ improving cluttered exis…
Improving cluttered existing dashboards for clarity and mobile use
Yours to keep.
Drag time forward. Watch what stays.
Forever
That's what owning means.
The rented stack
ai writing tool: subscription
expired · access lostanalytics suite: subscription
expired · access lostdesign platform: subscription
expired · access lost(nothing left)
Your forge
-
Drive faster decisions by leading with the result, then the supporting detail
license: perpetual -
Cut visual noise by focusing on the highest-impact metrics, not every number
license: perpetual -
Give every metric meaning by showing it against targets, trends, and context
license: perpetual -
Build dashboards people actually read with fast load times and clear hierarchy
license: perpetual
subscriptions expire · deeds don't
Everything in the box.
Pick a piece up. Watch it work.
KPI hierarchy framework spanning strategic, tactical, and operational levels
6 parts · one working system · ships instantly by email
This wasn't forged for everyone.
- Not for you if you'd rather rent a tool than own one.
- Not for you if you want someone else to run your stack.
- Not for you if you're happy guessing.
Data analysts, product managers, and operators who design business dashboards and want metrics that lead to action instead of clutter.
then this was forged for you.Works with
Universal by design: these run in any AI. Delivered in the open Agent Skills + MCP format (native in Claude); ChatGPT, Gemini, Cursor and Copilot adapt the same files their own way.
- Claude Native format
- ChatGPT Adapts via open standards
- Gemini Adapts via open standards
- Cursor Adapts via open standards
- Copilot Adapts via open standards
Catch what's on your mind.
the air is clear. nothing between you and the forge.
catch a spark: the forge will answer
-
We're on Tableau, not Streamlit. Is the implementation code wasted on us?
No. The core of the methodology is tool-agnostic: the KPI hierarchy, metric selection, and layout patterns apply identically in Tableau or Looker. The SQL templates for MRR, cohort retention, and acquisition cost run on whatever database sits underneath, and the Streamlit code is just one reference implementation.
-
I have 40 candidate metrics. How do I get to a dashboard people actually read?
Through the hierarchy: metrics split into strategic, tactical, and operational levels, and each view commits to one level with 5 to 7 KPIs. Every metric is shown against targets, trends, and context, with the result leading and the detail following. The department catalogs help you cut vanity metrics early.
-
Does it connect to my data sources and build the pipeline?
No. It's a design methodology with templates, not an ETL tool. The SQL runs on data you already have in a queryable store; moving the data there is separate engineering work.
-
How is it delivered?
By email right after purchase: ready to run, downloaded instantly, no setup wait.
-
One-time or subscription?
A one-time purchase; no subscription or hidden fees. VAT (20%) is included.
-
Can I get a refund?
As a digital product, it can’t be refunded once downloaded. That’s why we show exactly what’s inside and who it’s for, right here.