How I fixed these data-heavy slides from McKinsey, BCG, and Bain

[@AnalystAcademy]

Our new data visualization course is live! Head to our website for a free preview.

[@tomthetitan101]

this guy is the michael jordan of data visualization

[@juniasfolly6089]

Of course 😊

[@judyl.7811]

wow! i scroll down for comments first and then watch videos. this is so exciting to know and i can dive in!

[@bridgetteojo5239]

*Kobe Bryant.

[@НастяХин]

From someone who hates doing decks and struggling to tell stories in PPT, this is very helpful to level up. Challenging though, not going to lie. Thank you, you make this so interesting.

[@aleksandrskaminskis1003]

Great work there with the Bain slide! Well done and looking forward to new videos from you. Well done!

[@tigertiger777777]

That first BCG slide tho. AWESOME WORK 👍

[@AnalystAcademy]

Thank you!!

[@rajeshparkar5683]

Wow, this simplified and delivered main messages very clearly. Thank a tons for these tips.

[@Zalo184]

Hi! This is super useful and I think your videos help both on-the-job consultants and aspiring ones. I would suggest one thing: use more recent presentations as some of the companies you refer to changed their templates and presentation styles quite drastically - I think this would upscale the relevance of your content! Thanks a lot

[@waadabdullah2191]

Where can I find the most recent presentation?

[@kendall452]

This is exactly the content I’ve been looking for.

[@valuations520]

The Bain graph is a classic example of how to "lie" with statistics or an obfuscated representation thereof. Comparing 2021 with 2019 value shows that the percentage increase in EU/Asia is at least as big as in the U.S. In fact, at least for Asia one might assert convergence with the U.S. Your graph shows clearly that which is obfuscated in their original graph. Good work. It is also a reminder to be explicit about whether one talks about relative numbers/growth or about absolute numbers.

[@anibalrojas6641]

I always feel I am learning a lot with these videos. Very useful to convey the message through slides.

[@quocanhnguyen4108]

Great video! Especially the first chart that you've changed from BCG looks phenomenal.

[@samarsyal3811]

The channel is GOLD.

[@markdasaolu-wilhelm5761]

Excellent! A much needed, no nonsense insight into making presentations better! Please keep it up!!! I hit 'like' and 'subscribe' after only a minute of watching!

[@romniyepez5206]

Summary: 5:06 Before - After: which industries are leaders and which other are laggards 8:50 Before - After: access to a large volume of plastic-waste feedstock 13:11 Before - After: how deal values surges globally Thanks Paul..!

[@Alves_Walysson]

Caramba, ficou realmente muito bom as modificações que você fez, e é bom ver como grandes empresas de consultoria (as melhores do mundo) também podem errar suas apresentações 😅, meio que dá um alívio 😂. Mas sendo sincero, o seu conteúdo tem me ajudado muito, conheci o seu canal nesse final de semana e maratonei quase tudo durante esses dias. Estou na busca por melhorar as minhas análises e apresentações corporativas para me tornar um profissional excelente e sentir orgulho do meu trabalho e você 🫵 tem me ajudado bastante. Continue fazendo esse excelente trabalho e que Deus o abençoe sempre!🙏 Ah e eu escrevi em português do Brasil mesmo 😂, acredito que não será um problema traduzir isso com A.I 😅. Envio essa mensagem de Santa Catarina, Brasil.

[@liliana910122]

I love this format, it makes the explanation of what makes a great slide great much clearer

[@Drojnosnared]

Super useful comparisons. Thanks a lot for your content

[@asigari0711]

Oooof the one from Bain is definitely a hard one. Tough to say which is better, I do like your aesthetic a lot more. Excellent video.

[@londonwebdesignagency]

Particularly loved that last example

[@martinhodell8465]

very nice- you're 3 for 3. Couldn't agree more with your comments and suggested changes.

[@waadabdullah2191]

This is very helpful, please can you make more of these videos!!!! Thanks alot

[@BigBeesNase]

Found your channel today, Love the Case Studies. Keep up the good work!

[@akashingole8720]

Great video. Lots of great insights.

[@shellyz77]

love the way you explain it! 👍

[@jepherdselloria7379]

This guy is really good and an expert in data vis.

[@ggas33dfdf]

At the final chart there would be an opportunity to put a rectangle in the background with soft color to emphasise that the last couple quarters are important. Or a small rectangle above with a percentage about overall growth in total deal value. Which would it make easier for the reader to deal with the scale on the left hand side since the jumps are in 50B. Thanks for the video!

[@peterxia]

Your video changed my life sir. I have subscribed

[@everstormz]

Fantastic work. I really like the transitions and the logic you use for your modifications.

[@Noname-iz9uo]

i am hypnotized by this man

[@yuscared1]

Nice explanation with references

[@arbo8018]

Imagine how they feel, the poor interns who designed these slides on Friday night at 11 p.m., while they were hitting their 80th weekly hour

[@martu33127]

It was really good to get introduced to this vision of cleanliness and communication with data! How were you able to customize the charts so much? Which tool did you use?

[@Zalo184]

think-cell quite likely

[@higiniofuentes2551]

The second case solution is very good indeed! The first case solution is not as good as we can expect because grouping title can be confusing, you can think is only for the first case. Better to add the two colors with a +. This way no possible confusion.

[@SL-hv4om]

Very insightful - even for a veteran consultant of 20 yrs!

[@romniyepez5206]

2:20: what kind of app did you used for adding a box around a section to indicate (which industries are leaders and which other are laggards)

[@qudsia2343]

Loving these videos!

[@chengwang411]

BTW, cannot agree more on putting legends around line chart ends. So much easier to view

[@AnalystAcademy]

Such an easy win!

[@rxsputin]

great explanation!!

[@EconWithDrA]

Great video!

[@fred4287]

awesome, greate storytelling techniques!

[@rodleaverton]

Really helpful guidance. Thank you!

[@escapepeterpan]

Hi Paul, really like how you put glows upon these charts, I totally agree to say that the changes you made makes the slide proves the point better. I have some question if you don't mind, how to decide what type of data visualizations needed to help prove our points. do you have any recommendations on this topic?

[@MahoganyHues]

This made me realise I’m great at creating slides for data visualisation and should give myself more credit

[@Danielhou1986]

This is very insightful! Thank you!!

[@kellybrehm911]

more excellent makeovers!!!

[@Mahshadn]

great ideas! looking forward to more!

[@kedards]

Thank you for sharing. Great video!

[@judyl.7811]

0:10 coming up 1:35 one very function of iPad is to write the master mouse and revise the slide just on it. 2:05 put y axis will lead to distraction. 2:15 when you draw a chart, you want to simplify the most and draw to the most importance. 2:50 a combination chart can be great but usually the scatter plot can do much better in these. 3:25 a problem: when we see trendline, we want to see the pattern of growth. But this is just data from low to high. 5:35 these 4 legends in different countries. 6:00 why i'm confused is because of the color scheme. 6:15 this dark blue is their emphasis color and accented by this blue color. 6:40 it's not a background or foreground color. as it is in between. 7:15 this has a downside that, this might not fit with their color scheme, but in personal opinions, this emphasizes the messages better. 7:50 i'm adding the percentage sign here, even if that's against Mckinsey's formatting guideline, it makes more clear. 8:25 no confusion for dumb people like me. 8:45 that's more of a personal preference. 9:30 a very good-looking slide with 3 different charts showing 2 dimensions. 10:00 the tile should give you an indication for what you should focus in your chart or slide. 11:05 it's very difficult to compare with N america with the rest. 11:50 notice how i put here right next to line themselves than legends. it's more visible. 12:05 the obvious missing piece is deal count. it provides contents for info but doesn't need to be emphasized. 12:20 but one way around that is to include the table. 12:35 something to add up the clarity: the connection between the two subtitles, and the color scheme.

[@user-cj5hu9ip4d]

I liked the transformation of the Bain chart very much, great visualisation of the main points of the headline. Deal count data kind of lost even though it provides additional insight, would deserve visualisation too.

[@costanzadotjpg]

Nice one! What program do you use though? I feel like some of these are limited in Excel

[@nanwuamitofo]

Magic! Great work!

[@dumisaralane]

Awesome lessons.

[@higiniofuentes2551]

Thank you for this very useful video!

[@Benabiin]

Rellay good explained, thanks for sharing :)

[@ourchitecture]

For the first example, I wonder if consultants might still argue for the classic bias toward "trending up" chart visuals. While the scatter plot is indeed more technically correct, the emotional bias for at least Western readers like the US might assume a "downward trend" and mistakenly associate it as "negative" or "bad". The third chart is fantastic, but I wonder here if pro consultants might be dealing with a bias to value complexity that "needs explaining" (by a high value consultant). While I prefer an honest and clear approach as was outlined in your recommendations, I do wonder if some folks out there would still pick the earlier, more complex, version because it might force readers to seek out an explanation from the presenter (the "expert"). Great leaders will see right through this given two options, but might miss it with only the one slide to look at as part of a larger presentation. Kudos to those of you who can reduce your 10s or even 100s of slides down to crystal clear and, ideally, actionable information! And, kudos to Paul and this channel for advocating for that.

[@filltheglass2618]

Just change the bottom axis to share of desked workers and then you make laggards bottom left and leaders top right

[@jadsoj]

Wonderful content

[@tayadihyt]

Great! Thanks for sharing!

[@AXISseven]

I love this videos, I’m starting at Strategy and I find them incredibly useful!

[@MuhammadDilshad-bj7dt]

Great job

[@gonzalochavez2006]

Great video!!! Thanks for sharing

[@Edman4Ever1]

Hey Paul thanks for the content, may I ask which platforms or tools do you use to edit the charts, thanks in advance.

[@sagittarini5191]

Brilliant!!

[@user-rj7oj3nw2p]

How do you add colors to those sections

[@Sillyyy1125]

How about making the deal count in the last chart into a bar chart?

[@cksschannel9470]

Hi Good morning, will you pls do different types of corporate charts videos in your channel

[@afihaileywibowo1095]

This is great! I worked at McK and I thought as good as their ppts are, they are kinda boring if I were the clients! 😂 ...on the Mexico plastic-waste slide, do you think it would help more if Mexico only part is emphasized more perhaps by adding dotted line around it or something else, so as to draw more attention to Mexico? Of course, that may not conform to McK standard, but from the viewer's POV?

[@tunggulmanik8928]

So I have these two workflows from two different divisions but basically they do kind of similar things. One division is doing it holisticly but manual and laborious. And the other is doing the same stuffs in parts but automatically. So I want the former division to sort of eliminate the redundancies and take advantage of the later division efficiency. Do you have an example for that? Apologize if I confuse you.

[@zulfchoudhary2746]

Thank you. 👍

[@keegroup]

Thanks Paul. I love what you teach so freely and openly on YouTUbe - it's very helpful. One question: on the mckinsey slide, the heading highlights 'volume' but the graph is about 'percentage'. In other words, Mexico percentages are the highest, but without knowing quantity, there is no way to know volume. To my mind, there is nothing in the slide to confirm that Mexico has the highest volume... it is assumed through percentage and the size of country/population. Thoughts?

[@AnalystAcademy]

This is a good catch, but I think the title still works because it says “large volume” (which is technically true), and not “largest volume”.

[@marcohghar]

@ 6:30 "It's navy blue, not black." Right?

[@terencetyl]

Instead of using the raw data on deal count, what about using some sort of heat map?

[@CalBeMe]

In the original version of the Bain (3rd) slide, the title under "Asia-Pacific" differs from the other two. The additional words "...and growth..." threw me off from the start.

[@spikeydude114]

What tools do you use to make such awesome looking charts?

[@Keizerin]

Hi. What software did you use to recreate these charts? Or did you use R or Python or other programming language?

[@AnalystAcademy]

I use Ampler! It's a PowerPoint add-in kind of like Think-Cell. Here's a free 1-month subscription: my.ampler.io/alumni/theanalystacademy (affiliate)

[@LeeMaverick]

Very helpful :)

[@flourishwithMJ]

Thank you

[@sujiechaow6798]

Could I suggest reducing the frequency of swapping out the graph while giving comments? It would be better to stay at the visuals so that we can look into it while listening to your explanation. Thank you!

[@AnalystAcademy]

Thank you for the feedback!

[@sik9802]

Thumbs up for this video!

[@plasticman2k]

I love you you bald smart man. Subbed

[@sirisaksirisak6981]

Nice slide.

[@borstenpinsel]

Color scheme (CI) doesn't mix well with graphs anyhow. Excel for example automatically uses the primary, secondary etc colors. And this what you described with the McKinsey slide. It doesn't make sense that one option about waste (or any other topic, not related to the company (for example: performance of us vs competitors) is simply the primary color. I only use the primary color of my company in completion charts (where are we vs the others) and in timeline charts (primary color is this week's revenue and secondary color is the past, for example)

[@zzFishstick]

I think the better option for the Bain slide would be a stacked column chart

[@talentio1999]

The video was really good, really insightful, i've been reading story telling with data by cole nussbaumer, and this video really puts the theory into a practice

[@chengwang411]

When i learn excel charts, my teachers always use charts from the Economist magazine as examples. I do like their style. Is it also considered top level abroad?

[@AnalystAcademy]

Definitely. Used lots of them in our data visualization course. Excellent charts.

[@AnalystAcademy]

Actually decided to make a video dedicated to this topic! Watch it here --> kzbin.info/www/bejne/mXiqnHR9d9eYaaM

[@oladayoowoeye3678]

I love this

[@helioliskfire5954]

I like the functional logic that goes into designing nice and effective visualization. Sad to say, in government, where I work, there's a certain limit to how slick your presentation can look. It's almost frowned upon when your presentations are "too pretty". Just the general vibe and aesthetic. The tone and messaging has to be toned down to the point of obscurity.

[@odc53]

question: on the Mck slide, wouldn't it be better to include the "capturable plastic waste" tag underneath the Landfilled and Recycling legend instead of on the first bar?

[@georgeroth3042]

Great video but also why am I entertained by this🧐

[@AnalystAcademy]

Sometimes I ask myself the same question. 🤷‍♂️

[@임우섭-y8u]

장표계의 메시 그 자체

[@beregu]

👍👍👍

[@itm1996]

🔥🙏

[@clove4381]

cool

[@edwardfrancis4647]

𝖕𝖗𝖔𝖒𝖔𝖘𝖒

[@maekwegner]

As a physicist and statistician in tech this video is really painful to watch. You really improved the first and the third one but still much space used by diagrams with almost no information in it. Consulting industry is not worth the money most of the time.

[@ZEROCARTOO]

4:26 translation of deskless workers is wrong