HR Analytics- Build an HR dashboard using Power BI
What if we could find the percentage of employees awaiting promotion in our department, who needs to be terminated with just a few clicks?
This is where I discovered one of the powerful tool-Power BI
We could enhance organizational workforce performance, gain data-driven insights into numerous facets of human resources, and foster a healthy work environment by analyzing data.
Lets see a simple project to build an HR Dashboard using Power BI
Overview of Dashboard
This dashboard gives us the percentage of employees that need to be promoted, employees that need to be terminated and paid severance pay.
Created the following KPIs using DAX
- Total employees working in particular department
- Total number of male and female present in each department
- Percentage of male and female present
- “Due for promotion” % and “Not Due” %-Employees who have not received a promotion in the past 10 years or more are considered “Due” for a promotion” while those who do not meet the requirements are considered “Not Due.”
- “Layoff Review” and “Stay on service”-Employees who have worked for the company for more than 18 years must be laid off and rest will stay on service
- Severance allowance for Due for promotion employees who would be retrenched
- Performance Rating: “High Rating”- equals to value 3 or else its considered as “Low Rating”
Visualization Chart
- Service years of employees-Stacked bar chart
- Job levels of employees-Stacked column chart
- Finding commute distance-Donut chart
Far-Employees residing more than 20 km from the office are considered;
Close-Employees residing more than or equal to 10 km from the office;
Very near-Employees residing less than 10 km from office - Job satisfaction-Stacked column chart
High-less than or equal to value 2
Medium-equals value 3
low-more than value 3 - Overtime of employees-Pie chart
Achieved Results
- Due for promotion Employees -5 %
- Layoff Review-8%
- Job Role-Manager, a total of 102 managers, of which 44 are considered for layoff review which is highest and 22 are about to be promoted.
p.s. : I love my manager, my job, no way we are laying off managers!
Key Takeaways
- Learn how to create measures with DAX
- Develop knowledge of choosing chart types for visualization and interactive dashboard creation
- Enhance your understanding of the HR field.
- Understand data-driven HR requirements.
- Create Power BI In-Page Navigation and using power query to clean data.
Well, HR data analytics will certainly help us but it also has its disadvantages like collecting data from many different departments is a huge task, privacy issues.
Get Green Coffee Blog’s stories in your inbox
Join Medium for free to get updates from this writer.
We have better decision making ability, we shouldn’t rely solely on data results because we can really lose a potential employee because of it.
Here are some previews of the dashboard I created:
There is a page navigation on the left side showing HOME, ACTION, DETAILS, ctrl + click takes us directly to the relevant sheet or page.
Credit: To all the Youtubers and especially Data with Decision!
So how far do you think Power BI is good for HR data Analytics?
