Fti Consulting Business Analyst Interview Questions
The questions to prepare for a Fti Consulting Business Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to structure a cohort retention query using cohort assignment, period offsets, and aggregation in PostgreSQL.
Fti ConsultingRank customers by total revenue within each region using a window function.
Capgemini FSSBU
Blend360
Capgemini InventRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoUse CTEs, joins, and monthly aggregation to measure cohort activity trends and classify engagement over time.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Analyze where users drop off in a product funnel and identify the biggest conversion leak.
Fti ConsultingPick metrics for a new program by tying them to the goal, separating leading and lagging signals, and defining a clear KPI set.
Fti ConsultingExplain how to design and evaluate an A/B test for a product feature, including metrics, MDE, sample size, and guardrails.
Fti ConsultingAssess and recover a project that is slipping its deadline while balancing scope, stakeholders, and delivery risk.
Fti ConsultingUse customer feedback to identify the biggest pain points in the user journey.
Fti ConsultingEvaluates your accounting fundamentals and ability to connect financial statements for analysis.
Fti Consulting