Udemy

RA: Retail Planning,Assortment Analytics with Excel & Python

Enroll Now
  • 15,400 Students
  • Updated 10/2025
4.6
(507 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
19 Hour(s) 22 Minute(s)
Language
English
Taught by
Haytham Omar-Ph.D
Rating
4.6
(507 Ratings)

Course Overview

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.

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.





Course Content

  • 13 section(s)
  • 208 lecture(s)
  • Section 1 Retail Metrics
  • Section 2 Welcome to Python
  • Section 3 Python Crash Course
  • Section 4 Manipulation and cleaning of Retail Data.
  • Section 5 Metrics in Python
  • Section 6 Managing Retail through metrics
  • Section 7 Budgeting
  • Section 8 Assortment Planning
  • Section 9 Price assortment planning
  • Section 10 Managing inventory-Seasonal Products
  • Section 11 Managing inventory- Staple Products
  • Section 12 Forecasting-OTB-AutoML Problem- Advanced manipulation with Pandas and Pycaret
  • Section 13 Keip

What You’ll 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


Reviews

  • D
    Dudekula Kullay sharif
    4.5

    Good

  • T
    Tarlis OLIVEIRA MACHADO
    5.0

    This is a very heavy and extensive course with theories assisted by real life examples. Thank you Omar for your explanations ☺️

  • A
    ADRIAN MORA
    4.5

    Excelente curso

  • F
    Feng Yuan
    1.0

    The explanation of key concepts contains fundamental inaccuracies, and the computational methods applied are neither methodologically sound nor logically consistent.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed