Business Analyst

Differentiate the responsibilities and hiring signals of MBB generalist consulting, Big Four advisory, strategy, business operations, and business analyst roles.

Build a prioritized target list of suitable on-campus and off-campus roles based on eligibility, fit, and application timing.

Extract responsibilities, required skills, and recurring keywords from a consulting or analyst job description.

Convert a business-operations internship achievement into a quantified action-and-impact resume bullet.

Produce a one-page consulting resume tailored to a selected job description.

Revise a LinkedIn profile headline, summary, and experience entry to support consulting and analyst applications.

Write concise alumni, employee, and recruiter outreach messages with appropriate follow-ups.

Build an eight-week application tracker with weekly targets for applications, networking, preparation, and follow-ups.

Convert an ambiguous business prompt into a precise problem statement with an objective, scope, and success metric.

Ask focused clarifying questions before analyzing a business problem.

Decompose a business problem into a mutually exclusive and collectively exhaustive issue tree.

State a testable initial hypothesis from limited business information.

Prioritize issue-tree branches by likely impact and ease of validation.

Translate an issue tree into a sequenced analysis plan.

Synthesize analysis into a top-down answer supported by two or three decisive findings.

Map a company’s customers, value proposition, channels, revenue streams, and major costs.

Decompose revenue into price, volume, product mix, and customer-segment drivers.

Classify costs as fixed or variable and direct or indirect for a given business scenario.

Calculate revenue, gross profit, operating profit, and their corresponding margins.

Calculate contribution margin, break-even volume, and basic customer unit economics.

Build a KPI tree that connects an operational metric to a financial objective.

Use a value-chain analysis to identify sources of cost, differentiation, and competitive advantage.

Perform percentage, ratio, and fraction calculations accurately without a calculator.

Calculate growth rates, compound annual growth rate, and index changes from business data.

Use weighted averages to analyze prices, margins, or customer segments.

Estimate an unfamiliar market using explicit assumptions and a top-down approach.

Estimate an unfamiliar market using explicit assumptions and a bottom-up approach.

Interpret tables, bar charts, line charts, and waterfall charts used in case interviews.

Check a quantitative result using units, magnitude, and an independent approximation.

Apply pacing and accuracy techniques to a timed consulting-style numerical reasoning exercise.

Select evidence from academic, internship, and extracurricular experiences for leadership, teamwork, impact, and resilience questions.

Structure one personal-experience story using situation, complication, action, and result.

Deliver a concise resume walkthrough that connects prior experience to consulting.

Construct an evidence-based answer to “Why consulting?”

Construct a firm-specific answer to “Why this firm and role?” using credible research.

Respond to probing follow-up questions while preserving a clear and truthful narrative.

Evaluate a recorded fit-interview response using a clarity, evidence, ownership, and impact rubric.

Construct a profitability issue tree for a company with declining profit.

Diagnose a revenue decline by separating price, volume, product-mix, and segment effects.

Diagnose a cost increase by separating fixed, variable, direct, and indirect drivers.

Compare cost-based, competitor-based, and value-based pricing approaches for a given product.

Estimate the profit impact of a price change under different volume-response assumptions.

Prioritize profitability initiatives by financial impact, feasibility, timing, and risk.

Complete a timed profitability case and deliver a supported recommendation.

Segment a market into decision-relevant customer groups using explicit criteria.

Generate growth options across existing products, new products, existing markets, and new markets.

Assess market attractiveness using size, growth, profitability, competition, and regulation.

Estimate the revenue potential of a growth option using market size, share, and price assumptions.

Compare organic entry, partnership, acquisition, and joint-venture entry modes.

Identify capabilities, investment needs, risks, and mitigations for a market-entry plan.

Complete a timed growth or market-entry case and deliver a supported recommendation.

Create a process map that identifies inputs, activities, handoffs, outputs, and owners.

Calculate process capacity, utilization, throughput, and the location of a bottleneck.

Use a root-cause tree to investigate an operational performance gap.

Compare operational improvements by impact, implementation effort, and execution risk.

Evaluate a make-versus-buy decision using cost, capability, control, and risk criteria.

Assess an acquisition target’s strategic fit, potential synergies, and major due-diligence risks.

Complete a timed operations or acquisition case and deliver a supported recommendation.

Clean a small business dataset by correcting data types, duplicates, missing values, and inconsistent labels.

Use relative and absolute references in formulas that calculate business metrics.

Apply IF, SUMIFS, COUNTIFS, and basic text functions to answer operational questions.

Combine tables using XLOOKUP or INDEX and MATCH.

Summarize business performance with a PivotTable and calculated fields.

Create a decision-oriented Excel chart with clear labels and an appropriate visual form.

Build a one-variable sensitivity analysis for a revenue, cost, or profit assumption.

Retrieve selected columns from a table and filter, sort, and limit the resulting rows.

Calculate grouped business metrics using aggregate functions, GROUP BY, and HAVING.

Combine related customer, order, or product tables using INNER and LEFT JOIN.

Create conditional business categories using CASE expressions.

Handle null values and avoid double counting in joined datasets.

Use a subquery or common table expression to organize a multi-step analysis.

Write a SQL query that answers a stated business question and explain the result in plain language.

Convert analytical findings into a single governing conclusion and a small set of supporting arguments.

Organize a recommendation using the situation-complication-question-answer structure.

Select a chart type that accurately communicates a comparison, trend, composition, or relationship.

Build a consulting-style slide with an action title, one main message, and clearly sourced evidence.

Write a concise executive summary covering the answer, evidence, risks, and next steps.

Present a recommendation in five minutes using top-down communication.

Respond to challenges by acknowledging the question, answering directly, and supporting the answer with evidence.

Define a scoped business-operations question and measurable objective for a portfolio case.

Create a reproducible analysis workflow that uses Excel or SQL to answer the portfolio question.

Derive three decision-relevant insights from the portfolio analysis without overstating the evidence.

Develop recommendations with expected impact, implementation steps, risks, and success metrics.

Assemble the portfolio case into a concise, interview-ready slide deck.

Perform a full mock case interview and diagnose weaknesses using a structured scoring rubric.

Run a weekly review of the application funnel and adjust targeting, networking, and interview practice based on results.