Back to Projects

HR Analytics Power BI Dashboard

Project Overview

This project focuses on performing HR Analytics using Power BI to understand key factors driving employee attrition. The goal was to analyze employee demographics, job roles, education levels, and salary patterns to uncover insights that help organizations improve retention strategies and workforce management. Using Power BI's Power Query and visualization features, the project involved data cleaning, transformation, and interactive dashboard creation. The final dashboard highlights metrics such as attrition rate, average age, salary, experience, and attrition distribution by job role, education, and age group – enabling a data-driven approach to understanding workforce dynamics.

Technologies & Skills Showcased

⚡ Power BI ⚡ Power Query ⚡ DAX ⚡ HR Analytics ⚡ Data Visualization

Power BI Dashboard

Key Metrics Analyzed

Attrition Rate

Overall employee turnover percentage

Average Age

Mean age of workforce

Average Salary

Mean compensation analysis

Experience

Years of service distribution

Analysis Dimensions

  • By Job Role: Attrition patterns across different positions
  • By Education: Impact of education levels on retention
  • By Age Group: Generational attrition trends
  • By Salary Slab: Compensation's effect on turnover
  • By Department: Cross-functional attrition comparison

What I Learned

Working on this HR analytics project helped me strengthen my business intelligence and storytelling skills in Power BI. Key takeaways include:

  • Using Power Query to clean and structure employee datasets efficiently
  • Designing interactive dashboards that visualize attrition trends and KPIs clearly
  • Applying DAX measures to calculate attrition rate, averages, and category breakdowns
  • Identifying how education, job role, and salary influence employee retention
  • Enhancing my ability to turn HR data into actionable insights for strategic decision-making

This project deepened my understanding of how data visualization can transform HR analytics—from descriptive statistics to predictive workforce planning insights.

Related Visualizations