Hierarchical Forecasting

[Mozammel]

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.

[mitrov]

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