DEMAND PLANNING COURSE
Become a Demand Planner — and Build a Career Companies Fight For
Learn to forecast sales, manage inventory, and drive profits — with real tools used by FMCG companies.
Learn to forecast sales, manage inventory, and drive profits — with real tools used by FMCG companies.
You will learn how to:
- Build accurate Sales Forecasts in Excel and Power BI
- Improve Forecast Accuracy (MAPE, Bias) with real models
- Use tools like SAP, Anaplan, o9, Power BI
- Apply Machine Learning to short- and long-term planning
- Run S&OP cycles and integrate forecasts into ERP systems
- Learn from real cases: Nestlé, Danone, Castrol, Starbucks
This course is for you if:
- You’re an analyst or planner ready to grow in operations, finance, or supply chain
- You work in FMCG, retail, e-commerce or manufacturing and want to upgrade your forecasting skills
- You're part of a team launching or improving S&OP or IBP processes
- You want to apply Machine Learning to real business forecasting
- You're switching careers and want a job-ready skill in 6–8 weeks
- You work in a mid-sized company and want to apply best global practices from Nestlé, Unilever, P&G and others
What You Will Learn
-
1. Introduction to Demand Planning
- What is Demand Planning and why it matters in business
- Strategic vs. Tactical vs. Operational planning
- Role of the Demand Planner in S&OP
- Data sources: sales history, marketing, CRM, weather
- Real cases: Nestlé, Mars, Starbucks
-
2. Types of Demand and Data Sources
- Independent vs. Dependent demand (with FMCG examples)
- Key data sources: historical sales, CRM, promo, POS data
- External drivers: weather, macroeconomics, search trends
- Common pitfalls: OOS, duplicate SKUs, promo distortion
- Cases: Target Canada failure, Starbucks weather impact, Unilever demand sensing
-
3. Forecasting Methods
- Qualitative methods: Delphi, expert opinions, analogy-based forecasting
- Time Series: Moving Average, Exponential Smoothing, ARIMA, ETS (Excel, Python)
- Causal Models: Regression using price, promo, and weather as drivers
- Machine Learning: Prophet, XGBoost, LSTM (P&G, Starbucks examples)
- Dynamic regression, lag effects, and calendar events
-
4. Forecast Accuracy and Improvement
- Core metrics: MAPE, RMSE, Bias, Tracking Signal
- How to analyze forecast errors and manage Bias
- Forecast Value Added (FVA): who really improves accuracy
- Tools: Excel calculators, Power BI dashboards
- Cases: Castrol, Coca-Cola, BIC
-
5. Collaboration and Integration
- S&OP process: from Demand Review to Executive Meeting
- IBP and Connected Planning platforms (SAP IBP, Anaplan, o9)
- Roles and responsibilities: RACI, process KPIs
- Real cases: Danone, BIC global planning system, Unilever IBP
-
6. Practice and Real Business Cases
- Building a forecast from raw data (Excel, Power BI)
- Scenario planning: Base, Best, Worst cases
- What-if analysis and risk simulations (Excel + Python)
- Final project: forecast, accuracy calculation, dashboard, and presentation
-
7. Advanced Strategies and Foresight
- Hierarchical and grouped forecasting (Top-down, Bottom-up, Middle-out)
- Ensemble models and AutoML for complex demand patterns
- Forecast strategy and culture: governance and maturity models
- Technology Roadmapping (3 horizons: BI → ML → AI)
- Patent and scientific trend analysis for market foresight
- S-Curve for product lifecycle and demand maturity
-
8. Career and Job Skills for Demand Planners
- Career paths: Analyst → Demand Planner → S&OP Lead → Head of Planning
- Skills for 2025+: BI, Python, Machine Learning, storytelling, facilitation
- How to create an ATS-friendly CV and optimize LinkedIn profile
- Real job descriptions from Nestlé, Danone, Unilever
- Downloadable CV template and LinkedIn checklist
-
9. Tools & Templates You’ll Get
- Excel: Forecast models (ETS, ARIMA), accuracy calculators (MAPE, Bias), scenario planning templates
- Power BI: Interactive dashboards for S&OP, forecast accuracy, scenario simulation
- Python: Ready-to-use scripts for ARIMA, Prophet, XGBoost, anomaly detection
- Business Templates: S&OP deck, RACI chart, data quality checklist, technology roadmap
This isn’t just a course — it’s a full career upgrade.
Master a skill that companies value at €30,000+ per year — and start applying it right away.
Master a skill that companies value at €30,000+ per year — and start applying it right away.
Take a free Modul 1. Introduction to Demand Planning
By clicking the button, you consent to the processing of personal data and agree to the privacy policy.
The course will be released on
September 1, 2025
September 1, 2025
Demand Planning on-line course
SKU: DP-01
150 EUR
200 EUR
An online course for those who want to understand and implement professional Demand Planning.
Learn how forecasts are built, what mistakes large companies make, and how to structure an accurate planning process.
Includes Excel and Power BI templates, real-world case studies from Nestlé, Unilever, Mars, Coca-Cola, Starbucks, and more.
Perfect for logistics professionals, analysts, marketers, and business owners.
7 modules, 28 lessons.
Learn how forecasts are built, what mistakes large companies make, and how to structure an accurate planning process.
Includes Excel and Power BI templates, real-world case studies from Nestlé, Unilever, Mars, Coca-Cola, Starbucks, and more.
Perfect for logistics professionals, analysts, marketers, and business owners.
7 modules, 28 lessons.
