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 tutor, 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 and a badge that is perfect for LinkedIn profiles or email footers.
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.
If you would rather not be listed, just let us know.
Index KPI Design with Excel
$184.99
Email us at training@madetomeasurekpis.com with your name, organisation (if appropriate), address and tax number (VAT/UTR etc.) as you would like it to appear on the invoice.
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.
Bernie travels the world delivering public and bespoke in-house training on performance measurement. All of his material is highly interactive and practical. He can also deliver hybrid, online training: a mixture of elearning and live training. Get in touch for a free conversation to explore if this is something you (or your organisation) might benefit from.
Bernie has written nineteen (and counting) books on KPIs and report design. On any given day his books will usually be in the top three for a 'KPI' search on Amazon. Each book is written to be practical, conversational and no-nonsense. Head over to madetomeasurekpis.com to get more details on his books.
Every method, checklist and tip in this online training has been derived from over 20 years of Bernie's consulting experience. Nothing beats custom advice when the stakes are high and you are under pressure to deliver. Every consulting role is different, so get in touch for a free initial exploratory conversation.
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
Email us at training@madetomeasurekpis.com with your name, organisation (if appropriate), address and tax number (VAT/UTR etc.) as you would like it to appear on the invoice.
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.
Absolutely! Get in touch using https://calendly.com/bernie-smith/introductory-conversation to set up a free introductory call to explore the options.
Yes! You earn the title 'ROKET-DS Target and Incentive Design Professional', once you have achieved 70% or higher in the end of course test (up to five attempts allowed). When you have graduated you will received...
If you decide that the course is not for you, and you have not completed more than 20% of the course, then you can contact us for a cheerful full refund of your course fees.
We want you to use your training and course materials to succeed. However, there are some reasonable restrictions on use, these are clearly and simply laid out on this page: https://kpi.academy/p/ip-acceptable-usage
Index KPI Design with Excel
$184.99
Email us at training@madetomeasurekpis.com with your name, the course your wish to enrol in, organisation (if appropriate), address and tax number (VAT/UTR etc.) as you would like it to appear on the invoice.
Drop us an email on hello@kpi.academy or set up a Zoom call here https://calendly.com/bernie-smith/catch-up