HR Attrition Analysis Report
Overview:
This Power BI report provides a comprehensive analysis of HR attrition data, focusing on understanding and improving employee retention strategies. The analysis uses datasets HR_1 and HR_2, each containing 50,000 records, to offer insights into various aspects of employee attrition and retention.
Key Features:
1. **Combined Attrition Rate**: The overall attrition rate for the company, calculated from the combined dataset of 50,000 employees.
2. **Department-wise Attrition**: Average attrition rates across different departments, highlighting the departments with the highest attrition rates.
3. **Attrition vs. Years Since Last Promotion**: Analysis of attrition rates based on the number of years since the last promotion, providing insights into the impact of promotions on employee retention.
4. **Monthly Income Bins**: Monthly income segmented into bins of 5,000 units, with corresponding attrition rates, to explore the relationship between income levels and attrition.
5. **Work-Life Balance**: Average work-life balance scores across different job roles, with an overall combined average.
6. **Average Working Years**: Analysis of average working years at the current company and total working years across departments.
7. **Hourly Rate for Male Research Scientists**: Specific focus on the average hourly rate for male research scientists.
Methodology:
- **SQL Queries**: Used for data extraction and aggregation.
- **Excel**: Utilized for data manipulation and initial visualization.
- **Power BI and Tableau**: Employed to create interactive dashboards for detailed insights.
Interactive Dashboards:
- **Attrition Rates by Department**: Bar chart visualization to display attrition trends across different departments.
- **Hourly Rates**: Card visual for evaluating hourly rates for male research scientists, with filters for gender and job role.
- **Monthly Income vs. Attrition**: Bar chart to explore the relationship between monthly income and attrition rates.
- **Average Working Years**: Bar chart to show average working years per department.
- **Work-Life Balance by Job Role**: Matrix visual for detailed insights into work-life balance trends across job roles.
- **Impact of Promotion on Attrition**: Line chart to illustrate attrition rate trends based on years since the last promotion.
Learnings:
- Effective use of SSMS, Power BI, and Tableau to present the required KPIs.
- Improved understanding of raw data and better visual representation techniques.
- Utilized DAX for creating custom measures and columns.
- Learned important features in Power BI and Tableau for creating interactive dashboards, such as Edit Interactions.
This detailed analysis report provides valuable insights into employee attrition, aiding in the development of effective retention strategies.
eyJrIjoiNGJmZmRiOWUtMjQzYy00NTA5LTg5ZDItOGM4YmQ4YWY2YzJjIiwidCI6ImJhZDEyODY0LTkxM2UtNGI5OS04N2Q2LWI4ZDJhZDQ1OWUyNyIsImMiOjEwfQ%3D%3D
