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.

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

Description

“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.

English
language

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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO

Check Today's 30+ Free Courses on Telegram!

X