Module 4: KPI design · Lesson 4.1 · about 12 min
What makes a good KPI
A KPI is a number tied to a goal that someone can act on. How to choose KPIs that matter, define them so nobody argues, and avoid vanity metrics and too many KPIs.
Module 4 · about 12 minutes · read first: 1.2. You’ll be able to choose KPIs for a business, define them precisely and spot vanity metrics.
1. Why this matters
Dashboards often show 20 numbers and nobody knows which matter. A good set of 3 to 6 KPIs tells a team, every morning, whether they’re on track. In BI interviews you’ll often be asked “which KPIs would you put on this dashboard, and why?”; the answer shows whether you understand the business.
2. The idea in one picture
A KPI card for Northbay: the number, what it’s compared to, and its trend. Try changing what it’s compared with:
3. What makes a good KPI
A useful test is whether it is:
- Tied to a goal. “Grow profitably” → Sales vs target, Margin %.
- Actionable. Someone can change it by doing something. Store managers can affect sales; they can’t affect the exchange rate.
- Owned. A named person or team answers for it.
- Compared. It has a target, last year or a benchmark (Lesson 4.2).
- Clearly defined. Formula, filters, time, source, written down.
- Few. 3 to 6 on a main page. More KPIs means less focus.
Leading vs lagging: sales are a lagging indicator (they tell you what happened). Footfall, conversion rate or stock availability are leading (they warn you before sales move). A good set has both.
Vanity metrics grow without the business improving: page views, app downloads, “total customers ever”. They feel good and drive no decision.
Principle
Principle: Goodhart’s law: “when a measure becomes a target, it ceases to be a good measure.” If stores are judged only on sales, they may discount heavily and destroy margin. Pair KPIs that balance each other: Sales with Margin %, speed with quality.
Analogy: a car dashboard. A few gauges (speed, fuel, warning lights) you can act on while driving. Not the tyre pressure history of the last five years.
4. Worked example
Northbay’s regional manager wants a weekly dashboard. Candidate KPIs:
| KPI | Definition | Why it’s there |
|---|---|---|
| Sales vs target | SUM(Sales[Amount]) ÷ target for the same stores and period − 1 | The main goal |
| Like-for-like growth | Sales of stores open in both years vs last year | Fair growth, not inflated by new stores |
| Margin % | (Sales − cost) ÷ Sales | Balances sales: growth must be profitable |
| Average sale | Sales ÷ number of sales lines | Explains whether growth comes from more or bigger sales |
Rejected: “Number of products in the catalogue” (no decision), “Total sales since opening” (only goes up).
5. Practice
- Is “number of transactions” a KPI or a supporting metric for Northbay? Why?
- Give a KPI that balances “Sales vs target”.
- Write a definition for “Monthly sales” that would end arguments.
Answers
- Usually a supporting metric: it helps explain sales (more customers vs bigger baskets) but on its own isn’t the goal.
- Margin %, so stores don’t hit sales targets by discounting.
- For example: “Sum of Sales[Amount] (after discounts, before tax) for lines with an order date in the calendar month, all open stores, refunds excluded. Source: Northbay sales system, refreshed daily.”
Next, Lesson 4.2: what to compare a KPI with.
Check yourself
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. The writing checks are simple rules run in your browser; nothing you type is sent anywhere or kept.