KPI tree builder: AI prompt for consulting

A ready-to-run prompt for data analysis work in management consulting. It assigns the AI a specific senior role, takes your details as variables, and defines the output format — so the first result is usable, not a warm-up.

What this prompt does

Act as an analytics consultant. It structures the request the way experienced practitioners brief a colleague: context first, then explicit deliverables, then quality constraints.

Best for

Consulting professionals — and anyone doing this work — who need data analysis handled to a professional standard for clients and engagement partners. Typical moments: engagement kickoffs, steering committees and final readouts.

Before you use it

Have these details ready to replace the highlighted variables:

• [business/goal metric]

The prompt

Act as an analytics consultant. Build a KPI tree for [business/goal metric]. Decompose the north-star metric into drivers and sub-drivers mathematically where possible, mark which drivers are directly influenceable, propose one owner-type and one data source per driver, and identify the 2 drivers with the best leverage-to-effort ratio to focus on this quarter.

Quality checklist before you run it

• Paste real data or a representative sample, not a description of it
• Sanity-check every calculated number independently
• Ask the model to state its assumptions before trusting conclusions

Common mistakes

• Trusting output numbers without independent spot-checks
• Describing your data instead of pasting a real sample
• Acting on findings whose assumptions you never read

When to use it — and when not to rely on it

Use it whenever data analysis would otherwise start from a blank page. Don't rely on it as a finished product: outputs need your judgment, your facts, and — in regulated work — professional review.

Related prompts

• Board-ready strategy deck outline — Consulting
• Market sizing (TAM/SAM/SOM) — Consulting
• Hypothesis tree for a client problem — Consulting
• Case interview drill partner — Consulting
• Pipeline review analysis — Sales
• Comparative market analysis — Real Estate

Logical next step

After this, most consulting teams move on to Board-ready strategy deck outline.

All Consulting prompts · All Data Analysis prompts · Search the full library