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.

Market Basket for HR Analytics

Charity_K_Wilson
10 - Fireball

Has anyone used Market Basket analysis within the HR Analytics arena?

 

To be specific, I want to see what "basket" of goodies go with employees who quit, and which things go with an employee who stays?  Which bonuses, what type of raises?  Do they get mentoring, promotions, or lateral moves within the company?  

 

A bit of background, I'm an economist by training.  Everything fits in a regression equation, or I don't work on it.  But in this case, the things that are colinear, if certain bonuses appear together, those really matter.  (Colinear is a dirty work for regression equations.)  I'm trying to say, Market Basket algorithms are not something I normally use.

 

I guess I'm asking, does this sound like a situation that a Market Basket would apply?  If anyone has done anything like this, what things should I be aware of?

1 REPLY 1
SusanCS
Alteryx Alumni (Retired)

Interesting question! Typically market basket analysis looks to find relationships among items that co-occur in transactions. I suppose you could take a dataset of information about employees who have left the company and, for each employee, list the “items” that pertain to that person (mentorship program participation, receipt of bonus, promotion, etc.). Applying market basket analysis would reveal connections between the items in the “basket” of each employee (e.g., mentorship co-occurred with promotion). You could do the same for data on employees who have stayed, then see if there are interesting/comparable patterns in the “baskets” of coinciding items most frequently occurring among those who stay or quit.

 

I’ve written a couple of blog posts about doing market basket analysis in Designer: Market Basket 101 and 102.

 

Hope that helps a bit as you think about how you might use this. I’d also love to hear if folks have tried this kind of approach and if it brought useful insights.

Labels