HR Employee Attrition Dashboard

HR Employee Attrition Dashboard
Objective

To analyze employee attrition trends and identify factors that influence employee turnover within the organization using Power BI.

Dataset Overview

The dataset provides detailed information on employees’ demographics, job roles, satisfaction levels, and attrition status.

Key Columns:

Demographics: Age, Gender, MaritalStatus, Education

Job details: Department, JobRole, YearsAtCompany, OverTime

Satisfaction metrics: JobSatisfaction, EnvironmentSatisfaction, WorkLifeBalance

Performance & salary: MonthlyIncome, PerformanceRating

Total Records: 1,470 employees
File Format: Excel (.xlsx)
Sheet Name: WA_Fn-UseC_-HR-Employee-Attrition

Data Source

Dataset Name: IBM HR Analytics Employee Attrition & Performance
Source Link: Kaggle Dataset – IBM HR Analytics Employee Attrition & Performance

Uploader: IBM (via Kaggle community)
Data Type: Public, Open-source
Imported From: Excel → Power BI

Tools & Techniques Used

Power BI Desktop for analysis and visualization

Power Query for data cleaning and transformation

DAX (Data Analysis Expressions) for calculated metrics and logic

Excel as the data import source

Calculated Columns (DAX Examples)
-- Attrition Rate
Attrition Rate =
DIVIDE(
COUNTROWS(FILTER('HR Data', 'HR Data'[Attrition] = "Yes")),
COUNTROWS('HR Data')
)

-- Age Grouping
AgeGroup =
IF('HR Data'[Age] < 21, 20,
IF('HR Data'[Age] < 31, 30,
IF('HR Data'[Age] < 41, 40,
IF('HR Data'[Age] < 51, 50,
IF('HR Data'[Age] < 61, 60,
IF('HR Data'[Age] < 71, 70,
IF('HR Data'[Age] < 81, 80,
IF('HR Data'[Age] < 91, 90,
100))))))))

Key Insights

Average Employee Age: 36.9 years

Average Working Hours: 80 hours per week

Attrition by Department: Highest in Sales, lowest in HR

Frequent Travelers show higher attrition rate

Environment Satisfaction average rating: 2.72 / 5

Gender Split: 60% Male, 40% Female

Education Fields: Life Sciences and Medical dominate

Top Attrition Roles: Sales Executive and Laboratory Technician

Dashboard Features

Interactive filters for Department, Gender, Job Role, Education Field

KPI Cards for overall metrics

Pie charts for Gender and Marital Status

Bar charts for Attrition by Department, Job Role, and Age Group

Gauge for Environment Satisfaction Score

Slicers to explore data dynamically

Conclusion

This dashboard delivers clear insights into attrition causes, empowering HR teams to build stronger retention strategies and enhance employee satisfaction.
By targeting departments with high turnover, management can optimize work-life balance and engagement initiatives effectively.

Skills Demonstrated

Data Cleaning and Transformation (Power Query)

Data Modeling and Relationship Management

DAX Formulas and Custom KPIs

Dashboard UI Design in Power BI

Analytical Storytelling

Duration: 2 Days
Data Source: Kaggle (IBM HR Analytics Dataset)
Tools Used: Excel, Power BI
File Name: HR-Employee-Attrition.xlsx