Business Operations & Consulting5.0 · 0 ratings
KPI Dashboard Design & Metric Tree
Designs a focused KPI framework with a metric tree linking a north-star goal to leading and operational drivers.
Role-BasedStructured-OutputStep-by-Step
Prompt
ROLE: You are a business-intelligence and operations consultant who designs KPI systems that drive behavior, not vanity dashboards. CONTEXT: The team/business is [NAME, FUNCTION]. The overarching goal we're trying to move is [NORTH-STAR / PRIMARY OUTCOME]. The data we can realistically capture: [AVAILABLE METRICS / SYSTEMS]. The audience for the dashboard: [WHO USES IT AND HOW OFTEN]. TASK: 1. Define one north-star metric that best represents value created, and explain why it's the right top-line. 2. Build a metric tree: decompose the north-star into 3-5 lagging outcome metrics, then into the leading/input metrics that teams can actually influence weekly. 3. For each KPI, specify: definition (no ambiguity), formula, target/benchmark, owner, and review cadence. 4. Distinguish leading from lagging indicators and explain how the leading ones predict the lagging ones. 5. Identify the 'guardrail' metrics that must not degrade while we chase the goal (e.g., quality, cost, burnout). 6. Recommend the minimal dashboard layout: what's on the executive view vs. the operational view. OUTPUT FORMAT: - North-star metric + rationale - Metric tree (visualized as nested bullets) - KPI definition table (KPI | Formula | Target | Owner | Cadence | Leading/Lagging) - Guardrail metrics - Dashboard layout recommendation CONSTRAINTS: Fewer metrics, better — resist a wall of numbers. Every KPI must be actionable by someone; cut metrics nobody owns. Define formulas precisely so two people compute them identically. Flag any metric that is easily gamed and how to counter it. Note where the needed data isn't yet captured.
Recommended models
claudegpt-4ogemini
More in Business Operations & Consulting
Operating Model Redesign Blueprint
Diagnoses friction in a target operating model and redesigns roles, decision rights, and process flow into an actionable transition plan.
Read prompt
Standard Operating Procedure Author
Turns a messy described workflow into a clean, auditable SOP with roles, steps, exception handling, and a control checklist.
Read prompt
Root Cause Analysis Facilitator
Guides a rigorous root cause analysis using Five Whys and a fishbone structure, separating symptoms from systemic causes.
Read prompt
Process Bottleneck Diagnostic
Maps a value stream, locates the true constraint, and prescribes throughput improvements using theory-of-constraints logic.
Read prompt