Unable to Load
Enrol now!
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.
For most real-world situations there is no 'magic bullet' single metric. Skipping KPIs to simplify reporting is fraught with risks.
Index KPIs are the safest and most flexible way to provide a simple, at a glance, overview without skipping crucial KPIs.
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.
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.
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.
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.
At the end of the course you will receive a personalised certificate of completion.
This course will develop deep practical knowledge of Index KPI design.
It is for professionals who would like to
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.
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.
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 includes 22 pages of carefully designed course notes as a PDF, with thumbnails of the course slides and a printable Index Design cheatsheet.
Index KPI Design with Excel
$184.99
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.
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.
Index KPI Design with Excel
$184.99
Yes. Every lesson is open as soon as you sign up. They are designed to be worked through in order.
To take part in the sessions you will need...
For copyright protection the videos can only be viewed through your KPI Academy account.
Yes, all of the lessons have closed captions for those with hearing issues or who are not comfortable with spoken English.
Yes. When you have completed every lesson and passed the quizzes you receive a personalised certificate of completion.
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.
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.
Index KPI Design with Excel
$184.99
Drop us an email on questions@kpi.academy.