How to sort a KPI wish list before you build a dashboard
Ask the owners of a building firm what they want to measure and you get a long list. On one build it was 83 numbers. The mistake is to start building from the top.
Before any dashboard work, I go through the list and give every number one of six verdicts.
The six verdicts
- On a dashboard: the data exists and the number can be shown now.
- Computable, not shown: the data exists, but the number does not earn a place on a screen yet.
- Needs a definition: two people in the firm mean different things by it.
- Needs a feed: the data exists in a system, but it has not been connected.
- Needs capture: nobody records it today.
- Duplicate: it is the same number as another one on the list, under a different name.
Keep feed and capture apart
A missing feed is a technical job, often one access request away. Missing capture is a change in how staff work, and the number only becomes useful some time after recording starts.
For every number that needs capture, I write down how long that wait is likely to be.
Leave the duplicates on the list
Do not delete duplicates. Mark them and leave them in. The person who asked for the second name will look for it, and the list should show them where it went.
Write the definitions as proposals
For numbers that need a definition, do not send the owners a blank question. Propose a default and ask them to approve or change it. Keep the whole document under two pages.
A decision is easier to make when someone has already made a first attempt.
Look for the one input that unlocks many
Some numbers wait on the same missing piece. On that build, one export, the job costing budget, unlocked the whole group of budget against actual measures. Finding these shows the owners where a small effort pays back most.
What the owners get
The result is one table: every number they asked for, its verdict, and what it is waiting on. On that build, 76 of the 83 ended up on a dashboard. The others are still on the list, each with a reason.
If you would rather have this built for you, I do it for building and remodeling firms. It starts with a small fixed-price review.