HR Analytics Dashboard Insights
Dashboard Link: https://app.powerbi.com/groups/me/reports/90f17bff-3382-4f3f-aae0-558509833f2a/ReportSection?experience=power-bi
Project Overview
This project showcases an HR Analytics Dashboard created using Power BI, which provides valuable insights into various HR metrics and workforce dynamics. The dashboard is designed to help organizations make data-driven decisions to improve employee retention, satisfaction, and overall performance.
Problem Statement
Organizations often struggle with high attrition rates, low employee satisfaction, and inefficient resource allocation. These issues can lead to increased costs, reduced productivity, and a negative impact on overall business performance. Traditional HR management approaches lack the ability to provide real-time, data-driven insights necessary for addressing these challenges effectively.
To tackle these issues, a comprehensive HR Analytics Dashboard is required to:
Monitor key HR metrics such as employee attrition, satisfaction, and performance. Identify trends and patterns that contribute to workforce challenges. Provide actionable insights for strategic decision-making.
Getting Started
DAX Formula:
- Active Employee's = SUM('HR data'[Employee Count])-SUM('HR data'[Attrition Count])
This DAX formula calculates the number of active employees by subtracting the sum of the attrition count from the total employee count. Specifically, the Active Employee's measure is defined as the difference between the total number of employees (SUM('HR data'[Employee Count])) and the total number of employees who have left the organization (SUM('HR data'[Attrition Count])).
-This calculation provides a clear and straightforward metric to monitor the current active workforce, which is essential for understanding the organization's staffing levels and making informed HR decisions.
- Attrition rate = DIVIDE(SUM('HR data'[Attrition Count]),SUM('HR data'[Employee Count]),"")
This DAX formula calculates the attrition rate by dividing the total number of employees who have left the organization by the total number of employees. Specifically, the Attrition rate measure is defined as DIVIDE(SUM('HR data'[Attrition Count]), SUM('HR data'[Employee Count]), "").
-This calculation provides a precise metric indicating the percentage of employees who have exited the company relative to the overall workforce, offering valuable insights into employee retention and helping HR professionals identify trends and areas for improvement.
Key Features
Total Employee Overview: Displays the total number of employees, active employees, attrition count, and attrition rate.
-Demographic Analysis: Includes gender and marital status distribution of employees.
-Income Analysis: Visualizes the average monthly income by job role.
-Departmental Insights: Shows active employees and the sum of attrition count by the department.
-Educational Background: Breaks down active employees by education field and level.
-Performance Ratings: Illustrates performance ratings by department.
-Age and Gender Distribution: Provides insights into the age bands and gender distribution of active employees.
-Job Satisfaction: Details job satisfaction ratings by job role.
-Average Age of Active Employees
Insights
Employee Demographics:
Total employees: 1,470 Active employees: 1,233 Average age: 37
Attrition Analysis:
Attrition count: 237 Attrition rate: 16.1% Highest attrition in R&D department Monthly Income:
Highest average monthly income in management roles
Education Fields:
-Predominantly Life Sciences (41.93%) and Medical (32.52%)
Performance Ratings:
Concentrated in R&D and Sales departments
-Job Satisfaction:
Detailed ratings by job role
-Education Levels:
-Bachelor's degree holders form the largest group Age and Gender Distribution:
-Diverse age bands and gender representation
Benefits
-Informed Decision-Making: Enables data-driven hiring, training, and retention decisions.
-Trend Identification: Identifies trends in attrition and job satisfaction.
-Resource Allocation: Optimizes resource allocation by understanding departmental performance.
-Employee Engagement: Enhances engagement through targeted interventions.
Tools Used
Power BI: For creating and publishing the dashboard:
To view the dashboard: https://app.powerbi.com/groups/me/reports/90f17bff-3382-4f3f-aae0-558509833f2a/ReportSection?experience=power-bi
-Source of Data
Data Sources: HR data.xlsx https://docs.google.com/spreadsheets/d/1FkDEbK2HCpb6qXgWTb5B0oNaBRHCwYZ3/edit?usp=drive_link
Access Power BI and import the dataset. You can use the visuals that are provided to explore insights.
Contributing
Contributions are welcome! Please open an issue or submit a pull request for any enhancements or bug fixes.
Contact For further insights or collaboration opportunities, feel free to connect with me at:
LinkedIn: linkedin.com/in/olanrewaju-james-olajuyi-9273b6b5
Olanrewaju Olajuyi LinkedIn