Seasonality in Time Series: Integrate it into Demand Forecasting (Full Excel Tutorial)
9.2 هزار بار بازدید -
11 ماه پیش
-
Download the seasonal time series
Download the seasonal time series and forecasts here: https://abcsupplychain.com/download-s...
Join my Demand Forecasting WORKSHOP (free): https://abcsupplychain.com/demand-for...
How do you deal with monthly, quarterly, or yearly cycles in your business? 🔄 🤷♂️
Integrating them into your forecasts is essential to allocate the right resources (time, money, people) at the right time 📆
I just made a new step-by-step Excel tutorial to identify, calculate, and integrate seasonality into your forecasts.
In the comments, let me know how you deal with seasonality!
▬▬▬▬▬▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬▬▬▬▬▬▬
00:00 Intro
00:32 Why you need to integrate seasonality into your forecasts
01:35 Seasonal Factors
02:30 Temporality
03:46 Seasonality for statistical forecasts
03:53 Amazon example in Excel
04:13 How to detect seasonality
05:18 Seasonality per Quarter
06:41 Base 100 (Normalization)
08:24 Seasonal Forecast (Quarter)
09:02 Bike industry example in Excel
09:42 Seasonality per month
12:35 What to do if you don't have enough historical data
12:54 How to deal with outliers
13:08 Why use demand rather than sales
13:31 Value vs Quantity
13:59 Which level of aggregation? (granularity)
15:01 How to get a more reliable forecast?
►MY BLOG : https://abcsupplychain.com/
#forecasting #seasonality
Join my Demand Forecasting WORKSHOP (free): https://abcsupplychain.com/demand-for...
How do you deal with monthly, quarterly, or yearly cycles in your business? 🔄 🤷♂️
Integrating them into your forecasts is essential to allocate the right resources (time, money, people) at the right time 📆
I just made a new step-by-step Excel tutorial to identify, calculate, and integrate seasonality into your forecasts.
In the comments, let me know how you deal with seasonality!
▬▬▬▬▬▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬▬▬▬▬▬▬
00:00 Intro
00:32 Why you need to integrate seasonality into your forecasts
01:35 Seasonal Factors
02:30 Temporality
03:46 Seasonality for statistical forecasts
03:53 Amazon example in Excel
04:13 How to detect seasonality
05:18 Seasonality per Quarter
06:41 Base 100 (Normalization)
08:24 Seasonal Forecast (Quarter)
09:02 Bike industry example in Excel
09:42 Seasonality per month
12:35 What to do if you don't have enough historical data
12:54 How to deal with outliers
13:08 Why use demand rather than sales
13:31 Value vs Quantity
13:59 Which level of aggregation? (granularity)
15:01 How to get a more reliable forecast?
►MY BLOG : https://abcsupplychain.com/
#forecasting #seasonality
11 ماه پیش
در تاریخ 1402/06/28 منتشر شده
است.
9,266
بـار بازدید شده