
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
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.
We will start by looking at how you can model such businesses in Excel. We will look at 3 businesses. First, we will see how you can model a consulting firm. We will also explore 2 totally different businesses: a logistics firm delivering parcels to parcel lockers and a firm offering its robots as a service
Next, we will move on to the business model of B2B services. They behave a little bit differently from the B2C service. I will show you the main challenges they are facing, KPIs that matter in B2C service, and examples of companies. At the end, I will show you how to model a consulting business in Excel.
I will shortly go through things that are important in other B2B Services.
In the next lecture, I will show you the main drivers of the B2C model, and on the basis of this, we will create a business model in Excel. I will concentrate on the example of a restaurant chain
Here we will discuss the models of a service company and a consulting firm. It is an introduction to modelling in Excel
Before I show you the model in Excel, I want to present to you in this lecture the overall logic
I showed you the consulting firm model in Excel during the lecture. After modifying it, you can use it for your purposes (we attach the Excel files to the lecture). This model will let you check whether your business idea makes sense.
I showed you the consulting firm model in Excel during the lecture. After modifying it, you can use it for your purposes (we attach the Excel files to the lecture). This model will let you check whether your business idea makes sense.
Imagine that you were hired by a firm that wants to produce robots that will help automate work in the hospitality industry.
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 section, I will share with you examples of sales analysis that you may have to do during consulting projects.
In this section, I will discuss the main challenges in sales and marketing in B2B Services. We will also go through a number of cases and business analyses devoted to sales and marketing in B2B Services. We will go through many cases, including consulting, analytical services, and aircraft maintenance
B2B Service firms use mainly their own sales force team. However, more and more options are available. We will discuss this subject in this lecture.
In this lecture, I will show you what matters most in marketing in this business model.
There are a number of challenges in the Sales and Marketing in B2B Services. We will discuss them in this lecture briefly to give you a taste of what you can expect during a consulting project.
Here, I show you how to calculate the price and the profitability of a consulting project using a fixed fee and time and materials formula. You will get a template in Excel, shown in the lecture as an attachment in the additional resources
Here, I show you how to analyze the profitability of sales channels in Consulting
Here, we show how to analyze the profitability of sales channels
Here, we show how to analyze the profitability of sales channels
In B2B Services, since you already have a nice base, you try to sell them more of your products. The best example are big 4 auditing companies. I will discuss the general preconditions for cross-selling and introduce the case we will be solving in the next lectures.
In this lecture, I will show you how to solve the case shown in the previous lectures.
Quite often, it makes sense to remove some of your customers. In this lecture, I will discuss when you should do it, and we will do a short introduction to the case study
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
The price formula in B2B services can drastically impact the margins and net profit. In this lecture, we will go through a case that will show you how to approach the analysis of a price formula with uncertainty on the scenario that will happen.
In this lecture, I will show you how to solve the case shown in the previous lectures.
In this lecture, I will show you how to solve the case shown in the previous lectures.
I will show you in this lecture how new customers can be acquired using a case study of a fitness club
Here, I will show you the solution to the previously introduced case
In this lecture, I will show you how to solve the case shown in the previous lectures
In this lecture, I will show you how to solve the case shown in the previous lectures
This course contains the use of artificial intelligence.
What is the aim of this course?
Consulting firms are hired very often to help improve Service Businesses that operate in the B2B segment. Those projects are extremely interesting, yet pretty difficult. Quite often, you not only have to increase profits or scale, but also to improve the customer service. Therefore, in this course, I will teach you how to perform, fast and efficiently, different types of analyses devoted to Service Businesses operating in the B2B segment.
In the course, you will learn the following things:
How to model different B2B Services Businesses in Excel
How to find potential improvements in B2B Services
How to analyze in Excel the potential improvements
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, SMCG, 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 are now 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 345 000 students, including people working in EY, 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 Excel files, as well as additional presentations and materials shown in the lectures. As 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?
As the Service Businesses become bigger, they are more likely to hire consultants to help them develop their business. Unfortunately, not that many consulting firms have experience in Service Businesses. On top of that, many service businesses used to be production businesses or internal departments in big conglomerates. Most firms don’t give you the full toolbox that you need to analyze fast and efficiently B2B Service Businesses. This may lead to huge frustration during such projects.
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 B2B Service Businesses. 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 devoted to B2B Service Businesses. You will master how to analyze data and draw conclusions from the analyses.
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 B2B Service Businesses. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who have come across similar businesses during their work. The course will help you become an expert in analyzing and improving B2B Service Businesses 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 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:
How to model different B2B Services Businesses in Excel
How to find potential improvements in B2B Services
How to analyze in Excel the potential improvements
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
Modeling B2B Services in Excel. We will start by looking at how you can model such businesses in Excel. We will look at 3 businesses. First, we will see how you can model a consulting firm. We will also explore 2 totally different businesses: a logistics firm delivering parcels to parcel lockers and a firm offering its robots as a service.
Sales Analyses in B2B Services. In this section, I will share with you examples of sales analysis that you may have to do during consulting projects.
Sales Funnels in B2B Services. In this section, I will explain the so-called funnel analysis, and we will see how you can use it to improve the B2B Service Businesses.
Sales Forecasting Case Studies. In the fourth section, you will see, based on 2 case studies, how you can create simple forecast models.
Case Studies in B2B Services. In the last section, we will look at other topics, not related to sales analysis. You will learn how to lower labor costs, reduce cash gap, estimate the impact of improving the speed of the service, and much more.
You will be able also 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…
How to model a B2B Service Business in Excel
Improve sales in a B2B Service Business
Estimate potential improvements in Excel
Increase profits
How to use Sales Funnels in the case of B2B Service Businesses
Analyze in Excel sales and operations
Who should take this course? Who should not?
Management Consultants and Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers
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