get app
    • Home
    • Udemy
    • Courses
    • RA Retail Planning Assortment Analytics with Excel and Python

    RA: Retail Planning,Assortment Analytics with Excel & Python

    BY
    Udemy

    Brochure Enquire
    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

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Cyber Security Courses Data Science Courses Law Courses Digital Marketing Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses NPTEL Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    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