👥 HR Analytics Dashboard – Employee Attrition Analysis

---

📌 Overview

This Power BI dashboard provides a comprehensive, data-driven analysis of employee attrition, helping HR professionals identify key trends and factors that influence employee retention.

---

🎯 Objective

• Identify patterns and drivers of employee attrition
• Provide actionable insights to HR teams for reducing turnover
• Enhance employee experience through data-backed decisions
• Support workforce planning and long-term talent strategies

---

📊 Dashboard Insights

The dashboard offers insights into attrition based on several key parameters:

1️⃣ Attrition by Gender & Age – Analyzes the impact of gender and age on employee attrition
2️⃣ Attrition by Education – Investigates how educational qualifications influence employee retention
3️⃣ Attrition by Salary Slab – Examines the relationship between salary levels and employee attrition
4️⃣ Attrition by Job Role – Identifies which job roles are most affected by attrition
5️⃣ Attrition by Years at Company – Shows the patterns of attrition based on employee tenure

---

📈 Key Performance Indicators (KPIs)

• Attrition Rate
• Total Attrition Count
• Average Age of Employees
• Average Salary
• Average Tenure
• Attrition by Role, Salary, Age, and Education

---

🔍 Key Findings

• Employees with salaries up to 5K show the highest attrition (163 cases)
• Age group 26–35 has the highest attrition (116 cases)
• Top roles affected: Laboratory Technicians (62), Sales Executives (57), Research Scientists (47)
• Highest attrition occurs within the first year of employment (66 cases)

---

💡 Retention Strategy Recommendations

1. Salary Revisions

   • Review compensation policies for employees earning below 5K
   • Introduce performance-based increments to retain early-career talent

2. Career Growth & Development

   • Provide clear career paths and internal mobility, especially for roles with high attrition

3. Onboarding & Engagement Programs

   • Improve onboarding experiences to reduce first-year attrition
   • Launch mentorship programs to help new hires integrate smoothly

4. Targeted Retention Initiatives

   • Focus on employees aged 26–35 with personalized development and wellness plans
   • Conduct exit interviews to continuously learn and refine HR practices

---

🌐 Use Cases

• HR Managers can track attrition by department or role
• Executives can identify cost-saving opportunities through retention
• Talent Acquisition teams can refine hiring strategies based on historical attrition
• L&D teams can design training for high-risk roles

---

🔐 Data Privacy & Ethics

This project uses anonymized or synthetic HR data strictly for educational and analytical purposes. No real employee data has been used, ensuring compliance with data privacy regulations like GDPR.

---

🧪 Data Preprocessing

• Cleaned missing and inconsistent values
• Created salary slabs for easier analysis
• Grouped ages into brackets (18–25, 26–35, etc.)
• Created calculated columns (e.g., Years at Company)
• Categorized education into key clusters

---

🔄 How to Use

1. Download and open HR_Attrition_Dashboard.pbix in Power BI Desktop
2. Interact with visuals using slicers (Department, Gender, Education, etc.)
3. Hover over charts to