Employee attrition analysis and retention plan from the IBM HR data set
Find what drives attrition in a 1,470-person workforce, estimate what it costs, and build a retention plan with targets, costs and fairness checks.
Industry project · for Corvane Pharma Services, the US commercial operations arm of a mid-size drug maker with 1,470 employees
Corvane Pharma Services runs sales, research support and HR for a mid-size drug maker in the US. It has 1,470 employees. Last year about 16% left, and in the sales function the rate was higher. The CHRO estimates each departure costs between a third and a full year of salary once recruiting, onboarding and lost sales are counted, but nobody has added it up.
The CHRO has asked you, as an HR analytics intern, to answer three questions in six weeks: - Who is leaving, and what seems to drive it? - What does it cost the company each year? - What should HR do about it, how much will that cost, and how will we know it worked?
You will use the IBM HR Analytics Employee Attrition and Performance data set from Kaggle. It has 1,470 rows and about 35 columns, including age, department, job role, monthly income, overtime, job satisfaction, years at company, years since last promotion and attrition. It was created by IBM data scientists as a fictional data set, so say so in your report, and treat it as Corvane's HR extract for this project.
You will audit the data, explore attrition patterns, build an interpretable model, put a dollar figure on attrition by segment, design a retention plan with interventions and their expected effect, and check the plan for fairness and privacy.
Done means a CHRO can read one page and know which three groups to focus on, what it costs to keep doing nothing, and what the proposed plan will cost and save. The analysis must never be used to target or penalise individual employees.
Data audit + EDA report + attrition model notebook + cost-of-attrition workbook + retention plan with fairness check + CHRO deck
Stack: Python with pandas and scikit-learn, or R, Excel or Google Sheets, Power BI or Tableau (optional), PowerPoint or Google Slides
- Careful data work15
The data audit finds and handles constant columns, encodings and imbalance, and states that the data is fictional.
- Insightful exploration20
Attrition patterns are shown by segment with rates and counts, and the main drivers are identified.
- Interpretable model20
A model is trained and evaluated properly, and its drivers are explained in plain words.
- Cost and plan30
Attrition cost is estimated by segment and the retention plan has costed interventions, targets and a measurement plan.
- Responsible use15
Fairness, privacy and limits on individual-level use are addressed explicitly.
Pass 60% · Merit 75% · Distinction 90%
Engineering Students
Diploma, B.Tech, B.E., BCA, MCA, or M.Tech students seeking practical experience.
Aspiring Developers
Developers who want to build proof-of-work capstone projects for tech resumes.
Job Seekers
Graduates looking for AI-evaluated code review & verified industry credentials.