Top 40

Prep plan

Updated weekly · Last refresh Sep 22

Fti Consulting Data Analyst Interview Questions

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

40questions

~6htotal time

Track your progressSign up free to work through all 40 questions and resume where you left off.

Start practicing free →

1

PipelinesStart here. 4 questions · ~33 min

Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQuality

End-to-End Analytical Project PlanMedium

Tests project planning, scoping, execution, and delivery discipline for analytics work.

ETLOrchestrationData Modeling

Fti Consulting

More Pipelines questions with a free account

2

Statistics & Probability3 questions · ~25 min

Market Sizing: Tires in SpainHard

Evaluates estimation and quantitative reasoning using assumptions and structured market sizing.

Consulting Math Multiple ChoiceMedium

Evaluates quantitative reasoning and test-taking approach for data and analytics tasks.

calculations

Fti Consulting

More Statistics & Probability questions with a free account

Sign up to see every question

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

Get my prep plan

3

SQL & Data Manipulation3 questions + 2 drills · ~45 min

OCR SQL PitfallsMedium

Evaluates practical SQL thinking and common pitfalls when supporting OCR data processing.

sql

Fti Consulting

Database Indexing and PerformanceMedium

Tests your understanding of query performance and database optimization fundamentals.

SubqueriesJoinsData Wrangling

Fti Consulting

SQL Window Function RankingEasy

Rank customers by total revenue within each region using a window function.

Window FunctionsRankingGroup By

Capgemini FSSBU

Capgemini InventAAccenture España

Monthly Sales Trends by CategoryMedium

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData Wrangling

Total Wine & More

More SQL & Data Manipulation questions with a free account

4

Behavioral & Leadership28 questions · ~232 min

More Behavioral & Leadership questions with a free account

5

More topics2 questions · ~17 min

Deriving Insights from PurchasesMedium

Tests your analytics thinking, feature/metric design, and ability to translate data into insights.

Funnel AnalysisKPIsDiagnosis

Fti Consulting

Measuring Marketing Campaign EffectivenessMedium

Tests experiment design and measurement of impact using data-driven evaluation.

ExperimentationGuardrail MetricsA/B Testing

Fti Consulting

The finish line: interview-readyComplete all 40 questions plus 2 hands-on drills to finish this plan.