Скачать с ютуб Seasonality in Time Series: Integrate it into Demand Forecasting (Full Excel Tutorial) в хорошем качестве

Seasonality in Time Series: Integrate it into Demand Forecasting (Full Excel Tutorial)

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