KPI and metrics for Management Consultants & Managers

Practical guide on how to use KPIs and metrics to understand & manage a business - tips from top consulting firms.

What you'll learn

How to understand the business through KPIs
How to use KPIs to model the business in Excel
How to use KPIs to manage the business
How to use KPIs to motivate people
How to use KPIs to improve the business

Requirements

Basic Finance & Accounting
Basic Excel

Description

What is the aim of this course?

Most businesses on the face of it look very complicated and difficult to understand. On top of that the competition is so fierce that you have to take decisions based on data and not on gut feeling (a very misleading creature). That’s why it’s crucial to define and understand the main drivers and metrics measuring those drivers. If you have properly defined Key Performance Indicators (KPIs) you can understand the mechanism behind any business, you will be able to model it in Excel and you will know how to grow it or improve it. You can also use properly defined KPIs to manage people efficiently, give them goals aligned with your goals. That’s why I have decided to create a course solely concentrated on this KPIs.

This course will give you the knowledge and insight into drivers and KPIs used in different business models that can be used for understanding the business, managing it, motivating people and improving results. The course will make your life during a consulting project much easier. If you are already a manager thanks to this course you will learn how to use the KPIs to understand and grow your business.

This course will help you drastically improve your knowledge and skills in understanding and improving your business using KPIs. It is designed for management consultants and newly appointed managers that want to excel at their work. In the course you will learn 6 things:

1. How to understand the business through KPIs

2. How to use KPIs to model the business in Excel

3. How to use KPIs to manage the business

4. How to use KPIs to motivate people

5. How to use KPIs to improve the business

6. What is a good KPI

The course is based on my 15 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from Retail, FMCG, SMCG, B2B and services sector that I worked for. On many occasions I had to optimize also businesses I was responsible for. On the basis of what you will find in this course I have trained over 100 consultants, business analysts and managers who now are Sales and Marketing Directors, Operational Directors, COO, CEO, Investment Directors, Directors in Consulting Companies, Supply Chain Directors, Board Members, Partners in PE etc. On top of that my courses on Udemy were already taken by more than 43 000 students.

I teach through cases, so most of the lectures are case studies showing some business problems solved in Excel. There will be also a practical guide how to create good KPIs and a library of KPIs from different business models such as: marketplace, retail, e-commerce, restaurant chain, SaaS businesses. To every lecture you will find attached (in additional resources) the Excels shown in the lecture so as a part of this course you will also get a library of ready-made analyses that can, with certain modification, be applied by you in your work.

Why I decided to create this course?

Many people are overwhelmed with the complexity of the businesses they have to manage or improve. During consulting projects I have seen business analysts and management consultants struggling with understanding the business fast enough to deliver value to the customer. The course will give you the knowledge and insight that will help you define KPIs and use them to understand, manage and improve any business. Thanks to this course, you will know what and how to define and uses KPIs during consulting project or as a manager. I will show you also how to use the KPIS to model businesses in Excel. This part will be useful for estimating the potential improvements that can be done by improving certain drivers measured by KPIs.

To sum it up, I believe that if you want to be great management consultant or manager you should master the art of defining and using KPIs. That is why, I highly recommend this course not only to consultants or managers that have to advice their customer but also to owners, founders of businesses as well as directors.

In what way will you benefit from this course?

The course is a practical, step by step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you define and use the KPIs or metrics. There is little theory – mainly examples, case studies with a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will learn:

How to understand the business through KPIs

How to use KPIs to model the business in Excel

How to use KPIs to manage the business

How to use KPIs to motivate people

How to use KPIs to improve the business

What is a good KPI

You can also ask me any questions either through the discussion field or by messaging me directly. If needed I will create additional content as well.


How the course is organized?

The course is divided currently in 7 sections and I will be adding new sections to address other important issues. Currently you will find the following sections:

Introduction. We begin with little intro into the course. I will show you here what you can expect from this course and how it is organized

Understanding the business through KPIs. In the second section I will show you how to use the KPIs to understand different business. We will start by defining drivers for different business and on the basis of that we will pick the right KPIs to understand those drivers. We will do it for different business models: e-commerce, marketplace, restaurant, retail and a SaaS business model

Using KPIs to model the business in Excel. In this section I will show you how to use the KPIs to model the whole business model in Excel. This part will help you see the big picture and to estimate the potential impact of the improvements to certain KPIs

How to use KPIs to manage? In the section number 4 I will show you how to use the KPIs to manage a business. We will use them to decided how to 10x the business, how to increase profitability, decrease costs etc.

How to use KPIs to motivate? In the next section I will discuss how to use the KPIs to motivate certain behaviors. We will also talk about the traps and pitfalls as well the problems that bad KPIs can cause

What is a good KPI? This section will be devoted to a little bit of theory. I will show you what a good KPI is and how to define it

You will be able also to download many additional resources

Excels with analyses shown in the course

Presentation of slides show in the course

Links to additional presentations and movies

Links to books worth reading

At the end of my course, students will be able to…

How to understand the business through KPIs

How to use KPIs to model the business in Excel

How to use KPIs to manage the business

How to use KPIs to motivate people

How to use KPIs to improve the business

How to create great, useful KPIs

Who should take this course? Who should not?

Management Consultants

Managers

Business Analysts

Directors

Startups founders

Controllers

What will students need to know or do before starting this course?

Basic or intermediate Excel

Basic knowledge of economics or finance

Who this course is for:

Management Consultants
Managers
Business Analysts
Directors
Startups founders
Controllers