- 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
RA: Retail Planning,Assortment Analytics with Excel & Python
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
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
Articles
Popular Articles
prev
next
Latest Articles
prev
next