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 make 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 these 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 the 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 110 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

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 on 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 modifications, be applied by you in your work.

Why have 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 use KPIs during a 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 a 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 advise their customers 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:

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

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 into the following sections:

• Introduction. We begin with a little intro to 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 businesses. We will start by defining drivers for different businesses 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, the 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 on certain KPIs

• How to use KPIs to manage? In section number 4 I will show you how to use the KPIs to manage a business. We will use them to decide 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 shown 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