HR Data model For Attrition and Manpower Planning

[Dharma]

Hello Guys,

In my HR team we working on Building Attrition Predictive Model and Manpower Planning model, since in my organization the Attrition Rate is preety high, therefore they asked us to explore ideas on building the same…

So what are the things to consider for building this model in Power BI because am using this tool, is there any used case which is done in Power BI which I can take idea from…

Thanks in Advance…

[BrianJ]

@Dharma,

Here are two prior threads on this same topic that I think you’ll find helpful.

https://forum.enterprisedna.co/t/employee-attrition-type-of-data-needed/4227https://forum.enterprisedna.co/t/employee-attrition-type-of-data-needed/4227

Reasons for employee attrition

@powerbideveloper, As an economist who spent the first third of my career building economic models to try to answer the “why” questions, let me NOT answer your question, but hopefully in a useful way… I think before asking HOW to do this in Power BI, the relevant question is “is Power BI the correct tool for this problem?” Power BI is a fantastic tool for uncovering patterns and correlations. However, it is much less well-suited to assessing causality. To establish causality, you first need …

When I think of predictive modeling, to me that typically indicates some form of regression analysis. You can do very simple linear regression in Power BI, but to really do it well I would recommend doing your predictive modeling in R and then integrating that analysis into Power BI. Fortunately, R and Power BI work beautifully together. I am actually working now on an Enterprise DNA platform course on R for Power BI users, to roll out this summer.

For an example on integrating predictive R modeling with Power BI, I would direct you to our team Data Challenge entry #11, where we built an R model of predicted COVID deaths worldwide within Power BI.

Power BI Challenge 11 - Covid 19 Reporting from Greg, Brian, Jarrett, and Mudassir

All, Introduction For a while, we’ve been planning to do a joint entry to explore the dynamics of collaborative Power BI development, in order to provide the Enterprise DNA community with a set of practical, tested recommended practices. Our ultimate plan is to use Analyst Hub as the primary mechanism to facilitate this collaboration, but the first time through we thought we would focus on the broader elements of learning to work together as a team, since each of us has only ever been the sole…

I hope this is helpful.

• Brian

[EnterpriseDNA]

It’s great to know that you are making progress with your query @Dharma. Please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!

[EnterpriseDNA]

Hi @Dharma, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

[EnterpriseDNA]

Hi @Dharma, we’ve noticed that no response has been received from you since the 31st of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.