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

Freshworks Business Analyst Interview Questions

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

24questions
~3htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 2 drills · ~97 min
Top Customers by Last-Quarter SpendMedium
Practice

Join customers and transactions, filter to the previous quarter, aggregate spend, and return the top three customers by total spend.

Date FunctionsJoinsAggregationsFreshworks
SQL and Multi-Project ExecutionMedium

Evaluates SQL proficiency and your ability to manage parallel workstreams.

sqlProject ManagementFreshworks
Second-Highest Resolution TimeMedium
Practice
Practice drill

Find every ticket tied at the second-highest non-null resolution time for each support agent.

Window Functionsnull handlingJoinsFreshworks
SQL Window Functions for MoM GrowthMedium
Practice
Practice drill

Use LAG and ranking to find the McDonald's item with the highest month-over-month sales growth in each category.

Window FunctionssqlMcdonald'S Global Office In IndiaFreshworks
More SQL & Data Manipulation questions with a free account
2
Strategy4 questions · ~34 min
Measure Exactly 4 LitersMedium

Tests your logical reasoning for constrained measurement problems.

EstimationProblem SolvingFreshworks
Weighing Puzzle Minimum StepsMedium

Tests your problem-solving and optimization under constraints.

EstimationProblem SolvingFreshworks
More Strategy questions with a free account
3
Behavioral & Leadership7 questions · ~60 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~34 min
Excel Financial ModelingMedium

Assesses your ability to use Excel for financial modeling and stakeholder-ready analysis.

ExcelFinancial ModelingFreshworks
Statistics and Evaluation QuizHard

Evaluates statistical reasoning and your ability to judge solution quality under uncertainty.

Freshworks
Pivot Table for MRR TrendsMedium

Tests ability to design pivot views that support recurring revenue analysis.

KPIDiagnosisCohort AnalysisFreshworks
Charting Quarterly Churn for ExecutivesEasy

Tests data visualization choices for executive decision-making at Freshworks.

CommunicationKPIChurnFreshworks

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