Guided projects
Each guided project is a realistic task from a fictional company, finished in one sitting. Start with an Intern task and work your way up to Senior Analyst.
12 of 12 scenarios
ShopKart · E-commerce
Why did Delhi sales drop last month?
Your first task: find out how much Delhi revenue fell in September and where the drop came from.
ShopKart · E-commerce
Who are our top 10% customers?
Rank customers by spend with window functions so the CRM team can launch a loyalty programme.
ShopKart · E-commerce
Where is cart abandonment highest?
Build a checkout funnel from raw events in Python and find the leak.
FinTrust Bank · Banking
Branch-wise monthly deposit report
Build the monthly deposit report every bank analyst makes — from a very messy core-banking export.
FinTrust Bank · Banking
Which customers may default on their loans?
Clean messy loan data and build a simple logistic regression to flag risky borrowers.
CareWell Hospital · Healthcare
Why is OPD wait time increasing?
Use timestamp maths in SQL to find which departments got slower, and when.
CareWell Hospital · Healthcare
Department-wise 30-day readmission rate
Use CTEs and LEAD() to calculate a key hospital quality metric correctly.
TalentCo · HR / IT services
Which team has the highest attrition — and why?
Exploratory analysis in pandas to find where people are leaving and what they have in common.
AdWave · Marketing
Which channel gives us the cheapest customer?
Calculate CAC and ROI per marketing channel by joining spend with attributed customers.
QuickBite · Food delivery
Why are deliveries late, and where?
Slice delivery data by zone, time, weather and kitchen to separate root causes.
ConnectOne · Telecom
Predict which subscribers will churn
Build and honestly evaluate a churn model — and avoid the data leak hiding in the table.
DailyMart · Retail
Forecast next month's stock
Build a time-series forecast for October that respects trend, weekly patterns and shifting festival dates.