Skip to main content

Unable to Load

The application couldn't load properly. This sometimes happens after a period of inactivity or when a new version is available. Please refresh to try again.

Index KPI Design

Simplify your KPI world

Enrol now!

Index KPIs: Summarising the complex, simply

It's difficult to read and digest multiple related KPIs. This can paralyse decision-making or lead to reliance on a restricted number of KPIs.

An index KPI rolls multiple related KPIs into a single 'headline' KPI, helping the user rapidly identify where they need to focus their attention and dig deeper.

In this course, we introduce you to a powerful structured approach - the 'EPIK' index design system and toolkit, developed by your presenter, Bernie Smith.

Five reasons to master Index KPI design

1. 'Too many measures' is the #1 management reporting user complaint

For most real-world situations there is no 'magic bullet' single metric. Skipping KPIs to simplify reporting is fraught with risks.

2. Index KPIs offer simplicity and clarity in a chaotic world

Index KPIs are the safest and most flexible way to provide a simple, at a glance, overview without skipping crucial KPIs.

3. Index KPI Design can be complex

Mixing 'more is good' with 'more is bad' KPIs, dealing with 'ranged' and 'open-ended' input values and handling 'netted out' differences all make Index KPI design complex for the first-time designer. Solutions to these challenges have been baked-in to the EPIK Index Design method.

4. There are lots of hidden risks and pitfalls in designing Index KPIs

Badly designed Index KPIs can give a misleading sense of security. Using the EPIK Design Method you will have confidence in your completed Index KPIs and a structured testing approach.

5. This course will help you become the go-to Index KPI designer for your organisation

Using the EPIK Design Method, you won't just have mastered a fantastic design method, you will have the language and toolkit to explain the Index KPI to others, building your reputation as a KPI pro.

Our approach

Self-paced online modules

We cover the principles of Index KPI design in 11 bite-sized lessons, taking about an hour in total. This is followed by a half hour step-by-step demonstration of the EPIK Excel Toolkit. You are free to pick up and put down the course whenever you like.

Certificate on course completion

At the end of the course you will receive a personalised certificate of completion.

Who is the Index KPI Design course designed for?

This course will develop deep practical knowledge of Index KPI design.

It is for professionals who would like to

  1. Develop and implement robust Index KPIs for their (or their client's) organisation
  2. Simplify management reports for dashboards for their (or their client's) organisation
  3. Lead clients, or colleagues, through the development of Index KPIs

The course in detail...

Notes and cheatsheet downloads

Index KPIs - Simple KPIs for complex situations

Includes: EPIK Excel Index Toolkit

Clear, logical design

The toolkit includes the EPIK Index KPI Method Cheatsheet, a logical colour coding system for the whole workbook and plenty of in-sheet notes to help you find your way round as quickly as possible. The colour coding clearly indicates which cells need data, which are for one-time values and which should be left alone.

Structured design dashboard

Index KPIs can get complicated quickly if you aren't organised. The 'Index Design Template' tab will become your design cockpit for your Index KPI, structured to help you painlessly document and manage your KPI Index as you develop it.

25 index function templates

The function library allows you to quickly turn your ideas into effective working functions. Each function template is designed to be easy to test and easy to tune. Charts are included with each function so you can see how it will response.

The course for anyone who wants to become the 'go-to' expert on Index KPI Design in their organisation

Clear, concise course notes and cheatsheet

Expertly designed course notes

The course includes 22 pages of carefully designed course notes as a PDF, with thumbnails of the course slides and a printable Index Design cheatsheet.

Certificate of completion

How do I earn the certificate?

Enrol now!

Index KPI Design with Excel

$184.99

About your presenter

Bernie is a highly experienced performance measurement consultant, trainer, speaker and  best-selling KPI author . Convinced that there are many lifetimes of terrible KPIs that need fixing, his mission is to share sensible, easy to understand methods with as many people as possible to improve the quality of management information being used around the world.

His ideas have shaped the world of performance measurement and can often be seen  referenced , reused and rebadged by others in the field.

Satisfaction Promise

We do our best to give you a full and honest picture of our courses, but if you decide that the course is not for you, tell us within 30 days of buying it for a cheerful full refund of your course fees. See our refund policy.

Enrol now!

Index KPI Design with Excel

$184.99

Frequently Asked Questions

Do I get immediate access to all the modules on signup?

Yes. Every lesson is open as soon as you sign up. They are designed to be worked through in order.

What IT do I need to take part in the course?

To take part in the sessions you will need...

Can I download the videos?

For copyright protection the videos can only be viewed through your KPI Academy account.

Do the videos have subtitles/closed captions?

Yes, all of the lessons have closed captions for those with hearing issues or who are not comfortable with spoken English.


Do I get a certificate?

Yes. When you have completed every lesson and passed the quizzes you receive a personalised certificate of completion.

What if I find the course is not for me?

If you decide the course is not for you, tell us within 30 days of buying it and we will refund you in full. See our refund policy.

Am I free to use the course materials in my organisation or with clients?

We want you to use your training and course materials to succeed. However, there are some reasonable restrictions on use, these are set out in our terms.

Enrol now!

Index KPI Design with Excel

$184.99

Still have questions? Get in touch!

Drop us an email on questions@kpi.academy.