K means clusters for Attrition Dashboard

Power BI
1

Hi Experts,
I am working on the employees attrition dashboard for my company. I came to know that using k means cluster i can draw the insight from the data.
I have all the demographic information of my staff like age, work experience, nationality etc.

Can someone please guide me which insights i can withdraw and based on which clusters.
Appreciate if some resources are shared.

Its a general questions and all feedback and guidance is welcomed. I am totally new in this area.

Thank you.

2

Bumping this post for more visibility from our experts and users.

3

Hi Experts,

Need your guidance on the topic please.

Thank you

4

Hi @EnanBahadur.

For myself (as I imagine many other forum members), I’ve not heard of “k means cluster” before, let alone its’ desired insights. To help the forum members further analyze your current state and visualize your issue, could you please provide as many as you can of:

  • • Your work-in-progress PBIX file, using sanitized data if necessary
  • • Your dataset as an Excel file (again, sanitized if necessary)
  • • A detailed mock-up (marked-up screenshot of the visual in question or Excel file) showing your desired outcome.

Also, if you provide DAX or Power Query code in your post, please format it using the built-in formatter.

Greg
_eDNA Forum - Format DAX or PQ

2 Likes
5

@EnanBahadur ,

This is not something you can run directly in Power BI, but you CAN call an R or Python script within Power Query to perform this analysis, and then output the results back to a table in Power Query.

I have a two-part video series on exactly how this process works. You can find the video here:

With regard to the K-means Cluster analysis itself, this is a fairly complex machine learning method that to implement properly, you will need to train your model, evaluate performance, and then likely adjust your parameters.

One of the best resources for this is Brent Lantz’s “Machine Learning with R” (newly published 4th edition).

Chapter 9 of this book is dedicated to “Finding Groups of Data - Clustering with k-means”.

I hope this is helpful to you.

  • Brian
1 Like
6

Hello @EnanBahadur ,

I would add that it appears from your description that the reporting
requirements are not complete. If it is inspiration which you seek,
Enterprise DNA includes a number of examples related to HR reporting.

Additionally Microsoft offers the Human Resources sample for Power BI
which would be a reasonable starting point. It is well known and has been offered to the
community for several years. It is anonymously published to the service, available
for download as a .PBIX, and the underlying dataset is available.

Some of the analytics covered include :

Very early on, this sample included ask a question in the dashboard Q&A box so as to encourage user engagement.

Best of luck.

7

Hello @EnanBahadur

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

8

Hi @EnanBahadur

Due to inactivity, we’d like to conclude that you no longer require assistance to solve your inquiry.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.