Retention & Cohort Analysis for DA Interviews
Nakul Sharma
5
Digital Product
24Sales
"How would you measure user retention?" is one of the most common Business Analytics questions asked at Amazon, Flipkart, Swiggy and Meesho, and most Data Analyst candidates get it wrong by just counting users.
What is inside:
What retention really means and why counting users is the wrong answer
Cohort analysis explained with a real cohort table you can read
The full SQL approach, built step by step with queries
Key metrics: retention rate, churn, D1 / D7 / D30, stickiness, repeat purchase
Common mistakes that get candidates rejected
practice interview questions with detailed answers
Useful for Data Analyst, Business Analyst and Product Analyst interviews.
What are people saying
Great talking with Nakhul He’s very comfortable to talk to and gives you a reality check, so it was great.
Anonymous
Aug 2026
A great listener, very friendly gave me useful insights which has cleared my mental fog during my preparation. Guided me to learn how to approach data analytics interview. Thank you!
Anonymous
Aug 2026
Found him really helpful for my neutral guidance without any biased advice. Gave me the direction that was really relevant to my background. Thanks a lot
Nikhil Kalra
Aug 2026
I reached out to Nakul in a clueless state.
He helped me clear my mind, focus on priorities, and restructure my Resume in ways I never knew.
the cherry on top was when he actually helped me learn more about the role I was trying get into and what market actually expects the candidates to know.
Felt really comfortable and confident after the session.
Highly recommended
Anonymous
Aug 2026
I had a resume review session with him, and it was really worth it. He explained everything clearly. He also pointed out the gaps and suggested how I could improve them. The best part was that he was very friendly and easy to talk to. Overall, it was a great session 😊
Janvi kashyap
Aug 2026
₹10