Graph and tables analysis

BCG McKinsey and Bain Data Analysis quantitative analysis Quantitative skills
New answer on Jan 15, 2022
84 Views

Hello,

I really struggle with analyzing tables and graphs. Most of the time, I have trouble priorizing when there is a lot of information and connecting insights to the case when it's not obvious.

I have been making drills on rocketblocks for several months and finished them, but didn't really improve.

Do you know some useful resources to improve on that? Both lessons and training.

Thanks

• Date ascending
• Date descending

Hi!

I just posted an extensive answer to an identical question, but let me repeat it here. First of all - doing isolated “drills” for chart interpretation like offered on Rocket Blocks is a COLOSSAL waste of time! It is IMPOSSIBLE to practice this in an isolated manner, since you will NEVER be able to gnerate an insight just by looking at a chart! The keyword is CONTEXTUALIZATION! Please refer to point 4 below!

Effectively interpreting data and information is one of the crucial success factors in most case interviews. Very often, this data comes in the form of graphs or charts which the interviewer shares with the candidate at some point during the case. Finding the central insight of the chart, the ‘so-what’, is the single most important quality you will have to show in this situation!

There are a few habits which, if properly internalized and applied, will massively help you to impress the interviewer in this domain! Let’s go through them one by one…

1 Take TIME!

The first thing you should do when presented with a table or chart is to take time to properly scan the information provided. In fact, you should ideally have a “standard phrase” such as

“Thank you! I see, there is quite some information on this chart. So let me take a brief moment to quickly scan the information and identify…

which steps we need to take to determine X” (if the interviewer has asked you a concrete question like “How to derive XYZ from this data?”)

…how we should proceed” (if the interviewer just gave you the chart but asked for no concrete analysis)

This is a very frequent Achilles’ heel with candidates! It is a pretty widespread problem that candidates tend to put themselves under time pressure and start talking before even having properly looked at the chart! The consequence is that you are not crisp in your messages, you’re just “wobbling around”, starting sentences without knowing how you will actually end them, etc. This leaves a very bad impression! Interviewers at MBB actually TEST for whether you have the maturity to take the space that you need in order to conduct a proper analysis! Just understand it from the interviewer’s perspective: as a project manager, the last thing I want to have on my team is a young colleague who tends to talk before thinking! This would represent an enormous risk in client interactions and can undermine credibility of the whole team, or even the whole firm!

What leaves a much better impression is to confidently announce that you will need a moment to

1. take in all the information on this chart,
2. link it to what has been discussed to this point,
3. suggest the best way forward.

Another reason for taking time is that it allows you to verify/clarify your understanding of the information given. Very often, e.g. unit abbreviations are not entirely clear (or even lacking!). Taking a moment after receiving the chart will allow you to scan these elements and clarify their meaning with the interviewer, before you start discussing observations and insights.

2 Scan the base parameters (“Read the chart correctly!”)

This is tightly related to the previous point of taking adequate time. Oftentimes, candidates do not pay attention to what is actually shown on a chart, hence they are not properly grasping the parameters and what they actually describe! A couple of habits are important when reading a data table or chart.

• It starts with reading the title (this sounds trivial, but oftentimes just properly reading the chart title would have prevented candidates from stating obvious nonsense!)
• Look at the units and labels (frequent source of misreading charts!)
• Identify whether and which dependencies are shown on the chart (just properly checking what depends on what is oftentimes a very effective way of preventing yourself from completely unnecessary instances of misreading data! For example, in a x-y-axis chart, the vertical metric (y-axis) usually depends on the horizontal metric (the x-axis), and NOT the other way round!)

3 Identify key observations

The key messages (the ones that are relevant for the client’s question) within data and charts are usually found amongst the following:

• Static relations
• Trends
• Correlations
• Breakdowns

Let’s look at each of these points.

• Static relations
• A simple comparison of values (comparing one number or group of numbers to the others - often a bar or a line chart), e.g.,
• comparing client metric vs. market average or vs. competitor (e.g., “Client’s profit margin is 30% below strongest competitor.”)
• comparing one scenario vs. another scenario (e.g., “Outsourcing is 20% cheaper than in-house production.”)

• Trends
• Specific number or group of numbers showing growth or decline (e.g., “Revenue has grown by about 10% over the last three years, however profits have halved during that time frame.”)
• Rate of change compared to other logically related numbers (e.g., “Sales volume drops by 20% for every 10% increase in price.”)

• Correlations
• Specific relationships between two or more numbers; such correlation can be geared towards the same direction (positive correlation) or in divergent direction (negative correlation)

• Breakdowns
• Pretty often, even if Totals seem to show a consistent pattern, digging deeper into specific segments will reveal certain “hidden shifts”

Spotting those kinds of patterns quickly is vital. When you are given two or more charts, the key message usually becomes evident by combining them. Again, here you might need to take appropriate time.

4 Turn observations into insights & avoid “spontaneous amnesia”!

This is a BIG one!

One of the most amazing observations I have made over the last couple of years is the following. Many candidates, as soon as they get a chart or data table, fall victim to what you can call “spontaneous amnesia”! This means, they immediately forget EVERYTHING that has been discussed leading up to this chart.

Instead, they  tend to stare at the chart, drowning in the information, and trying to distill insights JUST by looking at all the information on the chart. But they DON’T CONTEXTUALIZE the chart! This means, they don’t relate the information on the chart back to the core question, the criterion to answer this core question, or to the last insight generated BEFORE the chart was given out by the interviewer.

So, there is a simple trick: as soon as you receive a chart or data, your IMMEDIATE mental reaction should be “Wait, what did we just discuss, that led the interviewer to give me this data now?”. Usually, this is often sufficient to point you to the central insight of the chart!

You must be guided by the LOGIC which allows you to answer the core question, and the chart should just work as a source of information to perform the required corresponding analyses.

!!! Do not be guided by the chart itself !!!

Because very often, not all information on graphs you get is insightful or important! Parts of the information in the charts are crucial, others just create noise to distract you. Taking your LOGIC as the guiding star will allow you to quickly identify which pieces of information are crucial to generate the required insights to proceed towards an answer to the client question.

5 Communicate top-down and propose next steps

Whenever you present an insight during a case interview you should communicate your findings top-down. The same is true when presenting your interpretation of a chart, table, graph, etc. Start with the single most important fact you can extract from the chart.

1. Communicate this key insight that you identified from the chart
2. Then, give the reasons for your conclusion. These reasons must be substantiated by the data!
3. Based on the insight generated, proactively suggest (without having been asked by the interviewer) the logical next step in your navigation through the case in order to proceed towards reaching a recommendation/answer for the client!

------------------------------------------------

All of these points are vital to understand and master. Unfortunately, it is very difficult to do this on your own. You will need senior guidance for this, otherwise it will inevitably take quite long until you really reach excellence here. Just like on the job - adequate mentorship ensures swift progress. Trying to figure out curcial skills on your own will take a lot of time. And time is very expensive - much more expensive than cash usually...

Cheers, Sidi

Thank you for this very clear answer. Then how should I practice that to progress quickly, in addition to coaching?

You can only practice this within the context of solving cases. So once you understand the principles, internalizing it via repetition is the way to go. Once you UNDERSTAND what to do and how to do it, it is a very mechanical process to wire yourself to actually DO it. :)

Hi there,

The method I would suggest for graph analysis is the following:

• Ask for 30 seconds to understand the graph
• Summarize the graph. Read in particular the graph title, the legend, and the footnote. Candidates quite often skip this part and then make mistakes

2. ANALYZE THE GRAPH AND FIND THE MAIN INSIGHTS

• Repeat the question. Many candidates don’t spend time clarifying the question; consequently, they answer the wrong question. Be sure to align with the interviewer on what you have to do
• Provide an analysis related to the question. Identify the key insights of the graph based on the question (this is the most difficult part of graph analysis, as it is different in every graph)

3. PROPOSE THE NEXT STEPS

• State your hypothesis or suggestion on what to do next. Present what should be done next to help further the client
• Ask a question/propose an analysis related to what is needed to move forward. This will show you are able to drive the case

In case you need help, I do a specific session on graph analysis, please feel free to PM me for details.

Best,

Francesco

Hi there,

If you did all of the Rocketblocks drills and didn't improve then honestly I'm concerned. I think you should seriously consider a coach to teach/train you in chart reading. For whatever reason, you haven't fundamentally shifted your mindset/approach.

You're beyond the point of finding more resources online imho. Rather, you need teaching in the subject.

For a start, try reading my article on mindset shifts. There is some information there that should help with chart reading: https://www.preplounge.com/en/articles/how-to-shift-your-mindset-to-ace-the-case

Read the Economist (esp. the Charts section) and BCG Insights daily.

(edited)

Hello there,

I think it would be important to clarify: Are you having problems to read charts and graphs also outside the business case, in your day to day life?

… I would guess you may struggle to identify what information is relevant for your case, as during the interview, you may be given information out of which a significant part is not relevant (testing how you prioritize, 80/20 approach, able to navigate in complex problems).

If you struggle overall with the graphs and charts, I would recommend any course in the internet that gives tips and tricks. If you struggle only during the case, then I would recommend:

- start practicing cases where are no charts and graphs to identify what process works for you and so being able to transfer that process

- most importantly, when you approach the case and you formulate your early hypothesis, you identify what is information you will need to test it. This should help you to read the charts.

Please feel free to reach out if you would like to dig deeper → I can provide insight as a BCG trainer, teaching newly-joined Associate and Consultant precisely this

Wishing you all the best,

Lucie