Slides of my video presentation Combined Performance Index as pdf document:
Download Slides (pdf)
Incoming search terms:
- How to calculate composite index in Excel
In order to limit the number of Key performance Indicators (KPIs), and maintain clarity and conciseness of a dashboard, sometimes it might be useful, to combine a set of performance indicators into one single key performance indicator. This latest episode of my podcast will show, step-by-step, how you can build up a combined performance index. using
for each individual indicator. It also gives an example how to implement this concept in an Excel spreadsheet.