Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more

Reply
LB_Team
Advocate I
Advocate I

ML Model - SARIMAX

Hi all,

I'm working on time series forecasting using SARIMAX in Python, and I encountered a confusing result:
My dataset is count of tests taken on daily from the year 2022 jan to 2024 dec 

  • When I use this data and forecasted for next 12 months using SARIMAX gave me accurate forecasts.

  • But when I use the same data and tried to forecast for the next 7 days instead of 12 months, the predictions are often inaccurate sometimes showing a steep decline or not capturing the correct trend at all.

Where am I going wrong? Please guide me.

I've attached the link to the code :
https://drive.google.com/file/d/1fhOf-bY0oZTYyq9wifXRDEaHa659-pxp/view?usp=sharing

1 ACCEPTED SOLUTION
v-sdhruv
Community Support
Community Support

Hi @LB_Team ,

If your data shows seasonal patterns and you want to forecast for 7 days, then SARIMAX is sensitive. Your model probably learned seasonal trends well over long periods, but struggles to generalize for short-term prediction due to overfitting to long cycles or reacting too much to end-point anomalies.

Check residuals near the end of your training window.

If residuals are high, the model is already misfitting — so short-term forecasts will diverge quickly.

 

Tailor your model specifically for weekly forecasts-->s=7

Use smaller seasonal_order and possibly a narrower training window-- SARIMAX(..., seasonal_order=(P,D,Q,7))


I hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

View solution in original post

8 REPLIES 8
AnShikagautam
New Member

You can do yours work time to time so yous can't face these problems thnku 

AnShikagautam
New Member

U can do your work time to time because when you doing yours work at a time so you don't have any problem thnku 

v-sdhruv
Community Support
Community Support

Hi @LB_Team ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

v-sdhruv
Community Support
Community Support

Hi @LB_Team ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

v-sdhruv
Community Support
Community Support

Hi @LB_Team ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

v-sdhruv
Community Support
Community Support

Hi @LB_Team ,

If your data shows seasonal patterns and you want to forecast for 7 days, then SARIMAX is sensitive. Your model probably learned seasonal trends well over long periods, but struggles to generalize for short-term prediction due to overfitting to long cycles or reacting too much to end-point anomalies.

Check residuals near the end of your training window.

If residuals are high, the model is already misfitting — so short-term forecasts will diverge quickly.

 

Tailor your model specifically for weekly forecasts-->s=7

Use smaller seasonal_order and possibly a narrower training window-- SARIMAX(..., seasonal_order=(P,D,Q,7))


I hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

LB_Team
Advocate I
Advocate I

But my data shows seasonality patterns also will ARIMA be suitable for my usecase to forecast for next 7 days?

 

v-sdhruv
Community Support
Community Support

Hi @LB_Team ,

SARIMAX captures seasonal components, trends, and exogenous variables. If your model includes seasonal components (e.g., weekly or yearly), then:

Long-term forecasts (like 12 months) are more influenced by seasonal patterns it has learned.

Short-term forecasts (like 7 days) might be more sensitive to noise, recent variability, or model overfitting to short-term anomalies.

Improper seasonal or non-seasonal orders can have unexpected short-term behavior. For example:

1.Over-differencing can cause forecasts to trend downward.

2.Misidentified seasonal periods  can distort short-term forecasts

Try using ARIMA model:
Refer-
https://skforecast.org/0.10.0/user_guides/forecasting-sarimax-arima

Hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

June Fabric Update Carousel

Fabric Monthly Update - June 2026

Check out the June 2026 Fabric update to learn about new features.

Top Solution Authors