Dataford
Top 2
Prep plan
Updated weekly · Last refresh Sep 22
B

Bharti Airtel Data Analyst Interview Questions

The questions to prepare for a Bharti Airtel Data Analyst interview. Questions from real interview reports rank first. Updated daily.

2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →
1
Data WranglingStart here. 1 question + 2 drills · ~28 min
UNION vs UNION ALL UsageEasy

Explain how UNION and UNION ALL differ when combining result sets, especially around duplicate handling and performance.

Data WranglingperformanceUnionsBBharti Airtel
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymoCruise
2
Joins1 question · ~8 min
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByBBharti Airtel

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 1 drill · ~10 min
Department-Wise Second Highest SalaryMedium
Practice
Practice drill

Use DENSE_RANK and a department join to identify each department's second-highest distinct salary.

Window FunctionsRankingGroup ByIncedoMMindbodyHHoonartek
The finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.