image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

What is the aim of this course?
   
Retail has become very competitive. We have the rise of e-commerce and multichannel, and buyers' behavior has also changed drastically. This leads to lower margins. As a Business Analyst or Management Consultant, you have to be able to analyze the Retailer you work for fast and find possible improvements. This course will help you drastically improve your knowledge and skills in optimizing Retail business through a series of practical cases. It is designed for people who want to become consultants, business analysts or have to run and optimize Retail business on a daily basis. In the course you will learn 6 things:   
How to
analyze Retailer
and find low-hanging fruits   
How to
build the business model of the Retailer in Excel
in order to see the big picture and see how specific KPIs impact the profit   
How to
optimize Retailers' operations
   
How to
behave in a multichannel surrounding
(when you have also e-commerce operations)   
How to
expand your business
into new categories and markets   
How to
analyze in-store engagements
   
There will be also many growth hacks that Retailers use.   
The course is based on my 15 years of experience in Retail as well as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement, and turn-arounds in the biggest companies from Retail, FMCG, SMG, and B2B sectors that I worked for. I worked for retailers in home improvements, pharmaceuticals, vending, kids products, convenience stores, electronics, wood products, and many more so what you will see in this course are observations drawn from many industries.  I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained over 100 consultants, business analysts, and managers who now are CEOs, Operational  Directors, COOs, Investment Directors, Directors in Consulting Companies, Board Members, Customer Insight Managers, Data Science Managers, etc. On top of that my courses on Udemy have already been taken by more than
224 000 students.
The course you will take has been taken also by people from
EY, McKinsey, PwC, Walmart, Booz Allen Hamilton, Dell, Walgreens,
and many more as a part of Udemy for Business.
I teach through cases so most of the lectures are case studies showing some business problems solved in Excel. There will be also an overview of the main techniques used in optimizing and running retail. To every lecture, you will find attached  (in additional resources) the Excels 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?
   
Retail has become quite complex and there is a shortage of business analysts and consultants that have a good understanding of how to approach retail. There is a lack of knowledge on how to get a broader view of the retail business and at the same time to be able to go deep into details. Even people working for years in retail have problems with seeing the whole picture and being able to find potential savings. Therefore, I have decided to create a course that will bridge this gap. This course will transform you into a retail expert in a relatively short time and help you see all the elements of the business. The approach you will see in this course was tested on humans and I have seen tremendous positive results. Thanks to this course you will become a priceless member of any team that is doing strategic and operational improvements projects in retail. It will help you land a job not only with retailers but also with consulting firms, and private equities investing in retail.   
To sum it up, I believe that if you want to build or to find improvements in retail you should master the techniques shown in this course. That is why I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to retail managers, and analysts already working in retail or in PE.
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 find and analyze production. 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
analyze Retailer
and find low-hanging fruits   
How to
build the business model of the Retailer in Excel
in order to see the big picture and see how specific KPIs impact the profit   
How to
optimize Retailers' operations
   
How to
behave in a multichannel surrounding
(when you have also e-commerce operations)   
How to
expand your business
into new categories and markets   
How to
analyze in-store engagements
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 into the following sections:   
Introduction.
We begin with a little intro into the course as well as some general info on retail 
Basic analyses that you should perform.
In the second section, I will discuss the basic type of analysis that you can use to better understand the business that you work for. Here you will find the potential low-hanging fruits   
Retail Business Model.
As a business analyst or consultant, you may be asked to model the whole business in Excel. I will show you in this section how to do it and you will get ready-made models. I will also show you how to model e-commerce. 
Optimization of in-store processes – case study.
In section 4 I show you how to optimize processes in the store. I will use here a real case of a company from the home improvement / DIY sector. You will get also the model we used to calculate costs   
Business Hacks used by Retailers
. It is always good to look at what others are doing. Here I will show you some hacks used by other retailers   
Expansion
. At some point, you will start considering expansion. I will show you in this section how you can expand your retail      business and how to decide what to do   
Multichannel.
As e-commerce has been a significant distribution channel traditional retailers were forced to transform into multichannel players (operating both in traditional stores, the offline world as well as online business) Here I will show you the main challenges and how to tackle them   
In-store engagement and productivity analysis
. If you have data on the customer behavior in the store you can get nice insight and craft a better strategy to grow your business. Here I will show you examples of such analyses that we did with Retailnext – a system to collect data on customer behavior in the store.   
You will be able also to download many additional resources
:
Excels with analyses shown in the course
Presentation of slides shown in the course   
Links to additional presentations and movies   
Links to books worth reading
Who this course is for:
Management Consultants interested in Retail
Business Analysts
Operations Directors in Retail
Investment Directors in Private Equity
Controllers
Planning and allocation specialists

What you'll learn

Analyze retail business and find improvements especially low hanging fruits

Model the retail business in Excel and draw conclusions out of this

Optimize retail operations – make them faster, cheaper and at higher quality

You will be able to build expansion strategy

You will know what to look for when you move to multichannel

You will learn how to analyze the behavior of customers in the stores

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
6
1.1-Introduction
1.2-About me
1.3-Main Topics in retail you have to know
1.4-Structure of the course
1.5-What to do if a blurry image appears
1.6-How to find additional resources
2-Modeling Retail Business in Excel
12
2.1-Introduction to retailer business model
2.2-Main challenges in Retail
2.3-Business model of Retail - main drivers
2.4-Business model of Retailer in Excel - transaction version - 1 store
2.5-Business model of Retailer in Excel - transaction version - retail chain
2.6-Business model of Retailer in Excel - sq m version
2.7-Financial Model for a Retailer
2.8-E-commerce business model - intro
2.9-E-commerce business model - Excel example
2.10-More on e-commerce
2.11-More on marketplaces
2.12-Subscription Business Model
3-Basic analyses that you should perform
12
3.1-Basic analyses - Introduction
3.2-Issue tree - introduction
3.3-Issue tree example for a retailer
3.4-Analyses of stores by cohorts - Introduction
3.5-Analyses of stores by cohorts - Example
3.6-Product range analysis - Introduction
3.7-Product range analysis - Example
3.8-Inventory analysis - Introduction
3.9-Inventory analysis - Excel
3.10-Store checks - examples in retail
3.11-Store checks - examples in restaurants
3.12-How to use store checks to check a specific location?
4-Optimization of in-store processes – case study
27
4.1-Optimization of in-store processes - Introduction
4.2-Workshop - Introduction
4.3-Workshop – the scope of the project
4.4-Workshop – Tools overview
4.5-Lean manufacturing - introduction
4.6-Theory of constraints - introduction
4.7-Queuing problem - introduction
4.8-OEE - introduction
4.9-Workshop – defining metrics and cost drivers
4.10-Workshop – optimizing 1 process
4.11-Workshop – optimizing 1 process - Excel file
4.12-Workshop – timeline of the project
4.13-Introduction to in-store process optimization case
4.14-The store and the processes
4.15-Price Change
4.16-Price Change - calculation in Excel
4.17-Shelf replenishment
4.18-Shelf replenishment - calculation in Excel
4.19-Advising customers - Introduction
4.20-Advising customers - General solution
4.21-Advising customers - Details and results
4.22-Advising customers - calculation in Excel
4.23-Cash till and info point
4.24-Other potential improvements
4.25-Process cost estimation by groups
4.26-Summary of all costs and savings
4.27-How to optimize the head office?
5-Business Hacks used by Retailers
5
5.1-IKEA - low cost retailer
5.2-Biedronka - low cost retailer
5.3-Showroom - leveraging via strategic partner
5.4-Zappos - leveraging via strategic partner
5.5-Cinema City - selling the unsued
6-Expansion strategy
17
6.1-Introduction to Expansion
6.2-Expansion of current model - options
6.3-Saturating existing markets - intro
6.4-Saturating existing markets – Introduction
6.5-Saturating existing markets – Data for the case study
6.6-Saturating existing markets – Number of Stores
6.7-Saturating existing markets – Stores by concepts
6.8-Saturating existing markets – Concept & Space
6.9-Saturating existing markets – Solution in Power Point
6.10-Saturating existing markets – WaterFall Graph
6.11-Expansion strategy into other countries - introduction
6.12-Expansion strategy into other countries – Case Introduction
6.13-Expansion strategy into other countries – Data for the case study
6.14-Expansion strategy into other countries – Which function to use
6.15-Expansion strategy into other countries – Solution in Excel
6.16-Expansion strategy into other countries – Solution in Power Point
6.17-Overview of segmentation methods
7-Multichannel
9
7.1-What is multichannel?
7.2-Main problems with multichannels
7.3-Pricing dilemma - case study - Problem
7.4-Pricing dilemma - case study - Solution
7.5-Cannibalization of sales by offline - Introduction
7.6-Cannibalization of sales by online – Introduction
7.7-Cannibalization of sales - case study
7.8-Canibalization - tips how to solve the case study
7.9-Cannibalization of sales - case study - Calculation in Excel
8-Supply Chain in Retail
18
8.1-Introduction to Retail Supply Chain
8.2-Overview of Supply Chain in Retail
8.3-Main challenges in Supply Chain in Retail
8.4-Introduction to cases for Retail
8.5-Groceries – warehouse optimization – Introduction
8.6-Groceries – warehouse optimization – Current Cost estimation
8.7-Groceries – warehouse optimization – Potential improvements
8.8-Groceries – warehouse optimization – Estimation of savings in Excel
8.9-Measuring the capacity of Central Warehouse – Introduction
8.10-Measuring the capacity of Central Warehouse – Tips
8.11-Measuring the capacity of Central Warehouse – Capacity in Excel
8.12-Measuring the capacity of Central Warehouse – Cost in Excel
8.13-Convenience stores - Analysis of tariffs – Introduction
8.14-Convenience stores - Analysis of tariffs – Tips how to do it
8.15-Convenience stores - Analysis of tariffs – Solution
8.16-DIY - internal logistics optimization – Introduction
8.17-DIY - internal logistics optimization – Solution
8.18-DIY - internal logistics optimization – Solution in Excel
9-In-store engagement and productivity analysis
7
9.1-Introduction to in-store engagement
9.2-KPIs that you should follow - Retailnext
9.3-Examples of engagement analyses that you can make - Part 1
9.4-Examples of engagement analyses that you can make - Part 2
9.5-Examples of engagement analyses that you can make - Part 3
9.6-Examples of engagement analyses that you can make - Part 4
9.7-Main rules according to which people behave
10-How to manage tests
13
10.1-How to manage tests – Introduction
10.2-Definition of a Funnel Analysis
10.3-Funnel Anlayses in Testing – Introduction
10.4-Definition of Funnel Analyses in Testing
10.5-Funnel Analyses in Testing – the Process
10.6-How you can find ideas worth testing
10.7-Ranking of Ideas in Fashion – Case Introduction
10.8-Ranking of Ideas in Fashion – Data Avaialble
10.9-Ranking of Ideas in Fashion – Ranking and Self-checkout
10.10-Ranking of Ideas in Fashion – Cost Benefit Analysis
10.11-Analysis of Tests results in Fashion – Case Introduction
10.12-Analysis of Tests results in Fashion – Data Available
10.13-Analysis of Tests results in Fashion – Solution
11-Additional Resources worth checking
1
11.1-How to scale up a business – best practices from top firms
12-Conclusions
1
12.1-Bonus Lecture