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:
|
|
|
|
|
|
| |||
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.
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.