Analytics Consulting Interview Preparation

Convert an ambiguous client prompt into a precise decision question with an objective, scope, and success measure.

Ask targeted clarification questions that resolve material ambiguity without delaying the analysis.

Construct and quality-check a mutually exclusive, collectively exhaustive, and decision-relevant issue tree.

Prioritise case branches using an explicit hypothesis and the likely value of each analysis.

Deliver a two-minute case opening that clearly states the objective, structure, and initial priorities.

Calculate percentage changes, percentage-point changes, ratios, and indexed values accurately without unnecessary steps.

Estimate a market size using explicit demand-side or supply-side drivers and a numerical sanity check.

Extract the decisive comparison or trend from a dense chart or table and support it with the correct figures.

Diagnose the principal cause of a profitability change using revenue, cost, mix, and market evidence.

Assess market attractiveness using demand, competition, customer, and economic evidence relevant to the decision.

Evaluate whether a client should enter a new market by integrating attractiveness, capabilities, risks, and entry options.

Compare organic growth options using expected impact, feasibility, investment, and strategic fit.

Evaluate a pricing decision using willingness to pay, elasticity, competitive response, and unit economics.

Assess the commercial attractiveness of an acquisition target using market, customer, competitive, and financial evidence.

Synthesize interim findings, update the working hypothesis, and identify the next highest-value analysis during a case.

Determine the row grain, candidate keys, and expected relationship between a flight-information table and a longitudinal flight-price table.

Standardise date, time, categorical, missing-value, and duplicate representations in airline datasets before analysis.

Engineer and validate year, month, day, day-of-week, and booking-lead-time features from airline date fields.

Merge flight-information and price-history datasets while checking unmatched keys, duplicate expansion, and row-count consistency.

Calculate grouped fare statistics, flight counts, and unique-flight counts across destinations, weekdays, and service characteristics.

Compare competitors' fare levels and price trajectories as departure approaches while accounting for route and service differences.

Fit an interpretable pricing model and identify which route, flight, competitor, and booking-timing factors are associated with higher fares.

Convert airline summary statistics and model outputs into actionable dynamic-pricing recommendations with explicit limitations.

Clean and validate a messy pandas dataset within a fixed time limit.

Join and aggregate tabular datasets in pandas to answer a stated commercial question.

Debug a short Python data-analysis script by tracing incorrect logic, data types, and edge cases.

Diagnose speed and accuracy errors after completing a timed numerical-reasoning set.

Justify answers to a timed critical-reasoning set using only stated assumptions and evidence.

Complete a 45-minute two-table coding drill by triaging tasks and preserving reproducible intermediate outputs for later questions.

Complete a 45-minute output-based question set by checking numerical results, model interpretation, and client implications against saved outputs.

Present an analytical finding in a top-down format that separates the answer, supporting evidence, and implication.

Deliver a final case recommendation that addresses the client objective, quantifies the rationale, and acknowledges risks.

Answer a behavioural question and probing follow-ups consistently using concise evidence about your contribution, choices, setbacks, and learning.

Record a concise one-way video response with a direct opening, structured evidence, and confident delivery.

Complete a timed interviewer-led analytics case and diagnose specific improvements using an evidence-based self-review.

Complete a partner-style strategy or M&A case while defending assumptions, adapting to challenges, and delivering a persuasive recommendation.