{"id":1873,"date":"2015-08-26T14:30:15","date_gmt":"2015-08-26T14:30:15","guid":{"rendered":"http:\/\/box5167.temp.domains\/~leapica1\/?p=1873"},"modified":"2023-03-09T18:42:44","modified_gmt":"2023-03-09T18:42:44","slug":"podcast-004-primp-your-slide-vol-1","status":"publish","type":"post","link":"https:\/\/zohf.me\/lp\/podcast-004-primp-your-slide-vol-1\/","title":{"rendered":"Primp Your Slide Vol. 1: Makeovers for Your Slides and Charts [Video]"},"content":{"rendered":"<h2>VIDEO PODCAST<\/h2>\n<p><iframe loading=\"lazy\" class=\"wistia_embed\" src=\"\/\/fast.wistia.net\/embed\/iframe\/48nx0e43k9?videoFoam=true\" name=\"wistia_embed\" width=\"650\" height=\"366\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><script src=\"\/\/fast.wistia.net\/assets\/external\/E-v1.js\"><\/script><\/p>\n<h2>AUDIO-ONLY PODCAST<\/h2>\n<p><iframe loading=\"lazy\" src=\"https:\/\/playlist.megaphone.fm?e=POD1122304789&amp;light=true\" width=\"100%\" height=\"200\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>Today\u2019s special video episode kicks off a new podcast series I\u2019ve created called \u201cPrimp Your Slide\u201d. I\u2019ll be making over crappy charts and stinky slides that you, my listener, will be sending in to me!<\/p>\n<p>When I was starting out as a digital analyst and marketer, I didn\u2019t have a set of tools at my disposal to help me ensure my data story was getting heard loud and clear.<\/p>\n<p>My goal is to empower you with an approachable, repeatable framework to apply best practice design principles, bring thoughtful context and purpose to your visuals.<\/p>\n<p>I\u2019ll take you through the methodology I\u2019ve created to help me create data visualizations and presentation slides that communicate my insights quickly, easily and accurately.<\/p>\n<p>And now, it\u2019s your turn. Click the link in the Resources section to submit your crappy chart or stinky slide for a free video makeover!<\/p>\n<p><strong>In This Episode, You\u2019ll Learn:<\/strong><\/p>\n<ul>\n<li>How I define the P.I.C.A. methodology of impactful, effective data visuals<\/li>\n<li>The right questions to ask to make sure your visual actually has a purpose<\/li>\n<li>Approaches for surfacing and insight and applying context and aesthetics to your work<\/li>\n<li>How you can assess your own charts or slides for alignment with the methodology<\/li>\n<li>How you can submit your own troublesome charts and sneaky slides for a free video podcast visualization renovation!<\/li>\n<\/ul>\n<p><strong>People, Resources and Links Mentioned In This Episode:<\/strong><\/p>\n<ul>\n<li>Submit your troublesome charts and slides <a href=\"https:\/\/leapica.com\/makeover\">here<\/a><\/li>\n<li>PowerPoint Makeovers by Laura M. Foley of <a href=\"http:\/\/www.lauramfoley.com\/\">Foley Designs<\/a><\/li>\n<li>The Digital Analytics Association\u2019s <a href=\"http:\/\/www.digitalanalyticsassociation.org\/thoughtleader\">Thought Leader Conversation with Avinash Kaushik<\/a><\/li>\n<li>My <a href=\"https:\/\/leapica.com\/DAADataVizRecording\">Data Visualization Webinar<\/a> with the Digital Analytics Association<\/li>\n<li><a href=\"http:\/\/www.amazon.com\/Show-Me-Numbers-Designing-Enlighten\/dp\/0970601999\/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0393347281&amp;linkCode=as2&amp;tag=lepi0f7-20&amp;linkId=4WFPRTGWPXQIUUOD\">Show Me The Numbers<\/a> by Stephen Few<\/li>\n<li>The<a href=\"http:\/\/www.amazon.com\/Street-Journal-Guide-Information-Graphics\/dp\/0393347281\/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0393347281&amp;linkCode=as2&amp;tag=lepi0f7-20&amp;linkId=4WFPRTGWPXQIUUOD\"> WSJ Guide to Information Graphics<\/a> by Dona M. Wong<\/li>\n<\/ul>\n<p>[bctt tweet=&#8221;PODCAST: Submit your crappy charts or stinky slides for a video #podcast makeover by @LeaPica! #dataviz #pbm&#8221;]<\/p>\n<p><strong>Upgrade Tip of the Day:<\/strong><\/p>\n<p>Have you ever needed to format a number of objects on different slides the same way, but keep having to repeat the same series of actions over and over? Like, changing multiple text boxes\u2019 font and size, or similar shapes\u2019 color?<\/p>\n<p>You can quickly repeat the last action you took on an Excel or PowerPoint object using<strong> CTRL-Y on PC, or CMD-Y on Mac<\/strong>. It\u2019s the shortcut for redo (opposite of undo, which is CTRL-Z).<\/p>\n<p><strong>Thanks for Listening!<\/strong><\/p>\n<p>Thanks so much for joining me. Have some feedback you\u2019d like to share? Leave a note in the comments below, and I\u2019ll be sure to get back to you!<\/p>\n<p>If you enjoyed this episode, please share it using the social media buttons you see at the left of this page.<\/p>\n<p><a href=\"https:\/\/itunes.apple.com\/us\/podcast\/present-beyond-measure-show\/id1029765276\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1496\" src=\"https:\/\/leapica.com\/wp-content\/uploads\/2015\/07\/LeaPica.com-Subcribe-to-Podcast-iTunes.jpg\" alt=\"LeaPica.com Subcribe to Podcast - iTunes\" width=\"220\" height=\"72\" \/><\/a>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<a href=\"http:\/\/stitcher.com\/s?fid=71393&amp;refid=stpr\"><img loading=\"lazy\" class=\"size-full wp-image-1498 alignnone\" src=\"https:\/\/leapica.com\/wp-content\/uploads\/2015\/07\/LeaPica.com-Subcribe-to-Podcast-Stitcher.jpg\" alt=\"LeaPica.com Subcribe to Podcast - Stitcher\" width=\"220\" height=\"72\" \/><\/a><\/p>\n<p>If you liked what you heard, <strong>I would love if you could <\/strong><a href=\"https:\/\/leapica.com\/PBMiTunes\"><strong>leave me a rating or review in iTunes<\/strong><\/a>. Ratings &amp; reviews are extremely appreciated and very important in the rankings algorithm. The more ratings, the better chance of fellow practitioners getting to hear this helpful information!<\/p>\n<p>And finally, don\u2019t forget to subscribe to the show via my newsletter in the blue bar below, or on <a href=\"https:\/\/leapica.com\/pbmitunes\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a> to get automatic updates and never miss a show.<\/p>\n<p>And as always, <strong>viz responsibly, my friends.<\/strong><\/p>\n<p><strong>Transcript:<\/strong><\/p>\n<p class=\"text-collapse\" style=\"cursor: pointer;\">Click here to view the transcript for this episode.<\/p>\n<div class=\"content\">\n<p><strong>Lea<\/strong>: Hey guys. Welcome to the 4th episode of the <strong>Present Beyond Measure Show<\/strong>. This is the first volume in the new video series I\u2019m trying out called <em>Primp Your Slide<\/em>. Free online makeovers of your charts and slides. So, the reason I\u2019m doing this is because of slides like this. I presented a slide just like this in a past life, well before I went on my journey to what I call presentation enlightenment. It\u2019s not the worst but it definitely is not the best, but it represents a time in my life before I had a keen understanding of the the brain\u2019s comprehension of data and it really didn\u2019t do anything for me or my meeting audience.<\/p>\n<p>And one of the most common requests I get from you guys is for step-by-step makeovers of slides and charts. Now, I recognize it\u2019s really hard sometimes to think of new ways to visualize your data without outside guidance or inspiration, which is why I\u2019m always on the lookout for inspiration myself, and this is also something my good friend Laura M. Foley of Foley Designs does on her website. That\u2019s for more general presentation and powerpoint questions but if you\u2019re interested in that definitely check her out as well. She\u2018s going to be on my show notes page at LeaPica.com\/004.<\/p>\n<p>So I decided to add this kind of format to my podcasts to change things up a little bit and see a more practical application of some of the principles that I will be talking about on this show in the future. So to put all of these principles into practice I\u2019m going to use a methodology I call <strong>P.I.C.A.<\/strong><\/p>\n<p>Why <strong>P.I.C.A<\/strong>? Well, I\u2019m not terribly good at creating witty acronyms and I swear this is not self serving. The words happen to fit the methodology really well. But selfishly I really, really want to give my married name a meaning other than a psychological disorder that makes you want to eat non-food items like paint and dirt. Yep &#8211; dirt.<\/p>\n<p>(That guy looks way too much like my Greek third cousin. But I digress\u2026.)<\/p>\n<p>So let\u2019s get started. So to give you some background, this is actually a version of the slide I presented at a meeting many years ago. I\u2019ve obscured the data of course. Now, quick thing if you\u2019re listening to this in your car, through itunes, there is a video that accompanies this but you\u2019ll still get a lot of value if you\u2019re just listening. You can always visit the show notes page to watch the actual video. So I\u2019ve obscured the data from this of course and I\u2019m pretty sure this was my executive\u2019s reaction when I presented it. So let\u2019s go through the methodology to kinda whip this guy into shape.<\/p>\n<p>We\u2019re going to start with <strong>P<\/strong> which is <strong>Purpose<\/strong>. When I see graphs like this, and I see them a lot, I try to think to myself, \u201cWhy does this exist? Does it answer a burning question that my executives or clients have?\u201d It may answer a question they asked you. You know executives are always begging for visits, just counts of visits or even worse, hits. Huh huh. But you know what happens, when executives see a slide like this? They may nod enthusiastically but what they\u2019re really thinking is, \u201cSo what?\u201d<\/p>\n<p>So that\u2019s why this part of the methodology doesn\u2019t actually involve primping anything on the slide or the chart. It\u2019s about asking this very important question &#8211; \u201cWhat are my stakeholders really asking me for? Why are they asking me for this data? What decision can my data help them inform?\u201d And in this context, here is an answer that is getting a little closer to the heart of what they actually wanted, \u201cHow do our marketing channels compare in share of sales?\u201d<\/p>\n<p>Ok, now we have something we can work toward that\u2019s a little more actionable. But we\u2019re going to have to change the data a bit now. Back to the slide. I\u2019ll tell you first what doesn\u2019t have a purpose here, and that\u2019s the pie chart. For many reasons I won\u2019t get into here and now, I don\u2019t ever, ever use these. A table is actually a better option here so we\u2019re going to start with that, but we\u2019re not going to finish with that. Little more on that later.<\/p>\n<p>First, we\u2019re going to need to change the actual data into percent share of sales. So the presentation of this data still isn\u2019t doing it for me. We\u2019re going to go to the second step of the P.I.C.A. methodology and that is <strong>I<\/strong> for <strong>Insight<\/strong>. A lot of graphs that I see are just statements about something. Conversion rate by channel. Media spend by quarter. These are just statements, but as Avinash Kaushik mentioned on a recent thought leader conversation with the <a href=\"http:\/\/www.digitalanalyticsassociation.org\/\">Digital Analytics Association<\/a>, and I\u2019ll put a link to that on my show notes page as well, he said something really interesting. He said, \u201cAnalysts need to be able to distinguish between data and insights.\u201d So what does he mean by that exactly? By definition, an insight is the capacity to gain an accurate and deep intuitive understanding of a person or a thing, and that\u2019s not what this slide achieves for us. Maybe everyone on your team is always talking about how great email is and it\u2019s what the company spends a lot of time and resources on. But here it may be pointing out that email is only third on this list but we really wouldn\u2019t be doing our team a favor if we just stopped here.<\/p>\n<p>This isn\u2019t the whole story and that is the next stop in our methodology which is <strong>C <\/strong>is for<strong> Context.<\/strong> You have your share of sales. Is that good? Is it different than last month? Last year? How does that line up with our targets? How does that play into the context of our business? Having that metric alone really doesn\u2019t allow us to understand what is actually going on here. So here\u2019s a question that we can apply some context. Is there a better metric or second metric that can help us understand our performance? In this case how about we add in \u201cHow do our channel conversion rates compare?\u201d Volume alone really doesn\u2019t tell the whole data story. Here we\u2019re going to add a second table that has conversion rates and Whoah!&#8230; that\u2019s an interesting story now. Email converts way higher than any other channel. This is starting to flesh out an understanding of our marketing portfolio that\u2019s well beyond a count of visits, right?<\/p>\n<p>OK, so now, the title of our slide here is still just a statement about what the slide is showing. This does nothing for your audience. So I\u2019m going to swap it out with an observation or an assessment of what the data actually means. This is called a McKinsey Title, and it will help guarantee that no matter how your audience has interpreted your chart, the meaning of your data is clear. The first part is a meaningful assessment of the data. It\u2019s your power statement.<\/p>\n<p>And underneath you have a smaller statement of what the data represents just in case people aren\u2019t sure what it is. This is also really helpful for when someone might take things out of context or forward someone a screenshot of just this slide to someone else on your team without you there to guide them. Now I realize you\u2019re probably forwarding your presentation slides as is to your team afterwards, and in a few episodes I\u2019m actually going to be talking about why there is a better way to deliver that information, but that\u2019s for another day.<\/p>\n<p>So for now we\u2019re going to bring this all home with our last step in the methodology which is <strong>A <\/strong>for<strong> Aesthetics<\/strong>. Before you present your next chart or slide, I\u2019d like for you to ask yourself, \u201cIs this chart easy to understand? Will my audience get it? Does you viz follow best practice guidelines for data visualization? Does the color palette compliment my brand, help deliver my information, or does it create interference with my message like radio static?\u201d<\/p>\n<p>Something I found pretty shocking during my journey was that a few years ago the ICIA did a study and found that of professionals who count presentation as part of their jobs, only 7% of them had any experience in visual design and yet I would argue that this is a pretty critical skill to apply if you want your information understood quickly and effectively.<\/p>\n<p>On a recent webinar I did with the Digital Analytics Association I talked about how I kept saying the word \u201cviz\u201d and \u201cmistake\u201d over and over again while I was creating it and I accidently coined the term \u201cviz-take,\u201d [laugh] meaning a data visualization that fails in communicating its key message accurately, quickly and easily, which is what every slide and chart should aspire to do. So common use for this might be, \u201cWow, I\u2019ll never get my life back after trying to understand that viz-take.\u201d So, you kinda get where I\u2019m going with that and if you have any examples of terrible viz-takes definitely tweet it out and #Viz-take. Let\u2019s see where that goes.<\/p>\n<p>So learning to avoid some of the viz-takes that we saw in our earlier chart includes first detoxing your slide and chart of clutters like company logos, template bars, page numbers and all other kinds of doodads that just add noise to your visual. Changing the tables to a bar chart, and this is much easier to read and rank the data, but you\u2019re going to want to sort that bar and also detox your default charts settings of legends, gridlines and axis and things like that.<\/p>\n<p>You\u2019re going to want to select a more impactful font. The default font is Calibri. I think we can go beyond that to set ourselves apart with a different font. Increase the size for readability. Select a more neutral color for your baseline data and finally, use a standout color to highlight your key insight. I\u2019m going to be talking a lot more about the impact color has on the brain and how to use it in your data in a few episodes when we go through detoxing and powering up your charts so stay tuned for that.<\/p>\n<p>But for now, let\u2019s take a look at this slide before where we started, huh huh. And where we landed after applying the P.I.C.A. methodology. Hopefully you agree that this will work a lot better to communicate my information and I wish I had presented it that way but hindsight is always 20\/20 and if you agree or don\u2019t, please let me know.<\/p>\n<p>Now if you\u2019re new to data viz like this but you want to avoid making some common viz-takes<\/p>\n<p>there are a couple great ways to learn more about these principles. If you\u2019re a member of the DAA, and you didn\u2019t catch my webinar on data visualization in July definitely check that out. The link to the recording for that is LeaPica.com\/DAADataVizrecording and that link will also be on the show notes page for this episode at LeaPica.com\/004.<\/p>\n<p>Some other great resources you can check out are the <em>Wall Street Journal Guide To Information Graphics<\/em> by <a href=\"http:\/\/donawong.com\/\">Dona M. Wong<\/a>. Fantastic starter book to this. Sort of the gateway book to this whole field. Also <em>Show Me The Numbers<\/em> by Stephen Few this is a compendium of these principles. Both of those will extremely elevate your graphics to a new level. So those will also be on my show notes page.<\/p>\n<p>So let\u2019s take a minute to quickly recap the P.I.C.A. methodology. First, <strong>Purpose<\/strong>. Ask yourself &#8211; \u201cWhy does this exist? Why am I showing this? Is it just to serve an ask or is there a real reason?\u201d <strong>Insight<\/strong> &#8211; beyond just stating what the chart says, what does it actually mean?<\/p>\n<p><strong>Context<\/strong> &#8211; Am I showing the full story or is there other information that\u2019s going to complete the picture and help better informed decisions? And last but certainly not least, <strong>Aesthetics. <\/strong>It is SO important to learn data visualization best practices so that your audience can quickly grasp your information and focus their attention on your insights.<\/p>\n<p>So, we just went through my P.I.C.A. methodology and primped my own slide, but now it\u2019s your turn. I would love to see your naughty charts or slides and help you figure out how to tune them up and make them hum. It\u2019s completely free and your question or challenge may actually help others in the measure and marketing community too. So to submit your own work for a tune up please visit LeaPica.com\/makeover and upload your files via the cute little form there.<\/p>\n<p>Just a couple of ground rules when you\u2019re submitting to the Primp Your Slide segment. First, I\u2019ll accept files with up to three slides or charts. Nothing more than that, or else you\u2019ll have to hire me. When you do, please give a very detailed description of what your file represents, who your target audience is and what it is you\u2019re struggling with. I want to make sure I thoroughly understand your goals when I take a crack at fixing up your stuff. Now I won\u2019t be going through every step of the methodology for every makeover, some will maybe only need one or two steps applied, but over time we\u2019re going to start to see how you can view all of your visualizations and slides through this lens.<\/p>\n<p>OK, now this is extremely important. Please, please DO NOT submit files with proprietary or confidential data. I really don\u2019t want to accidentally broadcast your company&#8217;s annual earnings before they do so please make sure to scrub your files for any sensitive information. And if you want to submit a general question without a slide for the show that\u2019s totally fine too. I would like to be able to do regular Q&amp;A episodes as well to address what it is you need help with the most.<\/p>\n<p>Or if you want to come up with a better name for the methodology and submit that I am totally open to suggestions. And the last thing I\u2019ll say is, please don\u2019t be shy. We all have struggles to communicate our information. I still do on a daily basis. Please make sure to comment on these episodes with any thoughts or approaches that you have as well. Sharing our challenges and coming up with solutions together are what\u2019s going to take all of us and learn and grow as practitioners, right? Nice.<\/p>\n<p><strong>The Upgrade<\/strong><\/p>\n<p>And now we\u2019ve reached the segment I call the upgrade &#8211; some kind of power tip for powerpoint, excel, taplow &#8211; something to supercharge your work and get things done faster and better.<\/p>\n<p>Have you ever needed to format a number of objects on different slides the same way but keep having to repeat the same series of actions over and over, like changing text boxes or the font and their size or a shape\u2019s color? Did you know that you can quickly repeat the last action you took on an excel or powerpoint object? All you have to do is hit control-Y on a PC or command-Y on Mac. This is the shortcut for redo. The opposite of undo, which is control-X, and this is SO fast when you have to make a lot of the same changes on multiple slides. So thanks so much to Tim Wilson of <a href=\"http:\/\/analyticsdemystified.com\/\">Analytics Demystified<\/a> for cluing me in to that trick. It has saved me tons of time.<\/p>\n<p>Alright. That\u2019s all I\u2019ve got for you today. Thank you so much for listening to this special edition of the <strong>Present Beyond Measure Show<\/strong>. If you like what you\u2019ve heard, please hop on over to itunes to subscribe, leave a rating or review. Ratings and reviews are extremely appreciated because they affect the rankings of the show and I will be reading out all my favorite ones on future episodes so just click that ratings and reviews tab right in itunes.<\/p>\n<p>And if you want to continue the conversation and see the show notes for this episode you can visit me at LeaPica\/004 to review the show notes and find all the resources I\u2019ve mentioned today. You can also sign up for my newsletter which has tons of exclusive tips and techniques for presenting your data. You can find one at the bottom of my page, at the top, all over the place. And when you sign up, you\u2019ll also never miss an episode of the <strong>Present Beyond Measure Show. <\/strong><\/p>\n<p>So I would love if you can leave me a comment or suggestion because I want to hear about the challenges that you face when you are presenting information or doing visualizations quickly or anything you\u2019d like me to talk about here, or you can tweet me a question for this show by including my twitter handle which is @leapica and including the hashtag #PBM as in <strong>Present Beyond Measure.<\/strong><\/p>\n<p>By the way, you might be wondering why I had an entire bottle of olive oil in my purse to begin with and I think I\u2019m going to let you fill in the blanks here and let that marinate a bit. Oooh. [laugh] I\u2019ll be here all night. Seriously though. Since I\u2019m on a fairly restricted version of the Paleo diet I always have to be ready with organic olive oil and sea salt, and all other kinds of crazy seasonings I keep in my bag when I go out to eat. But next time maybe finding a bottle with a more secure cap would be good.<\/p>\n<p>So I\u2019ll leave you today with today\u2019s presentation inspiration which is from the magical Stephen Few and that is, \u201cGive a clear voice to the numbers that tell the story of your organization and clear visibility to the opportunities those numbers reveal.\u201d<\/p>\n<p>Let\u2019s look at these slides and charts as opportunities. Not just slides and charts. Til next time. Namaste.<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h2><strong>Do you have a crappy chart or stinky like you\u2019d like me to makeover? <\/strong><strong><a href=\"https:\/\/leapica.com\/makeover\">Submit it<\/a><\/strong><strong> today!<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>VIDEO PODCAST AUDIO-ONLY PODCAST Today\u2019s special video episode kicks off a new podcast series I\u2019ve&#8230;<\/p>\n","protected":false},"author":2,"featured_media":1874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[174,57,53,70,60],"tags":[],"_links":{"self":[{"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/posts\/1873"}],"collection":[{"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/comments?post=1873"}],"version-history":[{"count":1,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/posts\/1873\/revisions"}],"predecessor-version":[{"id":48539,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/posts\/1873\/revisions\/48539"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/media\/1874"}],"wp:attachment":[{"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/media?parent=1873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/categories?post=1873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/tags?post=1873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}