RA: Retail Planning,Assortment Analytics with Excel & Python (Udemy.com)

RETAIL ANALYTICS · RETAIL BUDGETING · OTB PLANNING · ASSORTMENT OPTIMISATION · MERCHANDISING · PYTHON · AUTOML · INVENTORY · PYCARET · RETAIL PLANNING

★ Highest Rated on Udemy — The Retail Planning Course That Practitioners Trust

This course carries Udemy’s Highest Rated badge — earned by 15,400+ enrolled students who completed it and came back to recommend it with a sustained 4.6-star rating. In a category crowded with short overview courses, the Highest Rated badge signals something rarer: a program that retail professionals, buyers, merchandisers, and planners actually found useful in their day-to-day work.

★ Top Performer on Udemy for Business — Chosen by Retailers for Team Upskilling

This course is consistently selected through the Udemy for Business catalogue for retail team training — the platform used by companies like Nasdaq, Volkswagen, and Eventbrite to upskill their professionals. When retail companies search for a course to train their buying, planning, and merchandising teams in data-driven retail analytics, this is the course they find.

★ Built by a Retail Industry Consultant — Co-Founder of Keip, a SaaS Platform for Retail Management

Haytham is an active retail and supply chain consultant who works with retailers including Sephora France and Sharaf Group Dubai, and is the co-founder of Keip — a SaaS platform built specifically for retail management and analytics. The retail metrics, assortment frameworks, OTB models, and pricing techniques in this course are not textbook constructs. They come directly from live client work and from the product built for retail professionals at Keip. That practitioner depth is what separates this course from all other retail analytics programs on Udemy.

★ The Only Retail Course That Teaches Full Budgeting, OTB, and AutoML Forecasting Together

Most retail courses on Udemy cover one area: either metrics, or buying, or assortment, or inventory. This course covers all of them in one 19.5-hour program — and goes further. Section 6 teaches retail budgeting from A to Z: top-down and bottom-up forecasting, OTB planning, budget markdowns, end-of-month stock calculation, seasonality modelling, and OTB by category. Then, added by student demand in August 2023, a full AutoML chapter using PyCaret generates forecasts for OTB automatically. No other retail course on any platform does this.

★ Python Applied to Retail from Day One — No Coding Experience Required

This course is not Python theory followed by retail examples. It is retail problems, solved in Python, from the first section where metrics appear. Conversion rate, inventory turnover, safety stock for all SKUs, reorder points, assortment optimisation, competing product pricing, and ML forecasting — all built in Python, step by step, with the instructor coding alongside you. The Python crash course is fully included. No prior coding experience is needed at any point.

Retail is a data business. Every buying decision, every OTB plan, every assortment call, every markdown — all of them have a number behind them. Most retail professionals know this but lack the tools to build those numbers analytically. This course changes that. It is the only retail planning program on Udemy that combines Excel fundamentals with Python automation and AutoML forecasting in one 19.5-hour program — and it carries Udemy’s Highest Rated badge to prove that retail professionals find it useful.

The course follows the same proven progression as all programs in this series: metrics and theory in Excel first, Python second. But unlike generic Python courses, every section applies Python to a specific retail problem from day one: calculating conversion rate and inventory turnover across a live retail dataset, building an OTB budget with top-down and bottom-up forecasting, optimising assortment against retail space, modelling competing product pricing with multinomial logit models, calculating safety stock for all SKUs simultaneously, and using PyCaret AutoML to generate sales forecasts for OTB automatically — comparing, blending, and stacking models in minutes.

The retail frameworks in this course come from Haytham’s active consulting work with retailers including Sephora France and Sharaf Group Dubai, and from Keip — the SaaS platform for retail management that he co-founded in Bordeaux. Every metric, every OTB model, every assortment framework, and every pricing tool has been tested in real retail operations — not adapted from a textbook.

WHAT MAKES THIS COURSE DIFFERENT

[ FULL ]

End-to-end retail analytics in one program

Metrics, Python, budgeting, OTB, assortment optimisation, competing product pricing, seasonal inventory, safety stock, and AutoML forecasting — all in one 19.5-hour program. No other retail course covers this breadth.

[ SEPH ]

Built by an active retail consultant and SaaS founder

Haytham consults for retailers including Sephora France and Sharaf Group Dubai, and co-founded Keip — a SaaS platform for retail management. Every model in this course comes from live client work and real retail operations.

[ AUTO ]

AutoML for OTB forecasting — PyCaret included

Section 11 applies PyCaret AutoML to generate retail sales forecasts for OTB planning — running model comparison, blending, stacking, and future prediction automatically. Unique to this course.

TOOLS COVERED IN THIS COURSE

Microsoft Excel | Python | PyCaret (AutoML) | Inventorize | Jupyter Notebook / Anaconda

WHAT YOU WILL LEARN

✓ Calculate and benchmark operational, inventory, and financial retail metrics: conversion rate, inventory turnover, gross margin, cash-to-cash cycle time, assets metrics

✓ Apply retail metrics in Python: conversion rate, daily orders, average transaction value, and inventory turnover across a live retail dataset

✓ Build advanced Python data manipulation skills applied to retail data: pivot tables, joins, group-by, imputations, filtering, and melting

✓ Calculate retail buying metrics: mark-ups, margins, sales per square foot, actual vs budgeted stocks, shrinkage, ROI, markdown percentage, weeks of stock, and VMC

✓ Build a retail budget from A to Z: top-down and bottom-up forecasting, OTB planning, budget markdowns, seasonality modelling, and end-of-month stock calculation

✓ Plan OTB by category and apply two distinct OTB planning methods including variations to plan