Course Overview
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 analysts or management consultants, work in management consulting, or do a lot of business analysis 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 the biggest companies from the FMCG, SMG, and B2B sectors 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 are now Investment Directors, Senior Analysts, Directors in Consulting Companies, Board Members, etc. On top of that, my courses on Udemy have already been taken by more than 315 000 students.
I teach through cases, so most of the lectures will be case studies showing some business problems solved in Excel. I will also show you the main techniques used by Management Consultants to properly structure the business analysis. To most lectures, 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 modifications, be applied by you in your work.
Why have 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 a huge problem with properly analyzing intermediate and advanced issues – they are usually preoccupied with current activities and have close to no time for analysis and strategic decisions. Moreover, they do not know how to approach many subjects from an analytical point of view to make sure that they are making 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 as operational and strategic analyses in FMC, SMCG, and B2B companies, including also online models like e-commerce, SaaS, and marketplaces.
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 do the analyses, as well as the quality of the conclusions coming out of the available data in your company. 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:
How to structure business analysis so you get the right results fast?
How to analyze different aspects of sales, marketing, and operations?
How to draw conclusions from those analyses – both for current operations as well as strategic ones?
How to be efficient in your work as a business analyst or management consultant?
How to build Excel files and PowerPoint presentations so that it is understandable for you and your team, even after some time?
You can also ask me any questions either through the discussion mode 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 intro into the course as well as some general info on the role of business analyst – what skills, education, and knowledge are 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 business analysis from the beginning to the end
Improving the results of a cinema - example of business analysis - example of business analysis. In this section, I will again show slowly 1 example of business analysis from the beginning to the end
Tools. In the second section, we briefly go through the main tools and concepts for business analysts. We devote some time to the most popular ones: Excel and PowerPoint
Sales & Marketing. Analyzing the market, sales activities, and efficiency, and the potential for expansion are some of the most typical tasks set for business analysts. Here, I provide you with plenty of practical, real-life examples of problems and solutions
Business modeling - example of analysis. On some occasions, you analyze the whole business to see what the logic behind it is. Here, we show how to do it for some of the business models
Operations. Quite often, business performance depends on Operational Excellence. In this section, we will show you examples of analysis from 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 also be able to download many additional resources
Excel files with the analyses shown in the course
Presentation of slides shown in the course
Links to additional presentations and movies
Links to books worth reading
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction 6 bài · 11 phút
Chương 2 How to create a top-notch business analysis in 8 steps 11 bài · 26 phút
- Introduction to business analyses Học thử 4:01
-
Prepare the end results of your analysis 4:02
- Create the logical structure for the analysis Học thử 1:29
-
TV market estimation - Case that we will work on 1:34
-
TV market estimation - Logical structure - Solution 2:48
-
Transform the logical structure of the analysis into Excel - Introduction 1:06
-
Transform the logical structure of the analysis into Excel - TV market example 2:06
-
Gather data 1:04
-
Fill in the Excel and the presentation 3:32
-
Presentation and discussion 2:49
-
Summary of how to create a top-notch analysis in 8 steps 1:05
Chương 3 Ceramic tiles market estimation - example of business analysis 5 bài · 11 phút
-
Introduction to the ceramic tiles case 1:00
-
Ceramic tile market – Case Introduction 1:29
-
Ceramic tile market – Solution 3:13
-
Ceramic tile market – Solution in Excel 4:34
-
Ceramic tile market – Presentation in Power Point 1:09
Chương 4 Improving the results of a cinema - example of business analysis 5 bài · 11 phút
-
Introduction to the KPIs for cinema case 0:52
-
KPIs for cinema - case to be solved 0:33
-
KPIs for cinema - solution 1:53
-
KPIs for cinema - solution in Excel 5:15
-
KPIs for cinema - Presentation in Power Point 1:57
Chương 5 Essential Excel Functions 18 bài · 47 phút
-
We will go through some Excel functions
-
Excel – Main Function you should master 0:55
-
VLOOKUP – Introduction 3:46
-
VLOOKUP with approximate match – Introduction 2:33
-
What you can use the VLOOKUP for? 1:37
-
Basic VLOOKUP usage 3:20
-
Some comments on basic VLOOKUP 1:58
-
How to assign categories using VLOOKUP? 2:58
-
How to use HLOOKUP? 1:37
-
The logic of MATCH function 2:32
-
How to assign categories based on 2 criteria using VLOOKUP and MATCH function? 3:52
-
How to assign categories based on 2 criteria using HLOOKUP and VLOOKUP function 2:44
-
Why NOT to use IF function 1:56
-
How to use if function? 1:42
-
How to use VLOOKUP instead of IF function? 3:45
-
How to use IFERROR function? 2:11
-
How to use MAX and MIN instead of IF function 4:08
-
Pivot tables – Introduction 5:28
Chương 6 Main tools and techniques used by Business Analyst 16 bài · 49 phút
-
Main tools and techniques - introduction 0:55
-
Excel - basic rules for every Business Analyst 4:22
-
Power Point - how it should be used by business analyst 5:47
-
Bottom-up approach 7:53
-
Top-down approach 3:45
-
Backward logic 2:43
-
Compounded effect 1:52
-
Issue tree 1:44
-
Issue tree - example in Logistics 1:42
-
Issue tree - example from retail 3:46
-
Opportunity Tree 3:19
-
OEE and OLE 3:10
-
Cost drivers 2:32
-
Theory of constraints and bottlenecks 3:14
-
5 Whys 2:45
-
Data Visualization
Chương 7 Sales and marketing analyses - examples 33 bài · 1 giờ 37 phút
-
Sales and marketing analyses - introduction 1:10
-
Catchment area / reach analysis - B2B 3:50
-
Efficiency of marketing activities 8:19
-
Sales and margin efficiency in retail 15:39
-
Sales channel analysis - case in FMCG 3:06
-
Saturating existing markets – General thoughts 1:00
-
Saturating existing markets – Case Introduction 1:11
-
Saturating existing markets – Data for the case study 3:12
-
Saturating existing markets – Number of Stores 3:09
-
Saturating existing markets – Stores by concepts 3:04
-
Saturating existing markets – Concept & Space 3:46
-
Saturating existing markets – Solution in Power Point 1:57
-
How to motivate not yours sales reps – Case Introduction 2:33
-
How to motivate not yours sales reps – Trainings 4:58
-
How to motivate not yours sales reps – Contests 2:17
-
How to motivate not yours sales reps – Incentive trips 2:32
-
How to motivate not yours sales reps – Loyalty program 2:19
-
How to motivate not yours sales reps – Summary and Comparison in Excel 2:01
-
How to motivate not yours sales reps – Solution in Power Point 2:26
-
How to shorten the lifespan of a product – Case Introduction 1:59
-
How to shorten the lifespan of a product – General rules 3:49
-
How to shorten the lifespan of a product – Current Situation 2:46
-
How to shorten the lifespan of a product – Fad 2:35
-
How to shorten the lifespan of a product – Lower Costs 1:46
-
How to shorten the lifespan of a product – Simplify Exchange 1:23
-
How to shorten the lifespan of a product – Parameters 2:24
-
How to shorten the lifespan of a product – Comparison 1:22
-
How to shorten the lifespan of a product – Solution in Power Point 1:56
-
What will be the effect of the price increase – Introduction 2:09
-
What will be the effect of the price increase – Solution - Impact on coffee only 4:01
-
What will be the effect of the price increase – Solution – full impact 2:34
-
Overview of segmentation methods
-
Sales Analyses - Summary
Chương 8 Business modeling - example of analyses 10 bài · 1 giờ 3 phút
-
Business Modeling - introduction 1:35
-
E-commerce business model - intro 20:57
-
E-commerce business model - Excel example 9:10
-
Business model of a restaurant in Excel - Basic model 9:11
-
Business model of a restaurant in Excel - Advanced model 8:58
-
Mechanics of business model for a consulting firm 2:26
-
The business model of a consulting firm in Excel - Capacity and revenues 2:54
-
The business model of a consulting firm in Excel - costs and profit & loss 5:05
-
Financial models vs Business Models 2:38
-
Other Business models
Chương 9 Operations - Production, Supply Chain - examples of analyses 13 bài · 1 giờ 4 phút
-
Operation analyses - introduction 0:23
-
Cases Studies that we will solve in this section
-
OEE analysis 6:10
-
Removing bottlenecks 5:23
-
Optimal production batch analysis - FMCG 6:37
-
2-stage production planning - example of cosmetics producers preparing bundles 5:32
-
Top-down approach for a FMCG - introduction 8:27
-
Top down approach for a FMCG - tips how to do it 15:26
-
Top down approach for a FMCG - solution 6:23
-
Car Industry – Planning the flow of finished goods – Introduction 0:33
-
Car Industry – Planning the flow of finished goods – Excel - First Option 6:12
-
Car Industry – Planning the flow of finished goods – Excel - Second Option 3:02
-
Operations Analysis - Summary
Chương 10 Cases for training analytical skills - Market Estimation 4 bài · 7 phút
-
Business analyst cases - introduction 1:09
-
Market estimation introduction 2:30
-
Estimation of kids wear market - case to be solved 1:11
-
Estimation of kids wear market - solution 2:10
Chương 11 Cases for training analytical skills - Sales and Marketing 11 bài · 24 phút
-
Sales and marketing cases - introduction 0:57
-
Sales channels comparison - Problem 0:50
-
Sales channels comparison - Solution 2:32
-
Potential for growth - retailer - Problem 0:27
-
Potential for growth - retailer - Solution 4:23
-
Efficiency of sales and marketing activities in consulting firm - Problem 2:20
-
Efficiency of sales and marketing activities in consulting firm - Solution 5:14
-
Pricing in multichannel surrounding - Problem 1:57
-
Pricing in multichannel surrounding - Solution 2:42
-
How to expand strong brand in Retail - Problem? 0:26
-
How to expand strong brand in Retail - Solution 2:05
Chương 12 Cases for training analytical skills - Strategy 9 bài · 19 phút
-
KPIs for marketplace - Problem 0:37
-
KPIs for marketplace - Solution 2:57
-
What is the business model of IKEA - Problem 0:43
-
What is the business model of IKEA - Solution 6:03
-
What could be the business model for Google Car - Problem 0:39
-
What could be the business model for Google Car - Solution 3:14
-
Why a niche strategy makes sense - Problem? 1:06
-
Why a niche strategy makes sense - Solution 3:40
-
How to scale up a business – best practices from top firms
Chương 13 Cases for training analytical skills - Operations 6 bài · 10 phút
-
Content marketing agency - how to increase it's output? - Problem 1:03
-
Content marketing agency - how to increase it's output? - Solution 1:54
-
How to improve line for cutting frozen fish? - Problem 1:21
-
How to improve line for cutting frozen fish? - Solution 3:25
-
How long will wait in the queue? – Problem 0:41
-
How long will wait in the queue? - Solution 1:48
Chương 14 Conclusions 1 bài
-
Bonus Lecture
Requirment
-
Basic knowledge of economics
-
Basic or intermediate Excel
Outcomes
-
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
0 Student
1 Course
0 review