Dataford
Dataford
Top 2
Prep plan
Updated weekly · Last refresh Oct 17
R

Riot Games Business Analyst Interview Questions

The questions to prepare for a Riot Games Business 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
SQL & Data ManipulationStart here. 1 question + 3 drills · ~38 min
Detect and Handle Outliers in SQLEasy

Explain common SQL-friendly ways to detect outliers and how to handle them without distorting downstream analysis.

Data WranglingGroup ByAggregationsRRiot Games
SQL Rolling Averages Over 10 GamesMedium
Practice
Practice drill

Calculate each player's rolling 10-game averages for points, rebounds, and assists using PostgreSQL window functions.

Window FunctionsDate FunctionsData ManipulationOklahoma City ThunderRRiot Games
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
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
2
Behavioral & Leadership1 question · ~8 min
Dealing With ConflictEasy

Tests conflict resolution, self-awareness, direct communication, and ownership of outcomes.

Conflict Resolutionexperiencebehavioral interviewRRiot Games

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