Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Shopee Business Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions · ~78 min
Rank Users or Sellers With Window FunctionsMedium
Practice

Rank sellers by completed order value, including sellers without orders and preserving ties.

Window FunctionsJoinsData ManipulationShopee
Daily or Regional AggregationsEasy
Practice

Calculate completed Shopee order counts and daily GMV using WHERE, GROUP BY, and SUM.

Date FunctionsGroup ByAggregationsShopee
More SQL & Data Manipulation questions with a free account
2
Metrics12 questions · ~105 min
Diagnose Regional Gross Margin DropEasy

Identify the first diagnostic step when gross margin drops sharply in one region and break the metric into likely drivers.

KPIsLeading IndicatorsDiagnosisShopee
Diagnose Conversion Drop Post LaunchMedium

Diagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.

Funnel AnalysisConversion RateDiagnosisShopee
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
Execution11 questions · ~96 min
Prioritize Multiple Urgent IssuesEasy

Explain how you would prioritize competing urgent issues while balancing delivery risk, stakeholder expectations, and near-term commitments.

Trade-offsRisk AssessmentScope ManagementShopee
More Execution questions with a free account
4
Strategy9 questions · ~78 min
Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisShopee
More Strategy questions with a free account
5
Product Sense4 questions · ~35 min
Improve Engagement on ShopeeMedium

Evaluates your product sense for engagement levers and how you would measure impact on Shopee.

Feature PrioritizationUser NeedsPain PointsShopee
More Product Sense questions with a free account
6
Behavioral & Leadership3 questions · ~26 min
More Behavioral & Leadership questions with a free account
7
More topics2 questions · ~17 min
Shopee Revenue and Cost StreamsMedium

Assesses your understanding of Shopee’s financial drivers and cost structure.

cost analysisShopee
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.