BookmarkSubscribeRSS Feed
Mozammel
Calcite | Level 5

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.

 

1 REPLY 1
mitrov
SAS Employee

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-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Discussion stats
  • 1 reply
  • 1087 views
  • 1 like
  • 2 in conversation