HR Drama Uncovered: Dashboard Edition

For my second Power BI project, I stepped into the world of HR analytics to answer the age-old question: Why do employees leave? Using the IBM HR Analytics Employee Attrition dataset with 1,470 employees, I explored everything from age, gender, and education to job roles, satisfaction levels, and attrition status. Basically, I became a “data detective” trying to solve the mystery of disappearing employees.

Some of the key insights were both expected and hilarious: Sales executives and frequent travelers were the top quitters, environment satisfaction averaged only 2.72/5 (yikes!), and long working hours made me wonder how anyone survived without turning into a coffee-fueled zombie.

To tackle this, I built a dynamic dashboard with interactive filters, KPIs, pie charts, bar charts, and gauges. Users can now slice and dice data by department, gender, job role, and education field to see attrition trends at a glance. My dashboard turned messy spreadsheets into a story that even management could understand, and maybe even laugh at.

By the end of the project, I had not only learned data cleaning, DAX formulas, and dashboard design, but also how to tell an analytical story in a way that’s insightful and slightly funny. The dashboard empowers HR teams to identify high-turnover areas, improve employee satisfaction, and maybe even fix the office coffee machine (because let’s be honest, that might actually help).

Duration: 2 Days | Tools Used: Power BI, Excel