Top 15
Prep plan
Updated weekly · Last refresh Sep 10

Hotstar Data Analyst Interview Questions

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

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 1 drill · ~106 min
Calculate 30-Day User RetentionHard
Practice

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregationsHotstar
7-Day Rolling Active UsersMedium
Practice

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsHotstar
SQL for Real MetricsMedium

Evaluates SQL proficiency for production-style metric computation and verification.

MetricssqlHotstar
Compare Monthly User Retention CohortsMedium
Practice
Practice drill

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsTrideumZulilyeBay
More SQL & Data Manipulation questions with a free account
2
More topics5 questions · ~48 min
Product Feature MetricsMedium

Assesses product sense by selecting metrics and defining measurable success criteria.

MetricsHotstar
Subscription Churn AnalysisMedium

Tests ability to define churn metrics and connect churn patterns to actionable drivers.

ChurnHotstar
Experiment: Recommendation Banner CTRHard

Tests experimental design, metrics, and controls for streaming UI changes.

experiment designA/B TestingHotstar
A/B Test for Landing Page LayoutHard

Tests A/B testing methodology, success metrics, and experiment validity.

experiment designHotstar
Case Study Problem SolvingMedium

Evaluates structured problem solving and how you apply your strengths in real data work.

Problem SolvingHotstar

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 15 questions plus 1 hands-on drill to finish this plan.