Roku Business Analyst Interview Questions

The questions to prepare for a Roku 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.

SQL & Data ManipulationStart here. 6 questions · ~60 min

Evaluates practical SQL skills for analyzing ordered events and time-based patterns.

MAU and Retention for RokuMedium

Practice

Calculate Roku monthly active users and month-over-month retention using monthly aggregation and prior-month comparisons.

Window FunctionsDate FunctionsCTEs

Roku

Rank Users by Weekly HoursMedium

Practice

Rank Roku users by total completed streaming hours during a calendar week using aggregation and a window function.

Window FunctionsDate FunctionsJoins

Roku

More SQL & Data Manipulation questions with a free account

Metrics4 questions · ~40 min

Tests metric design and revenue attribution for Roku's dual-revenue business model.

Balance Ads and User ExperienceHard

Tests data-driven tradeoff analysis between monetization and engagement for Roku.

revenue modelTrade-offsEngagement Metrics

Roku

Measure Home Screen Layout SuccessMedium

Tests KPI selection and experimental measurement for Roku UI changes.

KPIActivationEngagement Metrics

Roku

More Metrics questions with a free account

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

Behavioral & Leadership7 questions · ~70 min

Leading an Ambiguous Data ProjectMedium

Tests ownership and stakeholder management in leading a data project from vague problem definition through delivery and measurable impact.

impactLeadershipOwnership

Roku

More Behavioral & Leadership questions with a free account