Dataford
Top 18
Prep plan
Updated weekly · Last refresh Sep 10

Hotstar Business Analyst Interview Questions

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

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 2 drills · ~81 min
Compare Monthly User Retention CohortsMedium
Practice

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

Window FunctionsDate FunctionsAggregationsHotstar
Optimize Large PostgreSQL Query PerformanceMedium

Explain how to tune slow PostgreSQL queries on multi-million-row tables using indexes, execution plans, joins, and partitioning.

Performance Tuningquery optimizationsqlHotstar
Intermediate SQL for Hotstar AnalyticsMedium

Assesses SQL proficiency for analyzing Hotstar engagement and content performance data.

analyticscase studysqlHotstar
Calculate 30-Day User RetentionHard
Practice
Practice drill

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

Window FunctionsDate FunctionsAggregationsCurefitIndeedTikTok
7-Day Rolling Active UsersMedium
Practice
Practice drill

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

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account
2
Product Sense5 questions · ~43 min
Marketing Impact on Retention FrameworkHard

Tests ability to design end-to-end analysis for long-term retention effects of marketing.

user retentionHotstar
Dashboard for Live Cricket HealthMedium

Tests KPI selection, monitoring design, and operational thinking for live streaming.

product metricsdashboard designHotstar
Success Metrics for Subscription TierMedium

Tests metric design for monetization and engagement outcomes tied to product strategy.

user engagementHotstar
More Product Sense questions with a free account
3
Behavioral & Leadership4 questions · ~35 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
Increase Engagement for Niche ViewersHard

Assesses your ability to translate OTT user behavior into actionable engagement strategies.

Hotstar
Hotstar OTT Case Study Problem SolvingHard

Evaluates your problem-solving framework for OTT business cases and your validation approach.

Problem SolvingsqlHotstar

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 18 questions plus 2 hands-on drills to finish this plan.