BookmarkSubscribeRSS Feed
nareshab
Calcite | Level 5

Hi,

Can someone suggest me on how to improve the performance of the Forecasting model which is giving me MAPE error around 50+. and the distribution is attached.

What are all the best ways to improve the forecasting on a daily level.

Thanks.


Forecast.JPG
4 REPLIES 4
SnurreJensen
SAS Employee

By looking at the attached graph my first guess is that you have some periods where the absolute percentage (APE) error for the individual observations are extremely large due to very low (but not zero!) actual values. It's somewhat hard to tell from looking at the graph but what is the forecast and the actual value for 01jan2014 for instance? Try calculating the APE for that period for instance.

To counter this, either enable automatic outlier detection (I assume you use SAS Forecast Studio) or create your own model where you include events for those periods where the actuals are extremely low.

Thanks,

Snurre

udo_sas
SAS Employee

Hello -

How well is your model doing on out-of-sample data?

Thanks,

Udo

NareshAbburi
Calcite | Level 5

Thanks for your reply.

I'm actually building model on whole 2 years data. And now I've got even more bigger problem with the sporadic nature of the data. please refer to the picture attached.

Please let me know what is the best way to handle this data and reduce the forecasting error.

The main problem with model is that it is not able to fit all the data points based on OLS.

Also, I'd like to know if there is any option in SAS to provide multiple seasonal cycles as input.

Any help would be appreciated.

Thanks.

Naresh SASFC.JPG

SnurreJensen
SAS Employee

Hi,

Please bear in mind that when building a good forecast model the aim is not to find a model that fit all the existing data points. The aim is to find a model that is able to provide as accurate forecasts as possible given the exisitng conditions. For instance, if data is very noisy/erratic/stochastic etc. forecast accuracy will be lower than if the has nice stable patterns.

Having said that you can work with multiple seasonal cycles in FS by building your own model. For instance an ARIMA model with differences of (7,28) can be used to work with data where there are seasonal patterns each 7 and 28 days (assuming you have obs for all 7 days a week).

Thanks,

Snurre

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1608 views
  • 1 like
  • 4 in conversation