{"id":48084,"date":"2021-11-30T17:30:25","date_gmt":"2021-11-30T22:30:25","guid":{"rendered":"https:\/\/leapica.com\/?p=48084"},"modified":"2021-11-30T17:30:25","modified_gmt":"2021-11-30T22:30:25","slug":"podcast-074-steen-rasmussen","status":"publish","type":"post","link":"https:\/\/zohf.me\/lp\/podcast-074-steen-rasmussen\/","title":{"rendered":"Ann K. Emery Drops her Top Do&#8217;s and Don&#8217;ts of Dashboard Design"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;3.22&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_header title=&#8221;Ann K. Emery Drops her Top Do&#8217;s and Don&#8217;ts of Dashboard Design&#8221; subhead=&#8221;Present Beyond Measure Ep. 073&#8243; text_orientation=&#8221;center&#8221; header_fullscreen=&#8221;on&#8221; background_overlay_color=&#8221;rgba(31,39,81,0.73)&#8221; admin_label=&#8221;Fullwidth Header&#8221; module_class=&#8221;blog-hero-section&#8221; _builder_version=&#8221;4.14.1&#8243; title_text_color=&#8221;#ffffff&#8221; title_letter_spacing=&#8221;5px&#8221; title_line_height=&#8221;1.1em&#8221; subhead_text_color=&#8221;#76c8d6&#8243; subhead_font_size=&#8221;25px&#8221; background_image=&#8221;https:\/\/leapica.com\/wp-content\/uploads\/2021\/11\/Ann-K-Emery-Dashboard-Tips-Lea-Pica-Present-Beyond-Measure-Featured.png&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;175px||175px|&#8221; animation_style=&#8221;fade&#8221; title_font_tablet=&#8221;&#8221; title_font_phone=&#8221;&#8221; title_font_last_edited=&#8221;on|phone&#8221; title_letter_spacing_tablet=&#8221;&#8221; title_letter_spacing_phone=&#8221;1px&#8221; title_letter_spacing_last_edited=&#8221;on|phone&#8221; title_line_height_tablet=&#8221;&#8221; title_line_height_phone=&#8221;1em&#8221; title_line_height_last_edited=&#8221;on|phone&#8221; z_index_tablet=&#8221;500&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Section&#8221; _builder_version=&#8221;3.22&#8243; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.6.1&#8243; max_width=&#8221;750px&#8221; z_index_tablet=&#8221;500&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Body Content&#8221; _builder_version=&#8221;4.14.2&#8243; hover_enabled=&#8221;0&#8243; z_index_tablet=&#8221;500&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Data Viz Expert Ann K. Emery\u2019s Top Dashboard Do\u2019s and DOH\u2019nts!<\/h2>\n<p><iframe loading=\"lazy\" src=\"https:\/\/playlist.megaphone.fm?e=POD2781848020&amp;light=true\" width=\"100%\" height=\"200\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>Ann K. Emery is an internationally-acclaimed speaker who equips organizations to get their data out of dusty spreadsheets and into real-world conversations.<\/p>\n<p>Each year, she delivers over 100 keynotes, workshops, and webinars with the aim of equipping organizations to visualize data more effectively.<\/p>\n<p>She happens to be one of the foremost influencers in my journey as a data presentation educator and the latest star of my Women in Analytics Spotlight.<\/p>\n<p><strong>And in this episode, Ann shares her wealth of expertise in data visualization and dashboard dexterity for your benefit!<\/strong><\/p>\n<h2>In This Episode, You\u2019ll Learn\u2026<\/h2>\n<ul>\n<li>All about Ann\u2019s journey into data biz and how she leveraged her skills and personality.<\/li>\n<li>The poll that Ann uses to start the conversation around data dashboards!<\/li>\n<li>Different perceptions of dashboards and the first steps for client conversations.<\/li>\n<li>The four types of dashboards and the steps in the planning process.<\/li>\n<li>The necessary software for dashboard creation and thoughts on the nuances between different programs.<\/li>\n<li>Tips and tricks for streamlining your data extraction process.<\/li>\n<li>Challenges that Ann has seen most often in the dashboard creation process.<\/li>\n<li>Unpacking the discussion around layout and chart types and Ann\u2019s personal approach.<\/li>\n<li>Ann\u2019s recommendation of an impactful book dealing with the power of text placement.<\/li>\n<li>Why Ann is so excited about progress in the field of dashboard creation.<\/li>\n<\/ul>\n<h2>People, Blogs, and Resources Mentioned<\/h2>\n<ul>\n<li>Ann\u2019s <a href=\"https:\/\/depictdatastudio.teachable.com\/?affcode=202644_nqopy3te\">Data Visualization courses<\/a><\/li>\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Treemapping\">Treemap chart<\/a><\/li>\n<li><a href=\"https:\/\/www.fusioncharts.com\/resources\/chart-primers\/sunburst-chart\">Sunburst donut chart<\/a><\/li>\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Sankey_diagram\">Sankey diagram<\/a> &amp; <a href=\"https:\/\/sankeymatic.com\/\">SankeyMatic<\/a><\/li>\n<li><a href=\"https:\/\/www.strava.com\/\">Strava dashboards<\/a><\/li>\n<li><a href=\"https:\/\/leapica.com\/blog-podcast-050-nancy-duarte\/\">Nancy Duarte<\/a><\/li>\n<li><a href=\"https:\/\/marketingplatform.google.com\/about\/data-studio\/\">Google Data Studio<\/a><\/li>\n<li>Google Sheets resources from <a href=\"https:\/\/www.benlcollins.com\/\">Ben Collins<\/a><\/li>\n<li><a href=\"https:\/\/leapica.com\/blog-podcast-052-storytelling-with-data-practice-book-2\/\">Cole Nussbaumer Knaflic<\/a><\/li>\n<li><a href=\"https:\/\/www.amazon.com\/Am-Book-Portal-Universe\/dp\/024140875X\"><em>I Am a Book. I Am a Portal to the Universe<\/em><\/a><\/li>\n<li>My free 30-second <a href=\"https:\/\/go2.bucketquizzes.com\/sf\/aaad87f4\">online assessment<\/a> to find out and overcome the #1 silent killer of your data presentation success<\/li>\n<\/ul>\n<h2>How to Connect with Ann K. Emery:<\/h2>\n<ul>\n<li>Ann\u2019s <a href=\"https:\/\/www.linkedin.com\/in\/annkemery\/\">LinkedIn<\/a>, <a href=\"http:\/\/www.twitter.com\/annkemery\">Twitter<\/a>, <a href=\"https:\/\/www.instagram.com\/annkemery\/\">Instagram <\/a>profiles<\/li>\n<\/ul>\n<h2>Thanks for Listening!<\/h2>\n<p>Thanks so much for joining me. Have some feedback you\u2019d like to share, or a question? Leave a note in the comments below, and we\u2019ll get back to you!<\/p>\n<p>Now, I&#8217;m going to ask two favors from you:<\/p>\n<ol>\n<li>If you&#8217;re digging the show, <strong>don\u2019t forget to hit the Follow buttons on <a href=\"https:\/\/leapica.com\/PBMitunes\">iTunes<\/a> or <a href=\"https:\/\/open.spotify.com\/show\/3GcPp99cGG5zsLbArpNL3z?si=LLNTb78zTNShkfU2SK0IbA&amp;dl_branch=1\">Spotify<\/a><\/strong> to never miss an episode.<\/li>\n<li>If you liked what you heard, I would love if you could <a href=\"https:\/\/leapica.com\/PBMitunes\"><strong>leave me a rating or review in <\/strong><\/a><strong>Apple Podcasts<\/strong>. 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!<\/li>\n<\/ol>\n<p>And finally, always remember: <strong>viz responsibly, my friends.<\/strong><\/p>\n<p>Namaste,<\/p>\n<p><img loading=\"lazy\" class=\"wp-image-4501 alignnone size-full\" src=\"https:\/\/leapica.com\/wp-content\/uploads\/2018\/12\/Lea-Signature.png\" alt=\"Lea Signature\" width=\"100\" height=\"50\" \/><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_toggle title=&#8221;EPISODE TRANSCRIPT&#8221; _builder_version=&#8221;4.14.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>[00:00:44] LP:<\/strong> Hello my dear listener, and welcome to the 73rd episode of the Present Beyond Measure Show, the only podcast at the intersection of presentation, data visualization, storytelling and analytics. This is the place to be if you\u2019re ready to make maximum impact and create credibility through thoughtfully presented insights and ideas.<\/p>\n<p>&nbsp;<\/p>\n<p>Today, you are here either because you like data and you design dashboards for a living and you want to learn how to do it better. Or like me, you are a raving fan of today\u2019s super special guest. Now, as usual, I am super stoked for today\u2019s guest. That never changes. But in particular, this guest has been on my radar for a very long time. Where her practical and practitioner-centered approach to data visualization and communication has garnered her a very well deserved and raving fan base.<\/p>\n<p>&nbsp;<\/p>\n<p>Let\u2019s jump to it.<\/p>\n<p>&nbsp;<\/p>\n<p>[INTERVIEW]<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:01:55] LP: <\/strong>All right, everyone. Today\u2019s guest is an internationally acclaimed speaker who equips organizations to get their data out of dusty old spreadsheets and into real world conversations. She is considered one of the fields foremost experts. Each year, she delivers over a 100 keynotes, workshops and webinars with the aim of equipping organizations to visualize data more effectively. She has been invited to speak in 10 countries, thousands have enrolled in our online training academy and she\u2019s consulted to 200 organizations, including the United Nations, the CDC and Harvard University. Hmm! I don\u2019t know, heard of those. She\u2019s been a personal hero of mine since the beginning of my journey into data visualization awesomeness. Please, help me fangirl and welcome the latest guest in my superstar women in analytic spotlight, Ann K. Emery.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:02:53] AE: <\/strong>Thank you so much, Lea. That\u2019s great. What a great intro. Wow! Geez! I\u2019m blushing.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:02:59] LP: <\/strong>Well, it\u2019s a podcast, so half the people won\u2019t see that. But no, honestly, it\u2019s very well deserved. This is a moment in the making for me for 10 years now. Your work has had a profound impact on the development of my journey as both a date of vizier, and a speaker and trainer in this space. I\u2019m such a huge fan and I\u2019ve just been working so hard to get you on here, so this is an exciting moment.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:03:23] AE:<\/strong> Great. Great. Great.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:03:25] LP:<\/strong> Everyone loves a great superhero origin story. You\u2019ve been at this for quite a long time, but we\u2019d love to really hear how did you fall into this wacky and wonderful world of data viz.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:03:40] AE: <\/strong>Well, in college, I knew I liked spreadsheets. My dad is an economists, so I just kind of inherited the spreadsheet gene. I remember mentioning to my \u2013 I think you\u2019re just kind of born with it.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:03:50] LP:<\/strong> I have that.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:03:51] AE:<\/strong> Yeah. Some of us are. We\u2019ll talk about technical people in spreadsheets, I\u2019m sure plenty. I remember, I didn\u2019t know what career paths you went into with data. This was before data science, or data analytics, or big data, or whatever the big AI, whatever the big terms are these days. This is like back in college time. I mentioned to a professor, \u201cOh! I guess I\u2019ll be an accountant. I think I\u2019ll be an accountant. I think that\u2019s what I\u2019ll do.\u201d He was like, \u201cNo, you would be terrible at that.\u201d I thought he meant that my spreadsheet skills were terrible. I must have showed that on my face. Like \u201cWhat?\u201d And he said, \u201cNo, you\u2019re an extrovert. You can work with data, but you have to do something working with teams, and people and like bringing people together with that data. There\u2019s some other angle of it that\u2019s not just looking at spreadsheets all day every day like accountants.\u201d I was like, \u201cI don\u2019t know. That sounds like the best thing in the whole world to look at spreadsheets every day,\u201d which I get to do for big chunks of every day and is great.<\/p>\n<p>&nbsp;<\/p>\n<p>After college, I got the typical corporate jobs, and then one thing led to another. I started speaking at conferences, as I know you do a lot too and people just started to ask me to do this at their company. I would give a talk and they\u2019d say, \u201cWow! This was so helpful. Can we fly you out and you give the full day version of the star company?\u201d I did a couple of those to get my feet wet and turned it into a full-time job. And here I am, year eight of working for myself.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:05:12] LP: <\/strong>Wow! It\u2019s only been eight years. That\u2019s amazing, because that\u2019s not too far from how long I started. But I feel like you had such a strong presence even back then when I discovered you. You really must have hit the industry hard.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:05:28] AE: <\/strong>Well, I think, I started blogging and YouTubing before that, when I had a salary job, just for fun as a pure, honestly, as a pure hobby. I have three kids now, so this was back pre-kids when I could like wake up on Saturday morning and write a blog post. Not anymore. Not anymore at all. But yeah, I started doing like blogging and YouTubing as a hobby, pre-self-employment too. That might be the timeline that more people are familiar with for me.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:05:54] LP: <\/strong>Well, that\u2019s already an amazing tip right there is, if you\u2019re really passionate about the subject, that you\u2019re a specialist in, get out there and start writing a blog or writing videos and you never know what path that could lead you to. Right?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:06:07] AE: <\/strong>Absolutely. And do it before you have kids, before your time disappears.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:06:11] LP: <\/strong>Yes. Hire a team, automate. Yes, completely. Well, that is a really fascinating story. I\u2019m so thrilled that you were rejected from a career in accounting in order to bring so much knowledge to this space. Your work has really covered so much of the gamut of data visualization. You\u2019ve been on so many podcasts. I used to use your chart choosing tool and things like that. But today, we\u2019re very interested in talking about dashboards. These things that like I get asked about all the time, and everyone loves, because I\u2019m more on the more boring, non-sexy data presentation side, but people love their dashboards. I think this is one of the areas where the little changes can make big, massive improvements. You actually brought today an idea, like a framework that you have for helping people understand what kind of dashboards are out there and when to choose them. I\u2019d love to hear more about that.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:07:14] AE: <\/strong>Okay. I\u2019m going to give you a quiz first. This is not a hard quiz. This is a poll.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:07:19] LP:<\/strong> Okay. Let\u2019s see.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:07:20] AE:<\/strong> Yeah. Turning the tables. You\u2019re in the hot seat now. Okay, Lea. Give me your definition of dashboards, because there\u2019s 50 million correct answers. What\u2019s your definition?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:07:31] LP: <\/strong>All right. On the fly, my definition of a dashboard is a single view suite of data chart modules, or data form modules that are designed to alert a lay audience to the most critical business key performance indicators, business metrics in a way that they can either make very basic decisions on their own, or alert them to ask the proper teams to investigate those changes further.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:08:04] AE: <\/strong>Wow! That is a very sophisticated definition. Not that I expected anything less of you, but that\u2019s probably the best I\u2019ve ever heard, to be honest. You get a trophy. You get a Friday afternoon trophy. Gosh! I love asking people that because you truly get so many different answers. Then those are your words to describe it, but the picture you have in your head or ones you\u2019ve seen, that\u2019s different for everybody too. Because dashboard software programs have only existed for, I don\u2019t know, 10 years. When did Tableau become a thing? Five years ago maybe. I don\u2019t know. They\u2019re growing and growing in popularity all the time.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:08:42] LP: <\/strong>I want to say at least 10 years, because right when I discovered this whole field, they were there. It has to be around the 10-year mark.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:08:51] AE: <\/strong>Oh! You know what? You know how I mentioned, I started speaking at conferences, and then people would ask me to go speak. That was my first conference presentation was, I think 2009 about dashboards. That was 12 years ago now, about dashboards when they were the buzzword. If you talked about dashboards at a conference, it was a guaranteed standing room only presentation, which might still be the case now. Maybe, I don\u2019t know. I feel like there\u2019s other topics that are \u2013 you said dashboards are sexy. I feel like presentations are sexy. We should switch jobs.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:09:23] LP:<\/strong> Right? Exactly.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:09:25] AE: <\/strong>Nowadays, people have entered the field maybe more recently, might think of a dashboard as \u201cOh, it\u2019s Tableau. It\u2019s Power BI. They think of maybe a certain tool with a web-based interactive dashboard, where the user can drill down, and use checkboxes, and drop-down menus and explore the dashboard on its own. I think it was \u2013 it\u2019s interesting. You mentioned something about maybe a single screen or a single view. Some people use that in their definition, some people don\u2019t, some people are like, \u201cOh! I need multiple tabs.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:09:54] LP: <\/strong>Or scrolling is another option, yeah.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:09:57] AE: <\/strong>Before these software programs existed, 2009 and prior maybe, what people called a dashboard. This is my end of one personal opinion. I think they meant like a static dashboard, a printout or a PDF. That used to be the thing for dashboards, especially with the groups I work with. I think we have very different groups that we work with. I work with a lot of federal and state government agencies. I work with a lot of universities. I work with nonprofits and foundations. That still a lot of times how they think about dashboards, honestly, is it\u2019s a piece of paper at your annual meeting. It\u2019s the packet at the board meeting with your key facts and figures on it. Just getting people to sit down and recognize that there\u2019s different types of dashboards is so critical, because if you work in a data role, everybody has been asked for a dashboard at some point, everybody has\/<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:10:51] LP: <\/strong>What we need right now is more dashboard. It\u2019s the one I hear a lot.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:10:55] AE: <\/strong>I told you, I don\u2019t know if this is before we started recording or after. But I told you I was struggling with my computer this morning working on a dashboard. I\u2019m helping a group revamp their dashboard, like dashboard in air quotes. It\u2019s just an Excel file with columns and rows. There\u2019s not a single visual anywhere to be found. It\u2019s a very well-organized table that could feed into graphs, but it\u2019s like that\u2019s the lingo they\u2019re using in-house to mean dashboard. The file name says dashboard, the title on the document says dashboard. When we\u2019re emailing back and forth, and talking over Zoom, it\u2019s all dashboard, dashboard, dashboard. I open it and I\u2019m like, \u201cNo, this is a table. This is a data set.\u201d Yeah. Every single day, I have to kind of clarify. \u201cWait. You\u2019re asking for a dashboard or you say you have a dashboard. Tell me more? What does that look like? What does it feel like?\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:11:43] LP: <\/strong>Right. The word kind of creates certain expectations, I think, and I think this is important for both dashboard designers and consumers to understand is spending years in an agency and on the client side. That was almost the first thing people ask for it, \u201cOh! We need a dashboard for this. I don\u2019t know what I want, but we need a dashboard in.\u201d Getting very clear on the expectation of what that\u2019s supposed to accomplish on an ongoing basis, I think is the first critical step for making that ask. I don\u2019t know what do you think about that?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:12:15] AE: <\/strong>Absolutely agree. I\u2019d say, step zero is recognize the dashboard idea we have in our minds, is going to be probably a little bit different from the dashboard idea somebody else has in their minds. Then step one is get clear, get clear on what the expectations are for that dashboard. This is where the four types come in that I\u2019m going to try my best with my frazzled brain after my Excel was breaking on me all morning. I\u2019m so angry about this. I would go to insert a row and it would just freeze for like 60 seconds. I\u2019ve Googled all the things. I restarted the computer. It was it was fine for a couple of hours, and then I\u2019d go to insert a row and it just wasn\u2019t having it.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:12:57] LP: <\/strong>Maybe this is some dark ad where from a dashboard companies saying, \u201cMan! Come to us.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:13:03] AE: <\/strong>Stop using everyday software programs, pay more, use our fancy software. Maybe.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:13:09] LP: <\/strong>No, no. They would never do that. They would never do that.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:13:11] AE: <\/strong>Okay. Where were we? I\u2019m going to try to describe the four types of dashboards that \u2013 I have a visual for this. I think I have it on a blog post somewhere that we can put in the show notes. I\u2019m going to try to describe it [inaudible 00:13:23], so we\u2019ll see how we do. This is the planning convo we\u2019ve all got to have when people ask us about dashboards to make sure what people are expecting is what you make for them, that there\u2019s a nice cohesion there. Step one, figure out if you need a static or interactive dashboard. I\u2019m going to be like, I\u2019m thinking about kind of quadrants here. There\u2019s kind of this quadrant of \u2013 you\u2019re either on the static side or you\u2019re on the interactive side.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:13:53] LP: <\/strong>That\u2019s like the spectrum going from like left to right.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:13:55] AE: <\/strong>That\u2019s your left, right. Yeah, your left right and your \u2013 gosh! We can geek out on your podcast, right? It\u2019s your X axis, horizontal line. Static or interactive? Static is, you really just need a meeting handout. Once things go back to in-person more and more, you really just need like, there\u2019s a staff meeting in the conference room. What you really need is a on pager of key facts and figures that might be printed out and passed out as a meeting handout. Or static would be an email attachment. People say, \u201cHey! Do you have those key numbers and you say, \u201cSure. Here they are. Please see attached\u201d and you send them a fairly short PDF. It doesn\u2019t have to be a page. I think that\u2019s a made-up rule some people have in their head, but it\u2019s not a full report. It\u2019s a short-ish document. Where else would static come in? It\u2019s your printouts. It\u2019s your PDFs.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:14:49] LP: <\/strong>Could it also be informed by the level of acuity or savvy of your audience where maybe an audience, or decisionmaker really wants to have a little bit of narrative summary with a few graphics, and like it all tied up. Read to me like a mini bedtime story about our data, make it a page and I don\u2019t want to be drilling down and I don\u2019t want to \u2013<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:15:15] AE: <\/strong>Agree, 100%. Absolutely. Yeah. I have in my notes. It\u2019s more for the non-technical audiences or what you might call a lay audience. I think you used lay earlier. It could also be the busy audiences, which is like every supervisor or person in a leadership position ever, ever. I mean the really smart people, the really highly educated people. They just don\u2019t have the privilege of time. Providing them some little details, like you said, it\u2019s going to be so, so helpful. It\u2019s a gift that you\u2019ve said. I\u2019ve already dug through all the messy data. Here\u2019s what I think are the key findings for you in this tiny little package.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:15:56] LP: <\/strong>It\u2019s like putting the cooked dinner in a five star restaurant and lifting the metal, whatever that is, whispering the ingredients in the ear and then backing away quietly.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:16:07] AE:<\/strong> Lea, you\u2019re so good. That\u2019s so good. Yes.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:16:11] LP:<\/strong> I love analogies. They\u2019re like my thing. Thank you.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:16:14]AE: <\/strong>I love drawing diagrams, so you put us together, we\u2019ve got an analogy diagram going on. Static, we know when that would be really helpful. We know what that looks like. The other option, that\u2019s also correct sometimes is interactive. That\u2019s going to be, somebody opens, it\u2019s going to have to live on a computer or everybody\u2019s got phone apps that are dashboards that you can drill down, maybe you have your own data. I don\u2019t know. The apps that track your runs, or your bike rides or something and you can say, \u201cOh! Just show me this time frame right now\u201d or \u201cJust show me my \u2013\u201d I think Strava does this. I started using Strava again for exercise. It has some nice little charts in there and stuff, but it\u2019s digital. It\u2019s digital. It\u2019s not a PDF. It\u2019s something that you use the drop-down menus, you drill down yourself, you interact with it.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:17:02] LP:<\/strong> Right. Interact with it.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:17:04] AE:<\/strong> The trouble with interactive dashboards is, they\u2019re not always time appropriate for everybody. People like me, probably people like you who like data we\u2019re like, \u201cGreat! Let\u2019s make a dashboard\u201d and we like exploring the dashboard, and we like drilling down because data is our favorite thing in the world. We\u2019re like, \u201cYeah, let me explore it, and find the nuances, and find the insights, and figure out what\u2019s going on and know everything about this data set.\u201d But then the people we\u2019re giving the dashboard to, they often just need those quick insights, the key takeaways. I see a lot of mismatches happen in the real world a lot where the data people like using interactive dashboards, so they make interactive dashboards, but they\u2019re making it for somebody who really just needs a one-page PDF. There\u2019s just this constant kind of mismatch in what\u2019s designed and then what people actually need.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:17:58] LP: <\/strong>You may enjoy cooking the meal, at least a little bit, or prepping it, but your audience may want to have nothing to do with that.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:18:07] AE: <\/strong>They just want to eat it. They just want you to do your little reveal.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:18:11] LP: <\/strong>Right, exactly. Yep.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:18:15] AE: <\/strong>Okay. Many more interactive dashboards should be static dashboards. They really should. I hate saying that aloud. Nobody wants to hear it. But it\u2019s just \u2013<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:18:24] LP:<\/strong> But that\u2019s so not innovative, yeah.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:18:26] AE: <\/strong>It\u2019s so boring. Really? Are you sure my boss just wants a one-pager? Yeah, they do. They just want a one-pager. How do I know it\u2019s [inaudible 00:18:36]?<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:18:36] LP:<\/strong> Especially if you got an effective one.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:18:37] AE:<\/strong> Yeah, exactly. A good one. Not a terrible one, a good one. Okay. Static or interactive? That\u2019s a key decision-making point, and it really depends on your audience. Non-technical audiences, give them the static dashboard. Technical audiences, give them the interactive dashboard.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:18:57] LP:<\/strong> Got it.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:18:58] AE:<\/strong> The other decision-making factor, so imagine this one is your vertical line on the quadrant, like your vertical Y axis? If we\u2019re making a little like a plus sign kind of quadrants. That one\u2019s really easy. Do you need a single dashboard or do you need lots and lots of matching dashboards?<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:19:15] LP:<\/strong> Multiview.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:19:15] AE:<\/strong> The first time we worked on dashboards, I\u2019m thinking of that 2009 million years ago conference presentation. I used to do education data, so I would work with the US Department of Education or state education agencies. A single dashboard would be like all the schools in a state combined, however many hundreds or thousands of schools, the state overview. Then a series of dashboards would be one per school, like school A gets a dashboard, school B gets their own dashboard, school C gets their own dashboard.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:19:48] LP: <\/strong>Got it. The single is more like an aggregate level for that really bird\u2019s eye view and then Multiview is allowing you to get more granular for more specific users. Okay.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:19:58] AE: <\/strong>I also see mismatches there too sometimes. People will think like, \u201cWell, doesn\u2019t the school also want to see the aggregate dashboard for all the schools combined?\u201d I mean, sometimes, what they really want to see is their own school\u2019s data. It kind of just depends on somebody\u2019s position within a project, The people in the state education agency, they want to see all the schools combined. They might \u2013 they might want to see a couple of schools individually, but really, they want to see like, how\u2019s our state doing? The people working in the schools, they want to see how is my school doing. There\u2019s not a right or wrong answer there. It\u2019s just one of those planning considerations that we\u2019ve got to talk about upfront to make sure we\u2019re making the right dashboard and we don\u2019t run into so many issues later on.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:20:42] LP: <\/strong>If I\u2019m hearing you correctly, humans, who are the people consuming these dashboards generally want to see data at the level that pertains to us?<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:20:53] AE:<\/strong> Yeah, of course.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:20:55] LP:<\/strong> I hope everyone heard that.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:20:58] AE: <\/strong>Say it again for the people in the back, Lea. We want to see useful data, right? We want to see data about us, about our own project, which is so obvious to say aloud. It\u2019s one of those things you do need to say aloud at the beginning of a project, because otherwise, I see groups spend months working on dashboards, and so much money and \u2013 or they hire a consultant and the consultant might be very skilled at dashboards. But there hasn\u2019t been that conversation upfront about what type of dashboard. The consultant does their best guess, they of course, they do their best guess and they deliver what they think the people need. But it\u2019s just so much time and money lost, just because these conversations that take 15 minutes haven\u2019t taken place.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:21:49] LP: <\/strong>Well, I really think it\u2019s in the spirit and this goes for data presentations, too. But it\u2019s making these outputs audience centered. If it\u2019s designed for more than one audience, in one single view, there\u2019s going to be a red flag that someone or all will not be happy about some aspect of their view. You\u2019re right, an external consultant might not have that insight. They may come in and apply principles and use specific frameworks, but it\u2019s understanding that internal culture that is really essential.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:22:22] AE: <\/strong>Yep. I think a lot of times, that\u2019s like step zero zero too, which I think you and I know because we do this for a living. But thinking about who the audience is, and really trying to narrow your audience to one. Everybody has multiple audiences, so you know, I\u2019m sure you\u2019ve done this with groups like you\u2019re making some presentation slides. Who are the slides for? When is your presentation? Who\u2019s going to be in the room? Obvious questions like that, right?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:22:50] LP: <\/strong>What needs to be covered and how does everyone get their needs met?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:22:54] AE: <\/strong>Absolutely. Okay. We talked about the four types, static or interactive, single or series. Then depending on what type you need, depending on which of the four quadrants you fall into, that determines what software program you\u2019re going to use. Software comes later. Software comes later. Everybody is like, \u201cWe just got Power BI and what can we do with it?\u201d I don\u2019t know, \u201cWhat do you need to do?\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:23:20] LP: <\/strong>Right. Did you need it?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:23:22] AE: <\/strong>I started switching from Excel to sheets to see what sheets could do. Great! But it does the same things as Excel pretty much. Like what do you need it to do?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:23:32] LP: <\/strong>Why? The question is why.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:23:35] AE: <\/strong>Yeah. You know, Lea, I\u2019m a big fan of everyday software. I use Excel, and PowerPoint and Word as much as possible. It tends to be the common language among all the groups I work with anyway. I think people are usually pleasantly surprised to learn how much Excel can do. Everything on the static side, Excel can do. If you\u2019re making a one page PDF, make it an Excel, set it up to be PDFable. Just set the page margins, you can adjust the page breaks, you can add page numbers, you can adjust all the font sizes, you can make it look like it was made in some other software program. It can look very beautiful. It\u2019s just Excel saved as a PDF. You can even do a lot of interactivity with Excel too with slicers that are a lot easier to use than people might realize too. Slicers sound confusing, it\u2019s just a filter. There\u2019s a million Google resources and YouTube resources on how to add slicers. They\u2019re not complicated or time consuming at all.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:24:31] LP: <\/strong>Right. Though this is great. One of the questions I feel like would bubble up for practitioners since I spent many, many hours creating static dashboards in Excel. Well, I sort of exited this realm when things like Google Data Studio really started ramping up where they were kind of creating an Excel-ish experience, nothing insanely groundbreaking in terms of visualization. But these platforms, we\u2019re aiming to alleviate some of the headache that practitioners experience in actually creating and designing them of cleaner data, import, and hygiene and making the process of getting raw data into actual visuals more streamlined. That could still be PDFable. I\u2019d love to hear about tools like that, where you don\u2019t have to intend for it to be interactive, where a consumer gets lost in it. But they might solve for some of the like very rote manual data issues in Excel.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:25:33] AE: <\/strong>Yeah. I\u2019m not too familiar with Data Studio, to be honest. I\u2019m familiar with my Depict Data Studio, but not the Google Data Studio. But in terms of Google\u2019s sheets, I put Excel and sheets and then if you\u2019re on a Mac numbers, those are the same bucket in my mind. They do almost the exact same thing. There\u2019s little nuances that could give us all a huge headaches, but they\u2019re mostly some \u2013 it\u2019s like a Venn diagram [inaudible 00:26:00]. I can\u2019t help myself. [Inaudible 00:26:03].<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:26:05] LP: <\/strong>Yep, yep. Well, I guess that\u2019s something to think about, again, because it\u2019s about the why. Right? Someone might choose to use a platform Data Studio, definitely is more of a visual interface to like a repository of data, which I have found useful for pulling stuff in where you can pull in from sheets. But you can also pull indirectly from other data sources so that you\u2019re not extracting data and putting it into Excel, which is the way that I used to do it. Do you have any tips for that in terms of making that process easier and more streamlined? Or it just is what it is?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:26:45] AE: <\/strong>Google Data Studio specific tips would be, check out my friend, Ben Collins. That\u2019s what he does for a living. It\u2019s benlcollins.com. He is like the Google and data trainer. He\u2019s got all sorts of courses. Honestly, that\u2019s why I don\u2019t have to learn about sheets or Data Studio because I\u2019m like, \u201cGo ask my friend.\u201d He already knows how to do all of that, why would I learn? Just refer people to him. But then in terms of getting data into Excel, that I don\u2019t know, that\u2019s so tricky. Every organization is so different.<\/p>\n<p>&nbsp;<\/p>\n<p>I\u2019ll give people a really practical tip, I was working with a woman on Wednesday, just a couple days ago. Anyway, I don\u2019t know when this is airing, but it\u2019s just a couple days ago. She works at a foundation. so she has a foundation database, where they all enter in information about their grants that they give out to organizations in the community. I don\u2019t know. It\u2019s like a grant level type of database. She wanted to look at some patterns over time. Who doesn\u2019t? She was getting ready to pull one year\u2019s worth of numbers. We\u2019re trying to make it easy for her to pull the next year of numbers, so she could do some time comparisons. What she had been doing \u2013 what has she been doing? She had been like downloading the data one year at a time. 2020 data was its own sheet, and then 202 was its own sheet. She couldn\u2019t kind of compare across sheets and I told her, \u201cJust do one download. Do one download and include that column in your export that says the year\u201d and then we put that into a pivot table and filtered by year.<\/p>\n<p>&nbsp;<\/p>\n<p>If people who are listening work with data, they\u2019re like \u201cDuh! I understand exactly what you\u2019re talking about.\u201d If you don\u2019t work with data, I\u2019ll just say, \u201cTry to keep all your data in one spreadsheet when you download it. One single spreadsheet to use is going to save a lot of time.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:28:38] LP: <\/strong>One hundred percent. I think the hardest lesson I learned was all of these discrete imports and then placing them on sheets. I always thought to myself, can I create a column that allows me to enter this as just another dimension of the data. Saved so much headache. Very cool. That\u2019s it. That\u2019s a great tip, because I know there\u2019s a range of expertise of people coming into this, of who listens. Everyone loves the do&#8217;s and don\u2019ts. First, I want to start with, what are some of the more effective, awesome, either examples of dashboards you\u2019ve seen or techniques that are being used that you\u2019re like, \u201cYes, please more of this\u201d?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:29:23] AE: <\/strong>Well, anybody who has a dashboard, five gold stars, well done, because getting your first dashboard set up is the hardest part. So anybody who\u2019s listening, if you have one, you know how hard this has been. It might have required hiring a new staff member, it might have required going to training, it might have required lots of lots of long hours, and thought process and just mentally thinking about, what\u2019s the important data to include? Where do we get that data? Getting the first dashboard is super, super hard. It\u2019s hard to give examples of specific really good dashboards because so many groups dashboards are private. I get to see them because I sign all the papers with them to give me permission, but a lot of them aren\u2019t public facing. That\u2019s changing though for a lot of the foundations and government agencies they work with. More and more data is becoming public all the time, which is really cool. But a lot of the good ones are behind the scenes.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:30:15] LP: <\/strong>That\u2019s something to look out for. It is true that a lot more data is being socialized, especially in the last couple of years, where data has been sort of top of mind for a lot of people. But maybe this question then might be a little easier to answer. What do you think are the biggest challenges or mistakes practitioners are making when it comes to building their dashboards, whether it\u2019s charts, colors, formatting, layout? What do you think are the biggest hang ups?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:30:48] AE: <\/strong>I think the biggest challenge a lot of us run into is volume, just how much were trying to include in a dashboard. That seems to be a roadblock for everybody working on a dashboard? How do I fit all the charts on this page? Do I scroll or not? Do I have different sheets or tabs on the bottom? If it\u2019s a printed dashboard, how many different pages can I have to fit everything? If anybody listening is running into that problem, I would say, timeout, go back to the whatever 0.00 question, try to pick one audience that this is for. Because a lot of times people are like, \u201cWell, this is for my boss, but it\u2019s also for our Board of Trustees. But it\u2019s also going to be public facing on our website someday and it\u2019s also for that staff meeting. But I also want to share it at that concert with my peers\u201d and that\u2019s so many different data priorities, and data needs to try to fit into one dashboard.<\/p>\n<p>&nbsp;<\/p>\n<p>I just see a lot of dashboards that looks very full, just so many different charts.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:31:48] LP: <\/strong>Bulging.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:31:49] AE:<\/strong> Bulging, bursting at the seams, absolutely. Just take a step back and say, \u201cOkay. If I had to pick one audience, and prioritize just the data points that that one audience needs. That solves almost every other problem. It really does.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:32:04] LP: <\/strong>Right. That is interesting, because I\u2019ve often wondered about layout in dashboards. Does the layout of the modules matter? Because often, I\u2019ll go and I\u2019ll see like on a dashboard platform, they\u2019ll show you examples of what their dashboards look like, what the reporting looks like of different reporting platforms that you can use. They\u2019re like platinum view dashboard, just really very random. Seems like a very random selection of as many different kinds of chart types as possible to almost create like a candy shop feeling of, \u201cOoh! Look at all of these different things.\u201d What is your take on actual layout? Does it matter? Should it have all different chart types?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:32:50]AE: <\/strong>The chart types discussion is interesting. Because I come from a research background, like my first job was \u2013 I worked in a university and I churned out peer reviewed journal articles for an NIH funded study, like very academic, very technical, very researchy. I had all bar charts all the time. It was, I think, I\u2019ve seen, what if I maybe see in my first couple years of working. I had seen bar charts. I had seen a pie chart at some point, I hadn\u2019t used them. Maybe lines, if we collected data over time. Scatter plots, maybe scatter plots are kind of what you use in a stats class. They\u2019re out in the real world. They can absolutely work in the real world. That\u2019s about it. I don\u2019t think I\u2019ve ever even thought about including maps or any of the other options.<\/p>\n<p>&nbsp;<\/p>\n<p>Anyway, people should know my personal weakness is, I have way too many bar charts. I always do it in all my drafts so that I know that about my \u2013 like we all know our strengths and weaknesses, right? I know my weakness is, my go to his bar charts. Then as I edit my slides, or dashboards or reports, I try to add more variety so that I\u2019m not looking at it saying, \u201cOh, geez, Ann. Have you not learned anything? You have all bar charts over and over again.\u201d But then sometimes I hit the phase where I\u2019m like, but this is just for an internal audience, and they\u2019re all technical and the bar charts perfectly sufficient. Why am I trying to do anything that looks like a candy shop and just use variety for variety sakes? I don\u2019t know. Honestly, I\u2019ve gone back and forth in that decision about whether like everyday charts like bar charts are okay, or whether you do need variety. Honestly, I\u2019m not sure where I sit as of today.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:34:33] LP: <\/strong>Wow! That\u2019s insightful. In reading Nancy Duarte\u2019s <em>Data Story, <\/em>she talked about how their company conducted this massive research into thousands of their clients executive presentation slides. They were trying to look for the most common chart types. They were expecting elaborate innovative visualizations and things. What was amazing is, it came down to three where the vast majority are bars, pies, or doughnuts and lines. That was it. Well, I personally believe you can include a few more in there, especially with executive presentation, like bullets, stacked bar, 100% stack bars, things like that. Sometimes they\u2019re going to require the right training, because those three people immediately understand what they\u2019re supposed to understand from seeing those charts. There\u2019s no learning curve, there\u2019s no training gap. I think that\u2019s why we end up going back to that.<\/p>\n<p>&nbsp;<\/p>\n<p>To your point, asking that question why is still so critical? Why am I changing it up? Is it for variety sakes or is it because this is truly the best chart type for this? Or if it\u2019s kind of a neck and neck, like they can work equally well. Okay. Then let\u2019s throw some variety in there if that\u2019s really called for you.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:35:59] AE: <\/strong>Yeah. Or am I just picking it because I have a chip on my own shoulder and I\u2019m just embarrassed looking at my work from 10 years ago, these all bar charts. I\u2019m like, \u201cI got to jazz it up now, because the bar&#8217;s been raised.\u201d I didn\u2019t realize that. Oh my gosh! I had this conversation a couple weeks ago with a group that had \u2013 this is super, super nuanced. But you have a dataset, savvy audience, maybe they\u2019ll appreciate it. But it was a category with subcategories with sub subcategories. That\u2019s how their data was structured. Some people call that nested data or hierarchical data. It was three levels of data, like the broadest and then the subcategories sub sub, right. Okay.<\/p>\n<p>&nbsp;<\/p>\n<p>There\u2019s a lot of different ways you could display that. What they previously had was they previously had three separate charts on three different slides, which didn\u2019t work because these were related. You couldn\u2019t tell that something was a subcategory of something else, because it was physically on a different slide of the presentation. It would take a very skilled presenter to be able to click through and say like, exactly, to just say, with their voice, how these charts were connected. It needed to be one cohesive chart, not three separate charts on three separate slides. We\u2019re thinking, \u201cOkay. How do we bring these three disparate charts together?\u201d<\/p>\n<p>&nbsp;<\/p>\n<p>What are all the things we brainstormed? We tried a tree map to show how the nesting or the hierarchy worked. We tried a sunburst diagram, which is basically a donut chart, with layers going outward. You could see like, pretend one donut is a fourth of the donut, and then that breaks off into the next rung, and the next rung. Those, just based on their data, because they had some zeros or some 1%, or some little tiny slivers that just didn\u2019t show up. That didn\u2019t quite work. Then what we settled on as being the best approach was a Sankey diagram, which basically looks like stacked column charts kind of in a row. Here\u2019s this broad one, subcategory of sub sub covers. It was going from left to right across the screen.<\/p>\n<p>&nbsp;<\/p>\n<p>Well then, we ran into a different hiccup, where you can\u2019t really make that in PowerPoint or Excel. So then how do you make that? The guy was like, \u201cWell, I know how to make this in Tableau,\u201d but then making sure the formatting from Tableau matched everything else they had in PowerPoint, or do you go to like sankeymatic.com and make it there. But then that\u2019s an extra step. I wish it was some simple discussion of like, \u201cYeah, just use a bar chart if this, this or this or just use a Sankey diagram or this, this.\u201d But it\u2019s always more nuanced than that of like, \u201cYeah, we could make a Sankey diagram, but at what cost of staff time.? Is it really that much better than \u2013?\u201d I mean, honestly, we haven\u2019t finished this project yet, but we\u2019re probably going to end up with some bar charts. We probably are. We probably are going to end up with bar charts to save time. Because in the context of this broader presentation, these charts are not the star of the show. They matter, but they don\u2019t matter matter. I don\u2019t know.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:39:02] LP: <\/strong>Well, I think what you\u2019re getting to is, again, people are always blocking this line between form and function. Even though appeal, visual appeal is important, like people will actually trust something more because they like the way it looks, which is something I picked up from Cole Nussbaumer Knaflic\u2019s book. But the thing is, I think we make a lot of sacrifices for form and we sacrifice function. This is why that why question is literally like, I\u2019m constantly asking this myself. Why would I choose that? By the time I\u2019m done looking at this, can it answer these questions? It\u2019s like something I call the grunt test of like a cave person coming and looking at something, and grunting, and knowing exactly what they were supposed to get from it or they\u2019re grunting in like confusion.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:39:56] AE: <\/strong>You need a sound effect of grunt.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:39:57] LP: <\/strong>Yeah. I think this is why intentional design and data viz is like the core pillar of my entire approach to things, because I never want to do anything for the sake of doing something either because I\u2019m not thinking about it and I\u2019m just not conscious. Or the reason isn\u2019t in the highest service of comprehension and understanding for the audience.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:40:28] AE: <\/strong>Agreed. We\u2019re speaking the same language.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:40:33] LP: <\/strong>Yes, indeed. Well, good luck with the sand key that might end up being [inaudible 00:40:39] and that\u2019s perfectly fine.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:40:39] AE:<\/strong> Yeah, we\u2019ll see. To be determined. Stay tuned.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:40:44] LP:<\/strong> You have to keep us updated. All right. Okay. We\u2019ve arrived at our upgrade segment, which is a tool, a resource, a book, a something that you are loving right now that\u2019s really taking your practice to the next level or something that was really integral to your journey as a practitioner. What do you got?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:41:15] AE: <\/strong>All right. I have so many good books to choose from, but I\u2019m going to show the one that I am currently just fangirling over.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:41:22] LP:<\/strong> Welcome to Ann\u2019s Bookshop.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:41:24] AE:<\/strong> It\u2019s called <em>I Am a Book. I Am a Portal to the Universe<\/em>. It is by \u2013 here\u2019s the author\u2019s, Stefanie Posavec and Miriam Quick. I had to order this. I think it came from the UK, so there\u2019s no like Amazon one day shipping if you\u2019re in the US. It still comes in about a week though. It is amazing. In terms of text placement. Text placement, Nobel Prize for this. I told you, I come from a really boring research background of all academic reports, Times New Roman, size 12. This book gives me permission to use like font size 5,000 and to not have them all go \u2013<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:42:08] LP:<\/strong> This is going on my Christmas list.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:42:09] AE:<\/strong> \u2013 to not have them all linear. This whole book is a story. The story is based on the art of how the text is displayed. It\u2019s an educational story. It\u2019s about facts and figures in science. But it\u2019s just the text plate. It\u2019s just absolutely a masterpiece. It makes me think \u2013<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:42:27] LP: <\/strong>So visual.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:42:28] AE: <\/strong>\u2013 why have I been so boring with paragraphs. A paragraph doesn\u2019t just have to go from left to right in a certain font size. I don\u2019t know if this one \u2013 I don\u2019t know if they have an eBook version. You really have to get the physical one, I think to understand it.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:42:42] LP: <\/strong>Yeah. What sounds amazing about that is, it\u2019s so helpful sometimes when something comes along that breaks us out of a paradigm that we are so enmeshed in of reading paragraphs. Like I\u2019m writing my book right now and it\u2019s paragraph format, with visuals, but that\u2019s what I\u2019m used to. That\u2019s what I\u2019m used to reading. That\u2019s what I\u2019m able to produce at this time. But even just the pages you showed me, it\u2019s amazing to see what your brain does when it\u2019s challenged a little bit. It\u2019s like this crazy house that I heard about once, where they built the house with a floor that was completely uneven and nothing was even more predictable whatsoever. Like the stairs were all janky, and the floor had these constant slopes and you had to constantly watch your step and think about how to move across the space. You literally couldn\u2019t check out, like there\u2019s a word I\u2019m looking for. But you couldn\u2019t go on autopilot, right? I think a book like that is going to be amazing for jiggering some creative juices and seeing how that can flow. That\u2019s amazing. I\u2019d love it.<\/p>\n<p>&nbsp;<\/p>\n<p>Before I enter the final question, is there anything you\u2019re really excited about with the future of data storytelling right now?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:43:58] AE: <\/strong>I cannot wait till I can stop talking about some of the topics I\u2019m talking about.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:44:05] LP: <\/strong>I know exactly what you mean.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:44:08] AE: <\/strong>Let\u2019s rerecord this in 10 years.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:44:10] LP:<\/strong> You got it.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:44:11] AE:<\/strong> Our dashboard conversation, I cannot wait for that to be a different conversation. I hope. I hope. That\u2019s what I\u2019m working towards, that we no longer have to say, \u201cGuess what, not every dashboard has to be interactive. It\u2019s okay to have a one-page PDF\u201d or we don\u2019t have to say, \u201cHey! Really, we need to narrow down our audiences.\u201d That we just don\u2019t have to talk about that because everybody gets it, and they\u2019ve already moved on to bigger and better things. I cannot wait for the types of topics that I\u2019m blogging about, and talking about podcasts about and going to speak at conferences about. I can\u2019t wait for this to shift someday. I don\u2019t know if that was the answer you wanted me to say, but that\u2019s what\u2019s been on my mind a lot lately.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:44:48] LP: <\/strong>Actually, I completely resonate. There are certain parts of my training where I\u2019m like, I dream of the day I never have to say this again. But for now, I think as advanced certain things are getting with mobile dashboards, and predictive modeling and AI and things. I think what we\u2019re really seeing come to the surface is this gap in the foundations. We need to put a few cinder blocks in there before we start to build the glass sunroom. That\u2019s why I appreciate your work so much, because I think we\u2019re just going to have to keep doing that for a little bit. That\u2019s okay. It\u2019s called job security.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:45:27] AE: <\/strong>Yeah. Somebody the other day was like, \u201cAre you worried the robots will replace you?\u201d I was like, \u201cAbsolutely not. No. Not one bit. There\u2019s no robots to replace critical thinking skills for any of us.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:45:38] LP: <\/strong>In fact, thanks to the robots. It\u2019s probably going to be around for longer. All right. This is our final wildcard question. Think very hard here and imagine this very plausible scenario. You\u2019re backpacking along the coast of Spain with your family in tow, when suddenly you trip and fall into a vortex that pulls you back to the moment you\u2019re about to deliver your first presentation. Because we do talk about that here, too. I\u2019d love to know if you remember, what are you presenting about and what advice would you give to yourself?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:46:14] AE: <\/strong>Oh my gosh! Can I give you something that probably you were weren\u2019t expecting? Why not. Why not. We\u2019re recording this on a Friday, I get to be my source.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:46:21] LP: <\/strong>Of course, we love twists on a data storytelling show.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:46:24] AE: <\/strong>We\u2019ve talked about this one. Before, at my first conference presentation was 2009. It was about dashboards. The presentation was like, \u201cHey! We should have dashboards. We shouldn\u2019t just have 100-page reports. We should have dashboards.\u201d People get individualized data and it was my first presentation. Nobody was there to hear a little old Ann. Nobody had heard of me. I was like, very entry level person at my first conference. Everybody was there, because the term dashboard was in the conference session table. I was very unpleasantly surprised to be speaking to a standing room only audience along with my colleague too. I don\u2019t know if I could say this. I\u2019ve started the story, I guess I have to finish it.<\/p>\n<p>&nbsp;<\/p>\n<p>I wore a dress. I wore a very conservative business casual dress that was about knee length, but I had people sitting two feet in front of me on the floor. And the whole 90 minutes, I was just worried. Are they seeing more than they should see? Since then, I\u2019ve almost always spoken at pants. That\u2019s what I would do differently. I would just, I would have worn pants. Also, I would have brought handouts too. That\u2019s probably the answer that I should have given.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:47:34] LP:<\/strong> By the way, handouts.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:47:35] AE:<\/strong> By the way, handouts, because we were talking about VBA coding, and like nobody in the audience knew about VBA coding. We should have just set \u2013 we talked about these four steps. Like, \u201cHere\u2019s what you do with VBA coding to get started.\u201d We should have just had a one pager that had those four steps typed out, and maybe we did, but maybe we brought 20 copies, not 150 copies. I don\u2019t remember, but I think I just thought, a presentation is slides. Well, kind of but a presentation is also the people presenting and it\u2019s also supplemental materials like slides. Now, I always have handouts. Okay. I\u2019ve given you two answers.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:48:10] LP: <\/strong>I love where that \u2013 I love the journey that took, but building on the handout aspect, especially if you\u2019re considering conferences. I think absolutely one of the best things to do is to have a handout that\u2019s more readable, prepared, rather than when they inevitably ask you to send your slide deck, which, if you\u2019re designing it correctly, is most likely not suitable to be a printable handout. But bring that and I bet you that people will remember that talk so well, because you\u2019re helping seal your information into people\u2019s brains just by having that more readable version accessible.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>Yeah, I love how we just glossed over \u2014 no. Thinking about wardrobe, wardrobe is essential too. It\u2019s very important. All right. Well, Ann, unfortunately our time has run out. I have loved this discussion so much. There\u2019s such useful stuff here. Tell the listeners where they can keep up with you if they don\u2019t know already.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:49:08] AE: <\/strong>I\u2019m really easy to find online. If you just Google Ann K. Emery data viz, you\u2019ll find my website. I have a bunch of blog posts. I have a bunch of YouTube videos. I have a newsletter. All the usual stuff so we can stay in touch.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:49:20] LP: <\/strong>Perfect. You also have what sounds like a pretty robust data viz course library too. Why don\u2019t you share a little about that?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:49:28] AE: <\/strong>I do. I started making courses in 2018, which was pretty early for online courses. Nowadays, the technology is advanced a lot of people have courses. But I have courses on data analysis, data viz best practices, how to make graphs and edit them in Excel. Several dashboard classes on the different types of dashboards we talked about. Presentations, reports. I love making courses, so I have all the courses.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:49:56] LP: <\/strong>Well, what\u2019s funny is I think we\u2019re in the same course building like entrepreneurial community on Facebook, where we accidentally saw each other in there, where you were like, \u201cLea?\u201d because I posted something. Then you actually shared some kind of spreadsheet that shows all of the course topics you\u2019re tackling. I was like, \u201cWow! She is a machine.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:50:17] AE: <\/strong>I think about courses, I have all the diagrams and spreadsheets for the courses as well.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:50:22] LP: <\/strong>And I\u2019ll be borrowing some of those.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:50:23] AE:<\/strong> Go for it.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>[00:50:25] LP:<\/strong> Awesome. All of these links are going to be available on the show notes page for this episode. Ann, thank you so much for being on the show today. Such a long time coming. I\u2019m so glad we make it work. Your work has been such a major influence for so many, including myself, and I feel privileged to know you and get to share your wisdom here. I look forward to some future collaborations with you.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:50:48] AE: <\/strong>All right. Thanks, Lea. Thanks for having me.<\/p>\n<p>&nbsp;<\/p>\n<p>[END OF INTERVIEW]<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[00:51:00] LP:<\/strong> All right! Wow! What an incredible moment to finally have Ann on the show and have her share her brilliant wisdom, very practical wisdom around creating dashboards. Which, rather than where we tend to get caught up with the fancy sophistication of our chart types and interactivity, sometimes it really is about boiling it down to the basics.<\/p>\n<p>&nbsp;<\/p>\n<p>To catch all of the links to register for her course, check out her website. For all the resources mentioned in this episode, visit the show notes page at leahpica.com\/073. I would love if you could leave a comment, or suggestions or even a question for Ann, because we want to hear about the challenges you face when you\u2019re presenting your vital information. Please, if you\u2019ve liked what you\u2019ve heard, if you\u2019re a fan of the show, please, if you\u2019re on Apple podcast, just scroll to the top and hit that little plus sign to subscribe. Or if you\u2019re on Spotify, you can hit the follow button. Even better, leave a rating and review. Rating and reviews are extremely appreciated because they affect the rankings of the show and I read out my favorite ratings here. Last, if you\u2019re a fan, I welcome you to reach out to me on LinkedIn. I\u2019m very easy to find there. If you\u2019re a fan of the show, just drop a note, make sure you drop a note with your connection invite and I will be sure to accept it. I\u2019d love to connect.<\/p>\n<p>&nbsp;<\/p>\n<p>I\u2019ll leave you with today\u2019s little bit of presentation inspiration by my Greek homeboy, Aristotle. That is, \u201cExcellence is never an accident. It is always the result of high intention, sincere effort and intelligent execution. It represents the wise choice of many alternatives. Choice, not chance determines your destiny.\u201d Whew! That might be one of my favorite quotes of all time. As someone who takes a lot of pride and working towards excellence where I can without killing myself, it is so important to understand that when you move towards a path, towards excellence, it really is about identifying all the little choices that you\u2019re able to make along the way. It\u2019s doing things like dashboard and data visualization design not by default, but by design. Do you get me?<\/p>\n<p>&nbsp;<\/p>\n<p>Think about all the ways that you can make intentional choices when you are building dashboards, or data presentations, or reports, whatever you have to use to communicate your insights. I promise that the more you identify those choices and make them intentionally, the closer you will get to excellence. That\u2019s it for today. Stay well, stay safe and namaste.<\/p>\n<p>&nbsp;<\/p>\n<p>[END]<\/p>\n<p>[\/et_pb_toggle][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen as data viz queen Ann K. Emery talks about her powerful and innovative approach to creating dashboards and how you can apply these tips to your work.<\/p>\n","protected":false},"author":2,"featured_media":48086,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[213,57,53,70],"tags":[],"_links":{"self":[{"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/posts\/48084"}],"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=48084"}],"version-history":[{"count":0,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/posts\/48084\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/media\/48086"}],"wp:attachment":[{"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/media?parent=48084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/categories?post=48084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zohf.me\/lp\/wp-json\/wp\/v2\/tags?post=48084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}