The objective of this project was to conduct HR Analytics using Power BI to gain insights into key HR metrics and provide valuable information for decision-making.
- Total Employees: 1470
- Attrition Rate: 16%
- Attrition Count: 237
- Avg Age: 37 Years
- Avg Salary: $6.5K
- Avg Years at Company: 7 Years
- Employees by Gender: 60% males, 40% females.
- Job Satisfaction: Sales Executives are the happiest.
- Salary Range: Avg hourly rate $63.7-$66.8, highest in Healthcare Rep, lowest in Research Director.
- Age Distribution: 41% aged 26-36, 31% aged 36-45.
- Salary Slab: Most earn up to $5K monthly.
- Educational Background: Diverse, with many from Life Sciences.
- Data Analysis using Power BI
- Data Visualization
- Statistical Analysis
- HR Analytics
- Tailor HR strategies based on job satisfaction insights.
- Address attrition rate to retain valuable talent.
- Review salary structures to ensure competitiveness.
- Implement targeted recruitment strategies based on educational background insights.
Check out the Power BI Dashboard Video for a demo of the project.
Feel free to connect with me on LinkedIn for more exciting projects and content. Let's connect and collaborate!