Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help with Hierarchical forecasting

Mozammel
7 - Meteor

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 2016 June 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

 et.c         

 

 

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.

10 REPLIES 10
Mozammel
7 - Meteor

Thanks  

Labels