India & international online classes · Mon–Fri, 9 AM–7 PM IST+91 93900 23585info@learnai.co.in
← LearnAI blog

HR Analytics Practice Project: Explain a Recruitment Funnel

November 20, 2026 · LearnAI Editorial Team

A useful HR Analytics project starts with a question that someone can act on. For a learning exercise, ask: where do candidates leave a fictional recruitment process, and which stages need closer investigation? Build the project with invented records rather than real applicant information.

Define the process before choosing a chart

Write down the stages: application, screening, interview, offer and joining. Decide what one row represents. A candidate-stage event table answers different questions from a table containing only each candidate’s latest status. Record the meaning of each field so your results can be checked.

Prepare a fictional dataset

Create fictional candidate IDs, role categories, source channels, application dates, stage dates and outcomes. Include a few deliberately duplicated or incomplete records to practise validation. Use invented IDs and categories; a portfolio example does not need real names, contact details or interview notes.

Validate the records

Check that candidate IDs are consistent, dates follow the expected sequence and repeated records are explained. Keep withdrawn, rejected and still-in-progress applications distinguishable. If a joining date is missing, confirm whether the candidate is still in progress before labelling the record unsuccessful.

Define a few useful measures

Choose a small set of measures: applications by source, the number reaching each stage and conversion between defined stages. State the denominator for each percentage. A funnel based on all applications is different from one based on candidates who were interviewed. Use the same definition throughout your report.

Explain the result carefully

Describe a pattern without turning it into a conclusion about a person. A lower conversion rate from one channel may reflect different job roles, small sample sizes or incomplete records. Compare similar groups and record what extra information would be needed before recommending a change.

Prepare your project deliverables

Submit a data dictionary, a short cleaning log, a dashboard or analysis file and a written explanation. Include the fictional dataset, assumptions and known limitations. Your final demo should explain the question, show how you checked the data and identify one sensible follow-up investigation.

Review before presenting

Can another learner reproduce the totals? Are the funnel stages and denominators clear? Does the report distinguish observations from possible explanations? Have you removed any real applicant information? These checks make the project easier to review and discuss in an interview.

Explore related learning at LearnAI

HR Analytics · Business Analytics · Data Analytics

LearnAI has a classroom centre at Dilsukhnagar, Hyderabad, with online and hybrid options depending on the course and batch. Discuss the actual project scope and mentor arrangements with LearnAI. This article describes an illustrative exercise, not a guaranteed course deliverable or client engagement.

Explore project support · Explore internship formats

WhatsApp ↗