HR Analytics Dashboard – Power BI Project

📌 Project Overview

This project presents a comprehensive HR Analytics Dashboard built in Power BI to analyze employee attrition, salary distribution, job roles, education background, and workforce demographics.

The objective of this project was to:

Identify patterns behind employee attrition Analyze salary and job role distribution Understand demographic trends Build an interactive HR performance dashboard for decision-making This dashboard is designed for HR Managers and leadership teams to make data-driven workforce decisions.

🛠 Tools & Technologies Used

Power BI Desktop DAX (Data Analysis Expressions) Data Modeling (Fact & Dimension relationships) Data Cleaning & Transformation Conditional Formatting Slicers & Interactive Filtering KPI Card Visuals

📂 Data Modeling & Preparation

Cleaned and transformed raw HR dataset Built relationships between employee, salary, department, and job role tables Created calculated columns and measures Used DAX for attrition calculations and salary metrics Designed logical department-level filtering

📊 Dashboard Components

🔹 Executive KPI Summary

At the top of the dashboard:

👥 Employee Count: 967 🚪 Attrition Count: 133 📉 Attrition Rate: 13.8% 🎂 Average Age: 37 💰 Average Salary: 6.28K 🕒 Average Years at Company: 11.33

These KPIs provide a quick snapshot of workforce health.

🔹 Attrition by Gender

Male vs Female attrition comparison Identifies gender-based turnover patterns Supports diversity & retention strategies

🔹 Attrition by Education (Donut Chart)

Major contributors: Life Sciences (44%) Medical (35%) Technical Degree (15%) Helps HR understand which educational backgrounds have higher turnover.

🔹 Attrition by Age Group