Kpi And Metrics For Management Consultants & Managers

A 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 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:How to understand the business through KPIsHow to use KPIs to model the business in ExcelHow to use KPIs to manage the businessHow to use KPIs to motivate peopleHow to use KPIs to improve the businessWhat is a good KPIThe 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:How to understand the business through KPIsHow to use KPIs to model the business in ExcelHow to use KPIs to manage the businessHow to use KPIs to motivate peopleHow to use KPIs to improve the businessWhat is a good KPIYou 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 organizedUnderstanding 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 modelUsing 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 KPIsHow 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 causeWhat 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 itYou will be able also to download many additional resourcesExcels with analyses shown in the coursePresentation of slides shown in the courseLinks to additional presentations and moviesLinks to books worth readingAt the end of my course, students will be able to…How to understand the business through KPIsHow to use KPIs to model the business in ExcelHow to use KPIs to manage the businessHow to use KPIs to motivate peopleHow to use KPIs to improve the businessHow to create great, useful KPIsWho should take this course? Who should not?Management ConsultantsManagersBusiness AnalystsDirectorsStartups foundersControllersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics or finance

Overview

Section 1: Introduction

Lecture 1 What the course will be about

Lecture 2 A little bit about me

Lecture 3 How the course is organized

Lecture 4 What to do if a blurry image appears

Lecture 5 How to find additional resources

Section 2: Understanding the business through KPIs

Lecture 6 Understanding the business through KPIs – Introduction

Lecture 7 KPIs and main drivers – Introduction

Lecture 8 Overview of Business models

Lecture 9 Overview of case studies you will be solving in this section

Lecture 10 KPIs for cinema – Problem

Lecture 11 KPIs for cinema – Solution

Lecture 12 KPIs for cinema – Excel

Lecture 13 KPIs for cinema – Power Point

Lecture 14 KPIs for marketplace – Problem

Lecture 15 KPIs for marketplace – Solution

Lecture 16 KPIs for marketplace – Alternative Solution

Lecture 17 KPIs for a retailer – Problem

Lecture 18 Drivers for a retail business model

Lecture 19 KPIs for a retailer – Solution

Lecture 20 KPIs for SaaS – Problem

Lecture 21 Examples of SaaS businesses

Lecture 22 KPIs for SaaS – Solution

Lecture 23 KPIs for a restaurant – Problem

Lecture 24 Main drivers for restaurant business model

Lecture 25 KPIs for a restaurant – Solution

Lecture 26 KPIs for a consulting business – Problem

Lecture 27 Main drivers for consulting business

Lecture 28 KPIs for a consulting business – Solution

Lecture 29 KPIs for a FMCG business model – Problem

Lecture 30 Main drivers for FMG business model

Lecture 31 KPIs for a FMCG business model – Solution

Lecture 32 KPIs for a SMCG business model – Problem

Lecture 33 Main drivers for SMCG business model

Lecture 34 KPIs for a SMCG business model – Solution

Lecture 35 KPIs for a commodity business model – Problem

Lecture 36 Main drivers for Commodity business model

Lecture 37 KPIs for a commodity business model – Solution

Lecture 38 KPIs for an e-commerce – Problem

Lecture 39 Main drivers for e-commerce business model

Lecture 40 KPIs for an e-commerce – Solution

Section 3: Using KPIs to model the business in Excel

Lecture 41 Using KPIs to model the business in Excel – Introduction

Lecture 42 Overview of case studies we will discuss in this section

Lecture 43 Introduction to the B2C Services Business Model

Lecture 44 Things that matter in hairderssers, beauty salons etc.

Lecture 45 Things that matter in other B2C Services Business Model

Lecture 46 Introduction to modeling B2C Services in Excel

Lecture 47 Business model of a restaurant in Excel - basic model

Lecture 48 Business model of a restaurant in Excel - advanced model

Lecture 49 Restaurant chain - how to model it in Excel?

Lecture 50 Introduction to e-commerce

Lecture 51 Examples of e-commerce businesses

Lecture 52 Logic flow of customers in e-commerce

Lecture 53 Main KPIs for e-commerce

Lecture 54 Main challenges in e-commerce

Lecture 55 E-commerce financial model - basic version

Lecture 56 Introduction to the B2B Services Business Model

Lecture 57 Things that matter in B2B Services Business Model

Lecture 58 General thoughts on B2B Services

Lecture 59 Introduction to modeling B2B Services in Excel

Lecture 60 Mechanics of business model for a consulting firm

Lecture 61 The business model of a consulting firm in Excel - Capacity and revenues

Lecture 62 The business model of a consulting firm in Excel - costs and profit & loss

Lecture 63 Introduction to SaaS

Lecture 64 Examples of SaaS businesses

Lecture 65 Logic flow of customers in SaaS

Lecture 66 Main KPIs for SaaS

Lecture 67 Main challenges in SaaS

Lecture 68 SaaS financial model - basic version

Lecture 69 Other business models using KPIs

Section 4: How to use KPIs to manage?

Lecture 70 How to use KPIs to manage – Introduction

Lecture 71 Benchmarks – external and internal

Lecture 72 Backward logic

Lecture 73 Comparison metrics

Lecture 74 Overview of case studies we will discuss in this section

Lecture 75 How to decide how to 10x your business – Problem

Lecture 76 How to decide how to 10x your business – New Stores

Lecture 77 How to decide how to 10x your business – LFL

Lecture 78 How to decide how to 10x your business – Expansion, Margin & Summary

Lecture 79 How to decide how to 10x your business – Summary

Lecture 80 How to decide how to 10x your business – Solution in Power Point

Lecture 81 How to increase the profitability of a retail chain – Problem

Lecture 82 How to increase the profitability of a retail chain – Solution – Sales Increase

Lecture 83 How to increase the profitability of a retail chain – Solution – Cost Reduction

Lecture 84 How many waiters and dishwashers you need – Problem

Lecture 85 How many waiters and dishwashers you need – Solution – Waiters

Lecture 86 How many waiters and dishwashers you need – Solution – Dishwashers

Lecture 87 How to increase production and decrease costs – Problem

Lecture 88 How to increase production and decrease costs – Solution – Part 1

Lecture 89 How to increase production and decrease costs – Solution – Part 2

Section 5: How to use KPIs to motivate?

Lecture 90 How to use KPIs to motivate – Introduction

Lecture 91 Where you should put KPIs to motivate people

Lecture 92 Overview of cases that we will discuss in this section

Lecture 93 How to analyze the motivation system of sales force – Introduction

Lecture 94 How to analyze the motivation system of sales force – Solution

Lecture 95 Juice producer – motivation system of sales force – Introduction

Lecture 96 Juice producer – motivation system of sales force – Solution – Area Manager

Lecture 97 Juice producer – motivation system of sales force – Solution – Sales Rep

Lecture 98 How bad KPIs in production can cause troubles – Problem

Lecture 99 How bad KPIs in production can cause troubles – Solution

Lecture 100 Board of directors motivation system – Problem

Lecture 101 Board of directors motivation system – General Solution

Lecture 102 Board of directors motivation system – Detailed Solution

Lecture 103 More Content on Motivation/Bonus Systems

Section 6: What is a good KPI

Lecture 104 What is a good KPI – Introduction

Lecture 105 The definition of a good KPI

Lecture 106 Vanity metrics

Lecture 107 SMART KPIs – Introduction

Lecture 108 SMART rule for goals

Lecture 109 SMART KPIs – General rules

Lecture 110 SMART KPIs – Example

Lecture 111 Alignment of KPIs – Introduction

Lecture 112 Alignment of KPIs – Solution

Lecture 113 Cascading KPIs – Introduction

Lecture 114 Cascading KPIs – Solution

Lecture 115 Leading vs Lagging KPIs

Lecture 116 Input KPIs vs Output KPIs

Lecture 117 Proxy KPIs

Lecture 118 How to set the value for KPIs

Section 7: Conclusions

Lecture 119 Bonus Lecture

Management Consultants,Managers,Business Analysts,Directors,Startups founders,Controllers