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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.