Retail for Business Analysts and Management Consultants

Retail for Business Analysts and Management Consultants, available at $74.99, has an average rating of 4.5, with 135 lectures, based on 2973 reviews, and has 13457 subscribers.

You will learn about 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 This course is ideal for individuals who are Management Consultants interested in Retail or Business Analysts or Operations Directors in Retail or Investment Directors in Private Equity or Controllers or Planning and allocation specialists It is particularly useful for Management Consultants interested in Retail or Business Analysts or Operations Directors in Retail or Investment Directors in Private Equity or Controllers or Planning and allocation specialists.

Enroll now: Retail for Business Analysts and Management Consultants

Summary

Title: Retail for Business Analysts and Management Consultants

Price: $74.99

Average Rating: 4.5

Number of Lectures: 135

Number of Published Lectures: 128

Number of Curriculum Items: 135

Number of Published Curriculum Objects: 128

Original Price: $79.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Management Consultants interested in Retail
Business Analysts
Operations Directors in Retail
Investment Directors in Private Equity
Controllers
Planning and allocation specialists

Target Audiences

Management Consultants interested in Retail
Business Analysts
Operations Directors in Retail
Investment Directors in Private Equity
Controllers
Planning and allocation specialists

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 Retailerand 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 Retailerand 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: About me

Lecture 3: Main Topics in retail you have to know

Lecture 4: Structure of the course

Lecture 5: What to do if a blurry image appears

Lecture 6: How to find additional resources

Chapter 2: Modeling Retail Business in Excel

Lecture 1: Introduction to retailer business model

Lecture 2: Main challenges in Retail

Lecture 3: Business model of Retail – main drivers

Lecture 4: Business model of Retailer in Excel – transaction version – 1 store

Lecture 5: Business model of Retailer in Excel – transaction version – retail chain

Lecture 6: Business model of Retailer in Excel – sq m version

Lecture 7: Financial Model for a Retailer

Lecture 8: E-commerce business model – intro

Lecture 9: E-commerce business model – Excel example

Lecture 10: More on e-commerce

Lecture 11: More on marketplaces

Lecture 12: Subscription Business Model

Chapter 3: Basic analyses that you should perform

Lecture 1: Basic analyses – Introduction

Lecture 2: Issue tree – introduction

Lecture 3: Issue tree example for a retailer

Lecture 4: Analyses of stores by cohorts – Introduction

Lecture 5: Analyses of stores by cohorts – Example

Lecture 6: Product range analysis – Introduction

Lecture 7: Product range analysis – Example

Lecture 8: Inventory analysis – Introduction

Lecture 9: Inventory analysis – Excel

Lecture 10: Store checks – examples in retail

Lecture 11: Store checks – examples in restaurants

Lecture 12: How to use store checks to check a specific location?

Chapter 4: Optimization of in-store processes – case study

Lecture 1: Optimization of in-store processes – Introduction

Lecture 2: Workshop – Introduction

Lecture 3: Workshop – the scope of the project

Lecture 4: Workshop – Tools overview

Lecture 5: Lean manufacturing – introduction

Lecture 6: Theory of constraints – introduction

Lecture 7: Queuing problem – introduction

Lecture 8: OEE – introduction

Lecture 9: Workshop – defining metrics and cost drivers

Lecture 10: Workshop – optimizing 1 process

Lecture 11: Workshop – optimizing 1 process – Excel file

Lecture 12: Workshop – timeline of the project

Lecture 13: Introduction to in-store process optimization case

Lecture 14: The store and the processes

Lecture 15: Price Change

Lecture 16: Price Change – calculation in Excel

Lecture 17: Shelf replenishment

Lecture 18: Shelf replenishment – calculation in Excel

Lecture 19: Advising customers – Introduction

Lecture 20: Advising customers – General solution

Lecture 21: Advising customers – Details and results

Lecture 22: Advising customers – calculation in Excel

Lecture 23: Cash till and info point

Lecture 24: Other potential improvements

Lecture 25: Process cost estimation by groups

Lecture 26: Summary of all costs and savings

Lecture 27: How to optimize the head office?

Chapter 5: Business Hacks used by Retailers

Lecture 1: IKEA – low cost retailer

Lecture 2: Biedronka – low cost retailer

Lecture 3: Showroom – leveraging via strategic partner

Lecture 4: Zappos – leveraging via strategic partner

Lecture 5: Cinema City – selling the unsued

Chapter 6: Expansion strategy

Lecture 1: Introduction to Expansion

Lecture 2: Expansion of current model – options

Lecture 3: Saturating existing markets – intro

Lecture 4: Saturating existing markets – Introduction

Lecture 5: Saturating existing markets – Data for the case study

Lecture 6: Saturating existing markets – Number of Stores

Lecture 7: Saturating existing markets – Stores by concepts

Lecture 8: Saturating existing markets – Concept & Space

Lecture 9: Saturating existing markets – Solution in Power Point

Lecture 10: Saturating existing markets – WaterFall Graph

Lecture 11: Expansion strategy into other countries – introduction

Lecture 12: Expansion strategy into other countries – Case Introduction

Lecture 13: Expansion strategy into other countries – Data for the case study

Lecture 14: Expansion strategy into other countries – Which function to use

Lecture 15: Expansion strategy into other countries – Solution in Excel

Lecture 16: Expansion strategy into other countries – Solution in Power Point

Lecture 17: Overview of segmentation methods

Chapter 7: Multichannel

Lecture 1: What is multichannel?

Lecture 2: Main problems with multichannels

Lecture 3: Pricing dilemma – case study – Problem

Lecture 4: Pricing dilemma – case study – Solution

Lecture 5: Cannibalization of sales by offline – Introduction

Lecture 6: Cannibalization of sales by online – Introduction

Lecture 7: Cannibalization of sales – case study

Lecture 8: Canibalization – tips how to solve the case study

Lecture 9: Cannibalization of sales – case study – Calculation in Excel

Chapter 8: Supply Chain in Retail

Lecture 1: Introduction to Retail Supply Chain

Lecture 2: Overview of Supply Chain in Retail

Lecture 3: Main challenges in Supply Chain in Retail

Lecture 4: Introduction to cases for Retail

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 25 votes
2 stars: 48 votes
3 stars: 344 votes
4 stars: 1111 votes
5 stars: 1445 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu