📊 HR Employee Retention Dashboard

📋 Executive Summary

Employee churn is a critical metric for organizational health. This project delivers an Interactive Power BI Dashboard designed to help HR Managers audit workforce dynamics and identify root causes of attrition.

By transforming raw HR data into actionable visual insights, this dashboard allows stakeholders to drill down into attrition by Department, Role, and Demographics.

🔍 Key Insights & Analysis

Based on the data visualized in this report, several key trends emerged:

• Attrition Rate: The overall attrition rate stands at 16%, with significant variation across departments.
• The "Burnout" Factor: Employees working OverTime show a drastically higher attrition rate compared to those who work standard hours.
• Income Correlation: There is a strong negative correlation between Monthly Income and attrition; employees earning below the median salary are most at risk.
• Demographic Risk: Young professionals (Ages 25-30) and those in Sales Representative roles exhibit the highest turnover.

🛠️ Technical Implementation

• Data Cleaning: Processed the IBM HR Analytics dataset to handle categorical variables and standard hours.
• DAX Measures: Created custom calculations for:
  • Attrition Rate %
  • Average Tenure
  • Employee Satisfaction Score
• Data Modeling: Established relationships between Employee Demographics, Job Roles, and Performance metrics.