Dynamic HR Analytics Dashboard in Excel: Track Workforce TrendsDynamic HR Analytics Dashboard in Excel: Track Workforce Trends
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
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.
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started