Analytics Consulting Interview Preparation

Rewrite selected CV bullets to demonstrate quantified analytical or commercial impact while preserving the required anonymity.

Deliver a concise personal introduction that connects your data-science background to analytics strategy consulting.

Explain why you want analytics consulting rather than a purely technical data-science role.

Explain why OC&C's strategy focus, analytics practice, sectors, and working model fit your goals.

Reframe a technical project as a client-relevant story about the decision, analysis, insight, and business impact.

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.

Build a mutually exclusive and collectively exhaustive issue tree for a business problem.

Test an issue tree for overlaps, omissions, and branches that do not affect the client decision.

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.

Decompose revenue, cost, profit, and contribution margin into decision-relevant business drivers.

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

Determine whether a written conclusion is true, false, or unsupported using only the evidence provided.

Identify the assumption that most strengthens or weakens a short commercial argument.

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.

Translate a client decision into a testable analytical question and a decision-linked metric.

Identify data-quality problems in messy transaction, customer-behaviour, or web data that could distort a recommendation.

Calculate and interpret customer-level commercial metrics from transaction data.

Create actionable customer segments and compare their size, behaviour, and economic value.

Interpret conversion-funnel or cohort evidence to locate a commercially important performance problem.

Distinguish descriptive, predictive, and causal claims when deciding what recommendation the available analysis supports.

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.

Implement a requested business metric in Python and return a clear, decision-ready result.

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.

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 with a concise situation, action, result, and reflection drawn from your experience.

Respond consistently to probing follow-up questions about your individual 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.