Extracting insights from data in case interview

Hi! These are common challenges. A few practical suggestions for each point below, but TL;DR version: Always think about what you're solving for, and the so what, and then share your plan with the interviewer, before jumping into calculations

1. Extracting insights from tables and graphs

Before jumping into the numbers, take 5–10 seconds to orient yourself:

• What exactly is the question we’re trying to answer?
• What does each axis / column represent?
• What metric actually matters for the decision?

Then look for 2–3 key insights, not everything in the chart. Typical things to check:

• Largest / smallest segments
• Growth or decline over time
• Differences between segments
• Anything surprising or counterintuitive

A good habit is to state the insight first, then support it with numbers. For example:
“Two things stand out. First, Segment A accounts for ~60% of revenue. Second, while Segment B is smaller, it’s growing much faster at ~20% YoY.”

Sometimes, stating the obvious helps with: (1) giving the interviewer confidence that you know what the chart is saying; (2) leads you to 2nd order insights once you ask yourself so what? or what does this mean?

2. Calculations with finance tables

In most consulting interviews, you’re rarely expected to run complex finance formulas. The case interviews are to test your thought process and problem-solving approach

A helpful habit is to state the formula/ plan before calculating. That forces you to clarify the equation before diving into the math.

3. Recovering after a mistake

This happens to everyone. The key is not to panic and reset the conversation.

A simple recovery approach:

• Pause briefly
• Be coachable - Acknowledge the correction if needed
• Re-anchor on the objective

For example:
“Let me quickly correct that calculation… Given this revised number, the main takeaway is that Segment A still drives the majority of profits.”

Interviewers care more about whether they're able to work with this person or coach them, to recover and synthesize, than whether every calculation is perfect.

If you’d like help working through these types of questions more systematically, feel free to reach out. Happy to help with more targeted coaching.

Hi, in response to your questions:

1. Extracting and synthesising insights from tables and graphs: there is no replacement to practice. To practice efficiently, you need to ask yourself a few questions about what's troubling you - is it tough because of the amount of information? or the nature of information? whatever the issue is, you need to face it head on by practicing offline and then applying in live cases. 

   One way to be comfortable with this is walking the interviewer through what you're seeing in front of you and how you are interpreting that information (for e.g., This table shows volume on x axis and price on y axis. It looks like volume declined between 2022-2024. Given the rise in competition we discussed earlier, part of the client's demand has likely shifted to competitors but it would be helpful to see the overall market demand to confirm). One of the key roles interviewers play is as a guide who helps steer the candidate in the right direction

    

2. Laying out financial equations: Cases don't test niche information. There are a few common financial concepts that are likely to be tested and it is important that you familiarise yourself with those concepts and equations (for e.g., ROI, NPV, etc.). At the start of every 'calculation' question, the first step is to lay out the equation so that you know what variables you have information on and what you might need to make assumptions on

    

3. Pivoting after messing up: This is harder to comment on without seeing you case, but in general, you want to be professional in how you respond. You can apologise about taking the wrong approach and ask for a moment to review the information and gather your thoughts again. This is completely okay to do as it shows you can recover well from a setback.

Please feel free to reach out if you need in-depth support. Wishing you the best! 

hey there :)

This is a very normal hurdle in case prep, many candidates struggle more with interpreting exhibits than with the math itself. When you look at a chart or table, try not to read every number. First clarify what the exhibit is meant to show, then scan for the main patterns such as the biggest segment, strongest growth, or any clear outliers. A helpful habit is to first briefly describe what the chart shows, then highlight the most important observation, and finally explain what that implies for the client or the case question. That keeps your thinking clear and prevents getting lost in details.

For finance style calculations, most of them usually boil down to a few core ideas like profit equals revenue minus cost, payback period, or return on investment. Before calculating anything, quickly translate the information in the table into a simple logic or equation in words. Once the logic is clear, the calculation itself tends to be straightforward.

If you notice that you made a mistake, the best approach is to stay calm and reset the logic. You can briefly acknowledge the mistake, restate the goal of the calculation, and walk through the reasoning again step by step. Interviewers mostly care about how you think, so showing that you can recover and structure your thoughts again is actually a positive signal.

If helpful, feel free to reach out anytime if you want to discuss this further.

best,
Alessa :)

Hi there,

Three good questions. Let me take them in order.

1/ Charts and graphs

In terms of interpreting charts and graphs effectively:

1) Read the title and understand it

2) Read the legends and understand them

3) Remind yourself of the objective or hypothesis in the case, to see where this might fit

4) Find the differences. Where does the line graph plummet or spike? Which column is a lot smaller or bigger than the others? Where does change occur? The differences are what matter.

5) Talk out loud while interpreting. It helps you think, and it lets the interviewer course correct if needed.

For rote practice, Rocket Blocks is great specifically for charts and exhibits: https://www.rocketblocks.me/

For broader data fluency, read The Economist (especially the daily chart) and the FT regularly.

2/ Finance calculations

If you know the arithmetic but not which equation to lay down, the issue is pattern recognition not math. Run enough cases with financial tables until the setup becomes instinctive. Ask your case partners to specifically throw financial exhibit heavy cases at you.

3/ Pivoting after a mistake

Say "let me step back for a moment" and retrace your logic from the last solid data point. Talk out loud. Interviewers are not looking for perfection. They are looking for how you handle pressure.

For the overall mindset shift that makes the biggest difference at this stage: https://www.preplounge.com/en/blog/consulting/interview/how-to-shift-your-mindset-to-ace-the-case

Hi there, 

These are big questions. I would need to see you in a live coaching session to understand exactly what you do and how in order to tell you what to change.

From my experience, most candidates struggle with calculation questions because they try to do too many things at once - typically, they try to do logic + computations + communicating with the interviewer, all without taking thinking time. This tends to not go well. So a key part of helping them improve is teaching them how to separate these stages technique-wise.

If you need any help, reach out. 

For now, sharing here a resource that you might find useful for calculation questions:

• • Cheatsheet: The Must-Know Consulting Terms for Interviews 

Best,

Cristian