Executive Metrics
The few, governed, comparable numbers
Executives run on a tiny set of outcome metrics: revenue, margin, cash, churn, headcount, delivery. The analyst's job is distilling them into governed, comparable, decision-ready numbers across regions and periods.
What you will learn
- Name the executives' core outcome metrics
- Build comparability across regions and periods
- Serve execs a decision-ready one-pager, not a maze
What is this?
Executive analytics serves a handful of outcome metrics — revenue, margin, cash, churn, net-new, headcount, on-time delivery — that the leadership team actually decides on. The craft is comparability (same definition in every region), governance (the definition doesn't wobble), and restraint (five crisp numbers beat forty tiles). Each metric is a decision, not decoration.
Why do you need it?
- Executives carry the whole org on a one-pager; overload is failure.
- Comparability across regions/periods is where most exec decks rot.
- Decision-ready deltas fall out once metrics are governed.
- 'The exec deck' is a recurring, high-stakes analyst deliverable.
Mental model
An aircraft instrument scan
Executive metrics
Pilots don't read 40 gauges; they scan a small set — airspeed, altitude, heading, fuel — each tied to a decision. Every other gauge exists in the background. Executives fly the company the same way: a small, governed, decision-tied set, checkable at a glance.
How it works
- Choose the handful: the metrics already in the board's mouth.
- Govern definitions at the metric layer so every region agrees.
- Standardize periods (calendar vs fiscal, TTM vs YTD) and comparability.
- Present as value, delta vs prior period, delta vs plan, and direction.
- Keep drilldowns behind the page; the one-pager stays scannable.
From operational truth to the executive one-pager.
Examples
The launch one-pager skeleton
METRIC VALUE Δ vs LY vs PLANRevenue 12.4M +8% +2%Gross margin 64% +1pt -1ptOperating cash -0.9M n/a -1.2MNet retention 112% +3% +5%Delivery SLA 97.2% +0.4% -0.8% Each number has ONE owner, ONE definition,and a drill path, not a second page of tiles.Five decision-tied outcome metrics with deltas and owners — the whole board meeting in a glance.
In production
- A monthly board one-pager computed from a governed metric layer, identical definition per region.
- A quarterly earnings review uses cash + margin triangulated with the P&L roll-up.
- A growth review compares revenue by region on a fixed calendar/fiscal period basis.
Best practices
- Restraint: five to eight decision metrics max per page.
- Comparability rules locked: grain, period, currency, FX handling.
- Every page number routes to one metric-layer definition.
- Let the deck carry detail; the one-pager only decides.
Common mistakes
- Forty-tile dashboards that read as wallpaper.
- Revenue defined three ways across regions (currency/grain drift).
- Deltas absent — a value with no reference is a poster.
- Exec customers of the report having no owner when a number goes red.
Debugging tips
- Two regions disagree on the same KPI → comparability rules (FX/grain/period) not enforced.
- Board asks 'where is this from?' → the metric has no lineage to a governed definition.
- One-pager blooms into 40 rows → no restraint rule; cut to decision metrics.
Interview checkpoint
Hands-on lab
- Compute the core outcome metrics from raw tables
- Add deltas vs prior period and vs plan
- Render it as the one-pager row set
Build the Executive Outcome Set in SQL
45 min · intermediate
Quick quiz
The executive one-pager should carry:
Exec metrics need deltas and an owner to serve decisions.