Extracting insights from data in case interview

Question

I've been working on case interview for sometimes now and find myself struggling the most with extracting insights from data (E.g. tables, graphs...). I also have problems with those "finance calculation" where we should put in mind the years, discount rate, investments... anything that require me to look at a table full of numbers + finance terms then ask me to calculate and extract insights from it. To sum up, 3 questions to ask:

1/ How can I extract, interprete and connect insights from different tables and graphs?
2/ How can I practice calculating effectively with finance table? I can do calculation quite accurately, I just do not now what equation to lay.
3/ Any strategy to pivot back after I mess up? When calculation/insight goes wrong, my brain stops and I can not connect past data pieces anymore, leading to insufficient answer.

Thanks a ton!

Answer 1

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.