Business Analysis Fundamentals for Management Consultants
4.1 (132 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,285 students enrolled

Business Analysis Fundamentals for Management Consultants

Practical guide for Business Analysts and Management Consultants with exercises in Excel
4.1 (132 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,285 students enrolled
Created by Asen Gyczew
Last updated 7/2020
English
English [Auto]
Current price: $132.99 Original price: $189.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • 63 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Kill any discussion with solid data analysis
  • Do any business analysis 10x faster than your colleagues
  • Structure complex problems and solve them in Excel
  • Perform any business analysis in a very effective manner
  • Understand the main challenges in analyzing different aspects in sales, marketing and operations
  • Build business models for e-commerce, service companies and B2C services
  • You will get ready made examples of complex analyses from top-notch consulting companies
  • Learn top techniques and frameworks used in management consulting
Requirements
  • Basic knowledge of economics
  • Basic or intermediate Excel
Description

What is the aim of this course?

This course will help you drastically improve your knowledge and skills in business analysis through a series of practical cases. It is designed for people who want to become business analyst and management consultants, work in management consulting or do a lot of business analyses at their work. It is based on my 14 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for.  On the basis of what you will find in this course I have trained over 100 business analysts and management consultants who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members etc. On top of that my courses on Udemy were already taken by more than 28 000 students.

I teach through cases so most of the lectures will be a case study showing some business problem solved in Excel. I will also show you main techniques used by Management Consultants to properly structure the business analysis. To most lecture you will find attached  (in additional resources) the Excel 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 modification, be applied by you in your work.

Why I decided to create this course?

The companies I have worked with so far as a Board Member (I am usually, Chief Restructuring Officer VP responsible for Strategy and Development) still have huge problem with proper analyzing intermediate and advance issues – they are usually preoccupied by current activities and have close to no time for analysis and strategic decision. Moreover, they do not know how to approach many subjects from the analytical point of view to make sure that they are taking the right decision. Therefore, quite often they hire consultants who in turn lack the practical knowledge and experience. This course is my small contribution to improving both consulting as well operational and strategic analyses in FMC, SMCG, B2B companies including also on-line models like e-commerce, SaaS, marketplaces.

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 do the analyses as well as the quality of the conclusions coming out of available in your company data. 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 know:

  1. How to structure business analysis so you get the right results fast?
  2. How to analyze different aspect of sales, marketing, operations?
  3. How to draw conclusions from those analyses – both for current operations as well  ase strategic ones?
  4. How to be efficient in your work as a business analyst or management consultant?
  5. How to build Excels and Power Points so that it is understandable for you and your team, even after some time?

You can also ask me any question either through the discussion mode or by messaging me directly.

How the course is organized?

The course is divided currently in 5 sections and will be adding new section to address other important issues. Currently you will find the following sections:

  • Introduction. We begin with little intro into the course as well as some general info on the role of business analyst – what skills, education, knowledge is required from you and what are the available career paths  for you
  • How to create a top-notch business analysis in 8 steps. In this section I will show you how to structure a business analysis so you get the results you want fast.
  • Ceramic tiles market estimation - example of business analysis. In section 3 I will again show slowly 1 example of a business analysis from beginning till the end
  • Improving the results of a cinema - example of business analysis - example of business analysis. In section 3 I will again show slowly 1 example of a business analysis from beginning till the end
  • Tools. In the second section we briefly go through main tools and concepts for business analysts. We devote some time to the most popular ones: Excel an Power Point
  • Sales & Marketing. Analyzing the market, sales activities and efficiency, potential for expansion are one of the most typical tasks set for business analyst. Here I provide you with plenty of practical real-life examples of problems and solutions
  • Business modelling - example of analyses. On some occasion you analyze the whole business to see what is the logic behind. Here we show how to do for some of the business models
  • Operations. Quite often the business performance depends on Operational Excellence. In this section we will show you examples of analysis form logistics, production, production planning, and other supply chain issues.
  • Cases for training analytical skills - Market Estimation. This section will help you train your analytical skills using the market estimation cases
  • Cases for training analytical skills - Sales and Marketing. This section will help you train your analytical skills using the sales and marketing cases
  • Cases for training analytical skills - Strategy. This section will help you train your analytical skills using strategic cases
  • Cases for training analytical skills - Operations. This section will help you train your analytical skills using operational cases

We will be adding new sections in the coming months

 

You will be able also to download many additional resources

  1. Excels with analyses shown in the course
  2. Presentation of slides show in the course
  3. Links to additional presentations and movies
  4. Links to books worth reading
Who this course is for:
  • Management Consultants
  • Business Analysts
  • Researchers
  • Controllers
  • Small and medium business owners
  • Investment Directors
Course content
Expand all 129 lectures 06:42:21
+ Introduction
5 lectures 07:50

In this lecture we will explain why it makes sense to take the course, what you will get out of it and what you should look forward to. We will also explain the logic we used to build the course

Preview 01:30

A few words about your humble teacher

Preview 01:47

I will show you how the course is organized

Preview 01:24

Here I will show you what to do if a blurry image appears

How to deal with Blurry image
02:04

Here I will show you how to find additional resources attached to the coruse like Excel files, presentations, links etc.

How to reach additional resources
01:05
+ How to create a top-notch business analysis in 8 steps
11 lectures 25:36

In this section I will show you how to create a top-notch business analysis in 8 steps. This framework I will use later on all analysis that you will be shown here

Preview 04:01

You may find it  a bit surprising but the business analysis should be started from the end – the very slides you want to get as a results of your effort. It should also have the hypotheses that you are checking. Here I will show you how to do it

Preview 04:02

Most analysis will be done in Excel. Before you go into Excel it is better to construct the analysis on a piece of paper. If you have clear logical structure it will be easier to transfer it to Excel

Preview 01:29

Here I will show you the case that we will work on in this section. Have a look at the case and try to solve it on your own before you go any further

Preview 01:34

In this lecture I will show you the logical structure to the case presented in the previous lecture

Preview 02:48

Once you are done with the logical structure you should build the analysis in Excel on the basis of it

Preview 01:06

Here I will show you how to do the estimation in Excel for the previously mentioned case


Preview 02:06

Once the Excel is done you can move on to gather data to check your first rough estimation

Preview 01:04

The data you have gathered will be used in your business analysis. You can also fill in the slides prepared in the very beginning and modify it if needed

Preview 03:32

It’s time to discuss your analysis with some experts and the customers to validate its results

Preview 02:49

We summarize the whole process of preparing the business analysis

Preview 01:05
+ Ceramic tiles market estimation - example of business analysis
5 lectures 11:25

In this section I will do I little bit faster another case using the framework introduced in the previous section

Introduction to the ceramic tiles case
01:00

Here I present you the case. You will be asked to estimate the market for ceramic tiles

Ceramic tile market - case to be solved
01:29

In this lecture I will show you the logical structure to the case presented in the previous lecture

Ceramic tile market - solution
03:13

Once you are done with the logical structure you should build the analysis in Excel on the basis of it

Ceramic tile market - solution in Excel
04:34

The data you have gathered will be used in your business analysis. You can also fill in the slides prepared in the very beginning and modify it if needed

Ceramic tile market - Presentation in Power Point
01:09
+ Improving the results of a cinema - example of business analysis
5 lectures 10:30

In the next section I show how to estimate the potential improvement in a cinema

Introduction to the KPIs for cinema case
00:52

In this lecture I will show you the case you have to solve. As a first step you will have to define the KPIs that matter in the cinema business

KPIs for cinema - case to be solved
00:33

In this lecture I will show you the logical structure to the case presented in the previous lecture

KPIs for cinema - solution
01:53

Once you are done with the logical structure you should build the analysis in Excel on the basis of it

KPIs for cinema - solution in Excel
05:15

The data you have gathered will be used in your business analysis. You can also fill in the slides prepared in the very beginning and modify it if needed

KPIs for cinema - Presentation in Power Point
01:57
+ Main tools and techniques used by Business Analyst
16 lectures 49:57

In this section I will show you the main techniques that you should master to be greate at performing business analyses

Preview 00:55

Here I show basic rules for Excel that you should follow

Excel - basic rules for every Business Analyst
04:22

Here I show you a link to external resources where you can learn more about Excel that you should mastera

Excel - basic things you should know
00:28

Power Pointe presentation is the second most important tools to be used by Business Analyst in his work. After all it is not only important to analyse data and draw conclusions but also to show them in a nice manner to decision makers. Here you will learn basic rules on how to build your Power Point deck in fast and easy manner. You will see also some examples of good and bad slides. There are many advanced tools for presentation (i.e.) Prezi. Still Power Point is the most often used and widely accepted

Power Point - how it should be used by business analyst
05:47

In this lecture you will get to know our favorite method for first rough estimation – the bottom-up method. We give you also 2 examples with Excel calculation how to use it.

Preview 07:53

Top-down is the little brother of bottom-up approach – not used that often but still very useful for re-segmenting the market (niche an low cost strategy)

Preview 03:45

In this lecture I show the backward thinking /induction. This approach enables you to design the whole process, company on the bases of the expected outcome

Backward logic
02:43

In many cases you can get high end result from compounding effect in time or by getting small improvements in many areas. In this lecture I will explain the concept

Compounded effect
01:52

Issue tree is a simple yet powerful concept used in consulting for structuring discussion and picking the right topics to concentrate on. In this lecture I will show you the principles of using it as well as a practical example

Preview 01:44

Here I will show example of an issue tree in Logistics

Issue tree - example in Logistics
01:42

Here I will show example of an issue tree in Retail

Issue tree - example from retail
03:46

Opportunity tree is a tool that you can use to generate new ideas to improve your business by looking at main drivers of your business

Opportunity Tree
03:19

We show here how to use the so called OEE (Overall Equipment Efficiency) Analysis that shows you how efficient you are in using your resources. It is very useful for checking whether you use well machines and equipment

OEE and OLE
03:10

If you want to understand well a business you have to be able to identify the cost drivers that shape the business model. In this lecture I will show you how to do that

Cost drivers
02:32

In every company you have bottlenecks that limit your ability to go forward and deliver more goods and services. Here I will show you how to estimate what is the impact for the whole system and how you can remove improve them. I will use simple production example to show you the effect on the whole system. You will see how the bottleneck can shift from 1 shift to another. You will also learn how to prioritize where it make sense to invest to get the best results.

Before doing this lecture I strongly encourage you first to take the OEE lecture – we use the OEE concept here so if you are not familiar with it please start with OEE lecture as a warm-up.

Theory of constraints and bottlenecks
03:14

Here I present you a very useful techniques 5 Whys used to get down to the root cause, the real problem

5 Whys
02:45
+ Sales and marketing analyses - examples
31 lectures 01:37:13

I will show you what you will master in this section

Preview 01:10

In this lecture we show how you can measure and analyze what is the maximal reach of your B2B bussiness having in mind transportation costs and markups. We will provide you with fast way to identify potential customers and measure your targeted price on a specific foreign market

Catchment area / reach analysis - B2B
03:50

Here I will show you how to see which marketing activities you should bet on

Efficiency of marketing activities
08:19

In this lecture you will learn to calculate sales and margin density for a Retailer using pivot and sumifs function. I will also show you what conclusion you should draw from it.

Sales and margin efficiency in retail
15:39

Most producers / brand owners operate using many sales channels: wholesalers, own shops, e-commerce, marketplace etc. It makes sense to check how profitability looks across channels and what can e done to improve overall situation. I will show you how it cane be done with a simple Excel analysis and a pivot table. I will go also try to demonstrate what kind of conclusions can you draw and what should be your next steps, on the basis of the results you are getting form the analyses

Sales channel analysis - case in FMCG
03:06

We start by looking how you can estimate how many stores can a reatiler open. Here we will discuss the theory of reaching saturation point and in the next lectures we will use case study to do proper analysis

Saturating existing markets – General thoughts
01:00

We will now try to check in practice how to find saturation point for a retailer. In this lecture I will introduce the case that we will work with for the next few lectures. You will be asked to find the saturation for grocery store operating in Poland

Saturating existing markets – Case Introduction
01:11

Here I will show you the data we will use for solving the case study

Saturating existing markets – Data for the case study
03:12

In this lecture we solve previously introduced case.

Saturating existing markets – Number of Stores
03:09

In this lecture we solve previously introduced case.

Saturating existing markets – Stores by concepts
03:04

In this lecture we solve previously introduced case.

Saturating existing markets – Concept & Space
03:46

In this lecture we solve previously introduced case.

Saturating existing markets – Solution in Power Point
01:57

Let’s imagine that you have to decide which method to support sales reps that work for retailers will be the best one. Help you customer analyze which method is better. We will discuss what other methods are used by your competitors and what you should pay attention to in order to decide which methods is better

How to motivate not yours sales reps – Case Introduction
02:33

In this lecture I will show you the solution to previously introduced case study

How to motivate not yours sales reps – Trainings
04:58

In this lecture I will show you the solution to previously introduced case study

How to motivate not yours sales reps – Contests
02:17

In this lecture I will show you the solution to previously introduced case study

How to motivate not yours sales reps – Incentive trips
02:32

In this lecture I will show you the solution to previously introduced case study

How to motivate not yours sales reps – Loyalty program
02:19

In this lecture I will show you the solution to previously introduced case study

How to motivate not yours sales reps – Summary and Comparison in Excel
02:01

In this lecture I will show you the solution to previously introduced case study

How to motivate not yours sales reps – Solution in Power Point
02:26

Imagine that you are working for a ceramic tiles producer that wants to change the frequency at which customers are remodeling its houses. Your task is to analyze and decide which way is the best

How to shorten the lifespan of a product – Case Introduction
01:59

There are some standard ways to make people shorten the lifespan. In this lecture we will discuss them

How to shorten the lifespan of a product – General rules
03:49

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Current Situation
02:46

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Fad
02:35

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Lower Costs
01:46

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Simplify Exchange
01:23

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Parameters
02:24

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Comparison
01:22

In this lecture I will show you the solution to previously introduced case study

How to shorten the lifespan of a product – Solution in Power Point
01:56

The impact of the price change on your profit will depend on a few factors. I will discuss in this lecture on what you should take into account and how to calculate it . 

What will be the effect of the price increase – Introduction
02:09

In this lecture I will show you how to solve the case shown in the previous lectures 

What will be the effect of the price increase – Solution - Impact on coffee only
04:01

In this lecture I will show you how to solve the case shown in the previous lectures 

What will be the effect of the price increase – Solution – full impact
02:34
+ Business modeling - example of analyses
9 lectures 01:02:54

I will show you what you will master in this section

Preview 01:35

As a business analysts or a consultant you will have to from time to time create financial models. There are a bit different than business models. In business models you go into details of operations and you focus on getting the links on the KPIs. Those models are usually done for internal purposes, to manage in the right direction the business. Financial models on the other hand are more for external users. You concentrate in them on creating the picture of the business in a standardized, understood by everybody way. You also want to create the financial statements: profit & loss statement, balance sheet statement, cash flow statement

Financial models vs Business Models
02:38

Before I show you the model in Excel I want to present you in this lecture the overall logic

Mechanics of business model for a consulting firm
02:26

I show you in the lecture the model of the consulting firm in Excel. 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.

The business model of a consulting firm in Excel - Capacity and revenues
02:54

I show you in the lecture the model of the consulting firm in Excel. 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.

The business model of a consulting firm in Excel - costs and profit & loss
05:05

In this lecture you will get insight into the business model of different e-commerce companies. E-commerce businesses group is very diversified so we will try to show the similarities and the differences between concepts.. You will learn here the definition of this business model, see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect.

Preview 20:57

In this Lecture I will go through a business model of e-commerce and show you how you can model the behavior of the customer, acquisition methods and margins in Excel. Attached to this lecture you will find the file that I show in the video so download it and go through it. You can use it to model the e-commerce business you are analyzing

Preview 09:10

Excel gives you great opportunities to calculate whether your idea makes sense or not. For this you will use the knowledge you have gathered in the previous lectures on your concept, location and your customers. Excel is obviously less emotion than you and the model you will create here can be used as a cornerstone of your business plans. It shows also to banks and potential investors what is your cash flow. We start with a simple model so you can understand it and learn how to use it. 

Business model of a restaurant in Excel - basic model
09:11

In this lecture we make more advanced model. We introduce the traffic parameter and show how it is converted first into people that are engaged (stop and enter your restaurant) and later into customers (they buy something from you). Here we will be operating on 2 customer groups: first one eats at the restaurant; second one comes for take-aways. For both customer groups we calculate separate conversion rates and Average ticket (ATV). We still here show you a business model for a 1 restaurant

Business model of a restaurant in Excel - advanced model
08:58
+ Operations - Production, Supply Chain - examples of analyses
11 lectures 01:04:08

Here I will show you how you can analyse different aspect of sales and marketing. Examples will be taken from different industries - both B2C and B2B

Preview 00:23

We show here how to use the so called OEE (Overall Equipment Efficiency) Analysis that shows you how efficient you are in using your resources. It is very useful for checking whether you use well machines and equipment

OEE analysis
06:10

In every company you have bottlenecks that limit your ability to go forward and deliver more goods and services. Here I will show you how to estimate what is the impact for the whole system and how you can remove improve them. I will use simple production example to show you the effect on the whole system. You will see how the bottleneck can shift from 1 shift to another. You will also learn how to prioritize where it make sense to invest to get the best results.

Before doing this lecture I strongly encourage you first to take the OEE lecture – we use the OEE concept here so if you are not familiar with it please start with OEE lecture as a warm-up.

Preview 05:23

In this lecture you will learn how to calculate optimal batches and how to estimate savings when comparing to actuals batches. We will use his an example of juice producer

Optimal production batch analysis - FMCG
06:37

2-stage production planning (planning for assembling and bundles). In many cases you have to first prepare the components and then on the basis of this produce the end product. This requires certain amount of additional planning, especially taking into account that the same component can be in different end-products. I will show you here on the basis of example of cosmetics producer how to create such a production plan, assuming optimal production batches for components and taking into account the inventories.

2-stage production planning - example of cosmetics producers preparing bundles
05:32

During this lecture I will show you how on basis of small number of data create a model which will show you how logistics costs are created, on what stage and what is the biggest drivers. This in turn will enable you to apply 80/20 rule

Top-down approach for a FMCG - introduction
08:27

In this lecture we will give you some tips how to approach the case and show you the usage of the proper Excel functions

Top down approach for a FMCG - tips how to do it
15:26

In this lecture we solve the case with you, show you the outcome, interpret it and give you examples how the results can be presented in terms of Excel and slides

Top down approach for a FMCG - solution
06:23

Let’s have a look at car producer that is wandering which plant should supply to which country 

Car Industry – Planning the flow of finished goods – Introduction
00:33

In this lecture I will show you how to use solver to find optimal solution to the case of planning the flow of finished goods between factories and markets 

Car Industry – Planning the flow of finished goods – Excel - First Option
06:12

In this lecture I will show you how to use solver to find optimal solution to the case of planning the flow of finished goods between factories and markets 

Car Industry – Planning the flow of finished goods – Excel - Second Option
03:02
+ Cases for training analytical skills - Market Estimation
8 lectures 16:04

We start now cases that will help you strengthen your position as a Business Analyst with strong analytical skills

Business analyst cases - introduction
01:09

In this lecture I will show what cases we will solve in this section

Market estimation introduction
02:30

Imagine that you were asked to estimate the market for ceramic tiles. You have to ask yourself the following questions:

  • What is  meant here by “the market”? Annual sales or total ownership?
  • Do you want the market estimation to be in volumes or in values?
  • What is included in market? Should we include B2C or also B2B?
  • Are we talking about just ceramic tiles  or other connected products 
Estimation of TV market - case to be solved
01:34

In this lecture I show you the solution to the case you had to solve in the previous lecture

Estimation of TV market – solution
02:48

In this lecture I show you the solution to the case you had to solve in the previous lecture

Estimation of tile market - case to be solved
01:29

Imagine that you were asked to estimate the market for ceramic tiles. You have to ask yourself the following questions:

  • What is  meant here by “the market”? Annual sales or total ownership?
  • Do you want the market estimation to be in volumes or in values?
  • What is included in market? Should we include B2C or also B2B?
  • Are we talking about just ceramic tiles  or other connected products 
Estimation of tile market - solution
03:13

In this lecture I show you the solution to the case you had to solve in the previous lecture

Estimation of kids wear market - case to be solved
01:11

Imagine that you were asked to estimate the kid’s ware market

  • What do you mean by kids?
  • What products do you have in mind (i.e. toys, pampers,t-shirts)?
  • Do you want the market to be estimated in volumes or in values?
Estimation of kids wear market - solution
02:10
+ Cases for training analytical skills - Sales and Marketing
11 lectures 23:53

Here I will show you some simple cases from sales analysis

Sales and marketing cases - introduction
00:57

Imagine that as a consultant you were asked to analyze your client situation- FMCG producer that is using different channels of distribution. How would you check whether his using the right mix channels

Sales channels comparison - Problem
00:50

Here I will show you the solution to previous lecture

Sales channels comparison - Solution
02:32
Potential for growth - retailer - Problem
00:27

Here I will show you the solution to previous lecture

Potential for growth - retailer - Solution
04:23

Imagine that our consulting company is using 4 ways to acquire customers. Try to find the most efficient ways of acquiring customers? How would you do it

Efficiency of sales and marketing activities in consulting firm - Problem
02:20

Here I will show you the solution to previous lecture

Efficiency of sales and marketing activities in consulting firm - Solution
05:14

Imagine that you have a chain of physical stores and on-line store. What pricing would you use? How you would come up with the right pricing?

Pricing in multichannel surrounding - Problem
01:57

Here I will show you the solution to previous lecture

Pricing in multichannel surrounding - Solution
02:42

Imagine that you are a Retailers with 10 stores and very strong brand that are selling toys. How would you grow the business?

How to expand strong brand in Retail - Problem?
00:26

Here I will show you the solution to previous lecture

How to expand strong brand in Retail - Solution
02:05