0:30 we teach powerpoint presentation skills as what you find at a top consulting firm. 2:05 action title: what your audience can take away from this chart. 2:50 legends could be tricky because it makes audience look back and forth. 3:10 the bold of the word helps cut through the noise a bit 3:15 also extensively and exhaustively the footnote/ source down there. because it support the claims they made to the executives. 3:30 it explains each aspect of the chart in detail. 4:00 3 separate column charts placement is great when we have too many columns. 4:35 color is doing great here becuase it only does for the last two, which are the most important ones. 4:55 mekko chart is consultant favorite, basically the column charts that show additional dimension of data. as stacked column which shows the total size of booster by width. 6:35 purpose of mekko chart: 1. how much each opportunity contribute to the total. 2. distinguish between the 3 different growth boosters. 3. compare the size of each opportunity against each other. 7:15 the most unique and simplest chart: Praise about the chats they made. Mckinsey could just easily leave us the table since the numbers are so few here. 8:15 note here: if show the relative size of something, show the whole area but not on the radius of the circle. it's a common mistake! 8:45 to have an action title/ takeaway is above, especially the number in charts is crazy. it helps focus. 9:55 this show that how much 2% shows here. they show the line flow through the top and bottom lines.
I like how those unusual charts look more sophisticated. But the most important is that they condense a lot of information from previous work. Even if the message conveys a given point, those charts are supportive to answer possible questions.
You're absolutely right. Even with a specific message in mind, it's important to include any data that might be relevant to provide the right context and answer related questions. The trick is displaying that data in a way that doesn't distract from the important parts of the chart, which I think they do well here.
For me the sophistication comes at a significant cost. Effective visualisation is about delivering key message(s) in an efficient, effective and transparent way to a diverse audience. For data laymen, waterfall or mekko visualisations can be difficult to understand at a first glance and add unnecessary complexity to the data story. Perhaps in a future state with more data education and literacy, they will be present more value.
@@jordanbjorn8409 I pretty much agree. Data illiteracy is a huge blocker to use those sophisticated charts. However, there’s a reason why management consultants focused on strategy use them: they work with high level audiences, they want and need to bring unusual perspectives to discussion so they can be recognized for their typically intangible work, whose output is a set of recommendations written on a PPT.
Do you happen to know what tool/add in McKinsey and Bain are using to create these beautiful charts? Most of it can be done in Excel, but it's very time consuming customizing it.
Nice breakdown and analysis. One thing I heard from other Consulting slide training RUclips videos is try to never reuse the same chart format or at least space there use throughout you presentation.
What I found highly confusing about the last chart is that the 21% in the bottom left are also colored like the focused 2% of companies. Thus, for me it is still not clear if the bars on the right side, in total, reflect the 21% or 100% of companies. So do those 2% of companies yield 80% of the 400 or 1900 companies' value?
This chart is incredibly confusing. The leftmost column represents all 1900 companies, but the three columns to the right all represent the 400 companies with potential for privatization. So then 2% of companies yield 80% of the 400 companies' book value. The way I got to this conclusion was by reading the top and bottom lines and making some assumptions: "400 could be privatized with $140B book value". I'm assuming that the second column represents the $140B, and therefore the 400 companies. Same with the 3rd and 4th columns. But then afterwards I also realized it says it in the 2nd footnote. :)
@@AnalystAcademy love your stuff. I was hoping you were going to do some resuscitation on that last chart to show how much better it could be! it's not a good slide at all
Thanks for the informative video. Can you please explain why they have not used equal time periods when grouping the years from 2000-2019; in the Column Chart ?
The first chart was very confusing and I'm an analyst! If I was to present this to an executive team, I'm pretty sure I'd be asked to remove it on the first meeting!
Can't say I disagree with you. The 30M "transition to nonfarm jobs number" is a bit confusing and weirdly placed, making the chart a little harder to read. I don't know that I would put this in a presentation either, but it would depend on a number of factors, most critically my audience's familiarity with the content.
I'm infatuated with this. I had the pleasure of reading something similar, and I was completely infatuated. "The Hidden Empire: Inside the Private Worlds of Elite CEOs" by Adam Skylight
Thank you, glad you enjoyed the video! If you are asking about a tool to actually build the chart, I think the industry standard is Think-Cell. If you are looking for help in choosing and designing the chart, you might enjoy our video on charts here --> ruclips.net/video/pehzpJMqIPs/видео.html
You're right, I misspoke in the video. The problem I meant to highlight is that when you're comparing two circles you want to compare them relative to their area, not the radius. For example when you want to show that one bubble is twice the size of another, make sure you don't just try to double the radius of the circle. That will not give you double the area.
In the first chart, isn't the 30 million shown in lighter blue at the top misaligned? It could have served a better purpose if they had put it right next to the 30 million decrease shown in dark blue. Because that is actually where it is impacting, it is offsetting the loss of farm jobs with an increase in non-farm jobs. I am assuming whichever Excel plug-in they have used has restricted them from doing it.
I don’t think it’s necessarily misaligned, but I do think that it looks a little strange where it is. I probably would have deleted the top box altogether and just changed the bottom box to be half of each color.
There is a lot of value to your offering and really like your approach, however, these charts were not as user-friendly on first read and didn’t keep my interest and I do this for a living :). These charts need a consultant to make clear the take-aways. I have found Bain have this area nailed the best. The curse of knowledge
I couldn't have excepted that ,I would be able to understand or not, but after watching whole video I understand whole video even I able to understand it's is easy to make this type of charts, just need a good sense of humour !!
In chart 3.17, You can however see that they did a crtical error. They put the 30 bar "transition to non-farm jobs" on the wrong side of the line. Therefor, I can only rate this chart 3/5. The error is significant and sloppy.
I do not agree that these charts are great.... they neglect a golden rule, namely: only 1 message per slide. I have watched the first two slides and they confused me. So, this video is not presenting good examples...
I appreciate your perspective... thanks for sharing! I will agree with you that these charts aren't perfect, and that they're probably not as simple as they could be. But I also think there will inherently be some complexity just due to the underlying data and the complexity of the message itself. I would love to hear your thoughts on how you think the first two could have been better presented.
Thanks for watching! Learn more about our courses here --> www.theanalystacademy.com/all-courses/
Can't believe this kind of rich, amazing resource is available for free. Thank you so much!
You're very welcome!
Agreed!
0:30 we teach powerpoint presentation skills as what you find at a top consulting firm.
2:05 action title: what your audience can take away from this chart.
2:50 legends could be tricky because it makes audience look back and forth.
3:10 the bold of the word helps cut through the noise a bit
3:15 also extensively and exhaustively the footnote/ source down there. because it support the claims they made to the executives.
3:30 it explains each aspect of the chart in detail.
4:00 3 separate column charts placement is great when we have too many columns.
4:35 color is doing great here becuase it only does for the last two, which are the most important ones.
4:55 mekko chart is consultant favorite, basically the column charts that show additional dimension of data.
as stacked column which shows the total size of booster by width.
6:35 purpose of mekko chart:
1. how much each opportunity contribute to the total.
2. distinguish between the 3 different growth boosters.
3. compare the size of each opportunity against each other.
7:15 the most unique and simplest chart:
Praise about the chats they made. Mckinsey could just easily leave us the table since the numbers are so few here.
8:15 note here: if show the relative size of something, show the whole area but not on the radius of the circle. it's a common mistake!
8:45 to have an action title/ takeaway is above, especially the number in charts is crazy. it helps focus.
9:55 this show that how much 2% shows here.
they show the line flow through the top and bottom lines.
I like how those unusual charts look more sophisticated. But the most important is that they condense a lot of information from previous work. Even if the message conveys a given point, those charts are supportive to answer possible questions.
You're absolutely right. Even with a specific message in mind, it's important to include any data that might be relevant to provide the right context and answer related questions. The trick is displaying that data in a way that doesn't distract from the important parts of the chart, which I think they do well here.
For me the sophistication comes at a significant cost. Effective visualisation is about delivering key message(s) in an efficient, effective and transparent way to a diverse audience. For data laymen, waterfall or mekko visualisations can be difficult to understand at a first glance and add unnecessary complexity to the data story. Perhaps in a future state with more data education and literacy, they will be present more value.
@@jordanbjorn8409 I pretty much agree. Data illiteracy is a huge blocker to use those sophisticated charts.
However, there’s a reason why management consultants focused on strategy use them: they work with high level audiences, they want and need to bring unusual perspectives to discussion so they can be recognized for their typically intangible work, whose output is a set of recommendations written on a PPT.
Do you happen to know what tool/add in McKinsey and Bain are using to create these beautiful charts? Most of it can be done in Excel, but it's very time consuming customizing it.
That was so much useful insight in such a short video. Thanks Paul!
Nice breakdown and analysis. One thing I heard from other Consulting slide training RUclips videos is try to never reuse the same chart format or at least space there use throughout you presentation.
*their
What I found highly confusing about the last chart is that the 21% in the bottom left are also colored like the focused 2% of companies. Thus, for me it is still not clear if the bars on the right side, in total, reflect the 21% or 100% of companies. So do those 2% of companies yield 80% of the 400 or 1900 companies' value?
This chart is incredibly confusing. The leftmost column represents all 1900 companies, but the three columns to the right all represent the 400 companies with potential for privatization. So then 2% of companies yield 80% of the 400 companies' book value.
The way I got to this conclusion was by reading the top and bottom lines and making some assumptions: "400 could be privatized with $140B book value". I'm assuming that the second column represents the $140B, and therefore the 400 companies. Same with the 3rd and 4th columns.
But then afterwards I also realized it says it in the 2nd footnote. :)
@@AnalystAcademy love your stuff. I was hoping you were going to do some resuscitation on that last chart to show how much better it could be! it's not a good slide at all
Really appreciate your effort 👍👍👍
Do you know which font is used here?
It's called Bower - a font they made themselves. Looks really good in my opinion.
More info here: www.mckinsey.com/about-us/overview/our-new-identity
This was a great presentation! Thanks.
Thanks for the informative video. Can you please explain why they have not used equal time periods when grouping the years from 2000-2019; in the Column Chart ?
What aspect ratio is standard? Looks like these are quite tall like standard setting. Wide is the default but what’s normal?
Does Paul have a touch of cauli ear? If so, my respect!
Are these charts (and they look very complicated/sophisticated) done in MS PowerPoint or you use a different tool to create these stunning charts?
You can create these types of charts with think-cell
Great insights . Thanks
Great content
Really great, thanks for sharing!
You are welcome!
Great selection of charts. Modern and professional! Thanks!
Thank you!
The first chart was very confusing and I'm an analyst! If I was to present this to an executive team, I'm pretty sure I'd be asked to remove it on the first meeting!
Can't say I disagree with you. The 30M "transition to nonfarm jobs number" is a bit confusing and weirdly placed, making the chart a little harder to read. I don't know that I would put this in a presentation either, but it would depend on a number of factors, most critically my audience's familiarity with the content.
They us think-cell which is a plugin for powerpoint.
I'm infatuated with this. I had the pleasure of reading something similar, and I was completely infatuated. "The Hidden Empire: Inside the Private Worlds of Elite CEOs" by Adam Skylight
SUBSCRIBED BAM!
This is great content. Is there a tool to create these charts?
Thank you, glad you enjoyed the video! If you are asking about a tool to actually build the chart, I think the industry standard is Think-Cell. If you are looking for help in choosing and designing the chart, you might enjoy our video on charts here --> ruclips.net/video/pehzpJMqIPs/видео.html
@@AnalystAcademy are you able to repost this video? The link is listed as private
first time seeing your video. do you have links on how the charts are actually created? also where applicable the models used to create the charts?
Great video
Thank you!
I do not understand the remark regarding area and radius of the circle. The proportion of radiuses is directly proportional to its area by nature.
You're right, I misspoke in the video. The problem I meant to highlight is that when you're comparing two circles you want to compare them relative to their area, not the radius. For example when you want to show that one bubble is twice the size of another, make sure you don't just try to double the radius of the circle. That will not give you double the area.
In the first chart, isn't the 30 million shown in lighter blue at the top misaligned? It could have served a better purpose if they had put it right next to the 30 million decrease shown in dark blue. Because that is actually where it is impacting, it is offsetting the loss of farm jobs with an increase in non-farm jobs. I am assuming whichever Excel plug-in they have used has restricted them from doing it.
I don’t think it’s necessarily misaligned, but I do think that it looks a little strange where it is. I probably would have deleted the top box altogether and just changed the bottom box to be half of each color.
There is a lot of value to your offering and really like your approach, however, these charts were not as user-friendly on first read and didn’t keep my interest and I do this for a living :). These charts need a consultant to make clear the take-aways. I have found Bain have this area nailed the best. The curse of knowledge
I agree, especially for an article where you don't have someone explaining this to you.
I couldn't have excepted that ,I would be able to understand or not, but after watching whole video I understand whole video even I able to understand it's is easy to make this type of charts, just need a good sense of humour !!
that's a top one
Thank you!
In chart 3.17, You can however see that they did a crtical error. They put the 30 bar "transition to non-farm jobs" on the wrong side of the line. Therefor, I can only rate this chart 3/5. The error is significant and sloppy.
Action titles
I do not agree that these charts are great.... they neglect a golden rule, namely: only 1 message per slide. I have watched the first two slides and they confused me. So, this video is not presenting good examples...
I appreciate your perspective... thanks for sharing! I will agree with you that these charts aren't perfect, and that they're probably not as simple as they could be. But I also think there will inherently be some complexity just due to the underlying data and the complexity of the message itself. I would love to hear your thoughts on how you think the first two could have been better presented.
McInsaine
Lol. McKinsey. That's where DEI Pete Bootyfudge was hired. Lots of other ivy league clowns.