Dan Galletta
Dan Galletta
  • Видео 48
  • Просмотров 885 622
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...
Просмотров: 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

Комментарии

  • @MarcelaKPreininger
    @MarcelaKPreininger День назад

    Thank you!

  • @MarcelaKPreininger
    @MarcelaKPreininger День назад

    fantastic! Thank you!

  • @NikSept14
    @NikSept14 4 дня назад

    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

    • @DanGalletta
      @DanGalletta 4 дня назад

      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

  • @wadoku24
    @wadoku24 7 дней назад

    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!

    • @DanGalletta
      @DanGalletta 5 дней назад

      Thanks so much! Can’t believe it got 1,000 likes!

  • @fayezfamfa
    @fayezfamfa 10 дней назад

    Thank you data ... very informative

    • @DanGalletta
      @DanGalletta 9 дней назад

      Glad it was helpful Fayez!

  • @clk1977
    @clk1977 11 дней назад

    bless this man for sharing his knowledge! i've been learning so much from your videos.

    • @DanGalletta
      @DanGalletta 11 дней назад

      Awesome to hear! Keep on learning!

  • @catharinabhler7242
    @catharinabhler7242 13 дней назад

    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?

    • @DanGalletta
      @DanGalletta 11 дней назад

      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

  • @DanGalletta
    @DanGalletta 14 дней назад

    💥 The charting and visualization video has been published! ruclips.net/video/f-StupRcK8M/видео.html

  • @karinalopezhuitron6003
    @karinalopezhuitron6003 14 дней назад

    ❤❤❤❤

    • @DanGalletta
      @DanGalletta 14 дней назад

      Hope you liked it Karina!

  • @aswinr9092
    @aswinr9092 15 дней назад

    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?

    • @DanGalletta
      @DanGalletta 14 дней назад

      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.

  • @user-ge5df4yo7y
    @user-ge5df4yo7y 17 дней назад

    Great Videos, Dan! Which tools / software do you use for the hand written and animated sketches?

    • @DanGalletta
      @DanGalletta 16 дней назад

      Thank you! It’s just an iPad and an app called Good Notes

  • @kkbava67
    @kkbava67 18 дней назад

    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!

    • @DanGalletta
      @DanGalletta 18 дней назад

      That’s a great option when you don’t need multiple people to work on the same storyline, awesome!

  • @janetbutts7132
    @janetbutts7132 19 дней назад

    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!

  • @mrchndfyza3245
    @mrchndfyza3245 19 дней назад

    Thanks, it helps a lot

  • @CloudNativeJanitor
    @CloudNativeJanitor 19 дней назад

    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

    • @DanGalletta
      @DanGalletta 19 дней назад

      Definitely a report, spot on!

  • @solarwinds-
    @solarwinds- 20 дней назад

    It is more enjoyable if controversial subjects are left out. Solving homelessness is a divisive subject. Politics do not enter into Powerpoint storytelling.

    • @DanGalletta
      @DanGalletta 19 дней назад

      I will keep that in mind, thanks for the feedback!

  • @Stevie74133
    @Stevie74133 20 дней назад

    Thanks so much this saved me !!

  • @Lvly_Amariii
    @Lvly_Amariii 20 дней назад

    yes, please share the video on translating data on visualization

  • @YourAvgRunner
    @YourAvgRunner 20 дней назад

    Can we do the same when we report engagement metrics?

    • @DanGalletta
      @DanGalletta 20 дней назад

      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

    • @YourAvgRunner
      @YourAvgRunner 20 дней назад

      @@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!

  • @MariahDoesRandomArt
    @MariahDoesRandomArt 21 день назад

    MY LORD I LOVE YOU

  • @karinalopezhuitron6003
    @karinalopezhuitron6003 21 день назад

    Is there a way to recreate a tree map from excel tothinkcell?

  • @pratikmanavi
    @pratikmanavi 23 дня назад

    experts in ppt 👏👏👏

    • @DanGalletta
      @DanGalletta 22 дня назад

      I’m not sure if I love or hate this comment hahah

  • @karinalopezhuitron6003
    @karinalopezhuitron6003 24 дня назад

    Dan, you totally rock! Greetings from Mexico

  • @chinthamansharmila1779
    @chinthamansharmila1779 24 дня назад

    wonderful illustration, thank you for such a great video

  • @camilaloayza0012
    @camilaloayza0012 24 дня назад

    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 :)

    • @DanGalletta
      @DanGalletta 24 дня назад

      Camila, thanks SO much for your message. It’s so nice to hear and I’m glad that you’re finding them useful!

  • @MadAboutCakesManila_PH
    @MadAboutCakesManila_PH 25 дней назад

    Yes please.. Kindly create a vid about data storytelling. Thank you

  • @manuelaloaeza3949
    @manuelaloaeza3949 25 дней назад

    Loved the clarity!

  • @flyingsalmon
    @flyingsalmon 28 дней назад

    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.

    • @DanGalletta
      @DanGalletta 26 дней назад

      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!

    • @flyingsalmon
      @flyingsalmon 26 дней назад

      @@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.

    • @DanGalletta
      @DanGalletta 22 дня назад

      @@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 :)

  • @pamelabustamante2398
    @pamelabustamante2398 Месяц назад

    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?

    • @DanGalletta
      @DanGalletta Месяц назад

      Thanks Pamela! It’s still coming, trying to find some time to film 😣

  • @anecdotecentral
    @anecdotecentral Месяц назад

    This was very useful, thank you so much for sharing

  • @nrjmatta
    @nrjmatta Месяц назад

    Very well presented Dan 👍 Loved the way you presented it!

    • @DanGalletta
      @DanGalletta Месяц назад

      Thank you so much Neeraj!

  • @karinalopezhuitron6003
    @karinalopezhuitron6003 Месяц назад

    How would you it for an area lower-upper bound…

  • @karinalopezhuitron6003
    @karinalopezhuitron6003 Месяц назад

    More of thinkcell videos ❤❤❤

  • @kriti6669
    @kriti6669 Месяц назад

    Thnku soo much .... ❤❤❤

  • @NeelShah-vg7yt
    @NeelShah-vg7yt Месяц назад

    Excellent

  • @LaurieCawthorn
    @LaurieCawthorn Месяц назад

    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.

  • @AZNGoSu
    @AZNGoSu Месяц назад

    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

  • @vivbn_uk
    @vivbn_uk Месяц назад

    What is Elements and how did you you add the Elements in your Powerpoint?

    • @DanGalletta
      @DanGalletta Месяц назад

      It’s called Think-Cell and it’s an add on to PowerPoint

  • @flourishwithMJ
    @flourishwithMJ Месяц назад

    Thanks.

  • @flourishwithMJ
    @flourishwithMJ Месяц назад

    Helpful. Thanks.

  • @flourishwithMJ
    @flourishwithMJ Месяц назад

    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.

    • @DanGalletta
      @DanGalletta Месяц назад

      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 :)

  • @flourishwithMJ
    @flourishwithMJ Месяц назад

    Clear explanation that makes sense. Thank you, Dan.

    • @DanGalletta
      @DanGalletta Месяц назад

      Thanks for all the positive comments MJ!

  • @flourishwithMJ
    @flourishwithMJ Месяц назад

    Thank you

  • @flourishwithMJ
    @flourishwithMJ Месяц назад

    Thank you

  • @ozzyvega
    @ozzyvega Месяц назад

    Great Video Dan 👍🏻

  • @Spotofgardening
    @Spotofgardening Месяц назад

    Hugely valuable conent!

  • @andrewlong9991
    @andrewlong9991 Месяц назад

    Great for what but nothing for how

    • @DanGalletta
      @DanGalletta Месяц назад

      Would you like a video showing how to create a waterfall chart?

  • @olliehart9302
    @olliehart9302 Месяц назад

    so helpful, thank you Dan

  • @mihaelaiovan3316
    @mihaelaiovan3316 Месяц назад

    În ce varianta de excel lucrați?