HR Attrition Analysis Dashboard – Power BI

📊 Project Overview

The HR Attrition Analysis Dashboard is a Power BI dashboard designed to analyze employee attrition patterns within an organization.
It helps HR teams and management understand why employees leave, which departments are most affected, and what factors influence attrition.

This dashboard converts raw HR data into actionable insights using visual analytics and key performance indicators (KPIs).

---

🎯 Objectives

The main goals of this dashboard are:

• Monitor overall employee attrition rate
• Identify departments with highest attrition
• Analyze attrition by age, gender, job role, and salary
• Discover patterns that contribute to employee turnover
• Support data-driven HR decision making

---

📁 Dataset Information

The dataset used in this project contains employee-related information such as:

• Employee ID
• Age
• Gender
• Department
• Job Role
• Salary
• Years at Company
• Job Satisfaction
• Attrition Status (Yes/No)

The dataset is transformed in Power BI to create calculated columns and KPIs.

---

⚙️ Data Transformation

Data preprocessing was performed using Power Query in Power BI.

Steps performed:

1. Loaded dataset into Power BI
2. Cleaned missing or inconsistent values
3. Created a new Attrition Count column
4. Converted categorical fields where required
5. Structured the data for visualization

---

📈 Key KPIs in Dashboard

1️⃣ Attrition Count

Displays the total number of employees who left the company.

2️⃣ Attrition Rate

Percentage of employees who have left relative to total employees.

3️⃣ Total Employees

Shows the overall workforce size.

4️⃣ Average Salary

Displays the average salary of employees.

5️⃣ Average Years at Company

Indicates employee tenure.

---

📊 Dashboard Visualizations

The dashboard includes the following visual components:

• Attrition by Department
  Bar chart showing which departments have the highest attrition.

• Attrition by Job Role
  Helps identify roles with high employee turnover.

• Attrition by Age Group
  Shows which age groups leave the company most frequently.

• Attrition by Gender
  Compares attrition between male and female employees.

• Salary vs Attrition
  Analyzes whether salary impacts employee turnover.

• Years at Company vs Attrition
  Shows if new or experienced employees leave more often.

Filters (Slicers)

• Department
• Gender
• Job Role
• Age Group

These allow dynamic exploration of the data.

---

🖥️ Tools & Technologies Used

Tool	Purpose
Power BI	Dashboard development
Power Query	Data transformation
DAX	KPI calculations
Excel / CSV	Data source

---

📌 Insights Generated

The dashboard helps identify:

• Departments with the highest employee turnover
• Job roles where attrition is common
• Salary levels linked to attrition
• Age groups more likely to leave the organization

These insights help organizations improve employee retention strategies.

---

🚀 How to Use the Dashboard

1. Open the .pbix file in Power BI Desktop
2. Navigate through the dashboard pages
3. Use filters/slicers to explore different segments
4. Analyze KPIs and charts to derive insights

---

🔮 Future Improvements

Possible enhancements:

• Predictive attrition model using Machine Learning
• Employee satisfaction trend analysis
• Integration with HR databases
• Real-time data refresh
• AI-based attrition prediction

---

👨‍💻 Author

Pratham Sindkar
Aspiring Data Analyst | Data Scientist | AI Engineer

---

⭐ This project demonstrates skills in data visualization, business analytics, and Power BI dashboard development.