Top 36
Prep plan
Updated weekly · Last refresh Oct 17
D

Disney+HotStar Data Analyst Interview Questions

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

36questions
~6htotal time
Track your progressSign up free to work through all 36 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 15 questions · ~145 min
Top 10 Users by Watch TimeMedium
Practice

Rank the top 10 Disney+ Hotstar users in India by January watch time using a CTE, LEFT JOIN, and aggregation.

sql queryData Analysisuser engagementDDisney+HotStar
Subscriber Retention Over 90 DaysHard
Practice

Calculate Disney+ Hotstar subscriber retention by cohort and acquisition channel using CTEs, joins, conditional aggregation, and window functions.

sql queryDDisney+HotStar
DAU by Content CategoryEasy
Practice

Calculate daily unique viewers for Disney+ Hotstar Sports content using a filtered join and COUNT(DISTINCT).

sql queryData AnalysisDDisney+HotStar
More SQL & Data Manipulation questions with a free account
2
Metrics11 questions · ~106 min
Define Success Metrics for FeaturesMedium

Set a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.

North Star MetricLagging IndicatorsKPIsDDisney+HotStar
Define Success for a New FeatureEasy

Define the right metrics to judge whether a new product feature is successful.

KPIsConversion RateLeading IndicatorsDDisney+HotStar
Define Subscription ChurnMedium

Assesses your approach to defining and calculating churn metrics for a streaming subscription business.

ChurnDDisney+HotStar
More Metrics questions with a free account

Sign up to see every question

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

Get my prep plan
3
Behavioral & Leadership8 questions · ~77 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~19 min
Prioritize Features Using Historical DataMedium

Assesses product analytics judgment and how you translate historical signals into prioritization.

product analysisFeature PrioritizationDDisney+HotStar
A/B Test for Subscription ConversionHard

Evaluates experimental design choices for measuring causal impact on Disney+HotStar subscription conversion.

A/B TestingDDisney+HotStar
The finish line: interview-readyComplete all 36 questions to finish this plan.