KPI Trees – How to build one
Creating Meaningful KPIs: Why use a KPI Tree?
Most strategic objectives are high-level outcomes. It’s very hard to agree with total confidence that you should, for example, measure ‘process moisture content’ as a way of delivering ‘lowest cost per metre production of all manufacturers’ unless you understand precisely how one links to the other. KPI Tress are all about turning strategic objectives into meaningful KPIs.
What does a KPI Tree look like?
Here's an example I have developed for training. This one is fully fleshed-out and is for the strategic objective that pretty much everyone can buy-into - 'Be Healthy'
There are a number of benefits that come from using KPI Trees.
Benefit 1 - Sum up a complex situation with just a few indicators
With the KPI Tree you naturally arrange sub-measures into meaningful groups. Creating high-level summary measures becomes relatively straightforward, as all you need to do is decide on the relative weightings and the arithmetic you use to blend the sub-measures.
Benefit 2 - Help build agreement
Every client I have worked with has featured a dominant character in the group. They can bounce a group into a particular set of measures through a mixture of rational argument and strength of will. Creating a KPI Tree avoids this through a highly collaborative series of sessions. It also gives a tool, structure and visible output that anyone can easily challenge and question.
Benefit 3 - Explain the approach
It normally takes two two-hour workshops to get a group up to speed and to successfully create a complex KPI Tree, but it’s possible to get a group to grasp how to read one with about five minutes of explanation. It can also become a powerful way for the executive to explain their strategy in terms that a group can really understand. It shows a depth, coherence and clarity of thought that’s rare when it comes to strategy and measures.
Benefit 4 - Keep in step with changes in strategy
Businesses, markets and executive teams change. It’s absolutely guaranteed that, if you are lucky enough to have a good strategy, it will have to change - possibly very soon. Using the KPI Tree approach means that you can see what impact changes in the strategy will have on measures.
Benefit 5 - Understand how measures interact
You can have too much of a good thing. It’s especially true in the world of measures. By pushing a ‘good’ measure too far you can unexpectedly have a negative impact on your ultimate strategic objective.
All of these benefits help you choose meaningful and effective KPIs. If you don't use an approach like this then your KPIs are normally selected by the person with the loudest voice or strongest personality.
Building the branches of a KPI Tree
Below is a single branch from the earlier example, showing how you move progressively closer to something you can directly measure as you move towards the ‘measures’ level of the diagram.
Drilling down one branch of the KPI Tree
As you go down the levels there is a one-to-many relationship. So, for example, our strategic objective ‘Be healthy’ has several enablers that link into it. Here are the enablers I’ve identified:
- Eat well
- Control/lose weight
- Be aerobically fit
- Relax
- Sleep well
Each of these will have several tactical enablers living below them, and measures below them. Here I have fleshed out the Eat well branch:
Expanded branch of the KPI Tree
Any ‘node’ on the tree can be linked to any other to show a relationship. Use colour, intensity or terminator shape to distinguish between the three link types, described below.
Link type 1 - Cause and effect
Where one activity directly influences another. This the most common type of relationship, so I use a plain grey line for this.
Examples of cause-effect relationships include:
- ‘Sell popular flavours’ causes ‘Increase in ice cream sales’
- ‘Consumption of free salty snacks’ causes ‘Increase in drinks sales’
Link type 2 - Conflict
Where one activity conflicts with another. I use a red line to show this.
Examples of conflict relationships include:
- Minimise 'Average Handling Time’ conflicts with ‘Maximise First Touch Resolution’.
- ‘Minimise performance rewards’ conflicts with ‘We have motivated staff‘.
Link type 3 - Companion
Where one measure is a subset of the other, or there is significant overlap. I use a double line for this - implying a two-way relationship.
Examples of companion relationships are:
- 'Weight' is a companion measure to 'Body Mass Index'
- ‘Reduce loss from car accidents’ is a companion objective to ‘Reduce injury from car accidents’.
A real-world KPI Tree example - Profit
Here's an example of it all being put together. It's the 'profit branch' from a Financial KPI Tree I built for my latest book. Signup using the form below if you would like the full tree sending to you by email as a PDF. The downloadable version includes 'solvency' branch too.
Get the full Financial KPI Tree example as a free download!
We will use your email address to...
- Send you a link to the free template you have requested, so you can download it in future
- Send you our 'Made to Measure KPIs' newsletter
We will never share your details with third parties. You are free to unsubscribe from our newsletter at any point (unsubscribe link included in every email).
The KPI Tree Checklist - getting it right first time
Here's a useful checklist for the process of creating a KPI Tree...
KPI Tree Checklist 1- Preparation checklist
- Become fully familiar with the strategy of your organisation.
- Become fully familiar with the strategic objectives of your organisation.
- Double-check those strategic objectives with all engaged senior stakeholders - if there are differences then they must be ironed out before the sessions.
- Check that there are between two and seven strategic objectives - if there are more than this, it is likely that lower-level tactical objectives are in the mix.
- Gain support and approval to hold a session from senior stakeholder(s).
- Pull together some example outputs from previous sessions (or use the examples included in this book).
- Gather your stakeholders together in groups.
- Select groups of between three and nine people per session (certainly no more than twelve).
- Select group to have a good mix of seniority.
- Organise two two-hour long workshop sessions, separated by between one and five working days.
KPI Tree Checklist 2- Practicalities checklist
- Book meeting rooms for both sessions.
- Create briefing email and send out invitations.
- Base group selection around broadly similar remits.
- Make sure there are desks available for them to work at.
- Ensure a whiteboard is available, if possible.
- Print out examples and worksheets.
- Take Post-Its and pens to the session. A camera phone can also be useful.
KPI Tree Checklist 3 - The first session checklist
- Explain the approach.
- Identify the strategic objectives - agree these with the group.
- Give the background to the session.
- Show a finished example.
- Get the group to do a simple (non-work) exercise example.
- Explain the three link types: cause-effect, conflict and companion.
- Help the group work through a more complex non-work example, including link types.
- Get the group to develop a draft KPI Tree specific to the group's relevant organisational strategic objectives.
- Develop one tree per objective. The trees will almost certainly cross-link so it makes sense to create them using one large sheet if possible.
Tip: If the participants start to get anxious about the number of potential measures this process is throwing up, then it's worth reassuring them that the whole point of this step is to generate the longlist of measures. You will absolutely not simply take this longlist and attempt to implement it as it stands at the end of this session. There is a critical next step which involves shortlisting candidate measures.
- Write up the trees from all groups and merge into one tree.
- Add notes to show where decisions have had to be made on the merge.
KPI Tree Checklist 4- The second session checklist
- Review the merged tree.
- Are there important factors that will not register with any of the measures identified? If so, then you have missed something out of your tree.
- Is there a way of making a measure go the `right' way, but by doing something stupid?
- Add any further branches that need adding.
- Make corrections and discuss the merged tree.
The second session is normally quite straightforward as the group will be fresh, familiar with the purpose of the session and used to working as a group.
- Finish drawing up the trees from the second session (there may be several trees, but there should be only one version for each objective, the various versions having been merged after the first session).
- Add explanatory notes as needed.
- Circulate to the participants for final approval. State that the absence of a response will be taken as implicit approval.
Tools for building KPI Trees
There are several choices for drawing diagrams. Key points you need to consider when choosing one are:
- Does the read/edit software have to be a standard desktop application (like Microsoft Word or PowerPoint) or do you have the chance to install specialist applications like Visio or Aris?
- What is the IT skill level of the users?
- Do you have to attach meta-data to objects? If so, you will need to go for a more specialist diagram package e.g. Visio.
- Is there a company standard currently in use for this type of diagram? E.g. Mindjet, mind mapping software.
- Will the software be used on a variety of operating systems? Some applications like OpenOffice, Freemind and Mindjet cover two or more operating systems. Others, such as Visio, tie you firmly to one platform.
- What level of annotation and general sophistication are you looking for? How many nodes/branches do you need to fit in?
For more practical, concise advice on KPI Trees and choosing the best KPIs, check out my book KPI Checklists ...
[…] it’s particularly important when determining KPIs. One way to figure that out it to use a KPI tree. Start with the strategic business objectives and work down into the details. The level of KPI we […]