RA: Retail Planning,Assortment Analytics with Excel & Python

BY
Udemy

Mode

Online

Fees

₹ 2999

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 2,999
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

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
  • Average transaction value and average selling price
  • 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 square foot
  • Actual stocks vs Budgeted Stocks
  • Conversion Rate explanation
  • Average selling price and shrinkage rate
  • ROI
  • 30 cents on the dollar
  • Mark-ups vs Margins
  • 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

  • Intro
  • Budgeting
  • 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 calculations
  • 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

Instructors

Mr Haytham Omar
Consultant in Supply chain
Freelancer

M.E /M.Tech., Ph.D

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books