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

Factset Data Analyst Interview Questions

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

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
Optimizing a Slow QueryHard

Tests your performance troubleshooting skills across query design and database behavior.

SubqueriesJoinsCTEsFactset
Inner Join vs Left JoinEasy

Tests your understanding of SQL join semantics and how they affect result sets.

JoinsData WranglingFactset
Using SQL to Derive InsightsMedium

Tests your ability to translate questions into SQL and extract actionable insights from data.

JoinsGroup ByAggregationsFactset
SQL Query for Data ExtractionEasy

Tests your SQL proficiency for retrieving and shaping data for analysis.

JoinsGroup ByAggregationsFactset
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Unify CRM and Google Analytics ViewHard
Practice
Practice drill

Merge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.

SubqueriesJoinsData WranglingArtefact
2
Behavioral & Leadership12 questions · ~96 min
Leading a Deadline-Critical DeliveryMedium

Tests prioritization under pressure, ownership, and stakeholder alignment when leading a high-stakes project on a compressed timeline.

LeadershipOwnershipPrioritizationFactset
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Analyzing Product Launch ImpactMedium

Tests your analytical framework for measuring impact and selecting appropriate metrics and methods.

Value PropositionUse CasesProduct VisionFactset
Missing and Outlier DataMedium

Tests statistical handling choices and data-quality reasoning for trustworthy insights.

outliersdata handlingFactset
Identify Trends and AnomaliesMedium

Tests your ability to use metrics and exploratory analysis to surface meaningful patterns and outliers.

KPIsDiagnosisTime SeriesFactset

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