HR Analytics & Attrition Dashboard

HR Analytics & Attrition Dashboard (Advanced Excel)

I built a dynamic, interactive HR Analytics Dashboard entirely within Microsoft Excel to help people-operations teams track workforce health, monitor turnover trends, and improve employee retention strategy.

Key Features & Insights:

Core Workforce KPIs: Real-time visibility into Total Employees (1,470), Active Headcount (1,233), Attrition Volume (237), and an overall Attrition Ratio of 16.12%.

Sentiment Tracking: Built-in Job Satisfaction Rating indicator (2.6 score with visual star formatting) to monitor employee sentiment.

Attrition Breakdown Analysis: Comprehensive deep-dives looking into attrition by Education Level, Department (led by R&D and Sales), Age Group (highest in the 25–34 bracket), and Marital Status.

Demographics & Roles: Visual breakdown of employee gender distribution and role-specific turnover using conditional formatting and dynamic tree-maps.

Interactive Slicers: Added native Excel slicers for Education Field and Department, enabling seamless, one-click exploratory data analysis.