📊 HR Analytics Dashboard

📍 Repository Description

Power BI dashboard analyzing employee attrition and workforce trends with interactive visuals, KPIs, and insights to support data-driven HR decision-making.

---

📝 Project Overview

The HR Analytics Dashboard provides a comprehensive and interactive view of employee attrition data across various dimensions such as job role, salary slab, education, age groups, and years of service.
It helps HR departments understand turnover patterns, identify risk factors, and enhance workforce retention strategies.

---

🎯 Purpose

• Analyze employee attrition patterns and trends
• Identify high-risk job roles & demographic groups
• Support HR decision-making to improve retention and engagement
• Enable insight-driven workforce planning and budgeting

---

🛠 Tech Stack

• 📊 Power BI Desktop — dashboard development & visualization
• 📂 Power Query — data cleaning, merging & transformation
• 🧠 DAX — custom measures & KPI calculations
• 🗃 Data Modeling — Fact–Dimension relationship design
• 📁 File Types — .pbix (source file), .png (dashboard preview)

---

📈 Key Metrics (KPIs)

• 1473 — Total Employees
• 237 — Total Attrition Count
• 16.1% — Attrition Rate
• 37 — Average Employee Age
• 6.5K — Average Salary
• 7.0 Years — Average Experience

---

✨ Features & Highlights

• Attrition by Age — Highest attrition in age group 26–35
• Attrition by Education — Life Sciences & Medical backgrounds most affected
• Attrition by Salary Slab — Most attrition from Up to 5K salary range
• Attrition by Job Role — Highest among Laboratory Technician, Sales Executive & Research Scientist
• Attrition by Years at Company — Peak attrition during first year
• Job Role Performance Table — Drill-down view by department & role
• Gender-Based Attrition Comparison — Male attrition higher

---

💡 Key Business Insights

• Reveals turnover patterns for workforce restructuring and planning
• Helps HR plan salary corrections and retention strategies
• Identifies roles that require employee support programs & mentorship
• Assists in improving hiring processes and long-term engagement

---

🔗 Live Dashboard Link

👉 https://app.powerbi.com/view?r=eyJrIjoiYjIwMjFlOTItMTkzZC00MDk1LWE5ZWEtYzhmNDBjMzdmNWJmIiwidCI6ImFmN2E0MGMwLWE4MWQtNGZkZi05ZTQwLTcwNzNjNzQ1NzI1NCJ9

---

🖼 Dashboard Preview

---

📌 Tags

Power BI HR Analytics Employee Insights Business Intelligence Dashboard
Attrition Analysis HR Data Power Query DAX Interactive Reporting Data Visualization