RA: Retail Planning,Assortment Analytics with Excel & Python

EP2: Learn Python, Retail Budgeting and Metrics, OTB planning, Inventory and Assortment of retail space and price.

4.63 (180 reviews)
Udemy
platform
English
language
Data & Analytics
category
RA: Retail Planning,Assortment Analytics with Excel & Python
14,257
students
19.5 hours
content
Mar 2024
last update
$74.99
regular price

What you will learn

Make a retail Budget from A-Z

OTB

Learn Python and Analytics

merchandising

Assortment planning

Optimization

Python

Excel

Metrics

Operations

Conversion rate

Merchandise

Retail

Inventory

Consignment

Budget

Budgeting

Assortment

Why take this course?

New update : Forecast for OTB calculation with AutoML is added (Aug 2023)


"This is one of the three courses in the Retail Series by RA, each course can be taken independently."



Master Retail planning and analytics with Excel and Python

Retailers face fierce competition every day and keeping up with the new trends and customer preferences is a guarantee for excellence in the modern retail environment. one Keyway to excel in retail management is utilizing the data that is produced every day. It is estimated that We produce an overwhelming amount of data every day, roughly 2.5 quintillion bytes. According to an IBM study, 90% of the world’s data has been created in the last two years.


Retail analytics is the field of studying the produced retail data and making insightful data-driven decisions from it. as this is a wide field, I have split the Program into three parts.


Retail Planning and assortment analytics with Excel & Python.

1- Retail Metrics

2- Metrics in Python.

3- Budgeting.

4- Retail Planning in Python.

5- Retail Buying.

6- Assortment Optimization.

7- Managing Retail Inventory with Python.

8- Managing stocks based on Types.




Don't worry If you don't know how to code, we learn step by step by applying retail analysis!

*NOTE: Full Program includes downloadable resources and Python project files, homework and Program quizzes, lifetime access, and a 30-day money-back guarantee.

Who this Program is for:

· If you are an absolute beginner at coding, then take this Program.

· If you work in Retail and want to make data-driven decisions, this Program will equip you with what you need.

· If you are switching from Excel to a data science language. then this Program will fast-track your goal.

· If you are tired of doing the same analysis again and again on spreadsheets and want to find ways to automate it, this Program is for you.


Program Design

the Program is designed as experiential learning Modules, the first couple of modules are for retail metrics followed by Python programming fundamentals, this is to level all of the takers of this Program to the same pace. and the third part is retail applications using Data science which is using the knowledge of the first two modules to apply. while the Program delivery method will be a mix of me explaining the concepts on a whiteboard, Presentations, and Python-coding sessions where you do the coding with me step by step. there will be assessments in most of the sections to strengthen your newly acquired skills. all the practice and assessments are real retail use cases.





Content

Retail Metrics

Introduction
Curriculum
Intro To Benchmarking
Benchmarking
Retail Metrics
Operational metrics
Operational metrics excel
Inventory metrics
Inventory Metrics in excel
Inventory turnover
Tesco- Walmart - Kroger
Gross Margin and Net Profit
Assets Metrics
Cash to Cash Cycle time Intro
Cash to cash cycle time
Cash to Cash in excel
Keys to Improve
Data Orientation
Quiz on metrics
Summary

Welcome to Python

Python
Downloading Anaconda
Installing Anaconda
Spyder Overview
Jupiter Notebook Overview
Python Libraries
Inventories Package

Python Crash Course

Intro
Dataframes
Arithmetic Calculations with python
Lists
Dictionaries
Arrays
Importing data in python
Subsetting Data frames
Conditions
Writing functions
Mapping
for loops
For looping a function
Mapping on a data frame
For looping on a dataframe
Summary
Assignment
Answer Part 1
Assignment answer 2

Manipulation and cleaning of Retail Data.

Intro
Dropping Duplicates and NAs
Conversions lecture
Conversions
Filterations
Imputations
Indexing toutorial
Slicing index
Manipulation Lecture
Group by
Slicing the group by
Dropping levels
The Proper form
Pivot tables
Aggregate functions in pivot table
Melting the data
Left join
Inner and outer join
Joining in python
Inner, left and full join
Summary
Assignment
Answer 1
Answer 2
Answer 3
Answer 4
Answer 5

Metrics in Python

Intro
Preparing data for conversion rate
Conversion rate
Daily orders
Dictionary for orders
ATV, UPT and ASP
Operational Metrics conclusion
Stocks Discovery
Daily Sales
Creating Common Keys
Creating a year week key
Average weekly
Joining sales with stocks
Calculating inventory turnover
Conclusion
Section 2 Assignment
Assignment answer
Summary

Managing Retail through metrics

Mark-ups and Margins
Top line and Bottom line
Sales per squarefoot
Actual stocks vs Budgeted Stocks
Conversion Rate explanation
Average selling price and shrinkage rate
ROI
30 cents on the dollar
Mark-ups vs Magins
Supplier Retailer Margin Dynamics
Practical example inside python
Retail Price, actual price and Dollar Markdowns
Calculating Margin and Markups
Markdowns Percentage
Weeks of stocks
Weeks of stocks part2
VMC
Quiz
Summary

Budgeting

Budgeting Intro
Budgeting Introduction
Forecasting is the trigger point
Budgeting Components
Top Down Forecasting for budget
Bottom Up
OTB
Budget - Art of retail buying
Budget Markdowns and Stock turns
End to month stocks
Conclusion
Budgeting-Seasonality
OTB planning
OTB by category
OTB planning method 2
Variations to plan
Assignment budgeting
Assignment Answer
Summary

Assortment Planning

Assortment Intro
Assortment planning
Brand Assortment Planning
Store Persona and Planograms
Seasonal Calendar Assortment
Space Planning
Space assortment Modeling
Modeling sales against retail space
Predicting sales with log model
Building assortment optimization model
Maximizing Retail Space Profit
Assortment in Python
Coefficients
Developing the Optimization Function
Optimizing
Assortment assignment
Assortment answer

Price assortment planning

Inventorize Package
Introduction
Competing Products
Relation among products
Multi-variate Regression in python
Multinomial choice models
Multinomial Logit models
Multi-competing Products in Python
Competing Products Summary

Managing inventory-Seasonal Products

Intro
Managing inventory
Seasonal Products
Seasonal Products
Points of maximum profits
How much I will sell?
Data Table
Critical Ratio
Critical ratio in excel
What is actually happening
Critical ratio in python
Preparing Data for MPN
Creating Margin pf error in python
Applying MPN on all data
Conclusion
Seasonal inventory Summary
Assignment
Assignment answer

Managing inventory- Staple Products

Intro
Variability in supply chain
Demand Lead-time
Calculating Average daily demand
Method 1 for safety stock caclulations
Method 2 for safety stock calculations
Preparing the data for safety stock calculations
Calculating average and standard deviation
Segmentation of data for service level
Re-order point for all Skus
Rae-order point conclusion
Leadtime Variability
Leadtime variability in python
Summary
Assignment
Assignment Explanation
Final Message

Screenshots

RA: Retail Planning,Assortment Analytics with Excel & Python - Screenshot_01RA: Retail Planning,Assortment Analytics with Excel & Python - Screenshot_02RA: Retail Planning,Assortment Analytics with Excel & Python - Screenshot_03RA: Retail Planning,Assortment Analytics with Excel & Python - Screenshot_04

Reviews

Keegan
January 20, 2023
i dont think its a problem, i think im more the problem because it was a bit harder to understand the pronunciations, but he is extremely knowledgeable
Abhishek
December 17, 2021
This is an amazing course designed very well and easy to understand. Anyone who is interested in learning about key metrics used in Retail Stores using Excel and Python.
Mohamad
July 23, 2021
This course is such a great deal for anyone who’s interested to learn about inventory control and how targeted sales is being achieved in the end of the month.
Asli
July 10, 2021
A very comprehensive course from the beginning to the end about Retail analytics. With no doubt, you can not miss this course if you are in retail business. Thanks Haytham for this amazing course!
Jaume
July 9, 2021
I entered this course with little knowledge about python, and now I leave like a little expert. 100% for newcomers to Python.
Pratyush
July 1, 2021
till now I am enjoying this course but i expected topics in more detail. A knowledge which is use full for fetching job in retail sector. More practical and industrial knowledge.
Noof
March 25, 2021
To the point information. you will be amazing. the couple video content i saw, allow me to understand a-lot.. Don't hesitate to join this course.. Thanks Alot
Ayman
March 17, 2021
His content always unique and very useful, he continued his efforts in courses with full power.. thanks dr.haitham
Jennifer
March 15, 2021
The course was just what I was looking for to upgrade my skills in retail Planning. I highly recommend this to those looking to bridge the gap in Retail Analytics using Excel with Python

Coupons

DateDiscountStatus
10/19/202189% OFF
expired
10/22/2021100% OFF
expired
11/8/2021100% OFF
expired
11/14/2021100% OFF
expired
12/9/2021100% OFF
expired
12/22/2021100% OFF
expired
7/8/2023100% OFF
expired
7/27/2023100% OFF
expired

Charts

Price

RA: Retail Planning,Assortment Analytics with Excel & Python - Price chart

Rating

RA: Retail Planning,Assortment Analytics with Excel & Python - Ratings chart

Enrollment distribution

RA: Retail Planning,Assortment Analytics with Excel & Python - Distribution chart
3774014
udemy ID
1/14/2021
course created date
2/28/2021
course indexed date
Bot
course submited by