HR Analytics Dashboard in Excel and Power BI

Project Overview:

Developed an end-to-end Human Resources (HR) Analytics solution using Microsoft Excel and Power BI to analyze workforce demographics, employee turnover (attrition), and performance metrics.

Key Technical Tasks Implemented:

- Data Cleaning & ETL: Used Excel and Power Query to clean raw HR records, remove duplicates, standardize categories, and handle missing values.

- KPI Calculation & Modeling: Built structured data models and calculated essential HR metrics including Headcount, Attrition Rate, Average Tenure, Salary Distribution, and Satisfaction Scores.

- Interactive Dashboard Design: Created multi-page interactive reports enabling HR managers to filter workforce data by department, job role, age group, education field, and gender.

- Documentation: Organized and documented all project datasets, transformation steps, and dashboard files in a structured GitHub repository.

Business Impact:

Provided clear visibility into the key drivers of employee turnover, helping HR teams make data-driven decisions to improve employee retention and workforce planning.