Skip to Content
Author's profile photo Tammy Powlas

Forecasting Using Time Series Analysis – SAP Predictive Expert Analytics

Using data from the Bureau of Transportation Statistics ( http://www.rita.dot.gov/bts/acts ) I downloaded US domestic passenger data by year/month from 2005 to January 2015.

Passenger airline data (at least in the US) is seasonal, with high volumes in the summer months.  Given a series of actual / historical data values we can use triple exponential smoothing algorithms to project the data. The airline passenger data are a series of data points over time, giving the phrase time series analysis.

/wp-content/uploads/2015/04/1fig_687724.png

I am using SAP Predictive Expert Analytics.  In the above figure, I have loaded the .CSV file of airline passenger data.

/wp-content/uploads/2015/04/3figseasonal_687777.png

I select R-triple exponential smoothing, because as it shows above it provides “seasonality based time series forecasting”

See R – Forecasting – Training Material

I can drag it on to the workspace.

/wp-content/uploads/2015/04/4configure_687778.png

The above shows I select forecast mode as I want to forecast the data.

The dependent column is the column we wish to forecast, in this case, passenger count

Period for the data is monthly

/wp-content/uploads/2015/04/5fig_687779.png

After running the model, I see success and switch to the Results view.

/wp-content/uploads/2015/04/6results_687780.png

Above shows the forecast passenger values by month for 2015 and part of 2016.

/wp-content/uploads/2015/04/7triplestd_687781.png

For fun I also run the SAP-provided triple exponential smoothing (not the R-algorithm)

/wp-content/uploads/2015/04/8results_687782.png

It provides similar forecast results, with July 2015 being the high month of projected passenger travel in the US.

Reference:

Helping you Predict Your Future – ASUG Annual Conference & Other Upcoming Items of Interest

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi Tammy,

      It would be nice to try the same scenario in Automated Analytics and see what it gives you.

      Best regards

      Antoine