Back to Portfolio
Tableau · Case Study
HR Analytics
An interactive Tableau HR dashboard analysing workforce attrition, department headcount, diversity metrics, and employee satisfaction across a multi-location organisation.
📋 Project Overview
Built a Tableau HR analytics dashboard to help an HR team understand attrition drivers, monitor headcount, and track diversity KPIs. The dashboard replaced quarterly PDF reports with an always-current interactive view.
🎯 Objectives
- Identify top drivers of employee attrition by department and tenure
- Track headcount by department, location, and employment type
- Monitor gender and diversity ratios across management levels
- Build attrition risk scoring using calculated fields
📊 Key Findings
🔴
18.5%
Overall Attrition
Above industry benchmark of 12% — flagged as critical.
📊
Sales Dept
Highest Risk
Sales shows 28% attrition — highest across all departments.
⏳
1-2 Years
Peak Attrition Window
Employees most likely to leave between 12-24 months tenure.
👩
43%
Female Managers
Gender representation in management above industry average.
⚙️ My Process
1
Data Prep
Cleaned HR CSV: standardized job titles, filled missing dept codes, encoded tenure bands in Excel.
2
Tableau Connection
Connected Excel source, set up data extract for performance.
3
Attrition Analysis
Built calculated fields for attrition rate by dept, tenure band, age group, and salary tier.
4
Dashboard Layout
3-tab dashboard: Overview, Attrition Deep Dive, Diversity.
5
Interactivity
Added filters for department, location, employment type, and date range.
💻 DAX Highlights
-- Attrition Rate (Tableau Calculated Field) Attrition Rate: SUM(IF [Attrition] = "Yes" THEN 1 ELSE 0 END) / COUNT([Employee ID]) -- Tenure Band Tenure Band: IF [Years At Company] < 1 THEN "< 1 Year" ELSEIF [Years At Company] < 2 THEN "1-2 Years" ELSE "> 2 Years" END
🏆 Outcomes & Impact
Results Delivered
18.5%
Attrition Identified
3
Dashboard Tabs
C-Suite
Adopted
- HR team identified Sales attrition root cause — compensation gap confirmed
- Exit interview process redesigned based on tenure band findings
- Dashboard presented to C-suite as standard monthly HR review tool
Interested in Similar Work?
Open to data analyst and dashboard roles. Let's build something impactful together.