Most dashboards have a quiet problem: they show everything and decide nothing. A leader opens a report with twelve charts across twenty locations and has to do the hard work themselves, comparing trends, weighing measures against each other, and deciding what actually needs attention.
A composite KPI solves that by combining several measures into one score. Done well, it tells people where to look first. Done poorly, it hides problems behind a number nobody understands.
When a single score makes sense
A composite KPI works best when:
- People need to compare many units, such as facilities, offices, teams, or portfolios, on the same terms.
- Several measures together describe “good performance,” and no single one tells the whole story.
- The audience needs to act quickly, not study every chart.
It’s the wrong tool when a single measure already answers the question, or when the audience needs to manage each measure separately.
How we designed one
For a healthcare risk management firm, BRIO designed custom KPIs, including a composite facility score, so the firm’s clients could evaluate performance across their care facilities with a single number. Clients see at a glance which locations need attention, then drill into the detail behind the score. Here’s what we learned along the way.
1. Start with the decision, not the data
Ask what the score should help someone decide. “Which facility needs a visit this month?” leads to a very different score than “Which facility is our best performer this year?”
2. Choose a small set of measures that matter
Pick the few measures that genuinely reflect performance, such as how quickly incidents are responded to and closed, and how promptly they’re reported. More inputs don’t make a better score. They make it harder to explain.
3. Put measures on the same scale
Different measures come in different units: hours, days, percentages, counts. Each needs to be converted to a common scale before it can be combined, and the direction has to be consistent so that “higher” always means “better.”
4. Weight on purpose, and write it down
Decide how much each measure counts, with the people who’ll use the score. Document the weights and the reasoning, so the score can be explained and revisited as priorities change.
5. Always let people see behind the number
A score should be the start of a conversation, not the end of one. Every composite KPI should link to the measures that make it up and to the records behind those measures. If people can’t see why a score moved, they won’t trust it.
6. Keep definitions consistent everywhere
The same score, calculated the same way, should appear in dashboards, alerts, and client-facing portals. Shared, documented definitions are what make a composite KPI trustworthy. That’s why we treat data culture as part of the work.
Common mistakes to avoid
- Too many inputs. A score built from fifteen measures is impossible to explain.
- Hidden weights. If nobody knows how the score is calculated, nobody will defend it.
- No drill-down. A number without detail invites argument instead of action.
- Set and forget. Review the score with its users regularly and adjust it as the business learns.
One good number can change how leaders spend their time. Want help designing KPIs your team will actually use? Learn more about our Tableau and data visualization work.
Frequently asked questions
What is a composite KPI?
A composite KPI combines several performance measures into a single score, making it easier to compare units such as facilities or teams and see where attention is needed.
How many measures should a composite KPI include?
Usually just a few. A small set of meaningful measures is easier to explain and trust than a score built from many inputs.
How do you keep a composite KPI trustworthy?
Document how it’s calculated and weighted, keep the definition consistent everywhere it appears, and let users drill into the measures and records behind the score.
