Workforce and Attrition Analytics
A Tableau dashboard that shows where and why people leave, so HR can act on retention before it becomes a hiring problem.
Drag the handle to compare the raw data with the finished dashboard.
3 years
of sample HR history modeled
4 sources
headcount, exits, pay and teams joined
3 lenses
teams, tenure and pay position
The scenario
A company knows staff turnover is high but not where it comes from. Exit data lives in one system and headcount in another, and nobody can say whether people leave because of pay, managers or workload.
The data
Sample monthly headcount snapshots, exit survey responses, compensation bands and team structures, joined in SQL. Employee IDs are reused after people leave, so I built a surrogate key to keep each person’s history clean.
My approach
The first step is one agreed definition of attrition, since HR teams often count it differently. The dashboard then compares teams, tenure bands and pay position, and highlights the groups where the leaving rate is clearly above the company average.
What it changes
HR can see which teams and tenure bands lose people fastest and what they have in common, and can aim retention work there instead of company-wide.
Dashboard gallery
Hiring, or looking for a BI partner?
I'm open to senior BI and analytics roles and to selected consulting projects. Tell me what you're working on and I'll get back to you within 1 to 2 business days.