Engineers Clinic
BeginnerBusiness trackFP-MBA-05

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.

Business & ManagementHuman Resources
6 Guided Steps31h Internship TierSubmit: Data audit + EDA report + attrition model notebook + cost-of-attrition workbook + retention plan with fairness check + CHRO deckVerified CertificateAI Rubric Graded
Program Overview

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.

Exploratory data analysisLogistic regressionHR metricsCost modellingProgramme designEthics and privacy in people analytics
What you submit

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

How it is graded
  • 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%

Learning Outcomes
Audit and explore an HR data set
build and explain an interpretable attrition model
estimate the cost of attrition
design a costed retention plan
apply fairness and privacy checks
Target Audience

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.