Dataford
Top 13
Prep plan
Updated weekly · Last refresh Aug 30

FRND Business Analyst Interview Questions

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

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~56 min
7-Day Rolling Active UsersMedium
Practice

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

Window FunctionsDate FunctionsRunning TotalsFRND
Rank Functions for LeaderboardsEasy

Tests understanding of SQL ranking semantics and implications for leaderboard analytics.

Window FunctionsRankingperformanceFRND
SQL: Mutual Voice Note PairsMedium

Tests your ability to model user-to-user relationships and write correct self-join queries.

JoinsData WranglingSelf-JoinsFRND
Top Customers by Region VolumeMedium
Practice
Practice drill

Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.

Window FunctionsJoinsRankingJPMorganChaseSilicon Valley BankNavi
Rank Top Clients by Product RevenueEasy
Practice
Practice drill

Use a CTE, joins, and RANK() to find the top 2 clients by revenue for each product from completed 2024 orders.

Window FunctionsRankingAggregationsGooglePublicis GroupeRTX
More SQL & Data Manipulation questions with a free account
2
Strategy3 questions · ~27 min
Estimate Audio Rooms in IndiaMedium

Tests structured estimation and reasoning for FRND scale planning using assumptions and sanity checks.

EstimationBusiness AcumenMarket SizingFRND
Estimate Nationwide Voice BandwidthMedium

Tests your estimation skills for network and usage metrics using assumptions and unit conversions.

EstimationBusiness AcumenProblem SolvingFRND
Estimate Tier-2 City Monthly Gifting RevenueMedium

Tests your ability to build a defensible revenue model from limited inputs for FRND’s market.

Estimationrevenue modelMarket SizingFRND

Sign up to see every question

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

Get my prep plan
3
Metrics3 questions · ~27 min
Investigate DAU Drop in Audio RoomsMedium

Tests your approach to diagnosing engagement drops using metrics, segmentation, and root-cause analysis.

DAU/MAUDiagnosisEngagement MetricsFRND
Match Success Drop After ReleaseMedium

Tests your ability to prioritize diagnostic signals and isolate release-related causes using data.

Conversion Raterollout decisionDiagnosisFRND
More Metrics questions with a free account
4
Behavioral & Leadership3 questions · ~27 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 13 questions plus 2 hands-on drills to finish this plan.