All projects
02Data Analysis · Visualisation2026
HR Attrition Analysis
Raw HR data that nobody was reading. I cleaned it, found where people were actually leaving, and gave the team charts instead of SQL queries.
Problem
HR had numbers but no story. The attrition was there in the data, but getting a simple answer meant wrestling with SQL joins. I cleaned the data and made it readable.
Approach
- Pulled the raw export, fixed typos and missing values, grouped by department and tenure.
- Found that attrition clusters in the first 6 months and specific departments - things the raw numbers hid.
Architecture
- Raw HR records
- Pandas cleaning
- Exploratory analysis
- Matplotlib charts
- CSV summary
Specification
- Data source
- HR export (CSV)
- Analysis
- Attrition by dept, tenure, role
- Deliverable
- Charts + one-page summary
- Finding
- 6-month cliff in attrition
Stack
- Python
- Pandas
- Matplotlib
All case studies
Notebook is on my machine. I'll walk you through it.