Master the Demand Planner profession (demand forecasting) from scratch in 8 weeks
FMCG practice + real cases from Nestlé, Unilever, BIC, Castrol, Starbucks. Excel / Power BI / Python templates. Metrics Forecast Accuracy, Bias, FVA. Author — Demand Planner with 20+ years of experience in international FMCG companies.
Practice
Excel • Power BI • PythonMethods
MA • ES • ARIMA • MLMetrics
FA • MAPE • Bias • FVAWhy it matters
- Fuzzy forecast = losses: excess inventory and lost sales.
- Every miss means frozen cash and lower service levels.
- Demand Planner is among the most in-demand jobs of 2025.
- FMCG/retail/e-commerce actively hire Forecast Accuracy specialists.
What you’ll get in practice
- Excel workbooks: MA/ES/Regression, MAPE/Bias/FVA, forecast versions.
- Power BI dashboard: accuracy, trends, promo, scenarios.
- Python scripts: ARIMA/Prophet, ML features, Demand Sensing.
- S&OP templates: calendar, roles, consensus minutes.
During the course you will learn to
Forecast & visualize
Build forecasts in Excel and dashboards in Power BI: MA, ES, Regression, ARIMA/Prophet; use Machine Learning and Demand Sensing.
Manage accuracy
Calculate MAPE, Bias, FVA and defend the numbers to leadership.
Run S&OP
Organize S&OP/IBP: roles, calendar, artifacts, consensus and escalations.
This course is for you if you
Are an analyst/finance professional looking to move into a Demand Planner role.
Work in FMCG/retail/e-commerce and want to level up forecasting.
Take part in S&OP/IBP and want to understand how the forecast is built.
Need ML tools without deep coding.
Plan a career jump and income from 5000 EUR/month.
A student of a related major who wants to master the Demand Planner role faster.
Course plan — 12 modules, 130+ topics
Introduction to the role
What Demand Planning is and why it matters. Roles, artifacts, and quick wins in the first 30 days.
Data sources
Sales history, CRM, external factors and Big Data; data quality and forecast versioning.
Forecasting methods
From Excel models to ML: MA/ES/Regression, ARIMA, Prophet, LSTM, ensembles.
Forecast accuracy
MAPE, Bias, FVA, Power BI dashboards, error analysis and improvements.
Collaborative planning (S&OP/IBP)
Roles, processes, consensus; integration with Supply/Finance/Marketing.
Financials
P&L, cash flow, promo effects, KPIs and strategic alignment.
FMCG practice & cases
Nestlé, Unilever, Castrol, BIC, Ritter Sport — real situations and solutions.
Practical psychology for Demand Planners
Cross-functional communication, dealing with stress and deadlines, influence and emotional intelligence.
Files & templates
Excel
- MA/ES/Regression (auto-tuning)
- MAPE/Bias/FVA + version comparison
- S&OP calendar and minutes
Power BI
- Forecast Accuracy / Bias / FVA
- Promo analysis and scenarios
- Baseline/Promo/ML versions
Python
- ARIMA/Prophet, cross-validation
- Feature store for ML + Sensing
- Export of results to Excel/BI
How to start learning
Choose the format: try for free or purchase the full course right away
Access to the free module
“Introduction to Demand Planning” + a few open lessons
- Lessons on basic concepts (Demand Planning, Forecast)
- FMCG examples and interactive tasks
- Excel checklist for first steps
Full course — 500 EUR
12 modules • 8 weeks • 130+ topics • FMCG practice
- Excel/Power BI/Python templates for work
- Methods: MA, ES, Regression, ARIMA/Prophet, ML
- Final project + access to updates
Enroll at the early-bird price
We’ll send access to the free module and files (Excel/Power BI/Python). Payment after review.
What’s included
- 12 modules, 150+ topics, 8 weeks
- Excel/Power BI/Python files for work
- Practice with real FMCG cases
- Access to recordings and updates
Questions: natalia.elizarova@demandplanningcourse.com
