HR Data model For Attrition and Manpower Planning

[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