Developed a comprehensive, multi-page interactive Power BI dashboard leveraging the IBM HR dataset to analyze workforce demographics, evaluate employee performance, and diagnose the root causes of talent attrition. Designed an optimized Star Schema data model and implemented advanced DAX measures to track dynamic enterprise KPIs, translating complex workforce data into actionable business intelligence.
Key Features & Insights Delivered:
Executive Overview: Built high-level KPI cards tracking total headcount (1.47K employees), overall attrition rate (16.12%), and average monthly income ($6.50K) paired with dynamic filters for gender, department, and tenure.
Attrition Deep-Dive: Identified a critical vulnerability in entry-level staff, discovering that the highest attrition occurs among employees earning under $3,000 and those at Job Level 1.
Work-Life Balance Impact: Proved a direct correlation between corporate culture and turnover, showing a significant spike in departures among employees rating their work-life balance as "Poor".
Demographic Analytics: Highlighted talent mobility trends, showing that single employees have a higher propensity to leave compared to married or divorced staff.
Strategic Recommendations Provided:
Benchmarking salary structures for entry-level roles under $3K to mitigate high turnover costs.
Implementing a structured "Buddy System" or mentorship program specifically tailored for Job Level 1 integration.
Introducing flexible working options or remote initiatives to actively address work-life balance concerns
