- Видео 48
- Просмотров 885 622
Dan Galletta
Австралия
Добавлен 17 дек 2020
Advice from a reformed management consultant and corporate strategist.
How to choose the best chart for your data EVERY time
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree
🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/
🏞️ The Business Strategy & Consulting Template Pack (176+ slides, 527+ shapes, 952+ icons): slidescience.co/slide-templates/
In this video, we'll learn about the 4 types of insights (comparisons, relationships, distributions, and compositions). And we'll how to choose the best chart or visualization for your data using the Slide Science Charting Decision Tree.
Chapters:
0:22 - Comparisons
2:14 - Relationships
3:24 - Distributions
5:05 - Compositions
Any materials mentioned or shown have been obtained through...
🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/
🏞️ The Business Strategy & Consulting Template Pack (176+ slides, 527+ shapes, 952+ icons): slidescience.co/slide-templates/
In this video, we'll learn about the 4 types of insights (comparisons, relationships, distributions, and compositions). And we'll how to choose the best chart or visualization for your data using the Slide Science Charting Decision Tree.
Chapters:
0:22 - Comparisons
2:14 - Relationships
3:24 - Distributions
5:05 - Compositions
Any materials mentioned or shown have been obtained through...
Просмотров: 1 571
Видео
Why you should NEVER use pie charts (use this instead)
Просмотров 4,6 тыс.3 месяца назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we'll discuss why pie charts are often banned by consulting firms, ...
The one rule EVERY slide must follow
Просмотров 17 тыс.6 месяцев назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, you'll learn the Golden Rule of slide building, the two most common...
Presentation Flow: 3 Tricks That Consultants Use
Просмотров 11 тыс.7 месяцев назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, you'll learn three techniques that consultants use to improve prese...
The Pyramid Principle for Presentations & Slides (with Examples)
Просмотров 17 тыс.8 месяцев назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we look at Barbara Minto's Pyramid Principle and how you can apply ...
How To Use Waterfall Charts: 3 Types With Real Examples
Просмотров 38 тыс.9 месяцев назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, you'll learn the three different types of waterfall charts (also kn...
Storytelling in PowerPoint: Learn McKinsey’s 3-Step Framework
Просмотров 402 тыс.9 месяцев назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, you'll learn how to storyline in PowerPoint, just like McKinsey, BC...
The 3 Rules For Writing Perfect Slide Action Titles (Like McKinsey)
Просмотров 19 тыс.Год назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, you'll learn how to write action titles for your slides that are gu...
Add A Comparison Column To Waterfall Charts in Think-Cell
Просмотров 8 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we show you how to add a comparison column to a waterfall chart (al...
How To Write Killer Executive Summaries For Your Slide Deck [BCG Example]
Просмотров 4,7 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we cover three principles that BCG uses to write compelling Executi...
Build Butterfly Charts (Tornado Charts) in Think-Cell
Просмотров 5 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we show you how to build butterfly charts (also known as tornado ch...
McKinsey & Co Slide Breakdown: Global Trade Flows
Просмотров 2,6 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we break down and rebuild a real-world McKinsey slide deck to learn...
The Ultimate Guide to Gantt Charts (Timelines) in Think Cell
Просмотров 14 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video, we cover everything you need to know about Gantt charts (also known...
Live Slide Building: Three Panel Slide Showing Industry Revenue Over Time (PowerPoint + Think-Cell)
Просмотров 9 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video I build a live PowerPoint slide using Think-Cell. This time we build...
Live Slide Building: Line Chart Showing Bull vs Bear Case (PowerPoint + Think-Cell)
Просмотров 9 тыс.2 года назад
🏙️ The Free Charting Decision Tree: get.slidescience.co/charting-decision-tree 🎇 The Slide Science System (online course, slide templates, eBook, cheatsheets and more): slidescience.co/system/ 🏞️ The Business Strategy & Consulting Template Pack (176 slides, 527 shapes, 952 icons): slidescience.co/slide-templates/ In this video I build a live PowerPoint slide using Think-Cell. The slide shows a ...
The Ultimate Guide to Mekko Charts in Think Cell
Просмотров 3,6 тыс.2 года назад
The Ultimate Guide to Mekko Charts in Think Cell
How to add series CAGRs in think-cell
Просмотров 4,8 тыс.2 года назад
How to add series CAGRs in think-cell
Quickly paste activity labels in Gantt charts in think-cell
Просмотров 2,5 тыс.2 года назад
Quickly paste activity labels in Gantt charts in think-cell
Compare values with a target in think-cell
Просмотров 4 тыс.3 года назад
Compare values with a target in think-cell
4 Quick Multi-Select Shortcuts in think-cell
Просмотров 2,2 тыс.3 года назад
4 Quick Multi-Select Shortcuts in think-cell
The Ultimate Guide to Waterfall Charts in Think-Cell
Просмотров 32 тыс.3 года назад
The Ultimate Guide to Waterfall Charts in Think-Cell
Ultimate Guide to Scatter Charts in Think-Cell
Просмотров 4,9 тыс.3 года назад
Ultimate Guide to Scatter Charts in Think-Cell
Live Slide Building: Waterfall Chart Showing Expense Growth (PowerPoint + Think-Cell)
Просмотров 14 тыс.3 года назад
Live Slide Building: Waterfall Chart Showing Expense Growth (PowerPoint Think-Cell)
Live Slide Building: Revenue Composition Using a Mekko Chart (PowerPoint + Think-Cell)
Просмотров 2,7 тыс.3 года назад
Live Slide Building: Revenue Composition Using a Mekko Chart (PowerPoint Think-Cell)
Quickly Build Process Flows In Think-Cell
Просмотров 2,6 тыс.3 года назад
Quickly Build Process Flows In Think-Cell
How To Add Sub-Chapters To Think Cell Agendas
Просмотров 8 тыс.3 года назад
How To Add Sub-Chapters To Think Cell Agendas
How To Add Dynamic Think Cell Agendas Into PowerPoint Slides
Просмотров 3 тыс.3 года назад
How To Add Dynamic Think Cell Agendas Into PowerPoint Slides
Add Error Bars to Line Charts in Think-Cell
Просмотров 4,4 тыс.3 года назад
Add Error Bars to Line Charts in Think-Cell
Word Counts for PowerPoint Slides and Notes in 2 Minutes
Просмотров 7 тыс.3 года назад
Word Counts for PowerPoint Slides and Notes in 2 Minutes
How To Embed A YouTube Video In PowerPoint In 2 Minutes
Просмотров 1793 года назад
How To Embed A RUclips Video In PowerPoint In 2 Minutes
Thank you!
fantastic! Thank you!
I came with the mindset, Oh man, Pie isn't so bad, but let me still watch coz I have absolutely Loved Dan's other videos in this playlist Compelled to say I agree once again, completely, especially after the rationale shared about Visual Ambiguity, Clutter, and Scalability issue. I just feel that maybe pie isn't so bad if it is 3-4 categories and sometimes just helps break the monotony from those square rectangle lines/bars/shapes in these 6: Column Charts, Stacked Column Charts, 100% Stacked Column Charts Bar Charts, Stacked Bar Charts, 100% Stacked Bar Charts
Haha thank you mate! You’re right too, as long as you can avoid the major issues then using pie charts is not the end of the world and can break things up
Dear Dan, I am happy to be person # 1000 to like this video,- this is really well done, thanks a lot! BTW, also loved the SCQR / SCR video!
Thanks so much! Can’t believe it got 1,000 likes!
Thank you data ... very informative
Glad it was helpful Fayez!
bless this man for sharing his knowledge! i've been learning so much from your videos.
Awesome to hear! Keep on learning!
Trying to figure out what kind of revenue waterfall chart would make sense to use for visualizing the expected monthly sales of premium games. It might be an idea to highlight amount of discounted sales done versus full-price sales. This game is not SaaS, and most likely have no DLCs. It's definitely not these in the video (they were great to see though). Any suggestions to the type I need to look for?
Are you sure that a waterfall chart is the best chart for your use-case? Maybe it’s a simple as a stacked column chart
💥 The charting and visualization video has been published! ruclips.net/video/f-StupRcK8M/видео.html
Thank you
❤❤❤❤
Hope you liked it Karina!
Hi Dan, I was under the assumption that during the analysis stage, consultants worked with PowerPoint to brainstorm and generate final slides (except recommendations). What would be the best practice for documentation during the case analysis and synthesis stage?
In my experience, it's best to do analysis and synthesis in Excel or Word, and only use PowerPoint once you've finished those things. Instead of brainstorming slide design etc in PowerPoint, we would hand draw them on paper or on a whiteboard.
Great Videos, Dan! Which tools / software do you use for the hand written and animated sketches?
Thank you! It’s just an iPad and an app called Good Notes
Thank you for introducing the SCR! Just a small variation - I dont start with Word documents to create my dots and dashes, but use Powerpoint Outline Mode for doing exactly the same. I save myself the trouble of copy-pasting from Word into Powerpoint!
That’s a great option when you don’t need multiple people to work on the same storyline, awesome!
It's so obvious that we should create the outline in Word first, yet I've never done that. I just usually dive right in. Thanks!
Thanks, it helps a lot
Loved it, great way to start and refine, we have a similar system at AWS, however, our titles and body of slides are less noisy, concise or visual, that Deck was so noisy and less visual. More of a report
Definitely a report, spot on!
It is more enjoyable if controversial subjects are left out. Solving homelessness is a divisive subject. Politics do not enter into Powerpoint storytelling.
I will keep that in mind, thanks for the feedback!
Thanks so much this saved me !!
yes, please share the video on translating data on visualization
Coming next week!
Can we do the same when we report engagement metrics?
If it’s just a reporting slide deck then you don’t necessarily need the SCR structure, especially if you’re just updating the same slide templates with new data
@@DanGalletta I guess my question is more like how would consultants share such reports with their clients in a way that shows true value? Thank you!
MY LORD I LOVE YOU
Is there a way to recreate a tree map from excel tothinkcell?
experts in ppt 👏👏👏
I’m not sure if I love or hate this comment hahah
Dan, you totally rock! Greetings from Mexico
wonderful illustration, thank you for such a great video
My pleasure!
I just found your videos, and I wanted to tell you that they are incredibly helpful! I have one more year of university left, and I have been trying to gain as many skills as possible to be able to have a future in consulting. Thank you so much! You also seem super passionate about what you do, which is really nice to see :)
Camila, thanks SO much for your message. It’s so nice to hear and I’m glad that you’re finding them useful!
Yes please.. Kindly create a vid about data storytelling. Thank you
Filmed it today!
Loved the clarity!
Thanks so much Manuela!
Excellent explanation and tips. However, can you please share examples of how to shape the data in Excel for each of the 3 types (a link to a file containing sample datasets would be helpful)? Many thanks.
Thanks mate, I actually use think-cell to create the charts in PPT so the data structure would be different to native excel charts. But I’ll see what I can do!
@@DanGalletta Thanks. So far, I find that waterfall can only handle one numeric dataseries, if that's correct, then I'm good. If not, I'd like to see how it can be done with multiple data series. Cheers.
@@flyingsalmon It can be done with think-cell. You will have a stacked column for each part of the waterfall. If you're using think-cell, then you can find more information in their user manual :)
Dan excelent video, its clear and goes to the point. Thanks for charing. Did you do the vídeo about how to translation information into a visual presentation?
Thanks Pamela! It’s still coming, trying to find some time to film 😣
This was very useful, thank you so much for sharing
Thanks very much!
Very well presented Dan 👍 Loved the way you presented it!
Thank you so much Neeraj!
How would you it for an area lower-upper bound…
More of thinkcell videos ❤❤❤
Thnku soo much .... ❤❤❤
Excellent
Cheers mate!
significant key words, suggest, imply, indicates, refer, point to , associate..The term “implication” refers to the indirect consequences or effects that result from a specific action or any statement.
Whenever you got lost in your slide building and storylining with all the data and conflicts and direction it’s super helpful to bubble it up to SCR to see if it makes sense
Spot on 💯
What is Elements and how did you you add the Elements in your Powerpoint?
It’s called Think-Cell and it’s an add on to PowerPoint
Thanks.
No probs MJ!
Helpful. Thanks.
No probs!
Dan, you're excellent and relatable at explaining as though you're presenting to me directly. Please consider teaching on LinkedIn Learning so you can widen your platform and make it mainstream. You may also consider adding other topics to teach related to crafting clear, concise, and compelling presentations such as powerful business writings on email (by situation), delivering regular progress updates to executives, business report writing, and clear everyday business communications. Include the thought process on how to organize ideas and thoughts. Thank you.
Thanks so much for the comment MJ. I do plan on adding some of those topics soon! And I’ll look into LinkedIn Learning too :)
Clear explanation that makes sense. Thank you, Dan.
Thanks for all the positive comments MJ!
Thank you
My pleasure MJ!
Thank you
Thanks for watching MJ!
Great Video Dan 👍🏻
Cheers mate!
Hugely valuable conent!
Thanks so much!
Great for what but nothing for how
Would you like a video showing how to create a waterfall chart?
so helpful, thank you Dan
În ce varianta de excel lucrați?