
We begin with a little intro to the course as well as some general info on how the course is organized.
A few words about your humble teacher
Let's see how the course is organized
Here, I will show you what to do if a blurry image appears
Here, I will show you how to find additional resources attached to the course, like Excel files, presentations, links, etc.
To be able to fix a system, we have to first understand what this system is trying to achieve. In this section, we will try to see how the Education System works.
Let’s start by looking at what goals the Education System can have. We will discuss 5 main goals. Most Education Systems will concentrate only on 2-3 of them.
Let’s see what are the biggest challenges that Education System has to deal with. This will help us define what the solutions should be.
Let’s look at the 6 groups of solutions that will help you improve the Education System. Later, we will discuss them in detail, and I will show you how to analyze them in Excel.
Before analyzing and optimizing, it is a good idea to estimate how much we really spend on the Education System. We will look at direct and indirect costs, along with externalities.
In most cases, unfortunately, there is too big a focus on the costs of education. We will look at all aspects related to the education costs, but also the benefits and externalities.
Let's look at the bottom-up approach
Many countries only look at direct costs. Let’s look at the additional payments made by parents for things related to education as well.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
As we have mentioned, one of the directions to improve the Education System is to make it more accessible. In this section, we will look at examples of policies that may help you achieve that
One of the main things you can do to improve education is to make it more accessible. Let’s look at some of the potential solutions that can help you achieve that.
In many cases, you have to look at tradeoffs between costs and benefits. In such a situation, it is a good idea to conduct a cost-benefit analysis. Let's see how this can be done.
Imagine that you were asked to prepare an analysis to determine how the rearranging of the main office of the drugstore chain company will help reduce costs.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
Imagine that you are working for a ceramic tile producer that has 10 factories in Eastern Europe
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
Let’s imagine that you have decided to create, for primary and secondary education, online courses to help students learn. Let’s try to analyze whether it makes sense or not.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
The Education System has to provide a safe place for those who cannot look for support at home. In this section, we will look at how we can provide it.
Another thing you can do to improve Education is to provide safety and support at schools. Let’s look at some of the potential solutions that can help you achieve that.
Let’s imagine that you have decided to keep the schools open longer during the working week, and on top of that, during the weekend. Let’s see what the impact of this policy is.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
Let’s imagine that you have decided to offer free lunch to all kids at school. Let’s try to analyze whether it makes sense or not.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
The Education System can be very costly. In this section, we will look at some ways to lower the cost of the whole system.
Let’s have a look at the general framework we can use to cut costs
Cost reduction efforts are great because they help you do more with the same budget. Let’s look at specific things we can do in the Education System.
Let’s imagine that you have to check how much money you can save in the Education System. Let’s try to estimate the impact of certain policies.
In this lecture, I will show you the solution to the previously introduced case study.
In this lecture, I will show you the solution to the previously introduced case study.
A lot can be achieved by improving how students learn. You can impact the speed at which they learn, and this will impact both costs and future productivity.
Now, it’s time to look at what kind of things you can do to boost student productivity. We will look at groups of different potential solutions.
To solve the problem, you don’t have to know everything. You just have to know the selected issues. The obvious question is what things you should master and what things you can disregard. Let's see what we recommend doing.
There are a number of interesting methods that can help you understand certain subjects faster. Let’s look at the most useful ones.
Teachers have a huge impact on the costs and the effect of the Education System. In this section, we will look at their productivity.
Before we optimize their productivity, we first have to try to identify what teachers actually do. This will help us find more optimal and scalable solutions.
It’s crucial to increase the Teacher’s Productivity. Let’s look at some of the potential solutions that can help you achieve that.
Let’s imagine that you were hired by the Government to find ways to double the productivity of teachers. You have to come up with ways for the teachers to handle 2 times more students.
Just as a reminder, you were hired by the Government to find ways to double the productivity of teachers. You have to come up with ways for the teachers to handle 2 times more students.
In certain situations, you may be asked to model not the whole system but rather a chain of schools. In this section, we will see how this can be done in practice.
In this lecture, I will show you how you can build the model in Excel and what conclusions you can draw from it.
In the previous section, we showed you how to do a simple business model in Excel for e-commerce. In this section, we will concentrate on modeling the Cash Flow in a simple way.
Imagine that you have to create a financial model that will forecast the cash flow of an e-commerce business selling cosmetics and related products.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
In this lecture, we will solve the previously introduced case study.
This course contains the use of artificial intelligence.
What is the aim of this course?
Education Systems do not work properly in most countries. A lot of people are left behind, and the systems are usually extremely inefficient. On top of that, a lot of money is wasted. We also do not optimize the right things when it comes to Education. By adopting a rigorous approach from management consulting, you can significantly improve the situation and contribute to increased productivity across the entire economy. In this course, I will teach you how to perform fast and efficiently different types of analyses during consulting projects related to Education.
In the course, you will learn the following things:
What are the main problems of the Education System
What tools can you use to improve the Education System
How to conduct a cost-benefit analysis in Excel
How to analyze potential improvements in Education
How to cut costs in the Education System
How to create the financial model of a chain of schools 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 from the Retail, FMCG, SMG, 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 in total of 2 billion 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 have already been taken by more than 295 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, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, 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 modification, be applied by you or your team in your work.
Why have I decided to create this course?
Analyzing public services like Education is extremely difficult. On the one hand, you have to improve the quality of this service. On the other hand, you have to manage costs efficiently and look for productivity gains. Not all firms provide the full toolbox that you need to analyze the Education System. This may lead to huge frustration during consulting projects and a lot of inefficiencies.
Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need during consulting projects devoted to the Education System. 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 how to model the School as a business model in Excel.
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 pretty decent understanding of analyzing public services such as Education. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who want to disrupt public services or work for the government. The course will help you become an expert in the analysis of the Education System at 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, 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 main problems of the Education System
What tools can you use to improve the Education System
How to conduct a cost-benefit analysis in Excel
How to analyze potential improvements in Education
How to cut costs in the Education System
How to create the financial model of a chain of schools in Excel
You can also ask me any questions either through the discussion field or by messaging me directly.
How is the course organized?
The course is currently divided 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
Main Challenges in Education. To be able to fix a system, we have to first understand what this system is trying to achieve. In this section, we will try to see how the Education System works.
How much does the Education System Cost? Before analyzing and optimizing, it is a good idea to estimate how much we really spend on the Education System. We will look at direct and indirect costs, along with externalities.
Make education more accessible. As we have mentioned, one of the directions to improve the Education System is to make it more accessible. In this section, we will look at examples of policies that may help you achieve that.
Provide a safe & supporting environment. The Education System has to provide a safe place for those who cannot look for support at home. In this section, we will look at how we can provide it.
Reduce the Costs of Education. The Education System can be very costly. In this section, we will look at some ways to lower the cost of the whole system.
Increase the Productivity of Students. A lot can be achieved by improving how students learn. You can impact the speed at which they learn, and this will impact both costs as well as future productivity.
Increase the Productivity of Teachers. Teachers have a huge impact on the costs and the effect of the Education System. In this section, we will look at their productivity.
Financial Model of a school. In certain situations, you may be asked to model not the whole system but rather a chain of schools. In this section, we will see how this can be done in practice.
You will also be able to download many additional resources
1. Useful frameworks and techniques
2. Analyses shown 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…
What are the main problems of the Education System
What tools can you use to improve the Education System
How to conduct a cost-benefit analysis in Excel
How to analyze potential improvements in Education
How to cut costs in the Education System
How to create the financial model of a chain of schools in Excel
Who should take this course? Who should not?
Management Consultants
Business Analysts
Startup Founders who are working in areas related to Education
Project Managers
People responsible for improving the Education
Politicians
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