consulting excel case study

47 case interview examples (from McKinsey, BCG, Bain, etc.)

One of the best ways to prepare for   case interviews  at firms like McKinsey, BCG, or Bain, is by studying case interview examples. 

There are a lot of free sample cases out there, but it's really hard to know where to start. So in this article, we have listed all the best free case examples available, in one place.

The below list of resources includes interactive case interview samples provided by consulting firms, video case interview demonstrations, case books, and materials developed by the team here at IGotAnOffer. Let's continue to the list.

• McKinsey examples
• BCG examples
• Bain examples
• Deloitte examples
• Other firms' examples
• Case books from consulting clubs
• Case interview preparation

Click here to practise 1-on-1 with MBB ex-interviewers

1. mckinsey case interview examples.

• Beautify case interview (McKinsey website)
• Diconsa case interview (McKinsey website)
• Electro-light case interview (McKinsey website)
• GlobaPharm case interview (McKinsey website)
• National Education case interview (McKinsey website)
• Talbot Trucks case interview (McKinsey website)
• Shops Corporation case interview (McKinsey website)
• Conservation Forever case interview (McKinsey website)
• McKinsey case interview guide (by IGotAnOffer)
• Profitability case with ex-McKinsey manager (by IGotAnOffer)
• McKinsey live case interview extract (by IGotAnOffer) - See below

2. BCG case interview examples

• Foods Inc and GenCo case samples  (BCG website)
• Chateau Boomerang written case interview  (BCG website)
• BCG case interview guide (by IGotAnOffer)
• Written cases guide (by IGotAnOffer)
• BCG live case interview with notes (by IGotAnOffer)
• BCG mock case interview with ex-BCG associate director - Public sector case (by IGotAnOffer)
• BCG mock case interview: Revenue problem case (by IGotAnOffer) - See below

3. Bain case interview examples

• CoffeeCo practice case (Bain website)
• FashionCo practice case (Bain website)
• Associate Consultant mock interview video (Bain website)
• Consultant mock interview video (Bain website)
• Written case interview tips (Bain website)
• Bain case interview guide   (by IGotAnOffer)
• Digital transformation case with ex-Bain consultant
• Bain case mock interview with ex-Bain manager (below)

4. Deloitte case interview examples

• Engagement Strategy practice case (Deloitte website)
• Recreation Unlimited practice case (Deloitte website)
• Strategic Vision practice case (Deloitte website)
• Retail Strategy practice case  (Deloitte website)
• Finance Strategy practice case  (Deloitte website)
• Talent Management practice case (Deloitte website)
• Enterprise Resource Management practice case (Deloitte website)
• Footloose written case  (by Deloitte)
• Deloitte case interview guide (by IGotAnOffer)

5. Accenture case interview examples

• Case interview workbook (by Accenture)
• Accenture case interview guide (by IGotAnOffer)

6. OC&C case interview examples

• Leisure Club case example (by OC&C)
• Imported Spirits case example (by OC&C)

7. Oliver Wyman case interview examples

• Wumbleworld case sample (Oliver Wyman website)
• Aqualine case sample (Oliver Wyman website)
• Oliver Wyman case interview guide (by IGotAnOffer)

8. A.T. Kearney case interview examples

• Promotion planning case question (A.T. Kearney website)
• Consulting case book and examples (by A.T. Kearney)
• AT Kearney case interview guide (by IGotAnOffer)

9. Strategy& / PWC case interview examples

• Presentation overview with sample questions (by Strategy& / PWC)
• Strategy& / PWC case interview guide (by IGotAnOffer)

10. L.E.K. Consulting case interview examples

• Case interview example video walkthrough   (L.E.K. website)
• Market sizing case example video walkthrough  (L.E.K. website)

11. Roland Berger case interview examples

• Transit oriented development case webinar part 1  (Roland Berger website)
• Transit oriented development case webinar part 2   (Roland Berger website)
• 3D printed hip implants case webinar part 1   (Roland Berger website)
• 3D printed hip implants case webinar part 2   (Roland Berger website)
• Roland Berger case interview guide   (by IGotAnOffer)

12. Capital One case interview examples

• Case interview example video walkthrough  (Capital One website)
• Capital One case interview guide (by IGotAnOffer)

12. EY Parthenon case interview examples

• Candidate-led case example with feedback (by IGotAnOffer)

14. Consulting clubs case interview examples

• Berkeley case book (2006)
• Columbia case book (2006)
• Darden case book (2012)
• Darden case book (2018)
• Duke case book (2010)
• Duke case book (2014)
• ESADE case book (2011)
• Goizueta case book (2006)
• Illinois case book (2015)
• LBS case book (2006)
• MIT case book (2001)
• Notre Dame case book (2017)
• Ross case book (2010)
• Wharton case book (2010)

Practice with experts

Using case interview examples is a key part of your interview preparation, but it isn’t enough.

At some point you’ll want to practise with friends or family who can give some useful feedback. However, if you really want the best possible preparation for your case interview, you'll also want to work with ex-consultants who have experience running interviews at McKinsey, Bain, BCG, etc.

If you know anyone who fits that description, fantastic! But for most of us, it's tough to find the right connections to make this happen. And it might also be difficult to practice multiple hours with that person unless you know them really well.

Here's the good news. We've already made the connections for you. We’ve created a coaching service where you can do mock case interviews 1-on-1 with ex-interviewers from MBB firms . Start scheduling sessions today!

Related articles:

• What is Strategy?
• Business Models
• Developing a Strategy
• Strategic Planning
• Competitive Advantage
• Growth Strategy
• Market Strategy
• Customer Strategy
• Geographic Strategy
• Product Strategy
• Service Strategy
• Pricing Strategy
• Distribution Strategy
• Sales Strategy
• Marketing Strategy
• Digital Marketing Strategy
• Organizational Strategy
• HR Strategy – Organizational Design
• HR Strategy – Employee Journey & Culture
• Process Strategy
• Procurement Strategy
• Cost and Capital Strategy
• Business Value
• Market Analysis
• Problem Solving Skills
• Strategic Options
• Business Analytics
• Strategic Decision Making
• Process Improvement
• Project Planning
• Team Leadership
• Personal Development
• Leadership Maturity Model
• Leadership Team Strategy
• The Leadership Team
• Leadership Mindset
• Communication & Collaboration
• Problem Solving
• Decision Making
• People Leadership
• Strategic Execution
• Executive Coaching
• Strategy Coaching
• Business Transformation
• Strategy Workshops
• Leadership Strategy Survey
• Leadership Training
• Who’s Joe?

Analytical Modeling

“War is ninety percent information.”

– Napoleon Bonaparte

Employees make dozens of decisions a day. How much should I buy? Where can I cut costs? How does pricing affect my sales? What is the cost-benefit of this investment? On and on.

Creating an analytic model is often the best tool to inform a better understanding of the situation, dynamics, options , and decision-making. I’ve created hundreds of models, some spanning just a few lines of an Excel spreadsheet, others that took months to build with hundreds of Excel pages, and drove the strategic direction of multi-billion companies.

The final product, beyond the recommendations, of many strategy projects , is a robust model that represented the abstraction of the scope of reality that was the focal of the problem solving . A core competency for strategic leaders is understanding how to utilize analytic models properly. We’ll go over some of the best practices they teach in the top business schools and strategy firms.

What is an analytical model?

An analytical model is always an imperfect abstraction of reality. Though, by abstracting reality, pulling apart the variables of a system, and freely manipulating and observing the dynamics of those variables, in the petri dish of a model, you can often generate more insights than through any other type of problem solving.

An analytical model is a data representation of a situation or system. Analytical models are primarily used to better understand a situation and inform decisions. There are four main elements to any analytical model, which include:

Models are typically created to answer a particular question, and the answer to this question is the output of the model.

2. Parameters

The base assumptions of a model make up the parameters of a model. Assumptions are typically based on some sort of historical data or informed by facts. A model is only as good as the parameters and assumptions that drive it.

3. Decisions

Most analytical models are created to help make decisions, and potential decisions should be represented as the main part of any model.

4. Calculations

The calculations of a model are performed on inputs (i.e., parameters and decisions), to create the output of the model.

Below is a simple example of a model to better understand the future profit of a business.

In the above model, the parameters, decisions, outputs, and calculations are separated. This is a key attribute of good models since it makes the model much easier to follow, change, review, and think through. In this example, the parameters include the actual 2013 sales, gross margin percentage, and fixed costs, along with assumptions about future sales growth and gross margin percentages. The main decision is the fixed cost growth rate. The output of the model is the expected profit, given the parameters and decisions. And, the calculations are pretty simple, made up of the sales forecast, gross margin dollars, fixed costs, and profit.

As Steve Powell and Ken Baker, my fantastic MBA decision sciences professors, outline in their book Management Sciences, there are five main types of analysis that are conducted using models, including:

1. Base case analysis

Analyzing the current situation, under the most likely parameters and assumptions, and potentially projecting that current situation into the future.

2. What-if analysis

Evaluating the changes in outputs, given different scenarios and changes in parameters and decisions.

3. Breakeven analysis

Understanding the assumptions and decisions necessary to break even in profit, cost-benefit, or any other financial or investment situation.

4. Optimization

Determining the decision variables that will create the optimal value in the outputs.

5. Risk or simulation analysis

Analyzing the change in outputs given the uncertainty and probabilistic changes in parameters and potentially decisions.

In the above model, you can imagine performing each one of these analyses. For the different analyses, there are matching tools in Excel. For base case analysis, use regression tools to project historical trends into the future. For what-if analysis, use scenarios of parameters, decisions, and tornado charts . For breakeven analysis use the Excel goal seek tool. For optimization, use the Excel solver add-in. And, for risk or simulation analysis download a Monte Carlo 3rd party add-in.

What are the best practices in building models?

There are a lot of best practices in building models. We won’t get into Excel tutorials, but we will give you tips for building great models. Here they are:

First, Determine the Output

Define the problem you are trying to solve with the model and then define the output of the model. Streamline the process of making a model by working backward from what you are trying to solve.

Sketch it Out

Instead of jumping right into the data and building the model, take some time to sketch out the model. Given the output, what data do you need, and what are the main parameters and decisions? What is the general flow of calculations? What is the time dimension of the model? Sketching out and thinking through the main questions and blocks of a model will cut down the overall time of creating a great model.

Understand the Major Drivers

Almost every model has some select variables that are the main drivers of the output of the model, and these variables are the sensitivity variables. Understanding which variables are the sensitivity variables will give you a lot of insight into the dynamics of and the reality you are abstracting with the model.

Separate the Elements

Keep parameters, decisions, outputs, and calculations separated. It is one of the hardest, but one of the most important things to engrain into analysts. And, never hardcode assumptions within calculations.

Keep it Simple

There should never be more than 3-4 elements in an equation. If you find long, dense equations in your models, you should focus on staging the equations and creating new columns and rows to separate the staged equations, which will help in quality checking, auditing, making edits, updating, and taking people through your logic. Having long equations is like creating a knotted ball of yarn in your model.

Sanity Check

Once you create a model, spend some time changing parameters and decisions to check to see if the calculations and output make sense. Go through the calculations to ensure the logic and quality is sound. You can use the audit formulas in Excel to trace the variables in equations and check for errors.

DOWNLOAD A STARTER EXCEL MODEL

To get you going on modeling, download the free and editable starter Excel model.

NEXT SECTION: CHARTS

DOWNLOAD STRATEGY PRESENTATION TEMPLATES

THE $150 VALUE PACK - 600 SLIDES 168-PAGE COMPENDIUM OF STRATEGY FRAMEWORKS & TEMPLATES 186-PAGE HR & ORG STRATEGY PRESENTATION 100-PAGE SALES PLAN PRESENTATION 121-PAGE STRATEGIC PLAN & COMPANY OVERVIEW PRESENTATION 114-PAGE MARKET & COMPETITIVE ANALYSIS PRESENTATION 18-PAGE BUSINESS MODEL TEMPLATE

JOE NEWSUM COACHING

EXECUTIVE COACHING STRATEGY COACHING ELEVATE360 BUSINESS TRANSFORMATION STRATEGY WORKSHOPS LEADERSHIP STRATEGY SURVEY & WORKSHOP STRATEGY & LEADERSHIP TRAINING

THE LEADERSHIP MATURITY MODEL

Explore other types of strategy.

BIG PICTURE WHAT IS STRATEGY? BUSINESS MODEL COMP. ADVANTAGE GROWTH

TARGETS MARKET CUSTOMER GEOGRAPHIC

VALUE PROPOSITION PRODUCT SERVICE PRICING

GO TO MARKET DISTRIBUTION SALES MARKETING

ORGANIZATIONAL ORG DESIGN HR & CULTURE PROCESS PARTNER

EXPLORE THE TOP 100 STRATEGIC LEADERSHIP COMPETENCIES

TYPES OF VALUE MARKET ANALYSIS PROBLEM SOLVING

OPTION CREATION ANALYTICS DECISION MAKING PROCESS TOOLS

PLANNING & PROJECTS PEOPLE LEADERSHIP PERSONAL DEVELOPMENT

Hacking the Case Interview

Although case interviews do not require any technical math or finance knowledge, there are basic formulas that you should know in order to do well in order to master case interview math .

This article will cover the 26 formulas you should know for case interviews. These formulas are organized into the following categories:

• Profit Formulas
• Investment Formulas
• Operations Formulas
• Market Share Formulas
• Accounting, Finance, and Economics Formulas

If you’re looking for a step-by-step shortcut to learn case interviews quickly, enroll in our case interview course . These insider strategies from a former Bain interviewer helped 30,000+ land consulting offers while saving hundreds of hours of prep time.

Profit Formulas for Case Interviews

1. Revenue = Quantity * Price

Revenue is the amount of money a company brings in from selling its products. This can be calculated by taking the number of units sold and multiplying it by the price per unit.

Example: Your company sells shirts for $20 each. Last year, your company sold 1,000 shirts. So, your total revenue last year was 1,000 * $20 = $20,000.

2. Total Variable Costs = Quantity * Variable Costs

Costs are payments that a company needs to make in order to run and operate its business. There are two different types of costs, variable costs and fixed costs.

Variable costs are costs that directly increase for each additional unit of product made. It represents the cost of raw materials needed to make the product.

Total variable costs are calculated by taking the number of units produced or sold and multiplying it by the raw material cost per product.

Example: It costs your company $5 to purchase the raw materials needed to make a shirt. If your company sold 1,000 shirts last year, the total variable costs are 1,000 * $5 = $5,000.

3. Costs = Total Variable Costs + Fixed Costs

Total costs for the company can be calculated by adding total variable costs and fixed costs.

Fixed costs are costs that do not directly increase for each additional unit of product made. They may include costs such as rent for the building or equipment needed to make the product.

Example: Your company pays annual rent of $10,000. It also leases the equipment it needs to make its shirts for $2,000 a year. Therefore, fixed costs are $10,000 + $2,000 = $12,000. Total variable costs were calculated to be $5,000 from the previous example. So, total costs are $12,000 + $5,000 = $17,000.

4. Profit = Revenue – Costs

Profit is the amount of money the company keeps after paying for all of its costs. Profit is calculated by subtracting total costs from total revenue.

Example: Last year, your shirt company generated revenues of $20,000 and had costs of $17,000. The profit last year was $20,000 - $17,000 = $3,000.

5. Profit = (Price – Variable Costs) * Quantity – Fixed Costs

This formula summarizes the previous four formulas into one concise and simplified equation.

6. Contribution Margin = Price – Variable Cost

Contribution margin represents how much money each product sold brings into the company after accounting for the cost of raw materials needed to make the product.

Example: If your company’s shirts sell for $20 and raw materials cost $5, then the contribution margin is $20 - $5 = $15 per shirt.

7. Profit Margin = Profit / Revenue

Profit margin represents the percentage of revenue that a company keeps as profit after taking into account all of its costs.

Example: Last year, your company generated $20,000 in revenue and had $17,000 in costs. Its profit was $3,000. Therefore, your company’s profit margin is $3,000 / $20,000 = 15%.

Investment Formulas for Case Interviews

8. Return on Investment = Profit / Investment Cost

Companies make investments by spending money in the hopes of earning even more money in the future as a result of the investment. Return on investment, or ROI for short, represents how much additional money a company generates relative to the size of its initial investment.

ROI is calculated by taking the profit that the company generated from the investment and dividing it by the investment cost.

Example: Your company spent $5,000 on marketing to advertise its shirts. As a result, the company generated an additional $6,000 in profits from selling shirts. This profit does not yet take into account the costs of the marketing campaign.  Therefore, the company has a net increase in profits of $1,000 from its original $5,000 investment. The ROI is $1,000 / $5,000 = 20%.

9. Payback Period = Investment Cost / Profit per Year

Payback period represents how long it would take a company to recoup the money it spent on an investment. It is usually specified in years.

Example: Your company invested in redesigning its shirts for $5,000. As a result, the company expects annual profits to increase by $1,000 for every year going forward. Therefore, the payback period for this investment is $5,000 / $1,000 = 5 years.

Operations Formulas for Case Interviews

10. Output = Rate * Time

The output of production can be calculated by taking the rate of production and multiplying it by time.

Example: The machine that your company uses to produce shirts can produce 5 shirts per hour. If the machine runs for 12 hours, then it will produce 60 shirts.

11. Utilization = Output / Maximum Output

Utilization represents how much a factory or machine is being used relative to its maximum possible output.

Example: The machine that your company uses to produce shirts can produce 5 shirts per hour. Therefore, its maximum capacity in a day is 5 shirts per hour * 24 hours = 120 shirts. If your machine is being used to only produce 60 shirts per day, then it is at 60 / 120 = 50% utilization.

Market Share Formulas for Case Interviews

12. Market Share = Company Revenue in the Market / Total Market Revenue

Market share measures the percentage of total market sales a particular company has. Market shares can range from 0%, no presence in the market, to 100%, complete dominance in the market.

Example: Your company sells shirts and generates $100M in annual revenues. The market size of shirts is $500M. Therefore, your company has a market share of $100M / $500M = 20%. 

13. Relative Market Share = Company Market Share / Largest Competitor’s Market Share

Relative market share compares a company’s market share to the largest competitor’s market share. It measures how strong of a presence a company has relative to the market leader. If the company is the market leader, relative market share measures how much of a lead they have over the next largest player.

Instead of using company market share and the largest competitor’s market share, you can use company revenue and the largest competitor’s revenue. This will give you the same answer.

Example: Your company has a 20% market share in the shirts market. Your largest competitor has a 50% market share. Therefore, your relative market share is 20% / 50% = 0.4.

Example 2: Your company is the market leader and has a 50% market share in the shirts market. Your largest competitor has a 25% market share. Therefore, your relative market share is 50% / 25% = 2.

Accounting, Finance, and Economics Formulas for Case Interviews

These formulas are much less commonly seen in case interviews than the previous formulas. You likely won’t need to use these formulas since they require more technical knowledge of accounting, finance, and economics.

However, you should still be familiar with these formulas in the small chance that one of these concepts shows up in your case interview.

14. Gross Profit = Sales – Cost of Goods Sold

Gross profit is a measure of how much money a company makes from selling its product after taking into account the costs associated with making and sellings its product. These costs are often called the cost of goods sold.

Compared to the previous profit formula, which was simply revenue minus costs, gross profit is always higher since it does not take into account all of the costs of the business.

Example: Your company sold $20,000 of shirts last year. The cost to produce these shirts was $5,000. Therefore, your gross profit is $20,000 - $5,000 = $15,000.

15. Operating Profit = Gross Profit – Operating Expenses – Depreciation – Amortization

Operating profit is calculated by taking gross profit and subtracting all operating expenses and depreciation and amortization.

Operating expenses may include rent, utilities, maintenance and repairs, advertising and marketing, insurance, and salaries and wages. So, operating profit is always less than gross profit.

Depreciation is the spreading of a fixed asset’s cost over its useful lifetime.

For example, let’s say that a company purchases a new machine for $10,000 that it expects to last for 5 years. Instead of stating that it incurred $10,000 in costs in its first year, the company may choose to state that the new machine costs $2,000 per year for the next five years.

Amortization is the spreading of an intangible asset’s cost over its useful lifetime. It is the exact same principle as depreciation except that it deals with intangible assets, or assets that aren’t physical.

For example, let’s say that a company purchases a patent for $10,000 and expects the benefits of the patent to last for 20 years. Instead of stating that it incurred $10,000 in costs in its first year, the company may choose to state that the patent costs $500 per year for the next twenty years.

Example: You sold $20,000 of shirts last year. Cost of goods is $5,000, operating expenses are $10,000, depreciation of a machine is $2,000, and amortization of a patent is $500. Therefore, your operating profit is $20,000 - $5,000 - $10,000 - $2,000 - $500 = $2,500.

16. Gross Profit Margin = Gross Profit / Revenue

This is the exact same formula as the profit margin formula except that gross profit is used. Gross profit margin measures how much money a company keeps from selling its products after taking into account cost of goods sold.

Example: Your company has a gross profit of $15,000 from $20,000 of revenue. Therefore, your gross profit margin is $15,000 / $20,000 = 75%.

17. Operating Profit Margin = Operating Profit / Revenue

This is the exact same formula as the profit margin formula except that operating profit is used. Operating profit margin measures how much money a company keeps from sellings its products after cost of goods sold, operating expenses, depreciation, and amortization is taken into account.

Example: Your company has an operating profit of $2,500 from $20,000 of revenue. Therefore, your operating profit margin is $2,500 / $20,000 = 12.5%.

18. EBITDA = Operating Profit + Depreciation + Amortization

EBITDA stands for earnings before interest, taxes, depreciation, and amortization. It is a financial metric used to measure a company’s cash flow or the amount of cash that a company has generated in a period of time.

To calculate EBITDA, start with operating profit and add back depreciation and amortization expenses.

Example: Your company has an annual operating profit of $2,500. Depreciation expenses are $2,000 and amortization expenses are $500. Therefore, your EBITDA is $2,500 + $2,000 + $500 = $5,000.

19. CAGR = (Ending Value / Beginning Value)^(1/Time Period) – 1

CAGR stands for compounded annual growth rate. It measures how quickly something is growing year after year.

Example: Your company generates $144M in annual revenue. Two years ago, your company only generated $100M. Over this time period, your CAGR was ($144M / $100M)^(1/2) - 1= 20%. In other words, your company grew by 20% each year for two years.

20. Rule of 72

The Rule of 72 is a shortcut used to estimate how long a market, company, or investment would take to double in size. To use it, simply divide 72 by the annual growth rate to get an estimate for the number of years needed to double in size.

Example: Your company is growing steadily at 9% per year. Using the Rule of 72, we’d expect it to take 72 / 9 = 8 years for your company to double in size if it maintains its current growth rate.

21. NPV = Cash Flow / [(1 + Discount Rate)^(Time Period)]

NPV stands for net present value. It measures how much future cash flow is worth today.

Receiving $1,000 right now is not the same as receiving $1,000 five years from now. If you received $1,000 right now, you could invest it and grow your money. Therefore, it is better to receive $1,000 right now than to receive the same amount in the future.

Net present value takes this into account.

Cash flow is the amount of money you expect to receive in the future. Time period is how many years in the future you will receive that amount of money. The discount rate is the return you expect to get from investing your money.

Example: You expect to receive $1,000 five years from now. You expect that you will be able to get 8% annual returns by investing in the stock market. Therefore, the net present value of your future cash flow is $1,000 / [(1 + 0.08)^5] = $680.58.  In other words, receiving $680.58 today would give you the same value as receiving $1,000 five years from now.

22. Perpetuity Formula: Present Value = Cash Flow / Discount Rate

An annuity is a fixed sum of money paid at regular intervals such as every year. Perpetuity is an annuity that lasts forever.

The present value of a perpetuity is calculated by taking the cash flow of each payment and dividing it by the discount rate.

Example: You are expecting to receive $1,000 per year for the rest of your life. You expect that you will be able to get 8% annual returns by investing in the stock market. Therefore, the present value of this perpetuity is $1,000 / 0.08 = $12,500.  In other words, receiving $12,500 today would give you the same value as receiving $1,000 each year for the rest of your life.

23. Return on Equity = Profit / Shareholder Equity

Return on equity , or ROE for shirt, measures how effectively a company is using its assets to create profits. It is calculated by taking profit and dividing by shareholder equity, which represents the net worth of a company.

In other words, shareholder equity is the value of a company’s total assets minus its total liabilities.

Example: Your company’s profit this year is $100M. Shareholder equity, or the net worth of the company is $1B. Your company has a ROE of $100M / $1B = 10%.

24. Return on Assets = Profit / Total Assets

Return on assets , or ROA for short, measures how profitable a company is relative to its total assets. In other words, it shows how efficiently a company is using its assets to generate income.

Assets can be anything that has value that can be converted into cash. This includes cash, property, equipment, inventory, and investments.

Example: Your company’s profit this year is $100M. Your company as $400M worth of assets. Your company has a ROA of $100M / $400M = 25%.

25. Price Elasticity of Demand = (% Change in Quantity) / (% Change in Price)

Elasticity is a measure of how much customer demand changes for a product given a change in the product’s price. In almost all cases, an increase in a product’s price results in a decrease in customer demand. Therefore, price elasticity of demand is usually negative.

Example: Your company has decreased its product’s price by 10%. As a result, the number of units sold has increased by 20%. Therefore, the price elasticity of demand is 20% / -10% = -2.

26. Cross Elasticity of Demand = (% Change in Quantity for Good #1) / (% Change in Price for Good #2)

Cross elasticity of demand measures how much customer demand changes for a product given a change in price of a different product.

If two products are complements, an increase in price of one product will result in a decrease in demand of the other product. Complementary products have a negative cross elasticity of demand.

If two products are substitutes, an increase in price of one product will result in an increase in demand of the other product. Substitute products have a positive cross elasticity of demand.

Example: A competitor has decreased the price of a competing product by 20%. As a result, the demand for your product has dropped by 10%. The cross elasticity of demand is -10% / -20% = 0.5.

Land Your Dream Consulting Job

Here are the resources we recommend to land your dream consulting job:

For help landing consulting interviews

• Resume Review & Editing : Transform your resume into one that will get you multiple consulting interviews

For help passing case interviews

• Comprehensive Case Interview Course (our #1 recommendation): The only resource you need. Whether you have no business background, rusty math skills, or are short on time, this step-by-step course will transform you into a top 1% caser that lands multiple consulting offers.
• Case Interview Coaching : Personalized, one-on-one coaching with a former Bain interviewer.
• Hacking the Case Interview Book   (available on Amazon): Perfect for beginners that are short on time. Transform yourself from a stressed-out case interview newbie to a confident intermediate in under a week. Some readers finish this book in a day and can already tackle tough cases.
• The Ultimate Case Interview Workbook (available on Amazon): Perfect for intermediates struggling with frameworks, case math, or generating business insights. No need to find a case partner – these drills, practice problems, and full-length cases can all be done by yourself.

For help passing consulting behavioral & fit interviews

• Behavioral & Fit Interview Course : Be prepared for 98% of behavioral and fit questions in just a few hours. We'll teach you exactly how to draft answers that will impress your interviewer.

Land Multiple Consulting Offers

Complete, step-by-step case interview course. 30,000+ happy customers.

35 Case Interviews Examples from MBB / Big Four Firms

Studying case interview examples is one of the first steps in preparing for the  management consulting  recruitment process. If you don’t want to spend hours searching the web, this article presents a comprehensive and convenient list for you – with 35 example cases, 16 case books, along with a case video accompanied by detailed feedback on tips and techniques.

A clear understanding of “what is a case interview” is essential for effective use of these examples. I suggest reading our  Case Interview 101  guide, if you haven’t done so.

McKinsey case interview examples

Mckinsey practice cases.

• Diconsa Case
• Electro-Light Case
• GlobaPharm Case
• National Education Case

What should I know about McKinsey Case interviews?

At McKinsey, case interviews often follow the interviewer-led format , where the interviewer asks you multiple questions for you to answer with short pitches.

How do you nail these cases? Since the questions can be grouped into predictable types, an efficient approach is to master each question type. However, do that after you’ve mastered the case interview fundamentals!

For a detailed guide on interviewer-led cases, check out our article on McKinsey Case Interview .

BCG & Bain case interview examples

Bcg practice cases.

• BCG – Written Case – Chateau Boomerang

Bain practice cases

• Bain – Coffee Shop Co.
• Bain – Fashion Co.
• Bain – Mock Interview – Associate Consultant
• Bain – Mock Interview – Consultant

What should I know about BCG & Bain case interviews?

Unlike McKinsey, BCG and Bain case interviews typically follow the candidate-led format – which is the opposite of interviewer-led, with the candidate driving the case progress by actively breaking down problems in their own way.

The key to acing candidate-led cases is to master the case interview fundamental concepts as well as the frameworks.

Some BCG and Bain offices also utilize written case interviews – you have to go through a pile of data slides, select the most relevant ones to answer a set of interviewer questions, then deliver those answers in a presentation.

For a detailed guide on candidate-led cases, check out our article on BCG & Bain Case Interview .

Deloitte case interview examples

Deloitte practice cases.

Undergrad Cases

• Human Capital – Technology Institute
• Human Capital – Agency V
• Strategy – Federal Benefits Provider
• Strategy – Extreme Athletes
• Technology – Green Apron
• Technology – Big Bucks Bank
• Technology – Top Engine
• Technology – Finance Agency

Advanced Cases

• Human Capital – Civil Cargo Bureau
• Human Capital – Capital Airlines
• Strategy – Club Co
• Strategy – Health Agency
• Technology – Waste Management
• Technology – Bank of Zurich
• Technology – Galaxy Fitness

What should I know about Deloitte case interviews?

Case interviews at Deloitte also lean towards the candidate-led format like BCG and Bain.

The Deloitte consultant recruitment process also features group case interviews , which not only test analytical skills but also place a great deal on interpersonal handling.

Accenture case interview examples

Accenture divides its cases into three types with very cool-sounding names.

Sorted in descending order of popularity, they are:

These are similar to candidate-led cases at Bain and BCG. albeit shorter – the key is to develop a suitable framework and ask the right questions to extract data from the interviewer.

These are similar to the market-sizing and guesstimate questions asked in interviewer-led cases – demonstrate your calculations in structured, clear-cut, logical steps and you’ll nail the case.

These cases have you sort through a deluge of data to draw solutions; however, this type of case is rare.

Capital One case interview examples

Capital One is the odd one on this list – it is a bank-holding company. Nonetheless, this being one of the biggest banks in America, it’s interesting to see how its cases differ from the consulting ones.

Having gone through Capital One’s guide to its cases, I can’t help but notice the less-MECE structure of the sample answers. Additionally, there seems to be a greater focus on the numbers.

Nonetheless, having a solid knowledge of the basics of case interviews will not hurt you – if anything, your presentation will be much more in-depth, comprehensive, and understandable!

See Capital One Business Analyst Case Interview for an example case and answers.

Other firms case interview examples

Besides the leading ones, we have some examples from other major consulting firms as well.

• Oliver Wyman – Wumbleworld
• Oliver Wyman – Aqualine
• LEK – Cinema
• LEK – Market Sizing
• Kearney – Promotional Planning
• OC&C – Imported Spirits
• OC&C – Leisure Clubs

Consulting clubs case books

In addition to official cases, here are a few case books you can use as learning materials.

Do keep in mind: don’t base your study on frameworks and individual case types, but master the fundamentals so you can tackle any kind of case.

• Wharton Consulting Club Case Book
• Tuck Consulting Club Case Book
• MIT Sloan Consulting Club Case Book
• LBS Consulting Club Case Book
• Kellogg Consulting Club Case Book
• INSEAD Consulting Club Case Book
• Harvard Consulting Club Case Book
• ESADE Consulting Club Case Book
• Darden Consulting Club Case Book
• Berkeley Consulting Club Case Book
• Notre-Dame Consulting Club Case Book
• Illinois Consulting Club Case Book
• Columbia Consulting Club Case Book
• Duke Consulting Club Case Book
• Ross Consulting Club Case Book
• Kearney Case Book

Case interview example – Case video

The limitation of most official case interview examples is that they are either too short and vague, or in text format, or both.

To solve that problem for you, we’ve extracted a 30-minute-long, feedback-rich case sample from our Case Interview End-to-End Secrets Program .

This is a candidate-led, profitability case on an internet music broadcasting company called Pandora.

In 30 minutes, this candidate demonstrates the exact kind of shortcoming that most candidates suffer during real case interviews – they come in with sharp business senses, then hurt their own chances with inadequate techniques.

Here are seven notable areas where the candidate (and you) can improve:

Thanking Throughout the case, as especially in the opening, he should have shown more appreciation for the time the interviewer spent with him.

Structured opening The candidate’s opening of the case feels unstructured. He could have improved it by not mixing the playback and clarification parts. You can learn to nail the case in a 3-minute start through this video on How to Open Any Case Perfectly .

Explicitness A lot of the candidate’s thought process remains in his head; in a case interview, it’s better to be as explicit as possible – draw your issue tree out and point to it as you speak; state your hypothesis when you move into a branch; when you receive data, acknowledge it out loud.

Avoiding silence The silence in his case performance is too long, including his timeout and various gaps in his speech; either ask for timeout (and keep it as short as possible) or think out loud to fill those gaps.

Proactivity The candidate relies too much on the interviewer (e.g: asking for data when it can easily be calculated); you don’t want to appear lazy before your interviewer, so avoid this.

Avoiding repeating mistakes Making one mistake twice is a big no-no in consulting interviews; one key part of the consulting skill set is the ability to learn, and repeating your mistakes (especially if the interviewer has pointed it out) makes you look like someone who doesn’t learn.

Note-taking Given the mistakes this candidate makes, he’s probably not taking his notes well. I can show you how to get it right if you watch this video on Case Interview Note-Taking .

Nonetheless, there are three good points you can learn from the candidate:

The candidate sums up what he’s covered and announces his upcoming approach at the start and at key points in the case – this is a very good habit that gives you a sense of direction and shows that you’re an organized person.

The candidate performs a “reality check” on whether his actions match the issue tree; in a case interview it’s easy to lose track of what you’re doing, so remember to do this every once in a while.

The candidate prompts the interviewer to give out more data than he asked for; if anything, this actually matches a habit of real consultants, and if you’re lucky, your interviewer may actually give out important pieces you haven’t thought of.

These are only part of the “ninja tips” taught In our Case Interview E2E Secrets Program – besides the math and business intuition for long-term development, a key feature is the instant-result tips and techniques for case interviews.

Once you’ve mastered them, you can nail any case they throw at you!

For more “quality” practice, let’s have a mock case interview with former consultants from McKinsey, BCG, Bain, Oliver Wyman, Strategy& and many other consulting firms. They will help you identify your problem areas and give you actionable feedback, making your preparation much easier and faster.

Hi! This is Kim and welcome to another performance in the Tips & Techniques part of our amazing End-to-end program. You are about to hear a really interesting performance.

There is a common Myth that Profitability cases are easier. Well, for beginners, that’s may make sense, but I would argue that Profitability cases can be really tricky and candidates without good foundation will make about the same level of mistakes regardless of type of cases given.

The profitability case we are about to watch will show that. It’s a very unconventional

Profitability. It started out like a typical one but getting more and more tricky toward the end.

The candidate is fairly good in term of business intuition, but the Tips & Techniques aspect needs a lot of fine tune! Now let’s go ahead and get started! 

It’s actually a little better to playback the case information and ask clarifications. The candidate does not distinguish between the two and do both at a same time. Also, the candidate was asking these clarifications in an unorganized and unstructured fashion. This is not something terrible, but could have been better, especially when this is the very first part of the case, where the crucial first impression is being formed.

My pitch would sound like this:

“That’s a very interesting problem and I am happy to get the chance to solve it. First of all let me tell you my understanding of the case context and key objectives. Then I would like to ask a few clarifying questions regarding a few terminology and concepts. Both of these are to make sure that I will be solving the right problem.

So here is my understanding of the case: The client is ABC. Here are some DEF facts about the situation we just talked about. And the key case question is XYZ.

Does that correctly and adequately summarize the case?”

Once the interviewer confirms, I would move to the clarification part as follows: “Now I would like to ask a few clarification questions. There are three of them: No 1, … No 2, … and No 3, …”

You may see above pitch as obvious but that’s a perfect example of how you should open any cases. Every details matters. We will point out those details in just a second. But before we do that, it’s actually very helpful if you can go back, listen carefully to the above pitch, and try to point out the great components yourselves. Only after that, go back to this point and learn it all together.

Alright, let’s break down the perfect opening.

First of all, you hear me say: “That’s a very interesting problem and I am happy to get a chance to solve it”. This seems trivial but very beneficial in multiple ways:

1. I bought myself a couple of seconds to calm down and get focused. 2. By nature, we as human unconsciously like those who give us compliments. Nothing better than opening the case with a modest compliment to the interviewer.

And (c) I showed my great attitude towards the case, which the interviewer would assume is the same for real future consulting business problems.

You should do that in your interviews too. Say it and accompany it with the best smile you can give. It shows that you are not afraid of any problems. In fact, you love them and you are always ready for them.

Secondly, I did what I refer to as the “map habit”, which is to always say what you are about to do and then do it. Just like somebody in the car showing the drivers the route before cruising on the road. The driver would love it. This is where I said: “Let me tell you my understanding of the case context and key objectives. Then ABC…”.

Third, right at the beginning of the case, I try to be crystal clear and easy to follow. I don’t let the interviewer confused between playing the case vs. asking clarification questions. I distinguish between the two really carefully. This habit probably doesn’t change the outcome of how the case goes that much, but it certainly significantly changes the impression the interviewer has of me.

Fourth, in playing back the case, each person would have a different way to re-phrase. But there are three buckets to always include:

1. Who is the client 2. The facts regarding the client and the situation and (c) The key question and the objective of the case.

Fifth, after playing the case context and objectives, I pause for a second and ALIGN with the interviewer: “Does it correctly and adequately summarize the case?”. This is a habit that every consulting manager loves for young consultants to do. Nobody wants first-year folks to spend weeks of passion and hard-work building an excel model that the team can’t use. This habit is extensively taught at McKinsey, Bain and BCG, so therefore interviewers would love somebody that exhibits this habit often in case interview.

Lastly, when asking clarification questions, you hear me number them very carefully to create the strong impression that I am very organized and structured. I said I have three clarifying questions. Then I number them as I go through each. No.1, No.2, and No.3.

Sometimes, during interviews it’s hard to know exactly how many items you are going to get. One way is to take timeout often to carefully plan your pitch. If this is not possible in certain situations, you may skip telling how many items you have; but you should definitely still number your question: No.1, No.2; and so on. 

Just a moment ago, the candidate actually exhibited a good habit. After going through his clarification questions, the candidate ended by asking the “is there anything else” question. In this case, I actually give out an important piece of data.

Though this is not very common as not every interviewer is that generous in giving out data. But this is a habit management consultants have to have every day when talking to experts, clients, or key stakeholders. The key is to get the most data and insights out of every interview and this is the type of open-ended question every consultant asks several times a day.

To show of this habit in a case interview is very good!

There are three things I would like you to pay attention to:

First, it took the candidate up to 72 seconds to “gather his thoughts”. This is a little too long in a case interview. I intentionally leave the 72 seconds of silence in the recording so you get an idea of how long that is in real situations. But it’s worth-noting here is not only that. While in some very complicated and weird cases, it’s ok to take that long to really think and gather ideas. In this case, the approach as proposed by the candidate is very simple. For this very approach, I think no more than 15 to 20 seconds should be used.

No.2, with that said, I have told I really like the fact that this candidate exhibits the “map” habit. Before going straight to the approach he draws the overall approach first.

No.3. You also see here that the candidate tried to align the approach with me by asking my thoughts on it. As I just said on the previous comment, this is a great habit to have. Not only does it help reduce chance of going into the wrong direction in case interviews, but it also creates a good impression. Consulting interviewers love people doing it often!

Here we see a not-really-bad response that for sure could be much better. The candidate was going into the first branch of the analysis which is Revenue. I would fix this in 3 aspects:

First, even though we just talked about the overall approach, it’s still better to briefly set up the issue tree first then clearly note that you are going into one branch.

Second, this is not a must, but I always try to make my hypothesis as explicitly clear as possible. Here the candidate just implicitly made a hypothesis that the problem is on the revenue side. The best way to show our hypothesis-driven mindset is to explicitly say it.

Third, you hear this a ton of times in our End-to-End program but I am going to repeat it again and again. It is better to show the habit of aligning here too. Don’t just go into revenue, before doing that, give the interviewer a chance to agree or to actually guide you to Cost.

So, summarizing the above insights, my pitch would sound something like this:

“So as we just discussed, a profit problem is either caused by revenue or by cost. Unless you would like to go into cost first, let’s hypothesize that the problem is on revenue side. I would like to look deeper into Revenue. Do we have any data on the revenue?”

And while saying this, you should literally draw an issue tree and point to each as you speak.

There is an interesting case interview tip I want to point out here. Notice how the candidate responds after receiving two data points from me. He went straight into the next question without at least acknowledging the data received and also without briefly analyzing it.

I am glad that the candidate makes this mistakes… well, not glad for him but for the greater audience of this program. I would like to introduce to you the perfect habit of what you should react and do every time you have any piece of data during case interviews. So three things you need to do:

Step 1: Say … that’s an interesting piece of data. This helps the interviewer acknowledge that you have received and understand the data. This also buys you a little time. And furthermore, it’s always a good thing to give out modest compliments to the interviewer.

Step 2: Describe the data, how it looks, is there any special noteworthy trend? In this case, we should point out that revenue actually grew by more than 50%.

Also notice here that I immediately quantified the difference in specific quantitative measurement (in this case, percentage). Saying revenue went up is good, but it’s great to be able to say revenue went up by more than 50%.

Step 3: Link the trend identified back to the original case question and the hypothesis you have. Does it prove, disprove, or open up new investigation to really test the hypothesis? In this case, this data piece actually opened up new investigating areas to test the hypothesis that the bottleneck is within revenue.

My sample pitch for this step 3 would sound like this: “It’s interesting that revenue went up quite a bit. However, to be able to fully reject our hypothesis on the revenue, I would like to compare our revenue to that of the competitors as well.”

Then only at this point, after going through 3 steps above, I ask for the competitors’ revenue like the candidate did.

Notice here that I ended up asking the same question the candidate did. This shows that the candidate does have a good intuition and thought process. It’s just that he did all of these implicitly on his head.

In consulting case interview, it’s always good to do everything as explicitly as possible. Not only is it easier to follow but it helps show your great thought process.

… the rest of the transcript is available in our End To End Case Interview

Learn the Secrets to Case Interview!

Join countless other successful candidates around the world with our Case Interview End-to-End Secrets Program ! 10 example cases with 100+ real-time feedbacks on tips and techniques, 50+ exercises on business intuition and 1300+ questions for math practice!

Scoring in the McKinsey PSG/Digital Assessment

The scoring mechanism in the McKinsey Digital Assessment

Related product

Case Interview End-to-End Secrets Program

Elevate your case interview skills with a well-rounded preparation package

Preparing for case interviews is a hard task when you only have 1 week, so the first part you need to learn during this time is fundamentals of case interview

Case interview in consulting is difficult with the passing rate is around 10%. This is because big consulting firms keep an extremely high recruitment standard

A case interview is where candidates is asked to solve a business problem. They are used by consulting firms to evaluate problem-solving skill & soft skills

Table of Contents

Data Analysis Using Excel Case Study

Data analysis is an essential skill in today’s business world. As organizations deal with increasing amounts of data, it becomes crucial for professionals to make sense of this information and derive useful insights. Excel is a powerful and versatile tool that can assist in analyzing and presenting data effectively, particularly through the use of case studies.

A case study is a detailed examination of a specific situation or problem in order to better understand the complexities involved. By using Excel for data analysis, individuals can explore and analyze the data related to the case study in a comprehensive and structured manner. Excel offers various tools and functionalities, such as PivotTables, slicers, and data visualization features, which allow users to assess patterns, trends, and relationships within the data.

Applying these techniques for data analysis in Excel case studies enables professionals to make well-informed business decisions and communicate their findings effectively. By leveraging the capabilities of Excel in conjunction with case studies, individuals can unlock valuable insights that drive organizational success and contribute to an enhanced understanding of the overall data landscape.

Excel Basics for Data Analysis

Dataset preparation.

When working with Excel, the first step in data analysis is dataset preparation . This process involves setting up the data in a structured format, with clearly defined headers and cells. To start, you must import or enter your data into an Excel spreadsheet, ensuring that each record is represented by a row and each variable by a column. Headers should be placed in the top row and provide descriptive labels for each column. Proper organization of your dataset helps to ensure accurate analysis and interpretation .

For example, suppose you have a dataset that contains the following information:

In this dataset, the headers are “Year,” “Category,” “Sales,” and “Profit.” Each row represents a record, and the cells contain the corresponding data.

Data Cleaning

The next step in data analysis using Excel is data cleaning . Data cleaning is the process of identifying and correcting errors, inconsistencies, and inaccuracies in your dataset. Common data cleaning tasks include:

• Removing duplicate records,
• Filling in missing values,
• Correcting data entry errors,
• Standardizing and formatting variable names and values.

To perform data cleaning in Excel, you can use various functions and tools:

• Remove duplicates: To remove duplicate records, select your dataset and navigate to the Data tab. Click the “Remove Duplicates” button and select the columns to be used for identifying duplicate rows.
• Fill in missing values: Use Excel functions such as VLOOKUP , HLOOKUP , and INDEX-MATCH to fill in missing values based on other data in your dataset. You can also use the IFERROR function to handle errors when looking up values.
• Correct data entry errors: Use Excel’s “Find and Replace” tool (Ctrl + F) to search for and correct errors in your dataset. You may need to perform this multiple times for different errors.
• Standardize and format variable names and values: Use Excel functions such as UPPER , LOWER , PROPER , and TRIM to standardize text data. Format numerical values using the Number Format options in the Home tab.

By ensuring your dataset is clean and well-organized, you can confidently move forward with more advanced data analysis tasks in Excel.

Powerful Excel Functions

Excel is a versatile tool when it comes to data analysis. There are many powerful functions that can help you perform complex calculations and analysis easily. In this section, we will explore some of the top functions in three categories: Text Functions, Date Functions, and Lookup Functions.

Text Functions

Text Functions are crucial when working with large sets of data containing text. These functions help in cleaning, extracting, and modifying text data. Some key text functions include:

• LEFT : Extracts a specified number of characters from the beginning of a text string.
• RIGHT : Extracts a specified number of characters from the end of a text string.
• MID : Extracts a specified number of characters from a text string, starting at a specified position.
• TRIM : Removes extra spaces from text, leaving a single space between words and no space at the beginning or end of the text.
• CONCATENATE : Joins multiple text strings into one single string.
• FIND : Locates the position of a specific character or text string within another text string.

Date Functions

Date Functions are essential for dealing with dates and times in data analysis. These functions help in calculating the difference between dates, extracting parts of a date, and performing various date-related calculations. Some notable date functions include:

• TODAY : Returns the current date.
• NOW : Returns the current date and time.
• DATEDIF : Calculates the difference between two dates in days, months, or years.
• DATE : Creates a date by combining individual day, month, and year values.
• WEEKDAY : Returns the day of the week corresponding to a specific date, as an integer between 1 (Sunday) and 7 (Saturday).
• EOMONTH : Returns the last day of the month for a given date.

Lookup Functions

Lookup Functions are powerful tools used to search and retrieve data from a specific range or table in Excel. These functions can save time and effort when working with large datasets. Some essential lookup functions include:

• VLOOKUP : Searches for a specific value in the first column of a range and returns a corresponding value from a specified column.
• HLOOKUP : Searches for a specific value in the first row of a range and returns a corresponding value from a specified row.
• INDEX : Returns a value from a specific cell within a range, using row and column numbers.
• MATCH : Searches for a specific value in a range and returns its relative position within that range.
• XLOOKUP : Performs a lookup by searching for a specific value in a range or table and returning a corresponding value from another column or row (available only in Excel 365 and Excel 2019).

These powerful Excel functions can help make the process of data analysis more efficient and accurate. In combination with appropriate formatting, tables, and other visual aids, these functions can greatly enhance your ability to process and understand large datasets.

Related Article: Excel Functions for Data Analysts.

Data Exploration and Visualization

In the process of data analysis using Excel, data exploration and visualization play essential roles in revealing patterns, trends, and relationships within the data. This section will cover two primary techniques for data visualization in Excel: Charts and Trends, and Pivot Tables and Pivot Charts.

Charts and Trends

Charts in Excel are a highly effective method of uncovering patterns and relationships within the dataset. There are various types of charts available in Excel that cater to different use cases, such as bar charts, line charts, and scatter plots. These chart types can be customized to suit the needs of the analysis and to emphasize specific trends or patterns.

Trends in the data can be identified with the help of charts, and Excel offers trend lines functionalities to visualize these trends more clearly. By applying a trend line, one can easily identify the overall direction (positive or negative) of the dataset and make predictions based on this information. Additionally, Excel offers built-in formatting options that can help emphasize certain data points or highlight particular trends for easier interpretation.

Pivot Tables and Pivot Charts

Pivot Tables are another powerful data analysis feature in Excel. They allow the user to summarize, reorganize, and filter data by dragging and dropping columns into different areas. This enables the user to analyze data across multiple dimensions, revealing hidden insights and patterns.

To complement Pivot Tables, Excel also offers Pivot Charts, which allow users to create dynamic visualizations derived from the Pivot Table data. Pivot Charts offer the same chart types as regular Excel charts but with the added capability to update the chart when the Pivot Table data is altered. This makes Pivot Charts ideal for creating interactive and easily updatable visualizations.

Overall, incorporating these techniques into the data analysis process can enhance understanding and unveil valuable insights from the dataset. When using Excel for data analysis, data exploration and visualization with Charts and Trends, as well as Pivot Tables and Pivot Charts, can provide a comprehensive and insightful overview of the data in question.

Case Study: Covid-19 Data Analysis

Data collection and cleaning.

The Covid-19 pandemic has generated vast amounts of data, requiring researchers and analysts to collect, clean, and organize data sets to gain valuable insights. Several sources, such as the World Health Organization and Johns Hopkins University , provide updated information on confirmed cases, recoveries, and deaths.

Data collection starts with gathering raw data from various sources. These data sets may have inconsistencies, missing values, or discrepancies, which need to be addressed to ensure accurate analysis. Data cleaning is a critical step in this process, involving tasks such as removing duplicates, filling in missing values, and correcting errors.

Exploratory Data Analysis

Once the data is clean and organized, exploratory data analysis (EDA) can be conducted using tools like Excel. EDA helps analysts understand the data, identify patterns, and generate hypotheses for further investigation.

Some useful techniques in conducting EDA in Excel include:

• Pivot Tables : These allow users to summarize and reorganize data quickly, providing aggregated views of the data.
• Charts and Graphs : Visual representations of data, such as bar charts or line graphs, can display trends, correlations, or patterns more clearly than raw numbers.
• Descriptive Statistics : Excel’s built-in functions allow easy calculation of measures such as mean, median, and standard deviation, providing a preliminary statistical analysis of the data.

In the context of Covid-19 data, EDA can help reveal important information about the pandemic’s progression. For example, analysts can:

• Compare infection rates across countries or regions
• Monitor changes in case numbers over time
• Evaluate the effectiveness of public health interventions and policies

The insights gained from exploratory data analysis can guide further research, inform decision-making, and contribute to a better understanding of the pandemic’s impact on public health.

Case Study: Stock Market Data Analysis

Data collection and preparation.

The first step in the stock market data analysis case study is collecting and preparing the data. This process involves gathering historical stock prices, trading volumes, and other relevant financial metrics from reliable sources. The data can be cleaned and organized in Excel, removing any errors or inconsistencies. It’s essential to verify the collected data’s accuracy to ensure the analysis’s validity.

After preparing the financial data, the next step is to compute essential measures and ratios. These may include:

• Price-to-Earnings (P/E) Ratio
• Dividends Yield
• Total Return
• Moving Averages

Calculating these ratios and measures provides a general overview of a company’s performance in the stock market, which can be further analyzed with Excel tools.

Profit and Loss Analysis

In this stage of the case study, profit and loss analysis is conducted to assess the stock’s performance. Using Excel PivotTables, we can summarize the data to identify trends or patterns in the stock market. For instance, we can analyze the historical profits and losses of multiple stocks during a specific state or market condition.

Analyzing profit and loss data can also be done with natural language capabilities in Excel. This feature allows us to ask questions about the dataset, and Excel will produce relevant results. For example, we could pose a question like “Which stocks had the highest profit margins in the last quarter?” or “What is the average loss for the technology sector?”

After exploring the profits and losses of the stocks, we can gain insights into which stocks or sectors are more profitable or risky. This information can help potential investors make informed decisions about their investment strategies. Additionally, the insights from the case study can serve as a reference point for future stock market analyses.

Remember, this case study only serves as an example of how to conduct stock market data analysis using Excel. By adapting and expanding on these techniques, one can harness the power of Excel to explore various aspects of financial markets and derive valuable insights.

Case Study: San Diego Burrito Ratings

Data gathering and cleaning.

The main objective of this case study is to evaluate and analyze the various factors that contribute to the ratings of San Diego burritos. The data used in this analysis is collected from different sources, which include customer reviews and ratings from Yelp, along with other relevant information about burrito sales and geographical distribution. The raw data is then compiled and cleaned to ensure that it is consistent and free from any discrepancies or errors. This process involves standardizing the fields and records, as well as filtering out any irrelevant information. The cleaned data is then organized into a structured format, which is suitable for further analysis using Excel PivotTables and Charts.

Use of Pivot Tables and Charts

After cleaning and organizing the data, Excel PivotTables are utilized to analyze the regional distribution of San Diego burrito ratings. By categorizing the data based on regions, such as East and West, it becomes convenient to identify the ratings and sales trends across these regions. The organized data is then sorted based on the ratings and popularity of burrito establishments within specific densely populated areas.

Using Pivot Charts, a graphical representation of the data is created to provide a clear and comprehensive visual of the ratings distribution in different regions of San Diego. It becomes easier to discern patterns and trends, allowing for the development of informed conclusions on the factors influencing the popularity and success of burrito establishments.

Throughout the analysis, various parameters are investigated, which include the relationship between ratings and sales, the potential impact of particular fields on popularity, and the apparent differences between densely populated regions in terms of burrito preferences. By utilizing PivotTables and Charts confidently, it is possible to draw insights and conclusions that can help optimize marketing strategies, guide customer preferences, and influence the overall success of burrito establishments across San Diego.

Case Study: Shark Attack Records Analysis

Data collection and pre-processing.

In this case study, the primary focus is on the analysis of shark attack records recorded between 1900 and 2016, consisting of just under 5,300 records or observations. To begin the analysis, the data needs to be collected from a reliable source and pre-processed to ensure its accuracy and relevance.

Data pre-processing is an essential step to prepare the dataset for analysis. It involves checking for missing values, outliers, and inconsistencies in the data. Additionally, it may also require converting the data into a suitable format, such as categorizing dates or splitting location information into separate columns (latitude and longitude).

Identifying Trends and Patterns

Once the dataset has been pre-processed, it’s time to dive into the analysis using Microsoft Excel. Excel offers a fast and central way to analyze data and search for trends and patterns within shark attack records. One powerful tool for this purpose is Excel’s PivotTables, which allows users to easily aggregate and summarize data.

Some possible trends and patterns that can be identified through the analysis of shark attack records include:

• Temporal Trends: Analyzing the frequency of shark attacks over time to identify any patterns in the occurrence of attacks, such as seasonality or specific years with higher attack rates.
• Geographical Patterns: Identifying areas with a higher concentration of shark attacks, which can provide insights into hotspots and potentially dangerous locations.
• Victim Demographics: Examining the demographics of shark attack victims, such as age, gender, and activity type, to determine if certain groups are more prone to attacks.
• Species Involved: Investigating the types of shark species responsible for attacks and their relative frequency in the dataset.

By utilizing Excel’s data analysis tools and PivotTables, researchers can confidently and clearly identify trends and patterns in the shark attack records, providing valuable insights into shark behavior and risk factors associated with shark attacks. This analysis can be helpful in understanding and managing the risks associated with shark encounters for both public safety and conservation efforts.

Related Article: How to Solve Data Analysis Real World Problems.

Additional Resources and Exercises

Kaggle and data analysis courses.

Kaggle is a popular platform that offers data science competitions, datasets, and courses to help you improve your data analysis skills in Excel. The courses are designed for various skill levels, and they cover essential concepts like PivotTables and data visualization. The comprehensive exercises and practical case studies provide a real-world context for mastering data analysis techniques.

The course reviews on Kaggle are usually quite positive, with many users appreciating the knowledgeable instructors and engaging content. If you’re looking to become a data analyst or enhance your existing skills, exploring the data analysis courses on Kaggle is a great starting point.

Power Query in Excel

Power Query is a powerful data analysis tool in Excel that enables you to import, transform, and combine data from various sources. This feature is particularly useful when working with large datasets or preparing data for analysis. There are numerous resources available to learn how to use Power Query effectively.

To practice using Power Query, consider working on exercises that focus on data cleansing, data transformation, and data integration. As you progress, you will gain a deeper understanding of the various Power Query functionalities and become more confident in your data analysis abilities.

In conclusion, engaging with additional resources like Kaggle courses and Power Query exercises will help you hone your Excel data analysis skills and enable you to tackle complex case studies with ease.

Frequently Asked Questions

How can excel be used for effective case study analysis.

Excel is a versatile tool that can be utilized for effective case study analysis. By organizing and transforming data into easily digestible formats, users can better identify trends, patterns, and insights within their data sets. Excel also offers various functions and tools, such as pivot tables, data tables, and data visualization, which enable users to analyze case study data more efficiently and uncover valuable information.

Which Excel functions are most useful for data analysis in case studies?

There are numerous Excel functions that can be highly useful for data analysis in case studies. These include:

• VLOOKUP, which allows users to search for specific information in large data sets
• INDEX-MATCH, a more advanced alternative to VLOOKUP that’s capable of handling more complex data structures
• IF, which helps in making conditional statements and decisions in data analysis
• AVERAGE, MAX, MIN, and COUNT for basic data aggregation
• SUMIFS and COUNTIFS, which allow users to perform conditional aggregation based on predefined criteria

What are some examples of data analysis projects using Excel?

Many different projects can benefit from data analysis using Excel, such as financial analysis, market research, sales performance tracking, and customer behavior analysis. Businesses across industries are known to use Excel for evaluating their case studies and forming data-driven decisions based on their insights.

How can Excel pivot tables aid in analyzing case study data?

Pivot tables in Excel are powerful, enabling users to summarize and analyze large data sets quickly and efficiently. They allow users to group and filter data based on different dimensions, making it much easier to identify trends, patterns, and relationships within the data. Additionally, pivot tables provide user-friendly drag-and-drop functionalities, allowing for easy customization and requiring minimal Excel proficiency.

In which industries is Excel data analysis most commonly applied in case studies?

Excel data analysis is widely used across various industries for case studies, including:

• Finance and banking, for analyzing investment portfolios, risk management, and financial performance
• Healthcare, for patient data analysis and identifying patterns in disease occurrence
• Marketing and sales, to analyze customer data and product performance
• Retail, for inventory management and sales forecasting
• Manufacturing, to evaluate the efficiency and improve production processes

What steps should be followed for a successful data analysis process in Excel?

A successful data analysis process in Excel typically involves the following steps:

• Data collection: Gather relevant data from various sources and consolidate it in Excel.
• Data cleaning and preprocessing: Remove any errors, duplicate records, or missing values in the data, and reformat it as necessary.
• Data exploration: Familiarize with the data, identify patterns, and spot trends through descriptive analysis and visualization techniques.
• Data analysis: Use relevant functions, formulas, and tools such as pivot tables to analyze the data and extract valuable insights.
• Data visualization: Create charts, graphs, or dashboard reports to effectively visualize the findings for improved understanding and decision-making.

What you should know:

• Our Mission is to Help you to Become a Professional Data Analyst.
• This Website is a Home for Data Analysts.  Get our latest in-depth Data Analysis and Artificial Intelligence Lessons and Updates in your Inbox.

Tech Writer | Data Analyst | Digital Creator

Get Our Professional Data Analyst Roadmap for free

You may also like

• Case Interview: A comprehensive guide
• Pyramid Principle
• Hypothesis driven structure
• Fit Interview
• Consulting math
• The key to landing your consulting job
• What is a case interview?
• Types of case interview
• How to solve cases with the Problem-Driven Structure?
• What to remember in case interviews
• Case examples or building blocks?
• How do I prepare for case interviews
• Interview day tips
• How we can help

1. The key to landing your consulting job.

Case interviews - where you are asked to solve a business case study under scrutiny - are the core of the selection process right across McKinsey, Bain and BCG (the “MBB” firms). This interview format is also used pretty much universally across other high-end consultancies; including LEK, Kearney, Oliver Wyman and the consulting wings of the “Big Four”.

If you want to land a job at any of these firms, you will have to ace multiple case interviews.

It is increasingly likely that you will also have to solve online cases given by chatbots. You might need to pass these either before making it to interview or be asked to sit them alongside first round interviews.

Importantly, case studies aren’t something you can just wing . Firms explicitly expect you to have thoroughly prepared and many of your competitors on interview day will have been prepping for months.

Don’t worry though - MCC is here to help!

This article will take you through a full overview of everything you’ll need to know to do well, linking to more detailed articles and resources at each stage to let you really drill down into the details.

As well as traditional case interviews, we’ll also attend to the new formats in which cases are being delivered and otherwise make sure you’re up to speed with recent trends in this overall part of consulting recruitment.

Before we can figure out how to prepare for a case interview, though, we will first have to properly understand in detail what exactly you are up against. What format does a standard consulting case interview take? What is expected of you? How will you be assessed?

Let's dive right in and find out!

Professional help

Before going further, if this sounds like a lot to get your head around on your own, don't worry - help is available!

Our Case Academy course gives you everything you need to know to crack cases like a pro:

Case Academy Course

To put what you learn into practice (and secure some savings in the process) you can add mock interview coaching sessions with expereinced MBB consultants:

Coaching options

And, if you just want an experienced consultant to take charge of the whole selection process for you, you can check out our comprehensive mentoring programmes:

Explore mentoring

Now, back to the article!

2. What is a case interview?

Before we can hope to tackle a case interview, we have to understand what one is.

In short, a case interview simulates real consulting work by having you solve a business case study in conversation with your interviewer.

This case study will be a business problem where you have to advise a client - that is, an imaginary business or similar organisation in need of guidance.

You must help this client solve a problem and/or make a decision. This requires you to analyse the information you are given about that client organisation and figure out a final recommendation for what they should do next.

Business problems in general obviously vary in difficulty. Some are quite straightforward and can be addressed with fairly standard solutions. However, consulting firms exist precisely to solve the tough issues that businesses have failed to deal with internally - and so consultants will typically work on complex, idiosyncratic problems requiring novel solutions.

Some examples of case study questions might be:

• How much would you pay for a banking licence in Ghana?
• Estimate the potential value of the electric vehicle market in Germany
• How much gas storage capacity should a UK domestic energy supplier build?

Consulting firms need the brightest minds they can find to put to work on these important, difficult projects. You can expect the case studies you have to solve in interview, then, to echo the unique, complicated problems consultancies deal with every day. As we’ll explain here, this means that you need to be ready to think outside the box to figure out genuinely novel solutions.

2.1. Where are case interviews in the consulting selection process?

Not everyone who applies to a consulting firm will have a case interview - far from it!

In fact, case interviews are pretty expensive and inconvenient for firms to host, requiring them to take consultants off active projects and even fly them back to the office from location for in-person interviews (although this happens less frequently now). Ideally, firms want to cut costs and save time by narrowing down the candidate pool as much as possible before any live interviews.

As such, there are some hoops to jump through before you make it to interview rounds.

Firms will typically eliminate as much as 80% of the applicant pool before interviews start . For most firms, 50%+ of applicants might be cut based on resumes, before a similar cut is made on those remaining based on aptitude tests. McKinsey currently gives their Solve assessment to most applicants, but will use their resulting test scores alongside resumes to cut 70%+ of the candidate pool before interviews.

You'll need to be on top of your game to get as far as a case interview with a top firm. Getting through the resume screen and any aptitude tests is an achievement in itself! Also we need to note that the general timeline of an application can differ depending on a series of factors, including which position you apply, your background, and the office you are applying to. For example, an undergraduate applying for a Business Analyst position (the entry level job at McKinsey) will most likely be part of a recruitment cycle and as such have pretty fixed dates when they need to sit the pre-screening test, and have the first and second round interviews (see more on those below). Conversely, an experienced hire will most likely have a much greater choice of test and interview dates as well as more time at their disposal to prepare.

For readers not yet embroiled in the selection process themselves, let’s put case interviews in context and take a quick look at each stage in turn. Importantly, note that you might also be asked to solve case studies outside interviews as well…

2.1.1. Application screen

It’s sometimes easy to forget that such a large cut is made at the application stage. At larger firms, this will mean your resume and cover letter is looked at by some combination of AI tools, recruitment staff and junior consulting staff (often someone from your own university).

Only the best applications will be passed to later stages, so make sure to check out our free resume and cover letter guides, and potentially get help with editing , to give yourself the best chance possible.

2.1.2. Aptitude tests and online cases

This part of the selection process has been changing quickly in recent years and is increasingly beginning to blur into the traditionally separate case interview rounds.

In the past, GMAT or PST style tests were the norm. Firms then used increasingly sophisticated and often gamified aptitude tests, like the Pymetrics test currently used by several firms, including BCG and Bain, and the original version of McKinsey’s Solve assessment (then branded as the Problem Solving Game).

Now, though, there is a move towards delivering relatively sophisticated case studies online. For example, McKinsey has replaced half the old Solve assessment with an online case. BCG’s Casey chatbot case now directly replaces a live first round case interview, and in the new era of AI chatbots, we expect these online cases to quickly become more realistic and increasingly start to relieve firms of some of the costs of live case interviews.

Our consultants collectively reckon that, over time, 50% of case interviews are likely to be replaced with these kinds of cases . We give some specific advice for online cases in section six. However, the important thing to note is that these are still just simulations of traditional case interviews - you still need to learn how to solve cases in precisely the same way, and your prep will largely remain the same.

2.1.3. Rounds of Interviews

Now, let’s not go overboard with talk of AI. Even in the long term, the client facing nature of consulting means that firms will have live case interviews for as long as they are hiring anyone. And in the immediate term, case interviews are still absolutely the core of consulting selection.

Before landing an offer at McKinsey, Bain, BCG or any similar firm, you won’t just have one case interview, but will have to complete four to six case interviews, usually divided into two rounds, with each interview lasting approximately 50-60 minutes .

Being invited to first round usually means two or three case interviews. As noted above, you might also be asked to complete an online case or similar alongside your first round interviews.

If you ace first round, you will be invited to second round to face the same again, but more gruelling. Only then - after up to six case interviews in total, can you hope to receive an offer.

2.2. Differences between first and second round interviews

Despite case interviews in the first and second round following the same format, second/final round interviews will be significantly more intense . The seniority of the interviewer, time pressure (with up to three interviews back-to-back), and the sheer value of the job at stake will likely make a second round consulting case interview one of the most challenging moments of your professional life.

There are three key differences between the two rounds:

• Time Pressure : Final round case interviews test your ability to perform under pressure, with as many as three interviews in a row and often only very small breaks between them.
• Focus : Since second round interviewers tend to be more senior (usually partners with 12+ years experience) and will be more interested in your personality and ability to handle challenges independently. Some partners will drill down into your experiences and achievements to the extreme. They want to understand how you react to challenges and your ability to identify and learn from past mistakes.
• Psychological Pressure: While case interviews in the first round are usually more focused on you simply cracking the case, second round interviewers often employ a "bad cop" strategy to test the way you react to challenges and uncertainty.

2.3. What skills do case interviews assess?

Reliably impressing your interviewers means knowing what they are looking for. This means understanding the skills you are being assessed against in some detail.

Overall, it’s important always to remember that, with case studies, there are no strict right or wrong answers. What really matters is how you think problems through, how confident you are with your conclusions and how quick you are with the back of the envelope arithmetic.

The objective of this kind of interview isn’t to get to one particular solution, but to assess your skillset. This is even true of modern online cases, where sophisticated AI algorithms score how you work as well as the solutions you generate.

If you visit McKinsey , Bain and BCG web pages on case interviews, you will find that the three firms look for very similar traits, and the same will be true of other top consultancies.

Broadly speaking, your interviewer will be evaluating you across five key areas:

2.1.1.One: Probing mind

Showing intellectual curiosity by asking relevant and insightful questions that demonstrate critical thinking and a proactive nature. For instance, if we are told that revenues for a leading supermarket chain have been declining over the last ten years, a successful candidate would ask:

“ We know revenues have declined. This could be due to price or volume. Do we know how they changed over the same period? ”

This is as opposed to a laundry list of questions like:

• Did customers change their preferences?
• Which segment has shown the decline in volume?
• Is there a price war in the industry?

2.1.2. Structure

Structure in this context means structuring a problem. This, in turn, means creating a framework - that is, a series of clear, sequential steps in order to get to a solution.

As with the case interview in general, the focus with case study structures isn’t on reaching a solution, but on how you get there.

This is the trickiest part of the case interview and the single most common reason candidates fail.

We discuss how to properly structure a case in more detail in section three. In terms of what your interviewer is looking for at high level, though, key pieces of your structure should be:

• Proper understanding of the objective of the case - Ask yourself: "What is the single crucial piece of advice that the client absolutely needs?"
• Identification of the drivers - Ask yourself: "What are the key forces that play a role in defining the outcome?"

Our Problem Driven Structure method, discussed in section three, bakes this approach in at a fundamental level. This is as opposed to the framework-based approach you will find in older case-solving

Focus on going through memorised sequences of steps too-often means failing to develop a full understanding of the case and the real key drivers.

At this link, we run through a case to illustrate the difference between a standard framework-based approach and our Problem Driven Structure method.

2.1.3. Problem Solving

You’ll be tested on your ability to identify problems and drivers, isolate causes and effects, demonstrate creativity and prioritise issues. In particular, the interviewer will look for the following skills:

• Prioritisation - Can you distinguish relevant and irrelevant facts?
• Connecting the dots - Can you connect new facts and evidence to the big picture?
• Establishing conclusions - Can you establish correct conclusions without rushing to inferences not supported by evidence?

2.1.4. Numerical Agility

In case interviews, you are expected to be quick and confident with both precise and approximated numbers. This translates to:

• Performing simple calculations quickly - Essential to solve cases quickly and impress clients with quick estimates and preliminary conclusions.
• Analysing data - Extract data from graphs and charts, elaborate and draw insightful conclusions.
• Solving business problems - Translate a real world case to a mathematical problem and solve it.

Our article on consulting math is a great resource here, though the extensive math content in our MCC Academy is the best and most comprehensive material available.

2.1.5. Communication

Real consulting work isn’t just about the raw analysis to come up with a recommendation - this then needs to be sold to the client as the right course of action.

Similarly, in a case interview, you must be able to turn your answer into a compelling recommendation. This is just as essential to impressing your interviewer as your structure and analysis.

Consultants already comment on how difficult it is to find candidates with the right communication skills. Add to this the current direction of travel, where AI will be able to automate more and more of the routine analytic side of consulting, and communication becomes a bigger and bigger part of what consultants are being paid for.

So, how do you make sure that your recommendations are relevant, smart, and engaging? The answer is to master what is known as CEO-level communication .

This art of speaking like a CEO can be quite challenging, as it often involves presenting information in effectively the opposite way to how you might normally.

To get it right, there are three key areas to focus on in your communications:

• Top down : A CEO wants to hear the key message first. They will only ask for more details if they think that will actually be useful. Always consider what is absolutely critical for the CEO to know, and start with that. You can read more in our article on the Pyramid Principle .
• Concise : This is not the time for "boiling the ocean" or listing an endless number possible solutions. CEOs, and thus consultants, want a structured, quick and concise recommendation for their business problem, that they can implement immediately.
• Fact-based : Consultants share CEOs' hatred of opinions based on gut feel rather than facts. They want recommendations based on facts to make sure they are actually in control. Always go on to back up your conclusions with the relevant facts.

Being concise and to the point is key in many areas, networking being one for them. For more detail on all this, check out our full article on delivering recommendations .

Prep the right way

3. types of case interview.

While most case interviews share a similar structure, firms will have some differences in the particular ways they like to do things in terms of both the case study and the fit component.

As we’ll see, these differences aren’t hugely impactful in terms of how you prepare. That said, it's always good to know as much as possible about what you will be going up against.

3.1. Different case objectives

A guiding thread throughout this article and our approach in general will be to treat each case as a self-contained problem and not try to pigeonhole it into a certain category. Having said that, there are of course similarities between cases and we can identify certain parameters and objectives.

Broadly speaking, cases can be divided into issue-based cases and strategic decision cases. In the former you will be asked to solve a certain issue, such as declining profits, or low productivity whereas in the latter you will be ask whether your client should or should not do something, such as enter a specific market or acquire another company. The chart below is a good breakdown of these different objectives:

3.2. How do interviewers craft cases

While interviewers will very likely be given a case bank to choose from by their company, a good number of them will also choose to adapt the cases they would currently be working on to a case interview setting. The difference is that the latter cases will be harder to pigeonhole and apply standard frameworks to, so a tailored approach will be paramount.

If you’ve applied for a specific practice or type of consulting - such as operational consulting, for example - it’s very likely that you will receive a case geared towards that particular area alongside a ‘generalist’ consulting case (however, if that’s the case, you will generally be notified). The other main distinction when it comes to case interviews is between interviewer-led and candidate-led.

3.3. Candidate-led cases

Most consulting case interview questions test your ability to crack a broad problem, with a case prompt often going something like:

" How much would you pay to secure the rights to run a restaurant in the British Museum? "

You, as a candidate, are then expected to identify your path to solve the case (that is, provide a structure), leveraging your interviewer to collect the data and test your assumptions.

This is known as a “candidate-led” case interview and is used by Bain, BCG and other firms. From a structuring perspective, it’s easier to lose direction in a candidate-led case as there are no sign-posts along the way. As such, you need to come up with an approach that is both broad enough to cover all of the potential drivers in a case but also tailored enough to the problem you are asked to solve. It’s also up to you to figure out when you need to delve deeper into a certain branch of the case, brainstorm or ask for data. The following case from Bain is an excellent example on how to navigate a candidate-led case.

3.4. Interviewer-led cases

This type of case - employed most famously by McKinsey - is slightly different, with the interviewer controlling the pace and direction of the conversation much more than with other case interviews.

At McKinsey, your interviewer will ask you a set of pre-determined questions, regardless of your initial structure. For each question, you will have to understand the problem, come up with a mini structure, ask for additional data (if necessary) and come to the conclusion that answers the question. This more structured format of case also shows up in online cases by other firms - notably including BCG’s Casey chatbot (with the amusing result that practising McKinsey-style cases can be a great addition when prepping for BCG).

Essentially, these interviewer-led case studies are large cases made up of lots of mini-cases. You still use basically the same method as you would for standard (or candidate-led) cases - the main difference is simply that, instead of using that method to solve one big case, you are solving several mini-cases sequentially. These cases are easier to follow as the interviewer will guide you in the right direction. However, this doesn’t mean you should pay less attention to structure and deliver a generic framework! Also, usually (but not always!) the first question will ask you to map your approach and is the equivalent of the structuring question in candidate-led cases. Sometimes, if you’re missing key elements, the interviewer might prompt you in the right direction - so make sure to take those prompts seriously as they are there to help you get back on track (ask for 30 seconds to think on the prompt and structure your approach). Other times - and this is a less fortunate scenario - the interviewer might say nothing and simply move on to the next question. This is why you should put just as much thought (if not more) into the framework you build for interviewer-led cases , as you may be penalized if you produce something too generic or that doesn’t encompass all the issues of the case.

3.5. Case and fit

The standard case interview can be thought of as splitting into two standalone sub-interviews. Thus “case interviews” can be divided into the case study itself and a “fit interview” section, where culture fit questions are asked.

This can lead to a bit of confusion, as the actual case interview component might take up as little as half of your scheduled “case interview”. You need to make sure you are ready for both aspects.

To illustrate, here is the typical case interview timeline:

• First 15-30 minutes: Fit Interview - with questions assessing your motivation to be a consultant in that specific firm and your traits around leadership and teamwork. Learn more about the fit interview in our in-depth article here .
• Next 30-40 minutes: Case Interview - solving a case study
• Last 5 minutes: Fit Interview again - this time focussing on your questions for your interviewer.

Both the Case and Fit interviews play crucial roles in the finial hiring decision. There is no “average” taken between case and fit interviews: if your performance is not up to scratch in either of the two, you will not be able to move on to the next interview round or get an offer.

NB: No case without fit

Note that, even if you have only been told you are having a case interview or otherwise are just doing a case study, always be prepared to answer fit questions. At most firms, it is standard practice to include some fit questions in all case interviews, even if there are also separate explicit fit interviews, and interviewers will almost invariably include some of these questions around your case. This is perfectly natural - imagine how odd and artificial it would be to show up to an interview, simply do a case and leave again, without talking about anything else with the interviewer before or after.

3.5.1 Differences between firms

For the most part, a case interview is a case interview. However, firms will have some differences in the particular ways they like to do things in terms of both the case study and the fit component.

3.5.2. The McKinsey PEI

McKinsey brands its fit aspect of interviews as the Personal Experience Interview or PEI. Despite the different name, this is really much the same interview you will be going up against in Bain, BCG and any similar firms.

McKinsey does have a reputation for pushing candidates a little harder with fit or PEI questions , focusing on one story per interview and drilling down further into the specific details each time. We discuss this tendency more in our fit interview article . However, no top end firm is going to go easy on you and you should absolutely be ready for the same level of grilling at Bain, BCG and others. Thus any difference isn’t hugely salient in terms of prep.

3.6. What is different in 2023?

For the foreseeable future, you are going to have to go through multiple live case interviews to secure any decent consulting job. These might increasingly happen via Zoom rather than in person, but they should remain largely the same otherwise.

However, things are changing and the rise of AI in recent months seems pretty much guaranteed to accelerate existing trends.

Even before the explosive development of AI chatbots like ChatGPT we have seen in recent months, automation was already starting to change the recruitment process.

As we mentioned, case interviews are expensive and inconvenient for firms to run . Ideally, then, firms will try to reduce the number of interviews required for recruitment as far as possible. For many years, tests of various kinds served to cut down the applicant pool and thus the number of interviews. However, these tests had a limited capacity to assess candidates against the full consulting skillset in the way that case interviews do so well.

More recently, though, the development of online testing has allowed for more and more advanced assessments. Top consulting firms have been leveraging screening tests that better and better capture the same skillset as case interviews. Eventually this is converging on automated case studies. We see this very clearly with the addition of the Redrock case to McKinsey’s Solve assessment.

As these digital cases become closer to the real thing, the line between test and case interview blurs. Online cases don’t just reduce the number of candidates to case interview, but start directly replacing them.

Case in point here is BCG’s Casey chatbot . Previously, BCG had deployed less advanced online cases and similar tests to weed out some candidates before live case interviews began. Now, though, Casey actually replaces one first round case interview.

Casey, at time of writing, is still a relatively “basic” chatbot, basically running through a pre-set script. The Whatsapp-like interface does a lot of work to make it feel like one is chatting to a “real person” - the chatbot itself, though, cannot provide feedback or nudges to candidates as would a human interviewer.

We fully expect that, as soon as BCG and other firms can train a truer AI, these online cases will become more widespread and start replacing more live interviews.

We discuss the likely impacts of advanced AI on consulting recruitment and the industry more broadly in our blog.

Here, though, the real message is that you should expect to run into digital cases as well as traditional case interviews.

Luckily, despite any changes in specific case interview format, you will still need to master the same fundamental skills and prepare in much the same way.

We’ll cover a few ways to help prepare for chatbot cases in section four. Ultimately, though, firms are looking for the same problem solving ability and mindset as a real interviewer. Especially as chatbots get better at mimicking a real interviewer, candidates who are well prepared for case cracking in general should have no problem with AI administered cases.

3.6.1. Automated fit interviews

Analogous to online cases, in recent years there has been a trend towards automated, “one way” fit interviews, with these typically being administered for consultancies by specialist contractors like HireVue or SparkHire.

These are kind of like Zoom interviews, but if the interviewer didn’t show up. Instead you will be given fit questions to answer and must record your answer in your computer webcam. Your response will then go on to be assessed by an algorithm, scoring both what you say and how you say it.

Again, with advances in AI, it is easy to imagine these automated case interviews going from fully scripted interactions, where all candidates are asked the same list of questions, to a more interactive experience. Thus, we might soon arrive at a point where you are being grilled on the details of your stories - McKinsey PEI style - but by a bot rather than a human.

We include some tips on this kind of “one way” fit interview in section six here.

4. How to solve cases with the Problem-Driven Structure?

If you look around online for material on how to solve case studies, a lot of what you find will set out framework-based approaches. However, as we have mentioned, these frameworks tend to break down with more complex, unique cases - with these being exactly the kind of tough case studies you can expect to be given in your case interviews.

To address this problem, the MyConsultingCoach team has synthesized a new approach to case cracking that replicates how top management consultants approach actual engagements.

MyConsultingCoach’s Problem Driven Structure approach is a universal problem solving method that can be applied to any business problem , irrespective of its nature.

As opposed to just selecting a generic framework for each case interview, the Problem Driven Structure approach works by generating a bespoke structure for each individual question and is a simplified version of the roadmap McKinsey consultants use when working on engagements.

The canonical seven steps from McKinsey on real projects are simplified to four for case interview questions, as the analysis required for a six-month engagement is somewhat less than that needed for a 45-minute case study. However, the underlying flow is the same (see the method in action in the video below)

Let's zoom in to see how our method actually works in more detail:

4.1. Identify the problem

Identifying the problem means properly understanding the prompt/question you are given, so you get to the actual point of the case.

This might sound simple, but cases are often very tricky, and many candidates irretrievably mess things up within the first few minutes of starting. Often, they won’t notice this has happened until they are getting to the end of their analysis. Then, they suddenly realise that they have misunderstood the case prompt - and have effectively been answering the wrong question all along!

With no time to go back and start again, there is nothing to do. Even if there were time, making such a silly mistake early on will make a terrible impression on their interviewer, who might well have written them off already. The interview is scuppered and all the candidate’s preparation has been for nothing.

This error is so galling as it is so readily avoidable.

Our method prevents this problem by placing huge emphasis on a full understanding of the case prompt. This lays the foundations for success as, once we have identified the fundamental, underlying problem our client is facing, we focus our whole analysis around finding solutions to this specific issue.

Now, some case interview prompts are easy to digest. For example, “Our client, a supermarket, has seen a decline in profits. How can we bring them up?”. However, many of the prompts given in interviews for top firms are much more difficult and might refer to unfamiliar business areas or industries. For example, “How much would you pay for a banking license in Ghana?” or “What would be your key areas of concern be when setting up an NGO?”

Don’t worry if you have no idea how you might go about tackling some of these prompts!

In our article on identifying the problem and in our full lesson on the subject in our MCC Academy course, we teach a systematic, four step approach to identifying the problem , as well as running through common errors to ensure you start off on the right foot every time!

This is summarised here:

Following this method lets you excel where your competitors mess up and get off to a great start in impressing your interviewer!

4.2. Build your problem driven structure

After you have properly understood the problem, the next step is to successfully crack a case is to draw up a bespoke structure that captures all the unique features of the case.

This is what will guide your analysis through the rest of the case study and is precisely the same method used by real consultants working on real engagements.

Of course, it might be easier here to simply roll out one an old-fashioned framework, and a lot of candidates will do so. This is likely to be faster at this stage and requires a lot less thought than our problem-driven structure approach.

However, whilst our problem driven structure approach requires more work from you, our method has the advantage of actually working in the kind of complex case studies where generic frameworks fail - that is exactly the kind of cases you can expect at an MBB interview .

Since we effectively start from first principles every time, we can tackle any case with the same overarching method. Simple or complex, every case is the same to you and you don’t have to gamble a job on whether a framework will actually work

4.2.1 Issue trees

Issue trees break down the overall problem into a set of smaller problems that you can then solve individually. Representing this on a diagram also makes it easy for both you and your interviewer to keep track of your analysis.

To see how this is done, let’s look at the issue tree below breaking down the revenues of an airline:

These revenues can be segmented as the number of customers multiplied by the average ticket price. The number of customers can be further broken down into a number of flights multiplied by the number of seats, times average occupancy rate. The node corresponding to the average ticket price can then be segmented further.

4.2.2 Hypothesis trees

Hypothesis trees are similar, the only difference being that rather than just trying to break up the issue into smaller issues you are assuming that the problem can be solved and you are formulating solutions.

In the example above, you would assume revenues can be increased by either increasing the average ticket price or the number of customers . You can then hypothesize that you can increase the average occupancy rate in three ways: align the schedule of short and long haul flights, run a promotion to boost occupancy in off-peak times, or offer early bird discounts.

4.2.3 Other structures:structured lists

Structured lists are simply subcategories of a problem into which you can fit similar elements. This McKinsey case answer starts off by identifying several buckets such as retailer response, competitor response, current capabilities and brand image and then proceeds to consider what could fit into these categories.

Buckets can be a good way to start the structure of a complex case but when using them it can be very difficult to be MECE and consistent, so you should always aim to then re-organize them into either an issue or a hypothesis tree.

It is worth noting that the same problem can be structured in multiple valid ways by choosing different means to segment the key issues. Ultimately all these lists are methods to set out a logical hierachy among elements.

4.2.4 Structures in practice

That said, not all valid structures are equally useful in solving the underlying problem. A good structure fulfils several requirements - including MECE-ness , level consistency, materiality, simplicity, and actionability. It’s important to put in the time to master segmentation, so you can choose a scheme isn’t only valid, but actually useful in addressing the problem.

After taking the effort to identify the problem properly, an advantage of our method is that it will help ensure you stay focused on that same fundamental problem throughout. This might not sound like much, but many candidates end up getting lost in their own analysis, veering off on huge tangents and returning with an answer to a question they weren’t asked.

Another frequent issue - particularly with certain frameworks - is that candidates finish their analysis and, even if they have successfully stuck to the initial question, they have not actually reached a definite solution. Instead, they might simply have generated a laundry list of pros and cons, with no clear single recommendation for action.

Clients employ consultants for actionable answers, and this is what is expected in the case interview. The problem driven structure excels in ensuring that everything you do is clearly related back to the key question in a way that will generate a definitive answer. Thus, the problem driven structure builds in the hypothesis driven approach so characteristic of real consulting practice.

You can learn how to set out your own problem driven structures in our article here and in our full lesson in the MCC Academy course.

4.2. Lead the analysis

A problem driven structure might ensure we reach a proper solution eventually, but how do we actually get there?

We call this step " leading the analysis ", and it is the process whereby you systematically navigate through your structure, identifying the key factors driving the issue you are addressing.

Generally, this will mean continuing to grow your tree diagram, further segmenting what you identify as the most salient end nodes and thus drilling down into the most crucial factors causing the client’s central problem.

Once you have gotten right down into the detail of what is actually causing the company’s issues, solutions can then be generated quite straightforwardly.

To see this process in action, we can return to our airline revenue example:

Let’s say we discover the average ticket price to be a key issue in the airline’s problems. Looking closer at the drivers of average ticket price, we find that the problem lies with economy class ticket prices. We can then further segment that price into the base fare and additional items such as food.

Having broken down the issue to such a fine-grained level and considering the 80/20 rule(see below), solutions occur quite naturally. In this case, we can suggest incentivising the crew to increase onboard sales, improving assortment in the plane, or offering discounts for online purchases.

Our article on leading the analysis is a great primer on the subject, with our video lesson in the MCC Academy providing the most comprehensive guide available.

4.4. Provide recommendations

So you have a solution - but you aren’t finished yet!

Now, you need to deliver your solution as a final recommendation.

This should be done as if you are briefing a busy CEO and thus should be a one minute, top-down, concise, structured, clear, and fact-based account of your findings.

The brevity of the final recommendation belies its importance. In real life consulting, the recommendation is what the client has potentially paid millions for - from their point of view, it is the only thing that matters.

In a case interview, your performance in this final summing up of your case is going to significantly colour your interviewer’s parting impression of you - and thus your chances of getting hired!

So, how do we do it right?

Barbara Minto's Pyramid Principle elegantly sums up almost everything required for a perfect recommendation. The answer comes first , as this is what is most important. This is then supported by a few key arguments , which are in turn buttressed by supporting facts .

Across the whole recommendation, the goal isn’t to just summarise what you have done. Instead, you are aiming to synthesize your findings to extract the key "so what?" insight that is useful to the client going forward.

All this might seem like common sense, but it is actually the opposite of how we relay results in academia and other fields. There, we typically move from data, through arguments and eventually to conclusions. As such, making good recommendations is a skill that takes practice to master.

We can see the Pyramid Principle illustrated in the diagram below:

To supplement the basic Pyramid Principle scheme, we suggest candidates add a few brief remarks on potential risks and suggested next steps . This helps demonstrate the ability for critical self-reflection and lets your interviewer see you going the extra mile.

The combination of logical rigour and communication skills that is so definitive of consulting is particularly on display in the final recommendation.

Despite it only lasting 60 seconds, you will need to leverage a full set of key consulting skills to deliver a really excellent recommendation and leave your interviewer with a good final impression of your case solving abilities.

Our specific article on final recommendations and the specific video lesson on the same topic within our MCC Academy are great, comprehensive resources. Beyond those, our lesson on consulting thinking and our articles on MECE and the Pyramid Principle are also very useful.

4.5. What if I get stuck?

Naturally with case interviews being difficult problems there may be times where you’re unsure what to do or which direction to take. The most common scenario is that you will get stuck midway through the case and there are essentially two things that you should do:

• 1. Go back to your structure
• 2. Ask the interviewer for clarification

Your structure should always be your best friend - after all, this is why you put so much thought and effort into it: if it’s MECE it will point you in the right direction. This may seem abstract but let’s take the very simple example of a profitability case interview: if you’ve started your analysis by segmenting profit into revenue minus costs and you’ve seen that the cost side of the analysis is leading you nowhere, you can be certain that the declining profit is due to a decline in revenue.

Similarly, when you’re stuck on the quantitative section of the case interview, make sure that your framework for calculations is set up correctly (you can confirm this with the interviewer) and see what it is you’re trying to solve for: for example if you’re trying to find what price the client should sell their new t-shirt in order to break even on their investment, you should realize that what you’re trying to find is the break even point, so you can start by calculating either the costs or the revenues. You have all the data for the costs side and you know they’re trying to sell 10.000 pairs so you can simply set up the equation with x being the price.

As we’ve emphasised on several occasions, your case interview will be a dialogue. As such, if you don’t know what to do next or don’t understand something, make sure to ask the interviewer (and as a general rule always follow their prompts as they are trying to help, not trick you). This is especially true for the quantitative questions, where you should really understand what data you’re looking at before you jump into any calculations. Ideally you should ask your questions before you take time to formulate your approach but don’t be afraid to ask for further clarification if you really can’t make sense of what’s going on. It’s always good to walk your interviewer through your approach before you start doing the calculations and it’s no mistake to make sure that you both have the same understanding of the data. For example when confronted with the chart below, you might ask what GW (in this case gigawatt) means from the get-go and ask to confirm the different metrics (i.e. whether 1 GW = 1000 megawatts). You will never be penalised for asking a question like that.

5. What to remember in case interviews

If you’re new to case cracking you might feel a bit hopeless when you see a difficult case question, not having any idea where to start.

In fact though, cracking case interviews is much like playing chess. The rules you need to know to get started are actually pretty simple. What will make you really proficient is time and practice.

In this section, we’ll run through a high level overview of everything you need to know, linking to more detailed resources at every step.

5.1. An overall clear structure

You will probably hear this more than you care for but it is the most important thing to keep in mind as you start solving cases, as not only it is a key evaluation criterion but the greatest tool you will have at your disposal. The ability to build a clear structure in all aspects of the case inteview will be the difference between breezing through a complicated case and struggling at its every step. Let’s look a bit closer at the key areas where you should be structured!

5.1.1 Structured notes

Every case interview starts with a prompt, usually verbal, and as such you will have to take some notes. And here is where your foray into structure begins, as the notes you take should be clear, concise and structured in a way that will allow you to repeat the case back to the interviewer without writing down any unnecessary information.

This may sound very basic but you should absolutely not be dismissive about it: taking clear and organized notes will allow what we found helps is to have separate sections for:

• The case brief
• Follow-up questions and answers
• Numerical data
• Case structure (the most crucial part when solving the case)
• Any scrap work during the case (usually calculations)

When solving the case - or, as we call it here, in the Lead the analysis step, it is highly recommended to keep on feeding and integrating your structure, so that you never get lost. Maintaining a clear high level view is one of the most critical aspects in case interviews as it is a key skill in consulting: by constantly keeping track of where you are following your structure, you’ll never lose your focus on the end goal.

In the case of an interviewer-led case, you can also have separate sheets for each question (e.g. Question 1. What factors can we look at that drive profitability?). If you develop a system like this you’ll know exactly where to look for each point of data rather than rummage around in untidy notes. There are a couple more sections that you may have, depending on preference - we’ll get to these in the next sections.

5.1.2 Structured communication

There will be three main types of communication in cases:

• 1. Asking and answering questions
• 2. Walking the interviewer through your structure (either the case or calculation framework - we’ll get to that in a bit!)
• 3. Delivering your recommendation

Asking and answering questions will be the most common of these and the key thing to do before you speak is ask for some time to collect your thoughts and get organised. What you want to avoid is a ‘laundry list’ of questions or anything that sounds too much like a stream of consciousness.

Different systems work for different candidates but a sure-fire way of being organised is numbering your questions and answers. So rather than saying something like ‘I would like to ask about the business model, operational capacity and customer personas’ it’s much better to break it down and say something along the lines of ‘I’ve got three key questions. Firstly I would like to inquire into the business model of our client. Secondly I would like to ask about their operational capacity. Thirdly I would like to know more about the different customer personas they are serving’.

A similar principle should be applied when walking the interviewer through your structure, and this is especially true of online case interviews (more and more frequent now) when the interviewer can’t see your notes. Even if you have your branches or buckets clearly defined, you should still use a numbering system to make it obvious to the interviewer. So, for example, when asked to identify whether a company should make an acquisition, you might say ‘I would like to examine the following key areas. Firstly the financial aspects of this issue, secondly the synergies and thirdly the client’s expertise’

The recommendation should be delivered top-down (see section 4.4 for specifics) and should employ the same numbering principle. To do so in a speedy manner, you should circle or mark the key facts that you encounter throughout the case so you can easily pull them out at the end.

5.1.3 Structured framework

It’s very important that you have a systematic approach - or framework - for every case. Let’s get one thing straight: there is a difference between having a problem-solving framework for your case and trying to force a case into a predetermined framework. Doing the former is an absolute must , whilst doing the latter will most likely have you unceremoniously dismissed.

We have seen there are several ways of building a framework, from identifying several categories of issues (or ‘buckets’) to building an issue or hypothesis tree (which is the most efficient type of framework). For the purpose of organization, we recommend having a separate sheet for the framework of the case, or, if it’s too much to manage, you can have it on the same sheet as the initial case prompt. That way you’ll have all the details as well as your proposed solution in one place.

5.1.4 Structured calculations

Whether it’s interviewer or candidate-led, at some point in the case you will get a bunch of numerical data and you will have to perform some calculations (for the specifics of the math you’ll need on consulting interviews, have a look at our Consulting Math Guide ). Here’s where we urge you to take your time and not dive straight into calculating! And here’s why: while your numerical agility is sure to impress interviewers, what they’re actually looking for is your logic and the calculations you need to perform in order to solve the problem . So it’s ok if you make a small mistake, as long as you’re solving for the right thing.

As such, make it easy for them - and yourself. Before you start, write down in steps the calculations you need to perform. Here’s an example: let’s say you need to find out by how much profits will change if variable costs are reduced by 10%. Your approach should look something like:

• 1. Calculate current profits: Profits = Revenues - (Variable costs + Fixed costs)
• 2. Calculate the reduction in variable costs: Variable costs x 0.9
• 3. Calculate new profits: New profits = Revenues - (New variable costs + Fixed costs)

Of course, there may be more efficient ways to do that calculation, but what’s important - much like in the framework section - is to show your interviewer that you have a plan, in the form of a structured approach. You can write your plan on the sheet containing the data, then perform the calculations on a scrap sheet and fill in the results afterward.

5.2. Common business knowledge and formulas

Although some consulting firms claim they don’t evaluate candidates based on their business knowledge, familiarity with basic business concepts and formulae is very useful in terms of understanding the case studies you are given in the first instance and drawing inspiration for structuring and brainstorming.

If you are coming from a business undergrad, an MBA or are an experienced hire, you might well have this covered already. For those coming from a different background, it may be useful to cover some.

Luckily, you don’t need a degree-level understanding of business to crack case interviews , and a lot of the information you will pick up by osmosis as you read through articles like this and go through cases.

However, some things you will just need to sit down and learn. We cover everything you need to know in some detail in our Case Academy Course course. However, some examples here of things you need to learn are:

• Basic accounting (particularly how to understand all the elements of a balance sheet)
• Basic economics
• Basic marketing
• Basic strategy

Below we include a few elementary concepts and formulae so you can hit the ground running in solving cases. We should note that you should not memorise these and indeed a good portion of them can be worked out logically, but you should have at least some idea of what to expect as this will make you faster and will free up much of your mental computing power. In what follows we’ll tackle concepts that you will encounter in the private business sector as well as some situations that come up in cases that feature clients from the NGO or governmental sector.

5.2.1 Business sector concepts

These concepts are the bread and butter of almost any business case so you need to make sure you have them down. Naturally, there will be specificities and differences between cases but for the most part here is a breakdown of each of them.

5.2.1.1. Revenue

The revenue is the money that the company brings in and is usually equal to the number of products they sell multiplied to the price per item and can be expressed with the following equation:

Revenue = Volume x Price

Companies may have various sources of revenue or indeed multiple types of products, all priced differently which is something you will need to account for in your case interview. Let’s consider some situations. A clothing company such as Nike will derive most of their revenue from the number of products they sell times the average price per item. Conversely, for a retail bank revenue is measured as the volume of loans multiplied by the interest rate at which the loans are given out. As we’ll see below, we might consider primary revenues and ancillary revenues: in the case of a football club, we might calculate primary revenues by multiplying the number of tickets sold by the average ticket price, and ancillary revenues those coming from sales of merchandise (similarly, let’s say average t-shirt price times the number of t-shirts sold), tv rights and sponsorships.

These are but a few examples and another reminder that you should always aim to ask questions and understand the precise revenue structure of the companies you encounter in cases.

5.2.1.2. Costs

The costs are the expenses that a company incurs during its operations. Generally, they can be broken down into fixed and variable costs :

Costs = Fixed Costs + Variable Costs

As their name implies, fixed costs do not change based on the number of units produced or sold. For example, if you produce shoes and are renting the space for your factory, you will have to pay the rent regardless of whether you produce one pair or 100. On the other hand, variable costs depend on the level of activity, so in our shoe factory example they would be equivalent to the materials used to produce each pair of shoes and would increase the more we produce.

These concepts are of course guidelines used in order to simplify the analysis in cases, and you should be aware that in reality often the situation can be more complicated. However, this should be enough for case interviews. Costs can also be quasi-fixed, in that they increase marginally with volume. Take the example of a restaurant which has a regular staff, incurring a fixed cost but during very busy hours or periods they also employ some part-time workers. This cost is not exactly variable (as it doesn’t increase with the quantity of food produced) but also not entirely fixed, as the number of extra hands will depend on how busy the restaurant is. Fixed costs can also be non-linear in nature. Let’s consider the rent in the same restaurant: we would normally pay a fixed amount every month, but if the restaurant becomes very popular we might need to rent out some extra space so the cost will increase. Again, this is not always relevant for case interviews.

5.2.1.3. Profit and profit margin

The profit is the amount of money a company is left with after it has paid all of its expenses and can be expressed as follows:

Profit = Revenue - Costs

It’s very likely that you will encounter a profitability issue in one of your case interviews, namely you will be asked to increase a company’s profit. There are two main ways of doing this: increasing revenues and reducing costs , so these will be the two main areas you will have to investigate. This may seem simple but what you will really need to understand in a case are the key drivers of a business (and this should be done through clarifying questions to the interviewer - just as a real consultant would question their client).

For example, if your client is an airline you can assume that the main source of revenue is sales of tickets, but you should inquire how many types of ticket the specific airline sells. You may naturally consider economy and business class tickets, but you may find out that there is a more premium option - such as first class - and several in-between options. Similarly to our football club example, there may be ancillary revenues from selling of food and beverage as well as advertising certain products or services on flights.

You may also come across the profit margin in case interviews. This is simply the percentage of profit compared to the revenue and can be expressed as follows:

Profit margin = Profit/Revenue x 100

5.2.1.4. Break-even point

An ancillary concept to profit, the break-even point is the moment where revenues equal costs making the profit zero and can be expressed as the following equation:

Revenues = Costs (Fixed costs + Variable costs)

This formula will be useful when you are asked questions such as ‘What is the minimum price I should sell product X?’ or ‘What quantity do I need to sell in order to recoup my investment?’. Let’s say in a case interview an owner of a sandwich store asks us to figure out how many salami and cheese salami sandwiches she needs to sell in order to break even. She’s spending $4 on salami and $2 for cheese and lettuce per sandwich, and believes she can sell the sandwiches at around $7. The cost of utilities and personnel is around $5000 per month. We could lay this all out in the break-even equation:

7 x Q ( quantity ) = (4+2) x Q + 5000 ( variable + fixed costs )

In a different scenario, we may be asked to calculate the break-even price . Let’s consider our sandwich example and say our owner knows she has enough ingredients for about 5000 sandwiches per month but is not sure how much to sell them for. In that case, if we know our break-even equation, we can simply make the following changes:

P ( price ) x 5000 = (4+2) x 5000 + 5000

By solving the equation we get to the price of $7 per sandwich.

5.2.1.5. Market share and market size

We can also consider the market closely with profit, as in fact the company’s performance in the market is what drives profits. The market size is the total number of potential customers for a certain business or product, whereas the market share is the percentage of that market that your business controls (or could control, depending on the case).

There is a good chance you will have to estimate the market size in one of your case interviews and we get into more details on how to do that below. You may be asked to estimate this in either number of potential customers or total value . The latter simply refers to the number of customers multiplied by the average value of the product or service.

To calculate the market share you will have to divide the company’s share by the total market size and multiply by 100:

Note, though, that learning the very basics of business is the beginning rather than the end of your journey. Once you are able to “speak business” at a rudimentary level, you should try to “become fluent” and immerse yourself in reading/viewing/listening to as wide a variety of business material as possible, getting a feel for all kinds of companies and industries - and especially the kinds of problems that can come up in each context and how they are solved. The material put out by the consulting firms themselves is a great place to start, but you should also follow the business news and find out about different companies and sectors as much as possible between now and interviews. Remember, if you’re going to be a consultant, this should be fun rather than a chore!

5.3 Public sector and NGO concepts

As we mentioned, there will be some cases (see section 6.6 for a more detailed example) where the key performance indicators (or KPIs in short) will not be connected to profit. The most common ones will involve the government of a country or an NGO, but they can be way more diverse and require more thought and application of first principles. We have laid out a couple of the key concepts or KPIs that come up below

5.3.1 Quantifiability

In many such scenarios you will be asked to make an important strategic decision of some kind or to optimise a process. Of course these are not restricted to non-private sector cases but this is where they really come into their own as there can be great variation in the type of decision and the types of field.

While there may be no familiar business concepts to anchor yourself onto, a concept that is essential is quantifiability . This means, however qualitative the decision might seem, consultants rely on data so you should always aim to have aspects of a decision that can be quantified, even if the data doesn’t present itself in a straightforward manner.

Let’s take a practical example. Your younger sibling asks you to help them decide which university they should choose if they want to study engineering. One way to structure your approach would be to segment the problem into factors affecting your sibling’s experience at university and experience post-university. Within the ‘at uni’ category you might think about the following:

• Financials : How much are tuition costs and accommodation costs?
• Quality of teaching and research : How are possible universities ranked in the QS guide based on teaching and research?
• Quality of resources : How well stocked is their library, are the labs well equipped etc.?
• Subject ranking : How is engineering at different unis ranked?
• Life on campus and the city : What are the living costs in the city where the university is based? What are the extracurricular opportunities and would your sibling like to live in that specific city based on them?

Within the ‘out of uni’ category you might think about:

• Exit options : What are the fields in which your sibling could be employed and how long does it take the average student of that university to find a job?
• Alumni network : What percentage of alumni are employed by major companies?
• Signal : What percentage of applicants from the university get an interview in major engineering companies and related technical fields?

You will perhaps notice that all the buckets discussed pose quantifiable questions meant to provide us with data necessary to make a decision. It’s no point to ask ‘Which university has the nicest teaching staff?’ as that can be a very subjective metric.

5.3.1 Impact

Another key concept to consider when dealing with sectors other than the private one is how impactful a decision or a line of inquiry is on the overarching issue , or whether all our branches in our issue tree have a similar impact. This can often come in the form of impact on lives, such as in McKinsey’s conservation case discussed below, namely how many species can we save with our choice of habitat.

5.4 Common consulting concepts

Consultants use basic business concepts on an every day basis, as they help them articulate their frameworks to problems. However, they also use some consulting specific tools to quality check their analysis and perform in the most efficient way possible. These principles can be applied to all aspects of a consultant’s work, but for brevity we can say they mostly impact a consultant’s systematic approach and communication - two very important things that are also tested in case interviews. Therefore, it’s imperative that you not only get to know them, but learn how and when to use them as they are at the very core of good casing. They are MECE-ness, the Pareto Principle and the Pyramid principle and are explained briefly below - you should, however, go on to study them in-depth in their respective articles.

Perhaps the central pillar of all consulting work and an invaluable tool to solve cases, MECE stands for Mutually Exclusive and Collectively Exhaustive . It can refer to any and every aspect in a case but is most often used when talking about structure. We have a detailed article explaining the concept here , but the short version is that MECE-ness ensures that there is no overlap between elements of a structure (i.e. the Mutually Exclusive component) and that it covers all the drivers or areas of a problem (Collectively Exhaustive). It is a concept that can be applied to any segmentation when dividing a set into subsets that include it wholly but do not overlap.

Let’s take a simple example and then a case framework example. In simple terms, when we are asked to break down the set ‘cars’ into subsets, dividing cars into ‘red cars’ and ‘sports cars’ is neither mutually exclusive (as there are indeed red sports cars) nor exhaustive of the whole set (i.e. there are also yellow non-sports cars that are not covered by this segmentation). A MECE way to segment would be ‘cars produced before 2000’ and ‘cars produced after 2000’ as this segmentation allows for no overlap and covers all the cars in existence.

Dividing cars can be simple, but how can we ensure MECEness in a case-interview a.k.a. a business situation. While the same principles apply, a good tip to ensure that your structure is MECE is to think about all the stakeholders - i.e. those whom a specific venture involves.

Let’s consider that our client is a soda manufacturer who wants to move from a business-to-business strategy, i.e. selling to large chains of stores and supermarkets, to a business-to-consumer strategy where it sells directly to consumers. In doing so they would like to retrain part of their account managers as direct salespeople and need to know what factors to consider.

A stakeholder-driven approach would be to consider the workforce and customers and move further down the issue tree, thinking about individual issues that might affect them. In the case of the workforce, we might consider how the shift would affect their workload and whether it takes their skillset into account. As for the customers, we might wonder whether existing customers would be satisfied with this move: will the remaining B2B account managers be able to provide for the needs of all their clients and will the fact that the company is selling directly to consumers now not cannibalise their businesses? We see how by taking a stakeholder-centred approach we can ensure that every single perspective and potential issue arising from it is fully covered.

5.4.2 The Pareto Principle

Also known as the 80/20 rule, this principle is important when gauging the impact of a decision or a factor in your analysis. It simply states that in business (but not only) 80% of outcomes come from 20% of causes. What this means is you can make a few significant changes that will impact most of your business organisation, sales model, cost structure etc.

Let’s have a look at 3 quick examples to illustrate this:

• 80% of all accidents are caused by 20% of drivers
• 20% of a company’s products account for 80% of the sales
• 80% of all results in a company are driven by 20% of its employees

The 80/20 rule will be a very good guide line in real engagements as well as case interviews, as it will essentially point to the easiest and most straightforward way of doing things. Let’s say one of the questions in a case is asking you to come up with an approach to understand the appeal of a new beard trimmer. Obviously you can’t interview the whole male population so you might think about setting up a webpage and asking people to comment their thoughts. But what you would get would be a laundry list of difficult to sift through data.

Using an 80/20 approach you would segment the population based on critical factors (age groups, grooming habits etc.) and then approach a significant sample size of each (e.g. 20), analysing the data and reaching a conclusion.

5.4.3 The Pyramid Principle

This principle refers to organising your communication in a top-down , efficient manner. While this is generally applicable, the pyramid principle will most often be employed when delivering the final recommendation to your client. This means - as is implicit in the name - that you would organise your recommendation (and communication in general) as a pyramid, stating the conclusion or most important element at the top then go down the pyramid listing 3 supporting arguments and then further (ideally also 3) supporting arguments for those supporting arguments.

Let’s look at this in practice in a case interview context: your client is a German air-conditioning unit manufacturer who was looking to expand into the French market. However, after your analysis you’ve determined that the market share they were looking to capture would not be feasible. A final recommendation using the Pyramid Principle would sound something like this: ‘I recommend that we do not enter the German market for the following three reasons. Firstly, the market is too small for our ambitions of $50 million. Secondly the market is heavily concentrated, being controlled by three major players and our 5 year goal would amount to controlling 25% of the market, a share larger than that of any of the players. Thirdly, the alternative of going into the corporate market would not be feasible, as it has high barriers to entry.Then, if needed, we could delve deeper into each of our categories

6. Case examples or building blocks?

As we mentioned before, in your case interview preparation you will undoubtedly find preparation resources that claim that there are several standard types of cases and that there is a general framework that can be applied to each type of case. While there are indeed cases that are straightforward at least in appearance and seemingly invite the application of such frameworks, the reality is never that simple and cases often involve multiple or more complicated components that cannot be fitted into a simple framework.

At MCC we don’t want you to get into the habit of trying to identify which case type you’re dealing with and pull out a framework, but we do recognize that there are recurring elements in frameworks that are useful - such as the profitability of a venture (with its revenues and costs), the valuation of a business, estimating and segmenting a market and pricing a product.

We call these building blocks because they can be used to build case frameworks but are not a framework in and of themselves, and they can be shuffled around and rearranged in any way necessary to be tailored to our case. Hence, our approach is not to make you think in terms of case types but work from first principles and use these building blocks to build your own framework. Let’s take two case prompts to illustrate our point.

The first is from the Bain website, where the candidate is asked whether they think it’s a good idea for their friend to open a coffee shop in Cambridge UK (see the case here ). The answer framework provided here is a very straightforward profitability analysis framework, examining the potential revenues and potential costs of the venture:

While this is a good point to start for your case interview (especially taken together with the clarifying questions), we will notice that this approach will need more tailoring to the case - for example the quantity of coffee will be determined by the market for coffee drinkers in Cambridge, which we have to determine based on preference. We are in England so a lot of people will be drinking tea but we are in a university town so perhaps more people than average are drinking coffee as it provides a better boost when studying. All these are some much needed case-tailored hypotheses that we can make based on the initial approach.

Just by looking at this case we might be tempted to say that we can just take a profitability case and apply it without any issues. However, this generic framework is just a starting point and in reality we would need to tailor it much further in the way we had started to do in order to get to a satisfactory answer. For example, the framework for this specific case interview doesn’t cover aspects such as the customer’s expertise: does the friend have any knowledge of the coffee business, such as where to source coffee and how to prepare it? Also, we could argue there may be some legal factors to consider here, such as any approvals that they might need from the city council to run a coffee shop on site, or some specific trade licences that are not really covered in the basic profitability framework.

Let’s take a different case , however, from the McKinsey website. In this scenario, the candidate is being asked to identify some factors in order to choose where to focus the client’s conservation efforts. Immediately we can realise that this case doesn’t lend itself to any pre-packaged framework and we will need to come up with something from scratch - and take a look at McKinsey’s answer of the areas to focus on:

We notice immediately that this framework is 100% tailored to the case - of course there are elements which we encounter in other cases, such as costs and risks but again these are applied in an organic way. It’s pretty clear that while no standard framework would work in this case, the aforementioned concepts - costs and risks - and the way to approach them (a.k.a building blocks ) are fundamentally similar throughout cases (with the obvious specificities of each case).

In what follows, we’ll give a brief description of each building block starting from the Bain example discussed previously, in order to give you a general idea of what they are and their adaptability, but you should make sure to follow the link to the in-depth articles to learn all their ins and outs.

6.1 Estimates and segmentation

This building block will come into play mostly when you’re thinking about the market for a certain product (but make sure to read the full article for more details). Let’s take our Bain Cambridge coffee example. As we mentioned under the quantity bucket we need to understand what the market size for coffee in Cambridge would be - so we can make an estimation based on segmentation .

The key to a good estimation is the ability to logically break down the problem into more manageable pieces. This will generally mean segmenting a wider population to find a particular target group. We can start off with the population of Cambridge - which we estimate at 100.000. In reality the population is closer to 150.000 but that doesn’t matter - the estimation has to be reasonable and not accurate , so unless the interviewer gives you a reason to reconsider you can follow your instinct. We can divide that into people who do and don’t drink coffee. Given our arguments before, we can conclude that 80% of those, so 80.000 drink coffee. Then we can further segment into those who drink regularly - let’s say every day - and those who drink occasionally - let’s say once a week. Based on the assumptions before about the student population needing coffee to function, and with Cambridge having a high student population, we can assume that 80% of those drinking coffee are regular drinkers, so that would be 64.000 regular drinkers and 16.000 occasional drinkers. We can then decide whom we want to target what our strategy needs to be:

This type of estimation and segmentation can be applied to any case specifics - hence why it is a building block.

6.2 Profitability

We had several looks at this building block so far (see an in-depth look here ) as it will show up in most case interivew scenarios, since profit is a key element in any company’s strategy. As we have seen, the starting point to this analysis is to consider both the costs and revenues of a company, and try to determine whether revenues need to be improved or whether costs need to be lowered. In the coffee example, the revenues are dictated by the average price per coffe x the number of coffees sold , whereas costs can be split into fixed and variable .

Some examples of fixed costs would be the rent for the stores and the cost of the personnel and utilities, while the most obvious variable costs would be the coffee beans used and the takeaway containers (when needed). We may further split revenues in this case into Main revenues - i.e. the sales of coffee - and Ancillary revenues , which can be divided into Sales of food products (sales of pastries, sandwiches etc., each with the same price x quantity schema) and Revenues from events - i.e renting out the coffee shop to events and catering for the events themselves. Bear in mind that revenues will be heavily influenced by the penetration rate , i.e. the share of the market which we can capture.

6.3 Pricing

Helping a company determine how much they should charge for their goods or services is another theme that comes up frequently in cases. While it may seem less complicated than the other building blocks, we assure you it’s not - you will have to understand and consider several factors, such as the costs a company is incurring, their general strategic positioning, availability, market trends as well as the customers’ willingness to pay (or WTP in short) - so make sure to check out our in-depth guide here .

In our example, we may determine that the cost per cup (coffee beans, staff, rent) is £1. We want to be student friendly so we should consider how much students would want to pay for a coffee as well as how much are competitors are charging. Based on those factors, it would be reasonable to charge on average £2 per cup of coffee. It’s true that our competitors are charging £3 but they are targeting mostly the adult market, whose willingness to pay is higher, so their pricing model takes that into account as well as the lower volume of customers in that demographic.

6.4. Valuation

A variant of the pricing building block, a valuation problem generally asks the candidate to determine how much a client should pay for a specific company (the target of an acquisition) as well as what other factors to consider. The two most important factors (but not the only ones - for a comprehensive review see our Valuation article ) to consider are the net present value (in consulting interviews usually in perpetuity) and the synergies .

In short, the net present value of a company is how much profit it currently brings in, divided by how much that cash flow will depreciate in the future and can be represented with the equation below:

The synergies refer to what could be achieved should the companies operate as one, and can be divided into cost and revenue synergies .

Let’s expand our coffee example a bit to understand these. Imagine that our friend manages to open a chain of coffee shops in Cambridge and in the future considers acquiring a chain of take-out restaurants. The most straightforward example of revenue synergies would be cross-selling, in this case selling coffee in the restaurants as well as in the dedicated stores, and thus getting an immediate boost in market share by using the existing customers of the restaurant chain. A cost synergy would be merging the delivery services of the two businesses to deliver both food and coffee, thus avoiding redundancies and reducing costs associated with twice the number of drivers and vehicles.

6.5. Competitive interaction

This component of cases deals with situations where the market in which a company is operating changes and the company must decide what to do. These changes often have to do with a new player entering the market (again for more details make sure to dive into the Competitive Interaction article ).

Let’s assume that our Cambridge coffee shop has now become a chain and has flagged up to other competitors that Cambridge is a blooming market for coffee. As such, Starbucks has decided to open a few stores in Cambridge themselves, to test this market. The question which might be posed to a candidate is what should our coffee chain do. One way (and a MECE one) to approach the problem is to decide between doing something and doing nothing . We might consider merging with another coffee chain and pooling our resources or playing to our strengths and repositioning ourselves as ‘your student-friendly, shop around the corner’. Just as easily we may just wait the situation out and see whether indeed Starbucks is cutting into our market share - after all, the advantages of our product and services might speak for themselves and Starbucks might end up tanking. Both of these are viable options if argued right and depending on the further specifics of the case.

6.6. Special cases

Most cases deal with private sectors, where the overarching objective entails profit in some form. However, as hinted before, there are cases which deal with other sectors where there are other KPIs in place . The former will usually contain one or several of these building blocks whereas the latter will very likely have neither. This latter category is arguably the one that will stretch your analytical and organisational skills to the limit, since there will be very little familiarity that you can fall back on (McKinsey famously employs such cases in their interview process).

So how do we tackle the structure for such cases? The short answer would be starting from first principles and using the problem driven structure outlined above, but let’s look at a quick example in the form of a McKinsey case :

The first question addressed to the candidate is the following:

This is in fact asking us to build a structure for the case. So what should we have in mind here? Most importantly, we should start with a structure that is MECE and we should remember to do that by considering all the stakeholders . They are on the one hand the government and affiliated institutions and on the other the population. We might then consider which issues might arise for each shareholder and what the benefits for them would be, as well as the risks. This approach is illustrated in the answer McKinsey provides as well:

More than anything, this type of case shows us how important it is to practise and build different types of structures, and think about MECE ways of segmenting the problem.

7. How Do I prepare for case interviews

In consulting fashion, the overall preparation can be structured into theoretical preparation and practical preparation , with each category then being subdivided into individual prep and prep with a partner .

As a general rule, the level and intensity of the preparation will differ based on your background - naturally if you have a business background (and have been part of a consulting club or something similar) your preparation will be less intensive than if you’re starting from scratch. The way we suggest you go about it is to start with theoretical preparation , which means learning about case interviews, business and basic consulting concepts (you can do this using free resources - such as the ones we provide - or if you want a more through preparation you can consider joining our Case Academy as well).

You can then move on to the practical preparation which should start with doing solo cases and focusing on areas of improvement, and then move on to preparation with a partner , which should be another candidate or - ideally - an ex-consultant.

Let’s go into more details with respect to each type of preparation.

7.1. Solo practice

The two most important areas of focus in sole preparation are:

• Mental math

As we mentioned briefly, the best use of your time is to focus on solving cases. You can start with cases listed on MBB sites since they are clearly stated and have worked solutions as well (e.g. Bain is a good place to start) and then move to more complex cases (our Case Library also offers a range of cases of different complexities). To build your confidence, start out on easier case questions, work through with the solutions, and don't worry about time. As you get better, you can move on to more difficult cases and try to get through them more quickly. You should practice around eight case studies on your own to build your confidence.

Another important area of practice is your mental mathematics as this skill will considerably increase your confidence and is neglected by many applicants - much to their immediate regret in the case interview. Find our mental math tool here or in our course, and practice at least ten minutes per day, from day one until the day before the interview.

7.2. Preparation with a partner

There are aspects of a case interview - such as asking clarifying questions - which you cannot do alone and this is why, after you feel comfortable, you should move on to practice with another person. There are two options here:

• Practicing with a peer
• Practicing with an ex-consultant

In theory they can be complementary - especially if you’re peer is also preparing for consulting interviews - and each have advantages and disadvantages. A peer is likely to practice with you for free for longer, however you may end up reinforcing some bad habits or unable to get actionable feedback. A consultant will be able to provide you the latter but having their help for the same number of hours as a peer will come at a higher cost. Let’s look at each option in more detail.

7.2.1. Peer preparation

Once you have worked through eight cases solo, you should be ready to simulate the case interview more closely and start working with another person.

Here, many candidates turn to peer practice - that is, doing mock case interviews with friends, classmates or others also applying to consulting. If you’re in university, and especially in business school, there will very likely be a consulting club for you to join and do lots of case practice with. If you don’t have anyone to practice, though, or if you just want to get a bit more volume in with others, our free meeting board lets you find fellow applicants from around the world with whom to practice. We recommend practicing around 10 to 15 ‘live’ cases to really get to a point where you feel comfortable.

7.2.2. Preparation with a consultant

You can do a lot practising by yourself and with peers. However, nothing will bring up your skills so quickly and profoundly as working with a real consultant.

Perhaps think about it like boxing. You can practice drills and work on punch bags all you want, but at some point you need to get into the ring and do some actual sparring if you ever want to be ready to fight.

Practicing with an ex consultant is essentialy a simulation of a case interview. Of course, it isn’t possible to secure the time of experienced top-tier consultants for free. However, when considering whether you should invest to boost your chances of success, it is worth considering the difference in your salary over even just a few years between getting into a top-tier firm versus a second-tier one. In the light of thousands in increased annual earnings (easily accumulating into millions over multiple years), it becomes clear that getting expert interview help really is one of the best investments you can make in your own future.

Should you decide to make this step, MyConsultingCoach can help, offering bespoke mentoring programmes , where you are paired with a 5+ year experienced, ex-MBB mentor of your choosing, who will then oversee your whole case interview preparation from start to finish - giving you your best possible chance of landing a job!

7.3. Practice for online interviews

Standard preparation for interview case studies will carry directly over to online cases.

However, if you want to do some more specific prep, you can work through cases solo to a timer and using a calculator and/or Excel (online cases generally allow calculators and second computers to help you, whilst these are banned in live case interviews).

Older PST-style questions also make great prep, but a particularly good simulation is the self-assessment tests included in our Case Academy course . These multiple choice business questions conducted with a strict time limit are great preparation for the current crop of online cases.

7.4. Fit interviews

As we’ve noted, even something billed as a case interview is very likely to contain a fit interview as a subset.

We have an article on fit interviews and also include a full set of lessons on how to answer fit questions properly as a subset of our comprehensive Case Academy course .

Here though, the important thing to convey is that you take preparing for fit questions every bit as seriously as you do case prep.

Since they sound the same as you might encounter when interviewing for other industries, the temptation is to regard these as “just normal interview questions”.

However, consulting firms take your answers to these questions a good deal more seriously than elsewhere.

This isn’t just for fluffy “corporate culture” reasons. The long hours and close teamwork, as well as the client-facing nature of management consulting, mean that your personality and ability to get on with others is going to be a big part of making you a tolerable and effective co-worker.

If you know you’ll have to spend 14+ hour working days with someone you hire and that your annual bonus depends on them not alienating clients, you better believe you’ll pay attention to their character in interview.

There are also hard-nosed financial reasons for the likes of McKinsey, Bain and BCG to drill down so hard on your answers.

In particular, top consultancies have huge issues with staff retention. The average management consultant only stays with these firms for around two years before they have moved on to a new industry.

In some cases, consultants bail out because they can’t keep up with the arduous consulting lifestyle of long hours and endless travel. In many instances, though, departing consultants are lured away by exit opportunities - such as the well trodden paths towards internal strategy roles, private equity or becoming a start-up founder.

Indeed, many individuals will intentionally use a two year stint in consulting as something like an MBA they are getting paid for - giving them accelerated exposure to the business world and letting them pivot into something new.

Consulting firms want to get a decent return on investment for training new recruits. Thus, they want hires who not only intend to stick with consulting longer-term, but also have a temperament that makes this feasible and an overall career trajectory where it just makes sense for them to stay put.

This should hammer home the point that, if you want to get an offer, you need to be fully prepared to answer fit questions - and to do so excellently - any time you have a case interview.

8. Interview day - what to expect, with tips

Of course, all this theory is well and good, but a lot of readers might be concerned about what exactly to expect in real life . It’s perfectly reasonable to want to get as clear a picture as possible here - we all want to know what we are going up against when we face a new challenge!

Indeed, it is important to think about your interview in more holistic terms, rather than just focusing on small aspects of analysis. Getting everything exactly correct is less important than the overall approach you take to reasoning and how you communicate - and candidates often lose sight of this fact.

In this section, then, we’ll run through the case interview experience from start to finish, directing you to resources with more details where appropriate. As a supplement to this, the following video from Bain is excellent. It portrays an abridged version of a case interview, but is very useful as a guide to what to expect - not just from Bain, but from McKinsey, BCG and any other high-level consulting firm.

8.1. Getting started

Though you might be shown through to the office by a staff member, usually your interviewer will come and collect you from a waiting area. Either way, when you first encounter them, you should greet your interviewer with a warm smile and a handshake (unless they do not offer their hand). Be confident without verging into arrogance. You will be asked to take a seat in the interviewer’s office, where the case interview can then begin.

8.1.1. First impressions

In reality, your assessment begins before you even sit down at your interviewer’s desk. Whether at a conscious level or not, the impression you make within the first few seconds of meeting your interviewer is likely to significantly inform the final hiring decision (again, whether consciously or not).

Your presentation and how you hold yourself and behave are all important . If this seems strange, consider that, if hired, you will be personally responsible for many clients’ impressions of the firm. These things are part of the job! Much of material on the fit interview is useful here, whilst we also cover first impressions and presentation generally in our article on what to wear to interview .

As we have noted above, your interview might start with a fit segment - that is, with the interviewer asking questions about your experiences, your soft skills, and motivation to want to join consulting generally and that firm in particular. In short, the kinds of things a case study can’t tell them about you. We have a fit interview article and course to get you up to speed here.

8.1.2. Down to business

Following an initial conversation, your interviewer will introduce your case study , providing a prompt for the question you have to answer. You will have a pen and paper in front of you and should (neatly) note down the salient pieces of information (keep this up throughout the interview).

It is crucial here that you don’t delve into analysis or calculations straight away . Case prompts can be tricky and easy to misunderstand, especially when you are under pressure. Rather, ask any questions you need to fully understand the case question and then validate that understanding with the interviewer before you kick off any analysis. Better to eliminate mistakes now than experience that sinking feeling of realising you have gotten the whole thing wrong halfway through your case!

This process is covered in our article on identifying the problem and in greater detail in our Case Academy lesson on that subject.

8.1.3. Analysis

Once you understand the problem, you should take a few seconds to set your thoughts in order and draw up an initial structure for how you want to proceed. You might benefit from utilising one or more of our building blocks here to make a strong start. Present this to your interviewer and get their approval before you get into the nuts and bolts of analysis.

We cover the mechanics of how to structure your problem and lead the analysis in our articles here and here and more thoroughly in the MCC Case Academy . What it is important to convey here, though, is that your case interview is supposed to be a conversation rather than a written exam . Your interviewer takes a role closer to a co-worker than an invigilator and you should be conversing with them throughout.

Indeed, how you communicate with your interviewer and explain your rationale is a crucial element of how you will be assessed. Case questions in general, are not posed to see if you can produce the correct answer, but rather to see how you think . Your interviewer wants to see you approach the case in a structured, rational fashion. The only way they are going to know your thought processes, though, is if you tell them!

To demonstrate this point, here is another excellent video from Bain, where candidates are compared.

Note that multiple different answers to each question are considered acceptable and that Bain is primarily concerned with the thought processes of the candidate’s exhibit .

Another reason why communication is absolutely essential to case interview success is the simple reason that you will not have all the facts you need to complete your analysis at the outset. Rather, you will usually have to ask the interviewer for additional data throughout the case to allow you to proceed .

NB: Don't be let down by your math!

Your ability to quickly and accurately interpret these charts and other figures under pressure is one of the skills that is being assessed. You will also need to make any calculations with the same speed and accuracy (without a calculator!). As such, be sure that you are up to speed on your consulting math .

8.1.4. Recommendation

Finally, you will be asked to present a recommendation. This should be delivered in a brief, top-down "elevator pitch" format , as if you are speaking to a time-pressured CEO. Again here, how you communicate will be just as important as the details of what you say, and you should aim to speak clearly and with confidence.

For more detail on how to give the perfect recommendation, take a look at our articles on the Pyramid Principle and providing recommendations , as well the relevant lesson within MCC Academy .

8.1.5. Wrapping up

After your case is complete, there might be a few more fit questions - including a chance for you to ask some questions of the interviewer . This is your opportunity to make a good parting impression.

We deal with the details in our fit interview resources. However, it is always worth bearing in mind just how many candidates your interviewers are going to see giving similar answers to the same questions in the same office. A pretty obvious pre-requisite to being considered for a job is that your interviewer remembers you in the first place. Whilst you shouldn't do something stupid just to be noticed, asking interesting parting questions is a good way to be remembered.

Now, with the interview wrapped up, it’s time to shake hands, thank the interviewer for their time and leave the room .

You might have other case interviews or tests that day or you might be heading home. Either way, if know that you did all you could to prepare, you can leave content in the knowledge that you have the best possible chance of receiving an email with a job offer. This is our mission at MCC - to provide all the resources you need to realise your full potential and land your dream consulting job!

8.2. Remote and one-way interview tips

Zoom case interviews and “one-way” automated fit interviews are becoming more common as selection processes are increasingly remote, with these new formats being accompanied by their own unique challenges.

Obviously you won’t have to worry about lobbies and shaking hands for a video interview. However, a lot remains the same. You still need to do the same prep in terms of getting good at case cracking and expressing your fit answers. The specific considerations around remote case interviews are, in effect, around making sure you come across as effectively as you would in person.

8.2.1. Connection

It sounds trivial, but a successful video case interview of any kind presupposes a functioning computer with a stable and sufficient internet connection.

Absolutely don’t forget to have your laptop plugged in, as your battery will definitely let you down mid-interview. Similarly, make sure any housemates or family know not to use the microwave, vacuum cleaner or anything else that makes wifi cut out (or makes a lot of noise, obviously)

If you have to connect on a platform you don’t use much (for example, if it’s on Teams and you’re used to Zoom), make sure you have the up to date version of the app in advance, rather than having to wait for an obligatory download and end up late to join. Whilst you’re at it, make sure you’re familiar with the controls etc. At the risk of being made fun of, don’t be afraid to have a practice call with a friend.

8.2.2. Dress

You might get guidance on a slightly more relaxed dress code for a Zoom interview. However, if in doubt, dress as you would for the real thing (see our article here ).

Either way, always remember that presentation is part of what you are being assessed on - the firm needs to know you can be presentable for clients. Taking this stuff seriously also shows respect for your interviewer and their time in interviewing you.

8.2.3. Lighting

An aspect of presentation that you have to devote some thought to for a Zoom case interview is your lighting.

Hopefully, you long ago nailed a lighting set-up during the Covid lockdowns. However, make sure to check your lighting in advance with your webcam - bearing in mind what time if day your case interview actually is. If your case interview is late afternoon, don’t just check in the morning. Make sure you aren’t going to be blinded from light coming in a window behind your screen, or that you end up with the weird shadow stripes from blinds all over your face.

Natural light is always best, but if there won’t be much of that during your interview, you’ll likely want to experiment with moving some lamps around.

8.2.4. Clarity

The actual stories you tell in an automated “one-way” fit interview will be the same as for a live equivalent. If anything, things should be easier, as you can rattle off a practised monologue without an interviewer interrupting you to ask for clarifications.

You can probably also assume that the algorithm assessing your performance is sufficiently capable that it will be observing you at much the same level as a human interviewer. However, it is probably still worth speaking as clearly as possible with these kinds of interviews and paying extra attention to your lighting to ensure that your face is clearly visible.

No doubt the AIs scoring these interviews are improving all the time, but you still want to make their job as easy as possible. Just think about the same things as you would with a live Zoom case interview, but more so.

9. How we can help

There are lots of great free resources on this site to get you started with preparation, from all our articles on case solving and consulting skills to our free case library and peer practice meeting board .

To step your preparation up a notch, though, our Case Academy course will give you everything you need to know to solve the most complex of cases - whether those are in live case interviews, with chatbots, written tests or any other format.

Whatever kind of case you end up facing, nothing will bring up your skillset faster than the kind of acute, actionable feedback you can get from a mock case interview a real, MBB consultant. Whilst it's possible to get by without this kind of coaching, it does tend to be the biggest single difference maker for successful candidates.

You can find out more on our coaching page:

Explore Coaching

Of course, for those looking for a truly comprehensive programme, with a 5+ year experienced MBB consultant overseeing their entire prep personally, from networking and applications right through to your offer, we have our mentoring programmes.

You can read more here:

Comprehensive Mentoring

Account not confirmed

Download Chapter

You will receive additional complimentary videos/ updates by email. To complete the process please click the link in the email we will send you.

Download Preview

Welcome back!

Or, sign in with your email

Don’t have an account? Subscribe now

Download The Strategy Journal

Business case analysis in a consulting study.

Recent clients’ feedback indicates that most people do not know what the point of a study is, or what is the most important output to a client. Well, the point of any study in management consulting – whether it is a strategy, pricing, organizational optimization, salesforce effectiveness, operations or implementation study – is to ultimately present a business case analysis to the client.

https://youtu.be/gzh4n5z0tjM

Different but similar

It is true that all these reports are different in their content; contents types like analysis and recommendations are starkly different in each of these study types. However, all studies share the same underlying analytical process around top-down, bottom-up, and hypothesis, etc. It doesn’t matter what type of study being carried out, the ultimate output to the client is a business case analysis, or what we in consulting also call the benefit case (the latter makes it clearer to anyone that you are presenting to the client the benefits of your recommendation).

This article shows you the general steps you need to follow to generate business case analysis a client can effectively use.

The Importance of Business Case Analysis

The business case analysis, or of the benefit case analysis as its name implies, simply helps the client understand the overall benefit(s) of the recommended option and the steps to take to realize the stated benefit(s). If you are not presenting a business case, you are making it very difficult for the client to make the decision to implement the recommendations you are providing.

Steps to take when preparing Business Case Analysis

The figure below explains in clear terms what business case analysis is and should contain. Borrowed from the second edition of the book “Succeeding as a Management Consultant,” this slide presents the right way you should depict the business case analysis in every study.

Business Case Analysis  Step 1: Understand the Financial Levers

The first step is to understand the financial levers. Ask yourself, what drives profits for the client’s business? This depends on the company. By and large, you are ultimately looking at the Return on Invested Capital, the major driver of shareholder value creation. That said, you can prioritize profit or any other metric that is important to your client. In the end, the question of what levers to pull is important.

In a simple manner of speaking, the levers of profit are revenue and cost (Revenue – Cost). The levers for revenue could be revenue from product line 1, 2, 3, and so on. A step further will show that the lever for revenue of product line 1 would be price and volume (price x volume). You continue this process until you have exhausted all major drivers of the problem.

Business Case Analysis  Step 2: Focus Effort(s) at the Point of Greatest Leverage

The next step would be to focus your effort(s) at the point of greatest leverage. To do that, you will need to deploy the right set of analyses that answers the following question. Which of these levers do we need to pull in order to fulfill the following: one, solve the problem; two, generate the maximum benefit; and three, the easiest to do. These three conditions are important.

Business Case Analysis  Step 3: Understand the Impact of Identified Benefits on Client’s Financials

Once you have prioritized those levels, you then have calculated the effort it takes (in terms of cost and time); deduct it from the prior benefits to get the net benefit to pull these levers. You have to repeat this for all the other levers you have identified (if you have identified more than 1).

Business Case Analysis  Step 4: Categorize the Identified Benefits 

The fourth step is categorization. You categorize the net benefit of pulling one lever into 1 of 7 groups. In this article, we are first going to focus on the first five, and later discuss the last two. The last two are equally valuable if you can use them. But for now, the first five (5) broad buckets any net benefit can be placed in include the following:

• Revenue enhancement
• Cost reduction
• Cost avoidance
• Capital reduction
• Capital avoidance

As an example, if you pull a lever to increase the price, you are ultimately going to increase revenue (provided a relative change in cost is smaller than the change in revenue). The resulting business case analysis (benefit case) from such activity would be a “revenue enhancement case.”

Let’s assume, again, on a client’s engagement, you identified 17 levers that you could possibly pull. The next step would be to work out the type of net benefit you can get from each of these 17 things and then categorize it into one of the above-listed categories.

The two other categories of “the seven” are

• Risk avoidance
• Risk reduction

I will not delve into details on the two last buckets as risk calculation requires a special article of its own. Subscribers who follow the “ Partnership ” and “ Rebuilding a Consulting Practice ” series know that I built my consulting career on strategy risk analysis as I was known for finding creative ways for the executive to think about risk in their business. I certainly have a lot to say about how management consultants should think through risk.

Business Case Analysis  Step 5: Identify Corresponding Investment

That said, once all your net benefits are categorized in 1 of the 5 buckets (revenue enhancement; cost reduction, and avoidance; capital reduction and avoidance), you need to identify two things. These things are one, the investments the company needs to make to achieve those net benefits; two, the time it would take for such cost incurred (for the client to generate the benefit) to pay itself off.

Business Case Analysis  Step 6: Model the Impact of Each Benefit and accompanying Investment on Client’s Financial Metric(s)

To make this clear to the client, your next step would be to model the net impact of each of the benefits and its accompanying investment (cost) on the client’s Profit and Loss Statement, Balance Sheet, Cash Flows; if needed, Payback Period, Internal Rate Of Return (IRR) and Breakeven Analysis.

If you present that to a client at the end of any study you give them three valuable things. One, the reason to go ahead and implement. Two, the blueprint for knowing what the potential size of the benefits of each recommendation (which you can categorize even further into high, medium and low range benefits). And three, the levers they need to attack to do this.

Levers: a Power Tool

Think of levels as power. When you are telling a CEO that all the levers their business could pull lies in the division managed by a very problematic division head that doesn’t see eye-to-eye with the CEO, you are basically outlining, to the CEO, the scope of the challenges to implementing the recommendation. And this is very useful to the CEO or an executive because they can then say to themselves, “You know what, the benefits are there but we need to make some organizational changes if we are going to realize such benefits… And we have been having trouble with this executive, he hasn’t been easy to work with, he pushes back amongst many things. If the future of the company truly depends on us changing that division, we can’t let this person just do what they want forever. We’ve got to make some changes.”

That is the usefulness of this process to the client. It is not just about the numbers. It is about understanding where the benefits lie, who is responsible for them, how easy are they to work with, and what changes are needed for the client to realize those benefits.

So at the end of every study, this is what you need to present to the client, business case analysis (benefit case) as detailed above. It is the easiest, but least done thing. Having seen many studies from boutique consulting rival firms, I realize that while most do create a business case (benefit case), a large number of them are not consistent. The benefits are either spurious, or not clearly articulated. The document is difficult to understand, or it makes no effort to break down issues into levers. And in all of the cases, there aren’t even any benefits.

Take for instance a management consulting study that says “the benefit is that we will change the organization.” Yes, we know that. The question is why is the change necessary? What are the values the client stands to gain from such change? Poorly done business case analysis (benefit cases) are even more glaring in organizational design studies. This is because, more often than not, many executives and consultants just think, “Well, it is a soft issue. There is no point putting some numbers to it.” But, of course, you can put numbers to it. Sentiment dictates share price on a daily basis. How come there is a number to that? There isn’t a lot of science to how the numbers are reached but it is there and commands respect. There are equal numbers to put business case analysis (benefit case) together, irrespective of the type of study.

I hope you enjoyed it as much as I enjoyed doing the episode. Finally, I want you to remember that the only way to get access to our special offers, special pricing, and to get samples of our content is to join the list on firmsconsulting.com/promo . It’s the only way also to get access to our unique advanced content that we make available to FC Insiders (our most loyal members). So if you want to get a sneak-peek of things, test it out, see what’s in there, this is the place to go.

If you want to see samples of our advanced training materials go to  FIRMSconsulting.com/promo  and sign up for free to receive sample materials.

Recommended books:

When people think about the business strategy we often think about the field of strategy consulting/management consulting and firms like McKinsey, BCG, et al. If you are interested in learning how to conduct a management consulting engagement, you will likely enjoy this book.  Succeeding as a Management Consultant  is a book set in the Brazilian interior. This book follows an engagement team as they assist Goldy, a large Brazilian gold miner, in diagnosing and fixing deep and persistent organizational issues. This book follows an engagement team over an 8-week assignment and explains how they successfully navigate a challenging client environment, develop hypotheses, build the analyses, and provide the final recommendations. It is written so the reader may understand, follow, and replicate the process. It is the only book laying out a consulting assignment step-by-step. A great book if you want to learn consulting skills, including how to put together effective business case analysis.

Bill Matassoni’s (Ex-McKinsey and Ex-BCG Senior Partner)   Marketing Saves The World  is a truly unique book. Never before has a McKinsey partner published his memoir publicly. This book is a rare opportunity – a true exclusive – to see what shapes the thought process of a partner and learn about marketing and strategy. The memoir essentially lays out McKinsey’s competitive advantage and explains how it can be neutralized. A great book if you want to enhance your presentation skills and communication skills. If you are interested in learning how to put together effective business case analysis and in general if you are interested in management consulting you will enjoy this book.

Turquoise Eyes started off the groundbreaking new genre developed by FIRMSconsulting that combines compelling narrative while teaching problem solving and critical thinking skills. Set after a bank begins implementing a new retail banking strategy, we follow Teresa García Ramírez de Arroyo, a director-general in the Mexican government, who has received some disturbing news. A whistleblower has emailed Teresa with troubling news about a mistake in the loan default calculations and reserve ratios. The numbers do not add up. The book loosely uses the logic and financial analyses in  A Typical McKinsey Engagement , >270 videos.

WHAT IS NEXT? We hope you enjoyed the above article Business Case Analysis in a Consulting Study. If you would like to get more training resources sign up for our email updates on  FIRMSconsulting.com/promo . This way you will not miss exclusive free training episodes and updates which we only share with the Firmsconsulting community. And if you have any questions about our membership training programs (StrategyTV.com/Apps & StrategyTraining.com/Apps) do not hesitate to reach out to us at support @ firmsconsulting.com. You can also get access to selected episodes when you sign-up for our newsletter above. Continue developing your  strategy skills .

Cheers,  Kris

PODCASTS:   If you enjoy our podcasts, we will appreciate if you visit our  Case Interviews  podcast or  Strategy Skills  podcast on iTunes and leave a quick review. It helps more people find us.

COME HANG OUT WITH US:  Youtube  /  Facebook  /  Twitter  /  LinkedIn  /  Instagram

ENGAGE ON FC FACEBOOK AND LINKEDIN GROUPS:  Strategy Skills (FB)  /  Case Interviews (FB) /  Strategy Skills (LinkedIn)  /  Consulting Case Interviews (LinkedIn)

WANT TO LEARN FROM FORMER STRATEGY PARTNERS? BECOME A  PREMIUM MEMBER

Some links above are affiliate links. As an Amazon Associate we earn from qualifying purchases.

Want to learn more about how FIRMSconsulting can help your organization?

Related articles, uncategorized, the problem with following role models.

People say, “Success leaves clues.” The advice you often hear is find someone who achieved something you want to achieve, watch them carefully, repeat their steps, and you will achieve success too. It is useful, but to a point. There is one big problem with this approach. Each of us has a…

Senior McKinsey partner on the most important skill you should develop

Senior McKinsey partner on the most important skill you should develop We trained our AI system on our proprietary information. It’s like having access to our brains 24/7. That said, you might still run into challenges. Maybe you ask a question and don’t get the response you want. This is…

Career Stagnation. When Promotions End and the Runway Ends

In the final piece for Strategy Insights, called “When Promotions End and the Runway Ends,” I'm going to talk through an interesting client situation. We have an Insider, who later also became a coaching client, named Addie. He works for a large multinational company. There's nothing unusual about his career. He…

Sign up for emails

Never miss an insight. We'll email you when new articles are published on this topic.

All content remains the property of FIRMSconsulting LLC. When using material from this website, including but not limited to tools, frameworks, concepts and methodologies, please provide the proper citations and attributions.

Have you downloaded our free guides?

Case interview resume template used in The Consulting Offer . Offers from McKinsey, BCG, Bain et al.

Overall approach used in well-managed strategy studies PDF guide

8 Excel Consulting Services to Use in 2024 + VBA Support

Free Excel Resources

1. surveyking consulting, 2. excel complete, 3. automate excel.

• 4. Joshua Wilson

5. The Excel Experts

6. excelhelp.

• 7. Excel & Access

8. Excel4Business

• Reasons to Hire
• VBA Project Types
• Employee Feedback
• Creating the Survey
• Identity Protection
• Research Tools

Need help on an Excel Project or VBA development?

These 8 Excel consulting services offer support, training, and VBA development to troubleshoot issues, solve business problems, and increase efficiency using Microsoft Excel.

What does an Excel consultant do? An Excel consultant will improve your workbooks using advanced formulas, conditional formatting, chart creation, and VBA. A good Excel consultant should be well-versed in general data science, enabling source data to be organized using SQL or another language. This will ensure the flow of information in your workbooks is maintainable.

Below is a quick summary of each of these 8 Excel consulting companies. A detailed review and ranking for each company is also included.

Skills an Excel Consultant Should Have

Often a business project that requires an Excel consultation will have data flowing into Excel or from Excel to another platform. Understanding what technical skills a company should offer will help your organization choose the correct consultant.

VBA/Macro Development

A macro is a command that can be run to automate tasks. Macros are coded in VBA. VBA ( Visual Basic for Applications ) was Development by Microsoft and is the programming langue used to extend Office programs and automate repetitive tasks.

Nearly every consultant should be fluent in VBA. Utilizing VBA opens up the door for custom Excel formulas, automated emails , creating dynamic files, and uploading/exporting data. Later in this article, we give more detailed examples of how VBA can be used.

When it comes to managing large amounts of data, a relational database is crucial. A relational database uses  SQL to access, collect, and analyze all of the data inside the database.

Suppose an Excel consultant possesses strong SQL knowledge. In that case, you can create better source data files (with the use of view and stored procedures), link up SQL to Excel, or even inform you that an Excel solution is not ideal and help you implement a database-driven solution.

SharePoint is commonly used to distribute and share files across an organization. Many projects that require file uploads or downloads from SharePoint can be fully automated using VBA.

A good consultant will also be able to help create dynamic folders and dynamic permissions for these folders inside of the document library.

General Programming

Depending on the project, you may need VBA code to access an external API, send files over  FTP , or even create custom HTML emails.

VBA code can be condensed when the developer is well versed in other programming languages. For example taking advantage of arrays over Excel ranges will save computation time.

Business Tools

Organizations worldwide use ERP systems like SAP and data visualization tools like Tableau . Excel consulting services that are familiar with these tools can increase the scope of the project, reducing the need for additional consultants.

Before using a consulting company, you might want to check out some of the online resources available for free. These resources offer Excel demos, sample formulas, VBA code, and training programs. The forums contain common business-related Excel questions.

• MrExcel  – The largest online help forum for Excel. Very organized layout and many of the threads contain sample code and workbooks. They also have list of consultants that may be able to help with your project.
• OzGrid  – Another online help forum. They have paid help section where you can post a question and then hire someone that could come up with a solution.
• Exceljet  – The largest online resource for Excel help topics. Tons of sample formulas and functions. They offer training books for a cost. Their help resources lack any VBA code.

Our Rating:

Being one the most popular online survey tools, SurveyKing has the unique ability to offer Excel consulting services and assistance on any business-related IT tasks.

SurveyKing has a staff with a wide variety of skills, including VBA, SQL, and app development. Completed projects include pricing analysis, budgets, forecasts, market research, and operational metrics. In addition, many projects have included automated uploads to SharePoint.

SurveyKing consulting is based in Detroit, Michigan but services clients worldwide. A unique offering of SurveyKing is in-person Excel consulting and training. Generally, large accounting projects are more manageable in the office as the consultant can walk through processes alongside current staff.

SurveyKing Consulting Key Points

• Transparent pricing – $50 an hour.
• Wide range of technical skills. VBA + Business tools like SAP.
• SharePoint development.
• The resources of a large tech company to help solve complex business problems.

Excel Complete  is a versatile Excel consulting company. They provide additional programming services, are very transparent about their pricing, and offer on-demand support for simple Excel troubleshooting.

Their website has a dedicated  VBA development  and consulting section and a help document section with code and formula examples. They have licensed professionals such as CPAs to help streamline business functions like budgets and forecasts.

Excel Complete Key Points

• Simple pricing – $50 an hour for projects.
• Schedule a Zoom project consultation at your convenience.
• VBA development, website building, SQL, and statistical consulting.
• SharePoint development services + VBA (save and read files).
• Employs business professionals like CPAs.

Automate Excel has very transparent pricing and a simple way to submit your documents to request a quote. This service also has a list of functions and code examples to help get you started.

One of the coolest features of Automate Excel is a custom plugin they created to help your write VBA code, called AutoMacro . This makes learning a few advanced VBA concepts easy.

Automate Excel Key Points

• Simple, transparent pricing. $97 for smaller projects that take an hour. $71 an hour for larger-scale projects.
• Sample VBA code and online resources to get you started.
• A fantastic tool to help you write your own VBA code.

4. Joshua Wilson Consulting

Joshua Wilson Consulting focuses on finance and accounting-related projects. Process improvement and workflow automation are the most significant selling points.

While the rates at $200 may be a little higher than other firms, the apparent quality of the work, and a focus on how the data can improve your business is worth a discussion.

Joshua Wilson Consulting Key Points

• Accounting and finance focused.
• Can help export data from QuickBooks to Excel.
• Offers services such as an on-call/temporary financial analyst.
• Phone number listed on the website.

The Excel Experts  offers general consulting services and VBA development. They also offer Power BI solutions. The Excel Experts is a service that sees the value in eliminating repetitive tasks. This firm also mentions the use of SQL.

The Excel Experts are based in the UK, so there may be a slight time zone difference for US clients.

The Excel Experts Key Points

• Pricing is not listed on the website.
• Their contact form offers no ability to attach a file. This can increase the amount of communication before starting the engagement.
• Additional services like Power BI and SQL.

ExcelHelp  offers a lot of Excel services, including VBA consulting. ExcelHelp has many examples and case studies on its website, which is a great resource. In addition, their home page has a phone number, making it easy to talk to someone for immediate help.

One of the biggest selling features is in-person or remote  training . This training could be ideal for large-scale VBA projects requiring multiple employees to share/use a central file.

ExcelHelp Key Points

• No pricing is listed on their website.
• Phone support.
• In-person or remote Excel training.
• Lots of case studies on their website are organized by industry or job type.
• They offer additional services like database implementation and SQL support.

7. Excel & Access

Excel & Access  is a company that focuses on Excel Troubleshooting, VBA development, and database development. They also offer Access and Azure support, which are staples in an organization that uses Microsoft products exclusively.

Excel & Access has a solid track record of reviews on Google. While rates for their services are not listed on their website, many reviews mention an affordable cost.

Excel & Access Key Points

• They appear to have reasonable rates based on reviews.
• Offers Excel and VBA consulting.
• Database consulting, including SQL Server, Access, Azure.
• Office locations in the US, Canada, and the UK.

Excel4Business  has a simple website but offers Excel support on demand. Their website doesn’t list specific prices but mentions offering fixed prices per job, which can prevent consulting fees from piling up from billed hours.

Excel4Business also has a  YouTube channel  that can help you understand the basics of Excel. This content is an excellent starting point before deciding to hire a consultant.

Excel4Business Key Points

• Phone number and email listed on their website.
• They appear to have reasonable consulting rates.
• On-demand support even for smaller jobs.
• YouTube channel with lots of content to learn Excel.

Reasons to Hire an Excel Consultant

Each project is unique, but consider these points when deciding what Excel consulting company to use. Here are some of the most important reasons to hire an Excel consultant.

A Fresh Perspective

After staring at an Excel workbook for a long time, the answer to even a simple problem may seem impossible. However, a consultant with a fresh perspective can step in and troubleshoot the issue better. In addition, they will have tricks to simplify formulas and simplify the flow of data in your workbook.

Depending on the job, an  Excel solution might not be efficient . A good consultant can recommend to your company how to improve the overall process. Process improvements could include setting up servers with a database or building online forms.

Increased Efficiency

Many times Excel projects can become unnecessarily complex. This can be because of duplicate data, inefficient formulas, or poor formatting. A consultant that can create custom formulas in VBA, simplify the flow of information, and take advantage of conditional formatting can quickly streamline an Excel Workbook.

Reduce Errors

When an Excel workbook is poorly created, the end result can be error-prone. This can be from bad source data, incorrect formats, or sloppy formulas.

For example, a workbook might use  SUMPRODUCT  to summarize sales by month and rep. However, if the source data contains text instead of numbers, the formula could return an #VALUE error. A good consultant can quickly spot this and either adjust the formula to ignore text or create a VBA solution to sanitize all source data before it is imported.

Excel VBA Project Types

To help guide your project, here are some tasks that can be better automated with VBA. Once you choose your VBA consultant, see if you can incorporate these tasks into the project scope; this will help to streamline your process further.

Automated emails

Send a notification  email  once a process completes. You can even attach a file or a SharePoint link.

Upload files to SharePoint

Perfect for budget planning or payroll reports. The templates can be populated from a SQL or BI report to give the accountant an idea of where prior year expenses were.

Read files from SharePoint

Once the data is an array, it can be easily manipulated. For example, read all employee payroll rates in a file, loop over a set of locations, and send a payroll summary to each location with only those employees.

Convert a CSV file to an array

Once the data is an array it can be easily manipulated. For example read all employee payroll rates in file, loop over a set of locations, send a payroll summary to each location with only that locations employees.

Create custom formulas

Instead of writing hard-to-read native Excel formuals, such as many  nested IFs , custom VBA formulas can be created. This formula would take a few input cells and lay out the logic more carefully, allowing fewer errors and easier maintenance.

ABOUT THE AUTOR

Allen is the founder of SurveyKing. A former CPA and government auditor, he understands how important quality data is in decision making. He continues to help SurveyKing accomplish their main goal: providing organizations around the world with low-cost high-quality feedback tools.

Ready To Start?

Create your own survey now. Get started for free and collect actionable data.

10 Great SurveyMonkey Alternatives to Use in 2024

Discover alternatives to the most popular online survey tool, SurveyMonkey. Gain an understanding of where SurveyMonkey lacks in features and get intr...

10 Survey Tools for Academic Research in 2024

These nine survey tools are perfect for academic research because they offer unique question types, solid reporting options, and support staff to help...

8 Best Strategies of Survey Promotion to Increase Response Rates

Survey promotion is the process of spreading surveys through different channels to encourage more responses and participation. It involves placing the...

Business Process Improvement Consulting: Expert Solutions

Definition: A business process improvement consultant will help design and implement strategies to increase the efficiency of workflows across your o...

7 Great Qualtrics Alternatives to Use in 2024

These seven alternatives to Qualtrics offer either more features, a lower cost, or a cleaner user interface. These alternative platforms also include ...

Union Negotiation Consulting: Planning Labor Agreements

A labor union negotiation consulting engagement involves quantifying member needs, proposing contract language, and developing communication strategie...

Creating a Transactional Survey: Examples + Template

Definition: A transactional survey captures customer feedback after a specific interaction, referred to as a touchpoint. This survey type provides dir...

Hire an Excel Expert: Automation + VBA Development

An Excel expert will help you to complete your projects within Microsoft Excel. A good Excel expert should be proficient in advanced formulas such as ...

Creating an Anonymous Employee Survey + Template, Sample Questions

Definition: An anonymous employee survey is a convenient way to collect honest feedback in the workplace. The survey can either measure employee satis...

Improving Fleet Performance Through Driver Feedback Surveys

In the US, the trucking industry generated $875.5 billion in gross freight revenues, accounting for 80.8% of the country’s freight invoice in 20...

13 College Study Tips to Use in 2023

These 15 college study tips will help you succeed in your academic career.

Maximizing the Value of Skills Assessment Tools Using Surveys

When you apply for a job, it’s only natural that you’ll aim to present the best possible version of yourself. You’ll focus on your best skills a...

Creating UX Surveys: 6 Tips and Examples

UX surveys are used to help create a great user experience. A good UX survey will incorporate a variety of question types to help understand what user...

5 Web Consultants to Use in 2023: Design + Development

Definition: A web consultant can update an existing website design, create a custom website, help increase traffic, recommend layout changes, and even...

Creating a Targeted Survey: Panels to Reach Your Audience

Definition: A targeted survey is used to research a specific audience, frequently utilizing a survey panel provider. A paneling service generally has ...

8 Typeform Alternatives to Use in 2023

These seven alternatives to Typeform offer a lower cost or additional features. In addition, these alternative platforms include question types that T...

7 Ecommerce Skills For Professionals + Students

Ecommerce has occupied its leading niche in the world, allowing us to draw certain conclusions. For example, it is not surprising that more specialize...

Ecommerce Analytics Explained + Tools to Use

Definition: Ecommerce analytics is the practice of continuously monitoring your business performance by gathering and examining data that affects your...

Planning a Survey: 6 Step Guide + Best Practices

Planning a survey involves six steps: Set objectives, define the target audience, select the distribution method, organize external data, draft the su...

4 Survey Consulting Services to Use in 2023

Definition: These 4 survey consulting services offer planning, design, development, and support to help complete your survey project. Whether it’s f...

Excel Automation Explained: VBA Code + Sample Workbooks

Definition: Excel automation will streamline repetitive tasks such as updating data, formatting cells, sending emails, and even uploading files to Sha...

Hire a Financial Modeling Consultant: Forecasts + Valuations

Definition: A financial modeling consultant will provide expertise in planning budgets, generating forecasts, creating valuations, and providing equit...

Excel Programming Services: Development, Macros, VBA

Definition: An excel programmer can be hired to organize workbooks, create custom formulas, automate repetitive tasks using VBA, and can consult on h...

Market Research Surveys: Sample Questions + Template

Definition: Market research surveys are a tool used to collect information about a target market. These surveys allow businesses to understand market ...

What do Americans Value Most in the Coming Election? A Comprehensive and Interactive 2020 Voter Poll

SurveyKing set out on a mission in the fall of 2020, to poll American's and help identify, with quantifiable data, what issues american are most focus...

Get Started Now

We have you covered on anything from customer surveys, employee surveys, to market research. Get started and create your first survey for free.

Case Competition: The Ultimate Guide on How to Excel

• Last Updated December, 2023

A case competition provides an exciting way for aspiring consultants to hone their problem-solving and presentation skills. If you’re drawn to the consulting world, you likely have a competitive spirit that thrives on challenges.

You’ll get the opportunity to tackle real business problems and present your solutions before judges, who are usually seasoned consultants.

In this article, we’ll discuss:

• What is a case competition (with examples of what you’ll do)
• How competing in consulting case competitions helps your resume and recruiting
• 5 tips on acing the business case competition and maximizing the opportunity
• A list of top case competitions to keep on your radar

Let’s get started!

What Is a Case Competition?

A case competition is an immersive learning experience that challenges students to solve complex business problems within a simulated consulting environment. 

In these competitions, participants work in teams to solve a hypothetical client problem and recommend a solution to a panel of judges.

A case competition tests your analytical thinking, teamwork, problem-solving, and presentation skills.

Examples of Cases and Topics

Case competitions can cover various business functions, such as marketing, strategy, operations, or a combination. You also won’t know what industry the case involves until the competition starts. It’s very similar to what you might experience in a consulting interview!

Case competition examples:

• BankCo aims to boost its market share among customers under 25. What recommendations would you propose to achieve this goal?
• TechCo is venturing into a new geographic market and seeks guidance on an effective market entry strategy to ensure a successful expansion. What approach would you recommend?
• EngineCo, an automobile manufacturer, is grappling with inefficient production processes. How would you optimize operations and foster innovation within the company?

If the case questions seem daunting, fear not! You’ll be provided with lots of data, including historical information, cost details, and other relevant considerations.

However, only some of the data provided will be useful or relevant to your recommendation. As a consultant, part of your skillset involves discerning which information is crucial to your analysis.

These cases simulate real-life consulting projects, so it’s a great chance to apply your skills and see if you like consulting!

Nail the case & fit interview with strategies from former MBB Interviewers that have helped 89.6% of our clients pass the case interview.

Typical Format of a Case Competition

In a case competition, participants are either assigned or choose to be part of a team of 4 to 6 students, mirroring a real consulting team. 

Each team is provided with identical information and allotted the same timeframe to analyze the data, develop recommendations, and present them to a panel of judges. A case competition usually takes place over a few days to allow for analysis and presentation preparation time.  

Let’s take a look at the typical schedule:

• Read Case Information : Teams receive a comprehensive case brief that presents the problem, client information, and pertinent data or information.
• Analyze Data and Options : Teams dive into the case, meticulously analyzing the provided data, extracting insights, and carefully evaluating different options for their recommendation. In most competitions, you can use publicly available information for research.
• Prepare Recommendation and Presentation : Teams consolidate their analysis and make an informed decision on the recommendation. They craft a compelling presentation, typically in slide format, showcasing the results of their analysis and their final recommendation.
• Present to Judges and Answer Q&A : Teams present their solutions to a panel of judges comprising industry professionals and experienced consultants. During the presentation, teams articulate their analysis, demonstrate their problem-solving approach, and emphasize the potential impact of their recommendations. Following the presentation, judges engage in a Q&A session, probing deeper into the team’s analysis and challenging their recommendation.
• Get Feedback and Results : Judges assess each team based on criteria such as the clarity of their problem-solving approach, the feasibility of their recommendations, and the effectiveness of their presentation.

Benefits of Participating in a Consulting Case Competition

Participating in a consulting case competition offers numerous advantages:

• Skill Development : From analyzing real client situations under time pressure to developing innovative solutions, you gain hands-on experience that sharpens your problem-solving abilities, data analysis skills, strategic thinking, teamwork, and communication. It’s a realistic glimpse of what a “day in the life” as a consultant is like.
• Valuable Feedback and Insights : While winning is rewarding, the feedback received provides invaluable insights and suggestions for improvement, enabling you to improve your skills and knowledge. 
• Prizes and Recognition : Many case competitions offer attractive prizes and recognition for outstanding performance. This can include monetary rewards or prize packages.
• Networking Opportunities : You have the chance to network with judges who are current consultants. They often are the ones involved in recruiting and interviews. Even if you don’t win the competition, you have a chance to impress judges, and it could lead to mentorship opportunities or potential internship opportunities.
• Resume Enhancement : Include any awards from case competitions on your resume. It is concrete evidence of your skills and can help your resume stand out.

5 Tips on Acing a Case Competition and Maximizing the Opportunity

1. review key consulting frameworks and concepts.

Take the time to review and understand essential consulting frameworks and structures, such as MECE (Mutually Exclusive, Collectively Exhaustive) and the Hypothesis-Driven Approach .

This will give you a strong foundation for analyzing case problems and developing practical solutions. Utilize resources like our Our Ultimate Guide to Case Interview Prep .

2. Establish Clear Roles and Responsibilities with Your Team

You are under a time crunch in a case competition, so aligning with your team on individual roles and responsibilities before you start the analysis will help you work efficiently.

Consider each team member’s strengths or developmental interests, and delegate tasks accordingly. For example, if you want to improve your proficiency in Excel, communicate your interest in doing analytical aspects. You can create a more efficient and cohesive team by working together and leveraging each other’s talents.

3. Avoid Memorizing Your Presentation

Memorizing your presentation word-for-word or reading the slides will make your presentation come off as less natural. You’ll appear less confident in what you are recommending.

Instead, focus on understanding the key points, logical flow, and supporting evidence. This approach allows flexibility, adaptability, and a more natural delivery during the presentation.

4. Prepare for Potential Questions

Allocate time to anticipate questions that judges may ask during the Q&A session. Consider different angles, alternative perspectives, and potential challenges to your recommendations. Being well-prepared for possible questions demonstrates your critical thinking skills, enhances confidence, and helps you respond effectively.

5. Leave a Lasting Impression on Judges

Make a positive impression on the judges and attendees of the consulting case competition. You never know who you might encounter again in your consulting journey. 

Consider sending a thoughtful thank-you note to the judges after the competition to express your gratitude for their feedback.

List of Case Competitions

Below, we have compiled a list of case competitions to keep on your radar and consider competing in. It’s important to note that this is not an exhaustive list, and competitions may vary yearly, so we recommend checking their official websites.

If you are in school, your consulting clubs will often host case competitions internally. Sometimes, firms also sponsor and run case competitions for specific communities.

Case Competitions in the USA

• ASCM Case Competition
• Collegiate Ethics Case Competition
• Danaher Case Competition
• David Eccles School of Business Case Competition
• Deloitte Consulting National Undergraduate Case Competition
• E-PARCC Teaching Case and Simulation Competition
• Global Case Competition at Harvard
• Heavener International Case Competition
• IACBE Case Competition
• KeyBank Case Competition
• Marshall International Case Competition
• Net Impact Case Competition
• NU-CUIBE International Business Case Competition
• Page Student Case Study Competition
• Penn Healthcare Case Competition
• Penn, Yale, Princeton, Columbia Case Competition
• Prism Consulting Group Case Competitions
• PRMIA Risk Management Challenge
• San Diego State University
• Student Big Data Case Competition
• The Katz Invitational
• The NASBITE International Student Case Competition
• The Schlesinger Global Family Enterprise Case Competition
• The University of California Press’ Case Studies in the Environment Prize Competition
• UConn International Business Case Challenge
• Yale Healthcare Case Competition
• Yale Graduate Consulting Club Case Competition

Case Competitions in Canada

• CFI FinMo Case Competition
• ICRA International Case Competition
• John Molson MBA International Case Competition
• McGill Management International Case Competition
• Schulich International Case Competition
• Scotiabank International Case Competition
• UCCA Case Competition

Case Competitions in Europe

• Aarhus Case Competition
• AAU Case Competition
• Amsterdam Case Competition
• Belgrade Business International Case Competition
• CBS Case Competition
• Central European Case Competition
• Creative Shock
• ILA International Case Competition
• International Case Competition @Maastricht
• Morpheus Cup
• NIBS Worldwide Case Competition
• Russian National Case League Changellenge
• SDA Bocconi Case Competition
• The Geneva Challenge

Case Competitions in International Locations

• CEIBS Global Case Competition
• EY CAFTA Case Championship
• HKUST International Case Competition
• HSBC/HKU Asia Pacific Business Case Competition
• IFAMA Student Case Competition
• IMA Middle East and India Student Case Competition
• KPMG International Case Competition
• Melbourne Business School Case Competition

– – – – – – –

In this article, we’ve covered:

• Insight into the nature of case competitions, including examples of the tasks and challenges
• How participating in a consulting case competition can benefit your resume and increase your chances of success in recruiting
• Tips on how to excel in a business case competition and make the most of your experience
• A starter list of case competitions you can explore

Still have questions?

If you have more questions about case competitions, leave them in the comments below. One of My Consulting Offer’s case coaches will answer them.

Other people prepping for a case competition found the following pages helpful:

• Our Ultimate Guide to Case Interview Prep
• How to Approach a Case Study
• Case Interview Examples
• MECE (Mutually Exclusive, Collectively Exhaustive)
• The Hypothesis-Driven Approach

Help with Your Consulting Application

Thanks for turning to My Consulting Offer for advice on excelling at case competitions. My Consulting Offer has helped 89.6% of the people we’ve worked with to get a job in management consulting. We want you to be successful in your consulting interviews too. For example, here is how Parth was able to get his offer from BCG.

© My CONSULTING Offer

We are excited to invite you to the online event.

Where should we send you the calendar invite and login information.

The Ultimate Guide to the Consulting Case Interview – With Examples

This guide, written by a former McKinsey consultant and Wharton MBA, breaks down the management consulting case interview into comprehensible parts with relevant, realistic examples at every turn.

By  Tracy V.

Posted March 12, 2024

Featuring Garrett W.

MBB Interviews: Ask Me Anything

Starting friday, august 23.

7:00 PM UTC · 60 minutes

Table of Contents

While the consulting case study interview may seem daunting at first, most cases follow a typical song-and-dance. Once you get a hang of it, prepping feels much more manageable. The first part of this guide will give a broad overview of the case interview. The second part will break out the typical structure of an interviewee-led case. The last part will dive into each component, with tips and suggestions for preparing. Note that some firms may have their own specific case interview style. Be sure to familiarize yourself with your target firms’ interview processes before the time comes to recruit.

Case interviews involve tackling a business issue or problem faced by a company (the client). These interviews allow consulting firms to gauge candidates’ ability to perform the job. Specifically, firms are testing whether candidates can:

• Think in a structured and creative way
• Analyze and interpret new information
• Communicate persuasively and succinctly

Most firms conduct interviewee-led cases, as outlined in the guide below. In these cases, the candidate is expected to drive the case forward by asking the interviewer for data or information relevant to forming the recommendation. A few firms, most notably McKinsey, are interviewer-led, meaning that the interviewer will be the one guiding the discussion.

Below are a few common types of cases that you can expect to receive. Some cases can be several types all in one (lucky you!):

• Profitability - Determine cause for profit decline and / or ideas for increasing profit; you will rarely get a standalone profitability case – It will usually be rolled up in another case type
• Growth - consider strategies for company growth; could be through sales or market share
• Market Entry / New Business - Assess attractiveness of entering new geography / business / sector and method for entering
• Due Diligence / M&A - Assess attractiveness of purchasing / acquiring a company or business; client can be another company or a financial sponsor
• Competitive Response - Address a competitor’s recent action (e.g., new acquisition, change in pricing strategy)
• Non-Traditional - Similar to the other cases but the client (non-profit, NGO, education-focused entity) has different objectives than a typical corporate company

Case Interview Components

• Prompt: Interviewer reads aloud the case while the interviewee takes notes
• Recap: Interviewee provides a high-level summary of the case and confirms accuracy of information written
• Clarifying Questions: Interviewee asks 2-3 high-level questions
• Structuring (<2 minutes): Interviewee takes a few minutes create a roadmap for approaching the case
• Framework Presentation (2-3 minutes): Interviewee reviews the structure with the interviewer, who may have follow-up questions. Interviewee then moves the case forward by asking for additional information
• Brainstorming: Interviewee is expected to list out several solutions or ideas (e.g., cost drivers for an industry, ways to increase sales)
• Exhibits: Interviewee will be given data in forms such as graphs or charts and expected to provide high-level insights
• Math: Interviewee will be asked to perform a calculation with the new information or using data from the exhibits. Oftentimes, interviewee is not given enough information and must ask for the relevant data
• Synthesis and Recommendation (2-3 minutes) : Interviewee provides the answer first, then supporting facts from the case, and finally risks and next steps

Setup (2-3 minutes)

Prompt : The interviewer may be giving you A LOT of information - don’t write down everything verbatim. Jot down facts and figures, the client name, and the objective(s). If you miss something or don’t remember what a number means, you can ask after your recap.

• Prep: Have a friend read you several different case interview prompts and practice taking down notes. Create your own shorthand and learn how to recognize extraneous pieces of information

Recap : I always reference the client by name and start my recap with the objective(s) first, since this is the most important part of the case. The recap should be summarized, not verbatim, and you should be checking that the figures you wrote down are correct.

• Prep: Practice summarizing your notes out loud instead of repeating the case verbatim. Time yourself to make sure it’s <1 minute.

Clarifying Questions : Very detailed questions should be saved for the case. Clarifying questions are meant to help you with your structure or alleviate any confusion. Keep these at 2-3 questions. I usually ask questions pertaining to:

• Language/terminology - The interviewer won’t expect you to know the nuances of every industry or practice area. It is better you start off the case on the right footing by asking for clarifying definitions
• Goals/objectives - I always ask if there are other goals the company has in mind and, if relevant, specific financial targets or timeframe. Sometimes, the objective given is vague, so I will ask the interviewer to be more specific.
• Business model or geography - Very helpful for cases in niche industries; understanding geography can also prompt you to think about factors like labor cost or global competition
• Scope - To save you time from considering every possibility, you can ask whether the company is leaning towards one option or excluding a set of options completely
• Prep: Have a friend read you case prompts and then practice asking 2-3 clarifying questions on the fly. Try to think of them as you’re taking down notes and giving the recap. Are they helping you with your structuring or are you asking the first thing that pops into your head? Are they broad enough or overly detailed? Are there types of questions you should be asking but keep forgetting?

Framework (4-5 minutes)

Structuring (<2 minutes) : Do not use the word “framework” during the interview. I ask if I could have time to “gather my thoughts” when I am structuring. In your structure, you should have at least three but no more than five “buckets.” These are areas that you want to explore in order to solve the case. In each bucket, there should be at least three sub-bullets. Make sure there is no overlap between the buckets.

• Prep: Time yourself structuring your roadmaps. Be comfortable with recalling the different buckets you should be considering for each type of case and brainstorming sub-bullets for those buckets. It’s okay to go over two minutes when you first start, but as you get comfortable, make sure you are becoming more efficient. For example, as you become more familiar with the buckets, you don’t need to write down every example for the sub-bullets, they will become muscle memory as you recite them out loud. Review the suggested frameworks for the case and take note of whether there are vital topics you keep forgetting or whether there are unnecessary buckets you keep adding. There is no one “right” answer, but your roadmap should enable you to uncover the necessary information to make your recommendation.

Presenting: Introduce the high-level buckets first before diving into each one. You will want to “customize” your framework to the specific case you’re working on. This does not mean creating a custom framework for every single case. You can use the same topics for similar types of cases (but ensure that those topics are relevant - some cases sneakily rule out an entire topic to see if you are paying attention), but you need to make sure that you are using case-specific language and examples when you present. This shows that you are thinking about the specific problem, not just recycling a generic framework. After going through the structure, pause and ask if the interviewer has any questions. Then, give your hypothesis and state which bucket you want to start with by asking for data pertaining to that bucket and why you want it.

• Prep: Present your structures out loud and note whether you are rambling or being case-specific in your language. If you find that your presentation is too long, consider cutting down on the examples or explanations. Be succinct and say enough to get your point across. Don’t just move on to the next case if your presentation falls short. Keep practicing until you feel satisfied and make mental notes for the next case.

Interview “Questions” (10-20 minutes)

For each type of question, you are going to be doing the same things: answering the question, providing insights, conveying how it impacts your recommendation, and driving the case forward. Every time you have “answered” a question, you want to be thinking, “ What else do I need? What’s the logical path forward ?” The only way you can prepare for this is to run through entire cases! Remember, your framework is your friend. Refer back to it often if you don’t know where to go next.

Brainstorming : You will want to structure your ideas into MECE buckets. They can be fairly simple (financials vs. non-financials, external vs. internal, etc.). Similar to your framework, you will give a preview of the buckets first before going into the details of each and you will need to ensure that it is “custom” for your case. If a structure doesn’t naturally come to you, you can create a pseudo-structure by organizing how you will present your brainstorm. For example, you can state how many ideas you have from the onset or say that you will first go through the ideas first and then the associated risks.

This is a highly debated practice, but I always ask for a few seconds so I can think of a structure (they may say no). Don’t take more than 30 seconds because you can add to your buckets as you are presenting.

For non-technical brainstorms, be creative! For example, when interviewers asked about how to increase sales for a consumer-facing retail company, I would bring up TikTok campaigns and celebrity endorsements as a few ideas. Have fun with it!

Occasionally, interviewers will prod you with, “What else?” This does not always mean you didn’t give enough ideas. Sometimes it’s the opposite – they are looking to challenge you or see how you will react. Just roll with it - if you don’t have anything else, say so.

• Prep: Practice brainstorming for different types of prompts. Collect a bank of general ideas and solutions that can be customized for use across industries. Try to think of as many ideas as you can (four to six at the very least) and exercise that creative muscle. To help you with structuring, have a list of “easy” MECE buckets that you can pull out on the fly.

Exhibits : First, give an overview of the exhibit. As an example, for graphs say what the axes represent, tie it back to the case, and give your interpretation of those axes. This gives the interviewer a chance to course-correct if you misinterpreted the exhibit. Give some insight, even if it is low-hanging fruit, and tie it back to the case. There are three levels of insights for both exhibits and math:

• What the numbers say, patterns/trends (X is smaller than anticipated, Y is the largest driver)
• What the client should do (enter the market, cancel plans, plan for launch)
• What we should do next (reconsider something specific, research more data on X, move on to Y)

Oftentimes, exhibits will tie into a calculation. If you are given an exhibit with data that can be used to calculate more insightful information, tell the interviewer that you would like to make those calculations. The interviewer will lead you down that path regardless but it is more impressive if you call it out.

• Prep: Run through different types of exhibits and see how many insights from each level you can pull out. Practice anticipating what type of data you need next in order to move ahead in the case or whether you can/should calculate anything from the data given. Don’t be too insightful though – you only have a limited amount of time to run through the case.

Math : Before you start calculating anything, it is critical for you to confirm what you are solving for and that the information you wrote down is correct. SUPER IMPORTANT – answer the question that is being asked !!  If the interviewer is asking for the incremental profit from a certain strategy, you don’t want to calculate the total profit from the strategy. Active listening is so important!

As you know by now, structure is everything. Again, I always ask for a few seconds to organize my thoughts (the worst thing they can say is no). Set up the problem before you start calculating. This allows you to identify whether there is data missing. Walk the interviewer through your method and ask for missing data. You may need to make your own assumptions or estimates – be sure you can justify them.

If your method is off, the interviewer will usually guide you back to the right path. This saves you from wasting time calculating the incorrect answer. Be sure to pay attention when the interviewer is trying to coach you.

As you are solving the problem, walk the interviewer through each calculation and use math shortcuts as much as possible. Again, if you make a math error, the interviewer can stop you before you go down the entire path. Save time by only calculating what is important for the case and understanding what you can skip.

• Prep: Practice setting up the problem, walking the interviewer through your proposed method, and verbalizing the calculations out loud. On paper, make sure your calculations are being done neatly and not all over the place. Look for different math shortcuts and try them out. Not all of them will fit your style, but you might find new tricks. Track whether you are answering the right questions. Once again, active listening is critical to your candidacy. Once you have correctly solved the problem, make sure you are thinking about the, “So what?” Determine how that number impacts your recommendation and where you should go next.

Synthesis and Recommendation (2-3 minutes)

Again, I always ask for a few seconds to collect your thoughts (<30 secs). If the “CEO is already in the elevator,” they may say no. Have a definitive stance – start with your recommendation and then provide two to three supporting facts using data from the case.

Address risks and next steps (i.e., what is the required analysis/gameplan – this is like real life where the firm is trying to sell additional projects). Your recommendation should be <2 minutes. Frankly, the interviewer has most likely made a decision on your candidacy. Don’t ramble and try to finish strong.

The hardest part of this is pulling out the supporting data in a succinct way. Throughout the case, you should be jotting down notes. I tend to circle what I believe to be relevant supporting data. When you present it, don’t be too specific or granular. You want your recommendation to be punchy.

• Prep: Run through whole cases where you are tracking the relevant supporting data along the way. Time your recommendation and practice verbalizing the information concisely. Don’t forget the risks and next steps. I usually have a list of generic risks (e.g., competitor response, regulation, inaccurate projections) that I can “customize” on the off-chance I’m scrambling to think of some. Your next steps can be collecting additional data to support your recommendation or ways to address those risks.

Free trial!

From 127 top coaches

Access a library of videos, templates, and examples curated by Leland’s top coaches.

Example resumes.

Example Cases

Casing Drills

Mock Interviews

Final Thoughts

• Your approach is more important than the solution – The interviewer is trying to understand how you think. Some cases have data that support recommendations in either direction. The key piece is that you are able to back your stance using the facts and data uncovered during the interview.
• Deadends are okay – There will be times when you make multiple requests for data and the interviewer does not have it. That’s perfectly fine! You can’t read the interviewer’s mind and the case could go in so many directions. Just look back at your framework to see where else you can proceed.
• Be coachable – It’s not the end of the world if your method is wrong or if you misinterpreted an exhibit. The interviewer wants to see that you are actively listening and can take feedback and improve. Don’t freak out! Stay calm! Listen to what the interviewer is trying to tell you.

This guide only scratches the surface of case interviews. The best way to prepare for case interviews is to get your reps in with entire cases. That way, you can identify your areas of weakness and be more precise with the drills. I can give you feedback and additional tips and tricks so that you are performing at your best on interview day. Book a free intro call with me on my Leland profile to discuss how we can personalize your case prep plan!

Preparing for consulting recruiting and/or case interviews? Here are some additional resources to help:

• Top 3 Tactics to Ace Your Case Interview
• A Comprehensive Guide to McKinsey & Co., Bain & Co., and Boston Consulting Group
• From No Offers to Multiple Offers - How to Take Your Casing to the Next Level
• How a Disneyland Churro Helped Me Land a Job at Bain (and 5 Pitfalls to Avoid in Market Sizing Problems)
• Five Tips to Break Into Management Consulting

Browse hundreds of expert coaches

Leland coaches have helped thousands of people achieve their goals. A dedicated mentor can make all the difference.

Browse Related Articles

May 18, 2023

McKinsey Bonus Structure: Understanding the Reward System

Discover how the McKinsey bonus structure works and gain a deeper understanding of the reward system in this comprehensive guide.

Victor Cheng LOMS: Is It the Ultimate Guide to Case Interviews?

Discover the ultimate guide to acing case interviews with Victor Cheng's LOMS program.

June 8, 2023

A Comprehensive Guide to McKinsey Case Interview Preparation

Looking to ace your McKinsey case interview? Our comprehensive guide has got you covered! From understanding the interview process to mastering case frameworks, we provide expert tips and strategies to help you prepare and succeed.

August 16, 2024

The McKinsey Sophomore Summer Business Analyst Program: What to Know

Learn what to expect from McKinsey's Sophomore Summer Business Analyst Program. Get insights, tips, and advice for a successful application.

January 2, 2024

The Ultimate Guide to the EY Parthenon Case Interview Process

Are you preparing for the EY Parthenon case interview process? Look no further than our ultimate guide, packed with insider tips and strategies to help you ace the interview and land your dream job.

How to Answer the "Why Consulting" Interview Question

Discover top strategies for answering the "Why Consulting" interview question. Learn how to highlight your passion and fit for the consulting role.

May 11, 2023

How to Prepare for McKinsey Management Consulting Behavioral Interviews?

If you're preparing for a McKinsey management consulting behavioral interview, this article is a must-read.

How to Prepare for McKinsey Management Consulting Networking Calls?

Learn how to ace your McKinsey management consulting networking calls with these expert tips and strategies.

McKinsey First Year Salary: What to Expect and How to Negotiate

Are you curious about what your first year salary at McKinsey might be? This article provides insights on what to expect and tips on how to negotiate your salary.

Mckinsey Consulting Salary: A Comprehensive Overview

Discover everything you need to know about McKinsey consulting salaries in this comprehensive overview.

Business Analyst McKinsey: A Comprehensive Career Guide

Discover the ins and outs of a career as a Business Analyst at McKinsey with our comprehensive guide.

50+ Case Interview Questions and Examples From Top Firms

Discover over 50 case interview questions and examples from top consulting firms. Prepare effectively for your next interview with expert insights and tips!