A comprehensive Power BI dashboard designed to analyze and visualize employee attrition patterns within IBM's workforce. This project provides actionable insights into retention challenges, helping HR teams identify at-risk employee segments and develop targeted retention strategies.
- Analyze employee attrition rates across multiple dimensions
- Identify high-risk departments and job roles
- Understand demographic patterns in employee turnover
- Provide data-driven recommendations for retention strategies
- Visualize tenure and career progression patterns
- Total Employees: 1,470
- Attrition Count: 237 employees
- Attrition Rate: 16.12%
- Average Salary: $6,500
- Average Tenure: 7 years
- Executive summary cards displaying key metrics
- Education field analysis
- Job level distribution
- Tenure trends over years
- Job role attrition patterns
- Marital status distribution
- Gender-based attrition
- Age group analysis
- Job involvement levels
- Attrition breakdown by department
- Age range segmentation
-
High Entry-Level Attrition
- 60% of attrition occurs at Job Level 1
- First-year employees show highest turnover (59 employees)
-
Departmental Challenges
- R&D department: 133 employees (56% of total attrition)
- Sales department: 92 employees (39% of total attrition)
-
Demographic Patterns
- Younger employees (18-25): Highest attrition rate (100 employees)
- Male employees: 63% of total departures
- Single employees: 50.6% of attrition
-
Role-Specific Issues
- Laboratory Technicians: 26.2% of attrition
- Sales Executives: 24.1% of attrition
- Research Scientists: 19.8% of attrition
-
Education Background
- Life Sciences: 89 employees leaving
- Medical field: 63 employees leaving
- Enhance first-year onboarding programs
- Implement retention bonuses for entry-level positions
- Review compensation for Laboratory Technicians and Sales roles
- Conduct comprehensive exit interviews
- Develop clear career progression frameworks
- Create mentorship programs for new hires
- Implement quarterly engagement surveys
- Build specialized retention programs for technical roles
- Power BI Desktop - Dashboard creation and data visualization
- DAX - Data Analysis Expressions for calculations
- Power Query - Data transformation and cleaning
- Power BI Desktop (latest version)
- Basic understanding of HR metrics
- Familiarity with data visualization concepts
- Clone the repository
git clone https://github.com/ziedidorsaf/IBM-HR-Analytics.git-
Open Power BI Desktop
-
Open the
.pbixfile -
Refresh data connections if needed
-
Explore the interactive dashboard
The dashboard analyzes HR data including:
- Employee demographics (age, gender, marital status)
- Employment details (department, job role, tenure)
- Education background
- Salary information
- Attrition status

