Forecasting using SAS Forecast Server, SAS/ETS, and more

Hierarchical Forecasting

Reply
New User
Posts: 1

Hierarchical Forecasting

Summary:

-Every month based on the need of  our different department we ask different vendors to provide us contractors to meet our work load.

-The contractors that the vendors provide start entering FTE hours as soon as they start working.

- Based on the data we will need  a model that will predict the future FTE hours for a particular state,  a particular city, a particular job family, a particular position title.

 

Example:

  • We have monthly data from 2014 to 2015 for the total FTE hours entered
  • The column headers are as follows:

 

 

 

 

 

 

 

Year

Month

State

City

Job Family

Job Title

Total Hrs

2014

April

AL

Selma

PM

PM3

10000

2015

Feb

AR

Hot Springs

Analyst

Analyst2

2300

          

 

 

So based on the above data we will be able to predict for

2016 September

2016 October

2016 November

For each state and for each of the city and for each of the job family and for each of the job title

Approximately how much hrs are needed.

 

SAS Employee
Posts: 36

Re: Hierarchical Forecasting

I would suggest that you look at Forecast Server. It is specifically designed for last scale automatic forecasting of time series organized in a hierarchical fashion. This video gives a brief overview of the feture of Forecast Server by guiding through a typical project creation.

https://www.youtube.com/watch?v=yZWY8cCzOKU

 

SAS Forecast Server generates forecasts quickly and automatically to help your organization prepare effectively for the future. To learn more about SAS Forecast Server, visit http://www.sas.com/forecastserver
Ask a Question
Discussion stats
  • 1 reply
  • 224 views
  • 1 like
  • 2 in conversation