What you'll learn:
- Analyze motivation systems in Excel
- Understand the components of salaries
- Learn different mechanisms that can be used in motivation systems
- Define good KPIs for the motivation systems
- Avoid putting the wrong KPIs into the system
- Rank in Excel employees
- Assign employees to a specific group
What is the aim of this course?
If you want to change people’s behavior, you must understand and adjust their motivation systems. A lot of firms create motivation systems without analyzing how they will impact employees’ behavior and the performance of the firm. During consulting projects, this is one of the things you will have to analyze and change in order to help the firm improve its performance. That’s why in this course, I will teach how to perform fast and efficiently different types of analyses of motivation systems.
In the course you will learn the following things:
What are the components of salaries (variable and fixed ones)
What is Pay Scale & Pay Matrix?
The mechanisms used in the motivation systems
How to define good KPIs that can be used in motivation systems
How to rank employees using simple rankings in Excel.
This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms in Retail, FMCG, SMG, and B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion of additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 224 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 case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures 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 or your team in your work.
Why have I decided to create this course?
The performance of almost all companies is driven by the behavior of people. Therefore, to change the firm's results, you have to influence the people through a motivation system. Most firms don’t give you the full toolbox that you need to analyze motivation systems during consulting projects. This may lead to huge frustration during projects and a lot of inefficiencies.
Therefore, I have decided to create this course that will help students understand and analyze motivation systems during consulting projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects. You will master how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to KPIs.
To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a decent understanding of motivation systems. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who want to become managers. The course will help you become an expert in analyses of motivation systems on the level of McKinsey, BCG, Bain, and other top consulting firms.
In what way will you benefit from this course?
The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand, and analyze businesses. There is little theory – mainly examples, 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:
What are the components of salaries (variable and fixed ones)
What is Pay Scale & Pay Matrix?
The mechanisms used in the motivation systems
How to define good KPIs that can be used in motivation systems
How to rank employees using simple rankings in Excel.
You can also ask me any question either through the discussion field or by messaging me directly.
How is the course organized?
The course is divided currently into the following sections:
Introduction. We begin with a little introduction to the course as well as some general info on how the course is organized
Essentials Concepts. We will start by discussing some essential concepts used in the analyses of motivation systems. You will learn what is a motivation system, pay scale, pay matrix, and many more.
What is a good KPI? A good motivation system should be based on properly defined KPIs. Let’s see what a good KPI is and how you can construct them in practice.
Motivation System using KPIs. Managing people is much easier if you set targets. The easiest way to do that is via well-defined KPIs that are part of the motivation system.
Employee assessment. Quite often before you build a motivation system, you have to do a fast employee performance assessment. Let’s see how you can do that in practice.
You will be able also to download many additional resources
1. Useful frameworks and techniques
2. Analyses presented in the course
3. Additional resources
4. Links to additional presentations, articles, and movies
5. Links to books worth reading
At the end of my course, students will be able to…
Analyze motivation systems in Excel
Understand the components of salaries
Learn different mechanisms that can be used in motivation systems
Define good KPIs for the motivation systems
Avoid putting the wrong KPIs into the system
Rank in Excel employees
Assign employees to a specific group
Who should take this course? Who should not?
Management Consultants
Business Analysts
Managers
Financial Controllers
HR Analysts
What will students need to know or do before starting this course?
Basic or intermediate Excel
Basic knowledge of economics
Basic or intermediate knowledge of finance & accounting
