Back to Projects
Power BI · HR Analytics

HR Analytics
Employee Attrition Dashboard

An interactive Power BI dashboard analyzing employee attrition trends, workforce demographics, job satisfaction, and departmental turnover — enabling HR teams to make data-driven retention decisions.

🛠️ Power BI 📊 DAX Measures 📁 HR Analytics 👥 Workforce Intelligence
HR Analytics — Employee Attrition Dashboard · Power BI

Project Overview &
Problem Statement

The HR Analytics Employee Attrition Dashboard is an interactive business intelligence project built using Power BI and Excel. It provides deep insights into employee attrition trends, workforce demographics, job satisfaction, departmental turnover, and retention patterns across an organization.

Organizations frequently struggle to identify the root causes of employee attrition. Key challenges include understanding which departments or age groups are most at risk, detecting satisfaction-driven departures, and analyzing turnover by job role, gender, and education background.

The objective was to build a centralized HR analytics solution that monitors workforce trends, surfaces behavioral patterns, and equips HR teams with the insights needed to design targeted retention strategies — all through a dynamic, slicer-driven Power BI dashboard.

Project Details
Category HR Dashboard
Tools Power BI · Excel
Data Prep Power Query · DAX
Domain Human Resources
Filters Dept · Age · Gender · Role
Source Files GitHub →

Project at a Glance

👥
1,470
Total Employees
📉
237
Attrition Count
🔁
16.12%
Attrition Rate
📊
7+
Attrition Dimensions

Key Insights

01
26–35 Age Group Has Highest Attrition
Mid-career employees in the 26–35 age bracket show the highest attrition rate, indicating a critical retention window that requires focused engagement and growth opportunities.
02
R&D Department Leads in Turnover
The Research & Development department records the highest attrition among all departments, suggesting workload pressure or limited career advancement in technical roles.
03
Male Employees Show Higher Attrition
Male employees demonstrate a higher rate of attrition compared to female employees, pointing to gender-specific workplace factors that HR policies should address.
04
Medium Satisfaction Drives Departure
Employees reporting medium job satisfaction levels are more likely to leave, suggesting that partial engagement — not just low satisfaction — is a key attrition trigger.
05
Lab Technicians & Sales Execs Most Affected
Laboratory Technicians and Sales Executives record the highest turnover by job role, highlighting the need for role-specific retention strategies and compensation reviews.
06
Education Background Influences Retention
Attrition patterns vary meaningfully by educational background, revealing opportunities for tailored career development programs that align with employees' academic profiles.

Tools & Technologies

📊 Power BI
📗 Microsoft Excel
🔧 Power Query
🧮 DAX Measures
🎛️ Interactive Slicers
📉 KPI Cards
🧹 Data Cleaning
📁 .pbix · .csv

Key Features

🎛️
Dynamic Filtering & Slicers
Interactive Power BI slicers allow filtering across department, gender, age group, education, and job role — enabling drill-down into any employee segment instantly.
📉
Attrition by Department
Visual breakdown of attrition across all departments surfaces which business units face the highest turnover, supporting targeted HR intervention and budget planning.
👤
Attrition by Gender & Age
Side-by-side demographic analysis reveals attrition patterns across gender and age brackets, helping HR design equitable and age-aware retention programs.
Job Satisfaction Analysis
A dedicated satisfaction view maps job satisfaction levels against attrition counts, making it easy to identify the satisfaction thresholds at which employees tend to leave.
🎓
Attrition by Education & Role
Cross-dimensional analysis across job role and education background uncovers structural attrition patterns beyond surface-level metrics.
🧮
DAX-Powered KPI Cards
Custom DAX measures compute Total Employees, Attrition Count, and Attrition Rate in real time — dynamically updating as filters are applied across the dashboard.

Dataset Information

The dataset is based on HR employee records, preprocessed using Microsoft Excel and Power Query to clean, transform, and structure data for meaningful analysis across multiple workforce dimensions.

Data fields included:

  • Employee demographics (age, gender, education)
  • Department and job role classification
  • Attrition status and count
  • Job satisfaction ratings
  • Tenure and experience metrics
  • Compensation and work-life balance indicators
📁 Project Files — via GitHub
📊
HR_analytics_BI_project.pbix
Power BI Dashboard File
GitHub
📗
HR_analytics_BI_project.csv
Source Dataset (CSV)
GitHub
🖼️
HR_analytics_dashboard.png
Dashboard Preview Image
GitHub

All files hosted on GitHub — click any row to download.

Takeaway

This dashboard transforms raw HR employee data into actionable workforce intelligence, enabling organizations to understand and address the root causes of employee attrition. By leveraging Power BI's interactive capabilities alongside DAX-powered KPI calculations and Power Query data transformation, it demonstrates how business intelligence tools can turn complex people data into clear strategic direction — from improving mid-career retention to reducing department-specific turnover and elevating overall job satisfaction.

Interested in
collaborating ?

Feel free to reach out for feedback, collaboration, or any data analytics opportunities.