Retail for Business Analysts and Management Consultants 

Introduction

About Me

Main topics in retail you have to know

Structure of the course

What to do if a blurry image appears

How to find additional resources

Introduction to retailer business model

Main challenges in Retail

Business model of Retail - main drivers

Business model of Retailer in Excel - transaction version - 1 store

Business model of Retailer in Excel - transaction version - retail chain

Business model of Retailer in Excel - sq m version

Financial Model for a Retailer

E-commerce business model - intro

E-commerce business model - Excel example

Basic analyses - Introduction

Issue tree - Introduction

Issue tree example for a retailer

Analyses of stores by cohorts - Introduction

Analyses of stores by cohorts - Example

Product range analysis - Introduction

Product range analysis - Example

Inventory analysis - Introduction

Inventory analysis - Excel

Store checks - examples in retail

Store checks - examples in restaurants

How to use store checks to check a specific location?

Optimization of in-store processes - Introduction

Workshop - Introduction

Workshop ? the scope of the project

Workshop ? Tools overview

Lean manufacturing - introduction

Theory of constraints - introduction

Queuing problem - introduction

OEE - introduction

Workshop ? defining metrics and cost drivers

Workshop ? optimizing 1 process

Workshop ? optimizing 1 process - Excel file

Workshop ? timeline of the project

Introduction to in-store process optimization case

The store and the processes

Price Change

Price Change - calculation in Excel

Shelf replenishment

Shelf replenishment - calculation in Excel

Advising customers - Introduction

Advising customers - General solution

Advising customers - Details and results

Advising customers - calculation in Excel

Cash till and info point

Other potential improvements

Process cost estimation by groups

Summary of all costs and savings

IKEA - low cost retailer

Biedronka - low cost retailer

Showroom - leveraging via strategic partner

Zappos - leveraging via strategic partner

Cinema City - selling the unused

Introduction to Expansion

Expansion of current model - options

Saturating existing markets - intro

Saturating existing markets ? Introduction

Saturating existing markets ? Data for the case study

Saturating existing markets ? Number of Stores

Saturating existing markets ? Stores by concepts

Saturating existing markets ? Concept & Space

Saturating existing markets ? Solution in Power Point

Saturating existing markets ? WaterFall Graph

Expansion strategy into other countries - introduction

Expansion strategy into other countries ? Case Introduction

Expansion strategy into other countries ? Data for the case study

Expansion strategy into other countries ? Which function to use

Expansion strategy into other countries ? Solution in Excel

Expansion strategy into other countries ? Solution in Power Point