Online Demand Forecasting Course & Certification
Forecasting Expert™
Generate More Accurate Forecasts automatically
VS
Through an immersive teaching experience
You have 4 weeks to save the company with the right forecasting process!
Story inspired by Edouard’s own experience that uses real company data and AI-Powered characters
(let’s keep it fun 😉)
Join certified students from companies like
The cost of innacurate forecasts
Bad forecasts often lead to a reactive approach where teams are compelled to address emergencies (the “firefighter syndrome”). This perpetual state of crisis management is a catalyst for increased stress and burnout among employees, hindering professional development.
How to improve your forecasting accuracy quickly?
Demand uncertainty can be driven by macroeconomic factors beyond individual
control, like financial crisis or inflation.
At a company level, we cannot change our organization or update our rigid ERP system in a few weeks only.
The focus should be on areas within your control: your own responsibilities and those of your team.
The solution we recommend is to:
- Assess your forecast maturity: the level of complexity of your forecasting process and models must match the level of your forecast maturity.
- Start immediately with simple action and tools: implement models in Excel. You can test quickly and practice by yourself to upskill.
- Improve your process & system: Only then, use your Excel tools as specifications for future developments in more advanced tools (if needed).
Meet the Directors & Define Clear Goals
Interactive Zoom meeting with the board of directors, when we need a forecast (or not), the costs of an inaccurate forecast, the three levels of forecast, forecast horizon & lead time, goals meetings with each director, forecasting goals matrice tool, forecast ownership, the right level of forecast accuracy, Amazon goals & forecast ownership process.
Collect, Clean & Transform Data
Essential forecasting data (Amazon example), why perfection isn’t needed, handling finished goods & components, extracting data with IT, intro to Power Query, cleaning & transforming data, merging in Excel without VLOOKUP, quick Power Query transformations, and data cleansing.
Choose the Right Forecasting Model
Top-down vs bottom-up forecasting, macro financial analysis, four forecasting methods, different forecast levels, CFO forecast insights, 10 key models, naive forecast, moving average, exponential smoothing, advanced models, choosing the best model, and Apple forecasting.
Forecast Baseline, New Products & Promotions
Building a forecasting tool, forecasting baseline, handling outliers, Amazon’s bullwhip effect, seasonality calculations (3 methods), Amazon’s seasonality clusters, integrating trends, forecast added value (FVA), sales promotions & price elasticity, forecasting new products, Amazon’s forecasting, and integrating sales & marketing.
Measure, Analyze & Review the Forecast (S&OP Best Practices)
ABC & XYZ analysis, tracking forecast accuracy, short-term reviews in 10 minutes, tracking accuracy in Excel, analyzing macro & micro gaps, financial vs supply forecast gaps, insightful forecast charts, three-step accuracy analysis, financial vs supply chain analysis, S&OP templates, and Amazon’s forecast review.
Automate Your Forecasting Process
Forecasting in Excel, automating with Power Query, multi-site forecasting, spreading forecasts to logistics & production, BI tools, choosing Excel or ERP, ERP optimization, ensuring accuracy, standardizing forecasting, and Amazon’s automation.
Communicate & Empower Your Teams
Cross-department communication, an S&OP manager’s story, facilitating without hierarchy, aligning teams to one forecast, handling stress, managing ego & politics, empowering teams & suppliers, building an expert team, and Amazon’s communication.
Prepare for the Future (Python, AI, Machine Learning)
Intro to Python, forecasting with Python, becoming an expert, probabilistic forecasting, big data, machine learning basics, starting with ML, future of coding, ERP & forecasting evolution, and Amazon’s forecasting future.
Who should enroll on Forecasting Expert?
- Professionals in Supply Chain, Finance & Operation who want to fast track their skills & career
- Managers/ Directors/ Executives who need to quickly get to the point to manage their teams
- Consultants who need concrete tools and methods to meet their clients’ expectations
- Entrepreneurs who want to achieve fast and lasting results by following a simple method.
- Students and job seekers wishing to boost their skill and attractively
Check the full course curriculum
The PRO course will suit those willing to generate more accurate demand forecasts by Implementing Methods, Tools & Forecasting Models.
First steps
- Welcome message from Edouard
- Welcome from the CEO
- Presentation of I Wheel Survive
- First meeting with the Board of Directors
- How Mario & I became experts
- How you will become an expert
- 8 Steps to forecasting excellence
- Tools to forecast
Define your goals
- Why do we need a forecast?
- The costs of innacurate forecasts
- 3 levels of forecast
- Forecast horizon
- Meet & clarify the team’s needs
- The expectations of Glance Armstrong – CEO
- The expectations of Bernard Layoff – CFO
- The expectations of Leonardo Wolf – Sales Directos
- The expectations of Lady Gagalytics – Marketing Director
- The expectations of Elon Mars – Product Director
- The expectations of Jeff Amazos – Logistics Director
- The expectations of Jack Machine – Production Director
- The expectations of Michelle Bamacare – H.R
- The expectations of Mark Zuckerbook – I.T
- The company’s expectations summary
- Who is responsible for the forecast at Amazon?
- What is the right level of accuracy?
Collect & transform data
- The data you need (Download)
- Finish goods? Components?
- Don’t wait for perfect data
- How to extract data in 7 steps
- Introduction to Power Query
- Integrate SKU List
- Import price automatically with Power Query
- Clean & integrate data
- Clean & transform sales quantity
- Clean sales quantity with Power Query
- Date US format issue
- Exercice – transforming sales
- Merging 2 sheets without Vlookup
- Pivot table from source
- Fix source error with Power Query
Financial forecast with a CFO
- Meet my CFO friend Jérémy
- Clichés of a CFO
- Roles & responsabilites of a CFO
- How a CFO forecasts
- How a CFO automates & empowers
- Advice from the CFO
Macro forecast finance in Excel
- Bottom up or top down forecast (Download)
- Bottom up or top down forecast (with Mario from Amazon)
- Macro sales Analysis
- Macro annual forecast basic
- 3 levels of forecasting targets
- Market share forecast
- Risk & Opportunity forecast
- Monthly basic forecast
- Multi axis chart analysis
- Seasonal macro annual forecast
- Category analysis
- Category annual forecast
Choose the right forecasting model
- Evolution of forecasting models
- Choose the right forecasting model
- Forecast accuracy in Excel (Download)
- Prepare & split the data
- Measure naive forecast error
- Moving average
- Correct outlier pandemic error
- Exponential smoothing simple
- Use solver to optimize your model
- Trend linear forecast
- Trend manual & optimization
- Trend + seasonal forecast
- Seasonal moving average
- Moving average + seasonality + growth
- Automatic forecast in Excel in 2 clicks
- Exponential smoothing double
- Exponential smoothing triple
- Test 10 models with other products
- How to choose the right model + other models
- Exercice: Apple revenue forecast
The EXPERT course is designed to master and automate end to end forecasting process and advanced models for thousands of products
Forecast level with 500 products
- How to forecast 500 products
- Introduction: Forecasting Expert file (Download)
- If the file is too slow
- Average sales introduction
- Get automatic sales with Power Query
- Average sales per month
- Your first average forecast
- Average sales selector
- Level per average store/client
- Remove negative values
- Clean outliers in Excel
- Service: demand VS sales
- Service KPI’s in Excel
- Stockout correction in Excel
- How Amazon corrects stockouts
- Deal with bullwhip effect
Forecast trends with 500 products
- Trend introduction
- Forecast trend linear automatic
- Trend category analysis
- Trend subcategory analysis
- Trend subcategory calculation
- Trend growth calculation
- Trend period optimization
- Clean trend outliers
- Trend VS Commercial forecast
- Include trend into your forecast
- Trend review process
Seasonality with 500 products
- Seasonality introduction
- Seasonality product analysis
- Seasonality category analysis
- Seasonality subcategory analysis
- Excel formula to detect seasonality
- Seasonality data preparation
- Different seasonality calculations
- Subcategory seasonality
- Seasonability optimization
- If no seasonability detected
- Include seasonality into your forecast
- Deseasonalize average sales (optional)
- Seasonability review process
- How Amazon manages seasonality & clusters
Test and optimize your model
- Add another forecast
- Split & prepare your data
- Track the error
- Test accuracy with manual formula
- Accuracy with calculate field
- Optimize parameters
- Edouard VS Excel forecast
- Triple exponential smoothing + Edouard seasonality
- Risk of overfitting models + parameters
Forecast promotions
- Enrich the forecast (FVA)
- How to deal with promotions
- Analyze promotion data (Download)
- Calculate price elasticity
- Linear regression elasticity method (optional)
- Standardize inputs & impact
- Create a promotion template calculator
- Different type of override in Excel
- Excel formula to override Excel
- Forecast promotion group of products
- Simplify & reduce promotion
- How Amazon manages promotions
Forecast new products
- The challenges to forecast new products
- 19 steps process to forecast similar product
- Build your new product Excel template (Download)
- Calculate your forecast
- Include seasonality
- Forecast multiple sizes
- Calculate MOQ Impact
- Update your expert forecast file
- Forecast discontinued product
- Forecast innovative products
- Forecast innovative product in Excel
- Simplify your new products launch
- How Amazon forecasts new products
Forecast review
- S&OP review planning
- ABC Analysis introduction
- ABC Analysis in Excel (Download
- Create a SKU analysis dashboard (optional)
- Short term forecast review
- Forecast accuracy horizon
- Save your forecast
- Save your forecast with Power Query (optional)
- Calculate forecast accuracy
- Forecast accuracy chart creation
- SKU forecast accuracy in the base file
- Introduction ABC XYZ analysis
- ABC XYZ analysis in Excel
- How I analyze forecast accuracy
- SKU forecast consolidation
- Growth forecast analysis YTD VS Target
- Chart growth forecast analysis
- GAP analysis Top down VS Bottom up
- Amazon forecasting review: Human VS Machine
Automate your process
- 8 tasks to automate
- Collect & Standardize format
- Update your Excel file in 1 minute
- Multi Sites Forecast + Consolidation (Optional)
- Component forecast
- Leave Excel
- How Amazon Automates everything
Communicate & empower your teams
- You are just a lonely Forecasting Expert
- Become a facilitator in your company
- Become a forecasting coach
- Empower your team as a manager
- Empower your clients & suppliers
- Become a leader
Forecast with Python
- Introduction to Python
- Python demo
- Coding without coding Python
- Excel + Python
- Go further with Python
The future of forecasting
- The future of forecasting
- Go further
- Introduction to Machine Learning
- Introduction to Deep Learning
- Forecast with Machine Learning
- Pitfall with Machine Learning
- How to learn Machine Learning
- Probabilistic forecasting with Amazon
- How Mario became a Machine Learning Expert
Celebrations & Go further
- Avoid my forecasting mistake with Decathlon
- Stress Management (My Burnout)
- Your last call with the board
- Celebration 🎉
- How to connect with SCM Analytics™️ (optional)
- How to connect with Inventory Management Expert™️ (optional)
Forecasting Tool Box & Bonuses
- Forecast with Google Trends for free (Excel)
- Google & Amazon Keyword analysis (Excel)
- Amazon workflow forecast optimization process
- Spread your forecast per day (Excel)
- Spread your forecast per day & week with power query (Excel)
+ Included : full PRO course
PRO course is also part of the EXPERT Course
- First Steps
- Define your goals
- Collect & Transform Data
- Financial Forecast with a CFO
- Macro Forecast finance in Excel
- Choose the right Forecasting Model
Become part of our 2,000 certified members community.
Crafted by Supply Chain Expert & Amazon Demand Forecast Specialist
Mario and I have been top performers in our forecasting careers partly because we were highly proactive and pragmatic. We co-created Forecasting Expert™ that combines our 2 different approaches and styles.
- Supply Chain & Operations
- Holistic Approach
- Keep it simple with 20/80 approach
- Loves to automate everything
- S&OP Facilitator
- Teach & Coach thousands of experts
- Gathered the input of hundreds of professionals to create this course
- Finance & Supply Chain
- World Class Forecasting Expert
- Mathematical modeling
- Machine Learning
- Down to earth approach
- Forecast +100 millions products
FORECASTING EXPERT™
Forecasting
PRO
Generate more accurate demand forecasts by Implementing Methods, Tools & Forecasting Models
-
lmplement a forecasting process in less than 4 weeks
-
Collect, Clean & Transform Data
-
Financial Forecast: Master Top-Down Macro Forecast with a CFO
-
Product Forecast: Master 10 different forecasting models, track accuracy & optimize parameters
-
Official PRO certification to prove your expertise and boost your career
-
Forecast Levels, Trends & Seasonality with hundreds of items
-
Forecast New Products & Promotions (process & templates)
-
Measure, Analyze, Review & Improve your own forecasting model
-
Automate your forecasting process with thousands of products
-
Engage and empower your team to collaborate on a single, unified forecast (S&OP process)
-
Forecast with Python: Foundation to start + Demo of Python in Excel
-
Understand Machine Learning & AI forecasting principles
-
Discover the Amazon Secret Forecasting Workflow Mind Map
-
Access to the Forecasting Tool Box to forecast anything
-
1 coaching call with Edouard to get you to the next level
Forecasting
PRO+EXPERT
Master and automate end to end forecasting process and advanced models for thousands of products
-
Implement a forecasting process in less than 4 weeks
-
Collect, Clean & Transform Data
-
Financial Forecast: Master Top-Down Macro Forecast with a CFO
-
Product Forecast: Master 10 different forecasting models, track accuracy & optimize parameters
-
Official EXPERT certification to prove your expertise and boost your career
-
Forecast Levels, Trends & Seasonality with hundreds of items
-
Forecast New Products & Promotions (process & templates)
-
Measure, Analyze, Review & Improve your own forecasting model
-
Automate your forecasting process with thousands of products
-
Engage and empower your team to collaborate on a single, unified forecast (S&OP process)
-
Forecast with Python: Foundation to start + Demo of Python in Excel
-
Understand Machine Learning & AI forecasting principles
-
Discover the Amazon Secret Forecasting Workflow Mind Map
-
Access to the Forecasting Tool Box to forecast anything
-
1 coaching call with Edouard to get you to the next level
Nov 3, 2023
MAGIC
Edouard, the pedagogy is terrific. The magic structure of the lean learning materials is easy to follow, understand and straight to the point… read more
I recommend
It was amazing
Years of experience concentrated in a few weeks of study. Rigorous and easygoing. I will take one more in the near future… read more
The program is for any professional managing demand/sales forecast.
- Professionals in Supply Chain, Finance & Operation who want to fast track their skills & career
- Managers/ Directors/ Executives who need to quickly get to the point to manage their teams
- Consultants who need concrete tools and methods to meet their clients’ expectations
- Entrepreneurs who want to achieve fast and lasting results by following a simple method.
- Students and job seekers wishing to boost their skill and attractively
You can join on the day and not start the program for several weeks or months. Start at your own pace. However, I recommend that you devote at least 30 minutes a week to the program to get quick results.
You don’t need to have a background in demand/sales forecasting (nor statistics or data science). This method is holistic and doesn’t focus only on time-series forecasting techniques: it englobes processes, people and tools needed at every step.
On the other hand, a beginner level on Excel (basic functions like Vlookup, Sum, If …) is useful to rebuild the Excel files quickly (be reassured, I film my screen step by step).
It is also important to have a stable Internet connection and Microsoft Excel installed on your computer.
Most of our pedagogy use Excel as a learning tool. But we also provide demonstrations of Machine Learning / Python for forecasting.
Those are demonstrations and not a course about coding or data science, because you would need much more time to deep dive into those subjects.
The goal is to make you more aware of the possibilities given by those tools: we also provide you external ressources if you want to go further.
You get access to the method in a replay platform, allowing you to go at your rhythm. Some very motivated trainees will go through it in a few days, while others will take a few weeks with less time. I record my screen as I build dashboards in front of you. Then, all you need to do is repeat my actions with your data. Or you can use mine to practice.
Once you have registered, you will immediately be emailed access to a site reserved exclusively for students. There you will find downloadable videos and Excel files organized in modules that cover everything you need to know one by one. We’ll get right down to business with simple examples.
We all have different schedules. That’s why our program is based on your availability and your desire to get up to speed quickly. You can log in and progress through the course at any moment and see improvement in the way your forecast after putting in practice the first few lessons.
There are 8 hours of PRO content and 20 hours of PRO + EXPERT content and exercises to apply immediately, because I know your time is valuable and I will get right to the point.
The completion time varies according to your initial level and how much you can apply in your company.
- The PRO training is designed to last 4 weeks (2 hours/week) or 2 weeks (4 hours /week) for fast learners
- The EXPERT training is designed to last 8 weeks (4 hours/week) or 4 weeks (8 hours/week) for fast learners
Each module is broken down into short episodes of less than 10 minutes to allow you to progress quickly and at your own pace.
The resources (videos, tools, downloadable files) will be available immediately after your payment has been confirmed and available for life.
The certificate, Excel and Power Point downloads will be also available for life.
After your order, you have 60 days to review the course, apply my advice and decide if it meets your expectations.
If you haven’t progressed, just send an email for a 100% refund.
The only condition to be eligible for reimbursement is to try the techniques that are revealed in this program.
If you would like to certify more than one person from your team and receive team support and additional bonuses.
Please contact us via the team training page to receive a tailored quotation suiting your needs.
Excel 365 is used in this program. The files are compatible with versions 2013, 2016, 2019 and office 365 in French and English.
The dashboards will however display slightly differently on excel versions prior to 2013 and MAC version (I will give several alternative solutions if you have a MAC).
Short on time or unsure? Start with our free 60-minute MasterClass to gain skills and discover our pedagogy.
