
Apply moving average forecasting to predict future demand by averaging the past n periods, demonstrated with 1-, 3-, and 5-month windows in a spreadsheet.
Learn to clean and prepare time series data in Python for moving average demand forecasting. Load the last two years, create a year-month period index, and filter for a store-item.
Develop a Python function to compute a simple moving average forecast from a demand data frame, using a configurable n and forecast periods.
Visualize time series forecast results using a moving average in Python, plot actual and forecast lines with Plotly, and assess forecast accuracy with error calculations.
Compare moving average forecast models across 1–10 periods by calculating forecast bias and error, and implement a Python function to identify the best model.
Learn to compute mean absolute percentage error (MAPE) by averaging absolute errors divided by demand, and examine its limitations for small or large demand.
Explain mean absolute error and its normalized mean absolute percentage error, and distinguish it from mean absolute error percentage, while outlining code to compute and print results.
Learn to compute and interpret root mean square error (RMSE) for forecast accuracy in Python, including mean square error, RMSE percentage, and comparing moving-average models using pandas and numpy.
Explore weighted moving average in Python by applying period weights to demand data, compare with simple moving average, and evaluate using bias and mean absolute error.
Optimize weighted moving average weights by selecting a KPI such as mean absolute error, choosing three periods, and testing 0–10 weights to minimize error.
Learn single exponential smoothing for time-series demand forecasting, using the alpha-weighted forecast to capture level and trend and seasonality, with moving-average comparisons.
Optimize alpha for single exponential smoothing by automatically testing a range of values, evaluating with mean absolute error and other KPIs, and selecting the best parameter for improved demand forecasting.
Implement double exponential smoothing to forecast demand, incorporating trend with alpha and beta, initializing level and trend, and optimize parameters in Python while comparing to smoothing using mae and rmse.
learn to apply double exponential smoothing with a damped trend and level handling in Python, introducing a damping factor pi to shrink the trend over time and improve forecasts.
Explore triple exponential smoothing with level, trend, and multiplicative seasonality to forecast demand in Python, leveraging gamma for seasonality, season length, and data preparation.
Understanding and predicting the demand is one of the key challenge in Supply chain planning. Having better forecasting meaning better supply planning and optimized business operations with good customer service, therefore learn to build better forecast is a key skill to master in Supply chain management. Demand forecasting sounds simple but it will get complex when we have thousands of SKUs and each with its own demand pattern such as seasonal, intermittent and lumpy.
In this course you will learn demand forecasting models from basic to more advanced. And implement each of the models in Python. You will gain practical knowledge with real life data with over 3000 skus and over 5 years of data and millions of transactions.
By the time you complete the course you would have learned how advanced demand forecasting engine works in expensive commercial software and you would build your own fully automated forecasting engine.
In this course you will not only learn to build forecasting models and predict demand but also learn to build a python tool which can automatically optimize and select the best forecasting model based on your data.
Last but not least, you will learn to visualize all the forecasted data and errors in an intutive way.