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

JOHN LEONARD Business Analyst Interview Questions

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

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 3 questions · ~24 min
Documenting Requirements for FeaturesMedium

Tests your requirements documentation process, clarity, and ability to capture stakeholder needs.

processdocumentationJOHN LEONARD
Auditing an Underperforming SystemHard

Tests your approach to diagnosing issues, gathering evidence, and prioritizing fixes in complex systems.

AnalysisJOHN LEONARD
Prioritizing Competing DeadlinesMedium

Tests prioritization, planning, and tradeoff decisions under time pressure.

time managementtask managementPrioritizationJOHN LEONARD
2
Behavioral & Leadership7 questions · ~56 min
Learning From a Project FailureMedium

Tests accountability, root-cause thinking, and lessons learned from unsuccessful delivery.

OwnershipJOHN LEONARD
Improving a Process InefficiencyMedium

Tests continuous improvement thinking and your ability to drive practical process changes.

process improvementanalytical thinkingJOHN LEONARD
Resolving Conflicting Stakeholder NeedsMedium

Tests stakeholder management, negotiation, and decision-making when requirements conflict.

Conflict ResolutionStakeholder ManagementCommunicationJOHN LEONARD
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Using Data to Justify DecisionsMedium

Tests how you use data and analysis to support business decisions in an insurance context.

Data AnalysisJOHN LEONARD
Using SQL or Excel ExamplesMedium

Assesses your practical experience using SQL and spreadsheets to analyze data and inform decisions.

technical skillssqlExcelJOHN LEONARD

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Top Users by Region QueryMedium
Practice
Practice drill

Rank the top 10 ResMed myAir users in each region using joins, aggregation, and ROW_NUMBER().

Data AnalysissqlResmed
SQL Window Functions Moving AverageMedium
Practice
Practice drill

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlAAreteMITREGlassdoor
The finish line: interview-readyComplete all 12 questions plus 3 hands-on drills to finish this plan.