Top 19
Prep plan
Updated weekly · Last refresh Oct 17

Factset Data Analyst Interview Questions

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

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 + 1 drill · ~47 min
Optimizing a Slow QueryMedium
Practice

Rewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.

Subqueriesdatabase optimizationJoinsFactset
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
Practice

Extract qualifying market observations by venue and price, then return them in chronological order.

JoinsData ManipulationGroup ByFactset
Handling Missing DataEasy
Practice
Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingUniversity of MinnesotaThe Home DepotNationwide
2
Behavioral & Leadership12 questions · ~111 min
Using Data Under AmbiguityMedium

Tests data-driven problem solving in ambiguous situations, with emphasis on ownership, stakeholder alignment, and measurable business impact.

CommunicationProblem SolvingOwnershipFactset
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~28 min
Analyzing Product Launch ImpactMedium

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

Value PropositionUse CasesProduct VisionFactset
Identify Trends and AnomaliesMedium

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

KPIsDiagnosisTime SeriesFactset
Missing and Outlier DataMedium

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

outliersdata handlingFactset

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 1 hands-on drill to finish this plan.