E-commerce for Management Consultants & Business Analysts

Focused View

Asen Gyczew

3:53:15

46 View

01 - Introduction

001 Introduction.mp4

02:53

002 How the course is organized.mp4

03:10

003 A little bit about me.mp4

01:47

004 How to deal with Blurry image.mp4

02:04

005 How to reach additional resources.mp4

01:06

external-links.txt

02 - Essential Concepts

001 Essential Concepts Introduction.mp4

01:26

001 E-commerce-v21-upload-version.pdf

002 Introduction to e-commerce.mp4

03:28

003 Examples of e-commerce businesses.mp4

01:53

004 Logic flow of customers in e-commerce.mp4

01:09

005 Main KPIs for e-commerce.mp4

09:36

006 Main challenges in e-commerce.mp4

04:51

007 E-commerce financial model the Basic Version.mp4

09:10

007 e-commerce-ENv2.xlsx

03 - Modeling Cash Flow in e-commerce

001 Essential-Finance-Accounting-v22-upload-version.pdf

001 Modeling Cash Flow in e-commerce Introduction.mp4

01:30

002 Cosmetics E-commerce Case Introduction.mp4

02:29

003 Cosmetics E-commerce Data Available.mp4

04:34

003 E-commerce-model-with-CFv8-Empty.xlsx

004 Cosmetics E-commerce Sales & Margin & Head Office Costs.mp4

03:24

004 E-commerce-model-with-CFv8-Partial.xlsx

005 Cosmetics E-commerce P&L.mp4

04:59

006 Cosmetics E-commerce How to get from Net Profit to Cash Flow.mp4

05:03

007 Cosmetics E-commerce Some comments on Working Capital.mp4

03:47

008 Cosmetics E-commerce Back to Excel.mp4

02:41

008 E-commerce-model-with-CFv8-Partial.xlsx

009 Cosmetics E-commerce Working Capital, Capex, Debt.mp4

03:56

009 E-commerce-model-with-CFv8.xlsx

010 Cosmetics E-commerce Cash Flow.mp4

03:53

011 Cosmetics E-commerce Interest Received.mp4

01:13

012 Cosmetics E-commerce How to create a Flexible Model.mp4

03:12

012 E-commerce-model-with-CFv8-Flexi-Version.xlsx

04 - Funnel Analysis

001 Funnel Analysis Introduction.html

002 What is Funnel Analysis Introduction.mp4

00:43

003 Definition of a Funnel Analysis.mp4

02:59

004 How to use a funnel analysis.mp4

02:21

005 How to present a Funnel.mp4

01:41

006 E-commerce Sales Funnel.mp4

04:55

007 Potential Improvements in e-commerce Case Introduction.mp4

02:33

008 E-commerce-sales-funnel-improvement-v2-Empty.xlsx

008 Potential Improvements in e-commerce Data Available.mp4

05:17

009 E-commerce-sales-funnel-improvement-v2.xlsx

009 Potential Improvements in e-commerce Solution.mp4

03:55

05 - Sales Funnels by Cohorts

001 Funnel Analyses by Cohorts Introduction.mp4

00:44

002 Cohort Analysis.mp4

03:55

003 Sales funnels by cohorts.mp4

02:44

004 Sales Funnel by Cohorts in Consulting Firm Case Introduction.mp4

00:58

005 Cohort-Sales-Funnel-consultingv3-Empty.xlsx

005 Sales Funnel by Cohorts in Consulting Firm Data Available.mp4

01:28

006 Cohort-Sales-Funnel-consultingv3.xlsx

006 Sales Funnel by Cohorts in Consulting Firm Solution.mp4

04:30

06 - Advanced model of e-commerce

001 Advanced Modeling of E-commerce.mp4

01:15

002 Fashion E-commerce Case Introduction.mp4

04:17

003 E-commerce-model-Fashion-v7-Empty.xlsx

003 Fashion E-commerce Data Available.mp4

03:46

004 E-commerce-model-Fashion-v7-up-to-Gross-Margin.xlsx

004 Fashion E-commerce Traffic, Sales & Gross Margin.mp4

05:05

005 E-commerce-model-Fashion-v7-up-to-SM-Costs.xlsx

005 Fashion E-commerce Cost of Acquring Customers.mp4

05:12

006 E-commerce-model-Fashion-v7-up-to-PL.xlsx

006 Fashion E-commerce P&L.mp4

04:38

007 E-commerce-model-Fashion-v7-up-to-Debt.xlsx

007 Fashion E-commerce Working Capital, Capex, Debt.mp4

04:16

008 E-commerce-model-Fashion-v7.xlsx

008 Fashion E-commerce Cash Flow.mp4

03:35

07 - Customer Acquisition

001 Customer Acquisition Introduction.mp4

01:20

002 Customer Acquisition Definition.mp4

03:07

003 Cost reduction framework.mp4

03:01

004 How to lower Customer Acquisition (CAC).mp4

07:07

005 Customer Lifetime Value (LTV).mp4

03:19

006 How to increase LTV Examples.mp4

02:31

007 How to increase LTV General Framework.mp4

04:51

008 Payback Time.mp4

03:18

external-links.txt

08 - 2-sided markets (marketplaces)

001 Introduction to 2-sided market.mp4

01:38

002 Examples of 2-sided market businesses.mp4

02:55

003 Logic flow of customers in 2-sided market.mp4

01:09

004 Main KPIs for 2-sided market.mp4

03:16

005 Main challenges in 2-sided market.mp4

05:50

006 2-sided market financial model Basic version.mp4

09:42

006 marketplace-EN.xlsx

007 Marketplace Sales Funnel.mp4

04:34

09 - Multichannel

001 Multichannel Introduction.html

002 What is multichannel.mp4

02:14

003 Main problems with multichannels.mp4

03:56

004 Pricing dilemma Problem.mp4

01:57

005 Pricing dilemma Solution.mp4

02:42

006 Cannibalization of sales by offline Introduction.mp4

02:13

007 Cannibalization of sales by online Introduction.mp4

02:32

008 Cannibalization of sales Case Study.mp4

01:19

009 Cannibalization of sales Tips how to estimate it.mp4

01:01

010 Cannibalizationv4.xlsx

010 Cannibalization of sales Case Study Calculation in Excel.mp4

03:42

external-links.txt

10 - Conclusions

001 Bonus Lecture.html

Description

A practical guide on how to model, analyze and improve e-commerce businesses

What You'll Learn?

The drivers of the e-commerce business model
Conduct analyses of e-commerce in Excel during consulting projects
How to model e-commerce business in Excel
How to analyze potential improvements in e-commerce
How to model marketplaces
How to do funnel analysis in e-commerce
How to measure and lower the costs of acquiring customers (CAC)
How to measure and increase the Lifetime Value of the Customer (LTV)

Who is this for?

Management Consultants

Business Analysts

Managers

Financial Controllers

Investment Analysts

Startup Founders

What You Need to Know?

Basic or intermediate Excel

Basic knowledge of economics

Basic or intermediate knowledge of finance & accounting

More details

Description
What is the aim of this course?
The share of online purchases is constantly growing. We have a lot of pure players, but also traditional businesses build their own e-commerce business units. Consulting firms are quite often hired to help analyze and improve e-commerce businesses. Those projects are interesting yet challenging. Luckily, there are a lot of interesting techniques and frameworks that will help you analyze and model e-commerce during consulting projects. In this course, I will teach how to perform fast and efficiently different types of analyses related to e-commerce.
In the course, you will learn the following things:
The drivers of the e-commerce business model
Conduct analyses of e-commerce in Excel during consulting projects
How to model e-commerce business in Excel
How to analyze potential improvements in e-commerce
How to model marketplaces
How to do funnel analysis in e-commerce
How to measure and lower the costs of acquiring customers (CAC)
How to measure and increase the Lifetime Value of the Customer (LTV)
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 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 a 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 were already taken by more than 181 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. Therefore, 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?
E-commerce has become an important business unit for the majority of Retailers and Consumer Brands (especially FMCG and SMCG). It behaves differently than traditional businesses and you have to adjust your approach to the new situation. Most firms donâ€™t give you the full toolbox that you need. 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 will need during consulting projects devoted to e-commerce. 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 e-commerce. 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 the e-commerce business model. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business school. The course will help you become an expert in e-commerce 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:
The drivers of the e-commerce business model
Conduct analyses of e-commerce in Excel during consulting projects
How to model e-commerce business in Excel
How to analyze potential improvements in e-commerce
How to model marketplaces
How to do funnel analysis in e-commerce
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
Essential Concepts. We will start with some essential concepts around e-commerce. This will help us later on with more advanced issues. We will also see how to create a basic e-commerce model in Excel.
Modeling Cash Flow in e-commerce. 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.
Funnel Analysis. Funnel Analysis can be used to map and analyze a series of events that lead to a particular goal. In this section, we will discuss what is a funnel analysis and how you can use it to achieve better business results.
Sales Funnels by Cohorts. Quite often you want to go deeper and analyze how the sales funnel looks like for different segments, and cohorts. This is when cohort analysis comes in handy. We will discuss it in this section.
Advanced model of e-commerce. In some cases, you will have to create more complex models of e-commerce. In this section, we will see how this can be done in practice.
Customer Acquisition. Without customer acquisition, you will not enjoy much growth. In e-commerce, you will spend a lot of time on optimizing and finding more optimal ways to acquire customers. In this section, you will learn how to analyze and optimize customer acquisition.
2-sided market. Many e-commerce businesses will try to expand their business by becoming a marketplace, which is a type of 2-sided market. We will discuss it in this section.
Multichannel. In this section, we will discuss the so-called multichannel and I will show you the main challenges in this concept
You will be able also to download many additional resources
Useful frameworks and techniques
Analyses showed in the course
Additional resources
Links to additional presentations, articles, and movies
Links to books worth reading
At the end of my course, students will learn:
The drivers of the e-commerce business model
Conduct analyses of e-commerce in Excel during consulting projects
How to model e-commerce business in Excel
How to analyze potential improvements in e-commerce
How to model marketplaces
How to do funnel analysis in e-commerce
Who should take this course?
Management Consultants
Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
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
Who this course is for:
Management Consultants
Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders

User Reviews

Rating

average 0

Total votes0

Focused display

Expert in performance improvement, scaling businesses, and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 500 million) and startups. I have trained in person over 100 consultants, business analysts, and managers who now are Investment Directors, CEO, Partners in PE and VC funds, Sales and Marketing Directors, Operational Directors, COO, Directors in Consulting Companies, Supply Chain Directors, Board Members, etc. Functional experience: performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence, turn-arounds, PMO; Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending, fashion, toys), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing), foodtech, marketplacesCountries: Poland, Serbia, Russia, Ukraine

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.