Dataford
Dataford
Top 13
Prep plan
Updated weekly · Last refresh Oct 17

FRND Business Analyst Interview Questions

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

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
Window Functions for Rolling TrendsMedium
Practice
Practice drill

Calculate rolling survey response rates and rank Ipsos regions by overall response performance.

Window FunctionsDate FunctionsJoinsIpsos
Rolling 30-Day Event CountsHard
Practice
Practice drill

Calculate each patient's rolling 30-day event count and rank events by recency.

Window FunctionsDate FunctionsJoinsMedtronic
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.