{"id":8107,"date":"2018-03-19T02:22:02","date_gmt":"2018-03-19T09:22:02","guid":{"rendered":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/"},"modified":"2026-05-19T15:29:44","modified_gmt":"2026-05-19T22:29:44","slug":"data-last-mile-gap-visualizing-for-impact","status":"publish","type":"post","link":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/","title":{"rendered":"Closing Data&#8217;s Last-Mile Gap: Visualizing For Impact!"},"content":{"rendered":"<p>I worry about data\u2019s <em>last-mile gap<\/em> a lot. As a lover of data-influenced decision making, perhaps you worry as well.<\/p>\n<p>A lot of hard work has gone into collecting the requirements and implementation. An additional massive investment was made in the effort to perform ninja like analysis. The end result was a collection trends and insights. <\/p>\n<p>The <em>last-mile gap <\/em>is the distance between your trends and getting an influential company leader to take action. <\/p>\n<p>Your biggest asset in closing that <em>last-mile gap<\/em> is the way you present the data. <\/p>\n<p>On a slide. On a dashboard in Google Data Studio. Or simply something you plan to sketch on a whiteboard. This presentation of the data will decide if your trends and insights are understood, accepted and inferences drawn as to what action should be taken.<\/p>\n<p>If your data presentation is good, you reduce the <em>last-mile gap<\/em>. If your data presentation is confusing\/complex\/wild, all the hard work that went into collecting the data, analyzing it, digging for context will all be for naught.<\/p>\n<p>With the benefits so obvious, you might imagine that the <em>last-mile gap<\/em> is not a widely prevalent issue. I\u2019m afraid that is not true. I see reports, dashboards, presentations with wide gaps. It breaks my heart, because I can truly appreciate all that hard work that went into creating work that resulted in no data-influence. <\/p>\n<p>Hence today, one more look at this pernicious problem and a collection of principles you can apply to close the <em>last-mile gap<\/em> that exists at your work.<\/p>\n<p>For our lessons today, I\u2019m using an example that comes from analysis delivered by the collective efforts of a top American university, a top 5 global consulting company, and a major industry association. The analysis is publicly available. <\/p>\n<p>I\u2019ve chosen to block out the name of entities involved. <em>Last-mile gaps<\/em> exist at all our companies. It is not important where this 2018 analysis came from. In the tiny chance that you recognize the source, I request you to <strong>keep it out<\/strong> of your comments as well.<\/p>\n<p>For each of the 17 examples we review, I\u2019ll share an alternative version I created. I invite you to play along and share your version of any of the examples. I\u2019ll add them to the post, and credit you.<\/p>\n<p>Ready? <\/p>\n<p>Let\u2019s go!<\/p>\n<p>I persistently advocate for simplicity in slides. <a href=https:\/\/www.kaushik.net\/avinash\/storytelling-with-data-simplify-focus-visualize-outcomes\/#nohandouts\" target=\"_blank\">Don\u2019t create handouts!<\/a><\/p>\n<p>In this case the goal was to create handouts, perhaps to make it easier for audiences to consume the data by themselves. I would humbly still advocate for simplicity when it comes to data presentation. <\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/optimistic_economy.png\"><img fetchpriority=\"high\" title=\"optimistic_economy_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"optimistic_economy_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/optimistic_economy_sm_thumb.png\" width=\"625\" height=\"471\" \/><\/a><\/p>\n<p>Some of the fixes to solve for simplicity could be to use fewer sprinkles, a simpler header \u2013 graphics and text \u2013, and we can be very selective about what\u2019s on he slide. As you look at the slide, I\u2019m sure you\u2019ll come up with other ways in which we can liberate the white space for the tyranny of text\/colors.<\/p>\n<p>Solving for simplicity contributes to communication effectiveness. It of course reflects on your brand, and, most of all, helps you have better control over the story you are trying to tell.<\/p>\n<p>For the rest of this post I\u2019ll ignore the simplicity and storytelling elements and focus exclusively on the data itself. How, what, why and instead of.<\/p>\n<p>Look at the graph above, and the little table\u2026 Ponder for a moment what you would do to close the <em>last-mile gap<\/em> and help the essential message shine through.<\/p>\n<p>Here are some things that stood out for me:<\/p>\n<p><strong><font color=\"#0000ff\">1. Graphing choices can exaggerate or undersell reality.<\/font> <\/strong><\/p>\n<p>One way to exaggerate is to start your y-axis at 40, as it the case above. The resulting line exaggerates the trend and ends up implying something that might not quite be there. <\/p>\n<p>Start at zero. Please.<\/p>\n<p><strong><font color=\"#0000ff\">2. False precision can cause clutter, and undercut the Analyst\u2019s brilliance.<\/font> <\/strong><\/p>\n<p>This is very subtle. <\/p>\n<p>You\u2019ll notice that the numbers on the graph are expressed with one decimal point. As in 47.7, 56.5, etc. If you pause and consider how this data is collected, via a small triple digit sample self-reported survey results, you\u2019ll quickly realize that the error range in this data is likely a few points. If that\u2019s true, showing the .6, .5 is implying a precision that simply does not exist. <\/p>\n<p>Besides, this false precision also clutters the graph.<\/p>\n<p><strong><font color=\"#0000ff\">3. Remove the distractions, ruthlessly.<\/font><\/strong><\/p>\n<p>In an 11-year span, each data point is a lot less important than the trend. Do you need the dots on the graph? Do you even need the numbers for the individual months?<\/p>\n<p>When it comes to closing the <em>last-mile gap<\/em> it is helpful to have a ruthless streak. It is helpful because in service of our ultimate objective, you\u2019ll have to kill some of your favorite things, you\u2019ll have push back against your boss\/peers who might love clutter, and you might have to help change an entire culture. Hard, painful, work. But, immensely worth it.<\/p>\n<p>Here\u2019s an alternative way to present the data, using nothing more than the standard settings in good old Excel:<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/optimistic_economy_v2.png\"><img title=\"optimistic_economy_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"optimistic_economy_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/optimistic_economy_v2_sm_thumb.png\" width=\"625\" height=\"412\" \/><\/a><\/p>\n<p>It shows the trend, simply. You can see it is up broadly over eleven years. That it was under 50 and is now close to 70. <\/p>\n<p>Did you notice the trend is not as exaggerated as the original? And, still effective! <\/p>\n<p>You might use a different font, perhaps have the graph be smaller, or maybe twist the month-year in the other direction. No problem. I\u2019m confident if you apply the first three filters, whatever you create will close the <em>last-mile gap<\/em> better.<\/p>\n<p>Here\u2019s an example of doing exactly the opposite of principle #1. The y-axis is artificially set at 100%, as a result the trend is understated.<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_sales.png\"><img title=\"customer_sales_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"customer_sales_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_sales_sm_thumb.png\" width=\"625\" height=\"469\" \/><\/a><\/p>\n<p>You don\u2019t need to go this far. <\/p>\n<p>Just let your favorite graphing tool auto-set the major and minor-axis, which will result in the graph looking like this\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_sales_v2.png\"><img loading=\"lazy\" title=\"customer_sales_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"customer_sales_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_sales_v2_sm_thumb.png\" width=\"625\" height=\"425\" \/><\/a><\/p>\n<p>Simple. No funny business.&#160; <\/p>\n<p>The trend stands by itself waiting your words as to why it is meaningful.<\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<p> <\/p>\n<p>This next one is pretty interesting. My request to you is to not scroll beyond the slide. Pause. Absorb the graph. Try to understand what the author is really trying to say.<\/p>\n<p>For bonus points, consider the perspective of the person reading this graph rather than the person who created it.<\/p>\n<p>Read. Don\u2019t scroll. Absorb.<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_priorities.png\"><img loading=\"lazy\" title=\"customer_priorities_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"customer_priorities_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_priorities_sm_thumb.png\" width=\"625\" height=\"470\" \/><\/a><\/p>\n<p>How well did you understand the trend and the insight being communicated? What would you have done differently if you\u2019d created the graph?<\/p>\n<p>Here are some things that stood out for me:<\/p>\n<p><strong><font color=\"#0000ff\">4. Show as much data as is required, and no more.<\/font><\/strong><\/p>\n<p>The goal in the original seems to be to show top priorities for 12 months. If so, is the data for August 2017 really adding value? <\/p>\n<p>Often we want to show all the data we have (after all we spent time collecting it!). In this case, it get\u2019s in the way of understanding the 12 month shift.<\/p>\n<p><strong><font color=\"#0000ff\">5. Experiment with visualization options, even in Excel!<\/font><\/strong><\/p>\n<p>We have five dimensions of data, and two data points each (if you apply principle #4). We want the audience to be able to compare two data points for each dimension, and look across all five dimensions.<\/p>\n<p>The bar chart is a sub-optimal way to let the audience <em>see<\/em> this. Consider experimenting with different visuals in Excel (<a href=https:\/\/d3js.org\" target=\"_blank\">or D3js<\/a>).<\/p>\n<p>I applied the radar chart to this data, and got this lovely end result\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_priorities_v2.png\"><img loading=\"lazy\" title=\"customer_priorities_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"customer_priorities_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/customer_priorities_v2_sm_thumb.png\" width=\"625\" height=\"499\" \/><\/a><\/p>\n<p>It is ten million times easier to <em>see<\/em> the two data points for five dimensions, and realize that only two have changed.<\/p>\n<p>Likewise, the overall trend also pops out at you so much easier in this case. <\/p>\n<p>It would have taken ten minutes for us to explain the data and trend in the original. We can do that in five seconds now. You can use the time remaining discussing why this trend is material and what to do about it (if anything). Actually allowing data to play its natural role: Influence decisions.<\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<p><\/p>\n<p>This is a really nice example of a lesson that we tend to forget all the time (myself included).<\/p>\n<p>You know the exercise by now. Pause, reflect on this slide, then scroll.<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_budgets_growth.png\"><img loading=\"lazy\" title=\"marketing_budgets_growth_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"marketing_budgets_growth_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_budgets_growth_sm_thumb.png\" width=\"625\" height=\"471\" \/><\/a><\/p>\n<p>Here\u2019s what stood out for me: <\/p>\n<p><strong><font color=\"#0000ff\">6. Don\u2019t send a graphic to do a table\u2019s job.<\/font><\/strong><\/p>\n<p>In this case, we are comparing two simple data points, on two dimensions (past, present). Why do we need a graph taking up all the space?<\/p>\n<p>Why not just have a table that shows previous 12 months as 7.1% and a row under it with next 12 months as 8.9%?<\/p>\n<p>Even better, why not just have one line of text: <\/p>\n<div style=\"margin-left: 2em\">\n<em>Percent change in marketing budgets = +1.8 PP<\/em>\n<\/div>\n<p><\/p>\n<p>Why have two fat bars? <\/p>\n<p>Once you arrive at that conclusion, you\u2019ll apply principle #4 and realize that the most interesting data on this slide is not the visual\u2026 Rather, it is the table on the top right corner of the slide.<\/p>\n<p>Bada, bing, bada, boom, ten seconds later here\u2019s your slide:<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_budgets_growth_v2.png\"><img loading=\"lazy\" title=\"marketing_budgets_growth_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"marketing_budgets_growth_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_budgets_growth_v2_sm_thumb.png\" width=\"625\" height=\"468\" \/><\/a><\/p>\n<p>A simple table with a touch of colors that draws out the core message simply, directly and quickly. <\/p>\n<p>The lighter shade for the core numbers will result in them being pushed a bit into the background. This simple choice guides the reader\u2019s eyes gently to the delta (the most important bit).<\/p>\n<p>I like playing with the borders a bit, as you see above. You might have other things you are picky about. And, that is ok. :)<\/p>\n<p>To illustrate principle #6, here\u2019s another slide where the graphic is completely unnecessary:<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/spending_on_marketing.png\"><img loading=\"lazy\" title=\"spending_on_marketing_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"spending_on_marketing_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/spending_on_marketing_sm_thumb.png\" width=\"625\" height=\"471\" \/><\/a><\/p>\n<p>A tiny table with two data points will do just fine. <\/p>\n<p>Here\u2019s a bonus lesson for the analysis ninjas out there. Please don\u2019t imply a linear trend between \u201ccurrent levels\u201d and \u201cnext three years.\u201d There is no indication that data from 2017 to 2020 is available, and it is highly unlikely that it will follow a linear trend. This is another example of breaking principle #1.<\/p>\n<p>(Let\u2019s not lose sight of the big picture: I am delighted that spending on analytics is going to increase that much! As our leaders spend this largesse, I hope that they\u2019ll remember <a href=https:\/\/www.kaushik.net\/avinash\/the-10-90-rule-for-magnificient-web-analytics-success\/\" target=\"_blank\">the 10\/90 rule<\/a> to ensure optimal returns. The money needs to go to you!)<\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<p> <\/p>\n<p>This one flummoxed me. <\/p>\n<p>Let\u2019s see if you can internalize what is going on. Stare at the graph intently, seriously, and see if you get the points\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/consumer_services.png\"><img loading=\"lazy\" title=\"consumer_services_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"consumer_services_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/consumer_services_sm_thumb.png\" width=\"625\" height=\"469\" \/><\/a><\/p>\n<p>Bold items naturally catch the eye, in this case the blue bars. Most people in the western world look from left to right, that is how you\u2019ll likely try and understand what\u2019s going on. <\/p>\n<p>Your first impression will likely be that the blue bars are showing a random trend in marketing spending. <\/p>\n<p>If you are the curious type you\u2019ll realize that is the wrong conclusion, and you\u2019ll want to understand what\u2019s really going on. Soon enough you\u2019ll get to the x-axis and a carefully review will illuminate that the reason for the weirdness is the choice to show the industry names alphabetically!<\/p>\n<p><strong><font color=\"#0000ff\">7. Please, please, please keep the end-user in mind.<\/font><\/strong><\/p>\n<p>In this case the end-users (our senior leaders) would be primarily be interested in understanding where marketing spending is highest and lowest. This is very difficult to accomplish above. <\/p>\n<p>Secondarily, they\u2019ll want to know where they fall in context of all other industries, this is almost impossible to accomplish above. <\/p>\n<p>The reason the x-axis is organized alphabetically is to allow you to look up your specific industry easily. This thought is good. My hypothesis is that it likely forms a small percent of the use cases, primarily because just knowing your spend is not that valuable. What\u2019s valuable are the above two use cases. <\/p>\n<p>Here\u2019s what I recommend keeping front of mind: <em>If a non-analyst is looking at the data, what uses cases form the basis of the value they\u2019ll extract<\/em>. Then, ensure the info viz is solving for that.<\/p>\n<p>In this case the bars with the data seem to be randomly sorted. The visualization is getting in the way, creating a wider <em>last-mile gap<\/em>. <\/p>\n<p>Luckily this is a quick fix in good old Excel. Two minutes later, you\u2019ll have a little waterfall\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/consumer_services_v2.png\"><img loading=\"lazy\" title=\"consumer_services_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"consumer_services_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/consumer_services_v2_sm_thumb.png\" width=\"625\" height=\"458\" \/><\/a><\/p>\n<p>It is easy to see the outliers and the pack of eight that are close to each other (something you can\u2019t even see in the original). <\/p>\n<p>It will certainly take an extra couple of seconds to find your industry, but in service of the two bigger use cases,&#160; it is a small price to pay.<\/p>\n<p>You can play with the layout to your heart\u2019s content. If you dislike waterfalls for some reason and prefer towers\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/consumer_services_v3.png\"><img loading=\"lazy\" title=\"consumer_services_v3_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"consumer_services_v3_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/consumer_services_v3_sm_thumb.png\" width=\"625\" height=\"468\" \/><\/a><\/p>\n<p>I like the waterfall, but this is not bad. :)<\/p>\n<p>Play with the colors, drop shadows, fonts, and more. Make the graph your own. Just don\u2019t forget to look at it through the eyes of the end user and solve for their use cases.<\/p>\n<p>(Speaking of colors\u2026 I\u2019m partial to chart styles 17 through 24 in Excel. In my work you\u2019ll see a particular affection for style 18.) <\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<\/p>\n<p>I hate pie charts. I really do.<\/p>\n<p>You can <a href=https:\/\/www.linkedin.com\/pulse\/eat-pies-dont-share-them-avinash-kaushik\/\" target=\"_blank\">read a 506 word love-letter<\/a> to my profound dislike (including a lovely exercise you can do). <\/p>\n<p>Here\u2019s the scientific reason: <\/p>\n<div style=\"margin-left: 2em\">\n<p>Comparison by angle is significantly more difficult than by length.\n<\/p><\/div>\n<p><\/p>\n<p>That is well on display below\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketers_talent.png\"><img loading=\"lazy\" title=\"marketers_talent_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"marketers_talent_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketers_talent_sm_thumb.png\" width=\"625\" height=\"470\" \/><\/a><\/p>\n<p>The colors in the pie will catch your eye. Yet, from the sizes of the slices it is difficult to internalizes the differences between each dimension.<\/p>\n<p><strong><font color=\"#0000ff\">8. Eat Pies, Don&#8217;t Share Them!<\/font><\/strong><\/p>\n<p>Since humans find comparing lengths much easier, it should only take a few minutes to take the data and convert the slide above into something that closes the <em>last-mile gap<\/em> efficiently.<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketers_talent_v2.png\"><img loading=\"lazy\" title=\"marketers_talent_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"marketers_talent_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketers_talent_v2_sm_thumb.png\" width=\"625\" height=\"471\" \/><\/a><\/p>\n<p>The above slide is a good example how to apply all the principles you\u2019ve learned thus far. The question and the data are the hero, almost all by themselves. Allowing you to focus sharply on your story.<\/p>\n<p>Scroll up and down and compare the two slides. You\u2019ll see many more differences.<\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<\/p>\n<p>I\u2019ve extoled the virtue of using a table, instead of trying to be extra sexy and throwing in a graphic.<\/p>\n<p>The challenge with tables is that they can become overwhelming very quickly.<\/p>\n<p>Here\u2019s an example that illuminates that clearly.<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences.png\"><img loading=\"lazy\" title=\"sector_differences_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"sector_differences_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_sm_thumb.png\" width=\"625\" height=\"471\" \/><\/a><\/p>\n<p>It feels like there is a lot. It also breaks principle #2, false precision,&#160; which makes things worse. <\/p>\n<p>Considering the core message the analysis is trying to send, I believe that it is also breaking rule #4, extra perhaps unnecessary data.<\/p>\n<p><strong><font color=\"#0000ff\">9. Make your tables pop, guide the reader\u2019s eye.<\/font><\/strong><\/p>\n<p>There are numerous tools available to you inside Excel to make your tables pop. I usually start by playing with the options at my disposal under Conditional Formatting.<\/p>\n<p>One straight-forward option is to use Color Scales, green to yellow, to produce a simpler table that pops\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v2.png\"><img loading=\"lazy\" title=\"sector_differences_v2_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"sector_differences_v2_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v2_sm_thumb.png\" width=\"625\" height=\"240\" \/><\/a><\/p>\n<p>The elimination of the overall average makes the table tighter. <\/p>\n<p>It is easier to look at the trend in each column. What\u2019s even more delightful is the second use case of comparing the highs and lows across the four dimensions. So much easier.<\/p>\n<p>While all the data is still there, most senior leaders want to understand trends and the contrasts. They want relative positioning, the above table does not require expending too many brain cells to get that. And, if your boss does not trust you\u2026 She still has the numbers there. <\/p>\n<p>Notice the combination of fonts, colors, style treatments, in the table above. Bunch of subtle points there.<\/p>\n<p>If your personal tastes are different, no problem. There are other styles you can use.<\/p>\n<p>Here\u2019s the data rendered using solid fill Data Bars\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v3.png\"><img loading=\"lazy\" title=\"sector_differences_v3_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"sector_differences_v3_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v3_sm_thumb.png\" width=\"625\" height=\"240\" \/><\/a><\/p>\n<p>In this case I feel data bars add clutter, but they make internalizing the trend across individual dimensions easier.<\/p>\n<p>If, like me, you are biased towards radical simplicity via white space, you can keep the table. Consider applying some subtle font color treatment to create something that\u2019s still a step change over the original\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v4.png\"><img loading=\"lazy\" title=\"sector_differences_v4_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"sector_differences_v4_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v4_sm_thumb.png\" width=\"625\" height=\"240\" \/><\/a><\/p>\n<p>I\u2019ve shown the highs and lows in a way that you\u2019ll <em>see<\/em> them quickly. <\/p>\n<p>Red was chosen on purpose to emphasize that it was the most important thing from the customer\u2019s perspective. Blue fades into the background a bit because it is the least important.<\/p>\n<p>One final touch.<\/p>\n<p>I felt it might be of value to see the product and services dimensions together, comparing them across B2B and B2C.<\/p>\n<p>Here\u2019s that version\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v5.png\"><img loading=\"lazy\" title=\"sector_differences_v5_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"sector_differences_v5_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/sector_differences_v5_sm_thumb.png\" width=\"625\" height=\"234\" \/><\/a><\/p>\n<p>There\u2019s a little air gap in the table to emphasize the two comparisons are different. You can usually use visual cues like these to help the consumers of your analysis.<\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<p><\/p>\n<p>We disagree on a whole lot of subjects in our country these days, but the one thing we can all agree on is that the human attention span is probably ten micro-seconds. <\/p>\n<p>Add to that short attention span the fact that each executive has 18 other urgent things taking up their brain cells. As if all that was not hard enough, while you are presenting they are also likely on their phone or laptop.<\/p>\n<p>Persuading anyone in these circumstances is a herculean task. <\/p>\n<p>With that context in mind, how many leaders do you think will understand what\u2019s going on here\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_knowledge.png\"><img loading=\"lazy\" title=\"marketing_knowledge_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"marketing_knowledge_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_knowledge_sm_thumb.png\" width=\"625\" height=\"468\" \/><\/a><\/p>\n<p>4 dimensions x 5 time periods x crazy swings = Ouch!<\/p>\n<p>For bonus points, notice the randomness in the x-axis. It jumps from 2014 to 2017 without any visible explanation. To make things worse, look at the trend lines \u2013 they connect the two data points to imply a trend between 2015, 2016 that may or may not exist.<\/p>\n<p>For even more bonus points, notice that there are four Februaries and as if it is no big deal an August is thrown in randomly.<\/p>\n<p>Ouch. Ouch.<\/p>\n<p>These might seem like small issues, but I assure you that you\u2019ll instantly lose credibility with any intelligent leader in the room. They won\u2019t raise their hand and start to berate you. They\u2019ll quietly make a mental note about you, and then not pay any attention to anything you are saying. <\/p>\n<p>There\u2019s an even more important principle to learn from this visual\u2026<\/p>\n<p><strong><font color=\"#0000ff\">10. Let the <i>higher order bit <\/i>be your north star.<\/font><\/strong><\/p>\n<p>It can be difficult to figure out how to go from the complex to the simple.&#160; My recommendation is to start with the most important thing you are trying to say. <\/p>\n<p>In this instance the goal is to illuminate the percent change in marketing knowledge in the next 12 months. So, are the rest of the data points necessary and of value?<\/p>\n<p>In service of the <em>higher order bit<\/em>, I would argue that we can also get rid of the two Februaries and the lonely August. (Though I sincerely respect the effort it took to get those data points.)<\/p>\n<p>With those decisions we are left with just two data points. We can move to a simple table and close the <em>last-mile <\/em>gap by creating this slide\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_knowledge_v2.png\"><img loading=\"lazy\" title=\"marketing_knowledgem\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_knowledge_v2_sm_thumb.png\" width=\"625\" height=\"471\" \/><\/a><\/p>\n<p>Simpler, right?<\/p>\n<p>We can do one better. <\/p>\n<p>If the objective is to just show the change, we can just show the percentage change.<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_knowledge_v3.png\"><img loading=\"lazy\" title=\"marketing_knowledge_v3_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"marketing_knowledge_v3_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/marketing_knowledge_v3_sm_thumb.png\" width=\"625\" height=\"470\" \/><\/a><\/p>\n<p>The colors help focus the attention even more.<\/p>\n<p>To see the dramatic change, scroll back up and look at the original and then come back here. Incredible, right? <\/p>\n<p>It might seem that this is hard work that takes time. It does take more time. But, it is not in the <em>ink<\/em> rather it is in the <em>think<\/em>. Discussing, debating, really thinking through what we are trying to communicate. The visualizing part takes a lot less time.<\/p>\n<hr color=\"#008000\" width=\"90%\" \/>\n<p><\/p>\n<p>The biggest problem with this type of analysis, compiled into 95 slides, is that it never answers the question <i>why<\/i>?<\/p>\n<p>Take this slide as an example. It shares a very positive view of analytics\u2026<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/analytics_spend.png\"><img loading=\"lazy\" title=\"analytics_spend_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"analytics_spend_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/analytics_spend_sm_thumb.png\" width=\"625\" height=\"472\" \/><\/a><\/p>\n<p>The slide breaks all ten principles we\u2019ve discussed in this post, but beyond that there is a bigger problem here. <\/p>\n<p><strong><font color=\"#0000ff\">11. Why. Your job is to answer <i>why!<\/i><\/font><\/strong><\/p>\n<p>Your first instinct is the marvel at the shift (all blues are up!), and reflect on how this graph is long-term job security for everyone who reads this blog.&#160; But, you\u2019re an Analyst and that good feeling won\u2019t last. <\/p>\n<p>Your mind quickly goes to\u2026 <i>Why?<\/i> What is causing this shift? <\/p>\n<p>Look at Mining\/Construction, 60 percent points of change. OMG! <i>Why?<\/i><\/p>\n<p>The entity creating this report sadly never answers any <i>why<\/i> question anywhere. Perhaps by design. <\/p>\n<p>But, consider this: Data creates curiosity. If the Analyst does not satiate that curiosity via deeper analysis that explains <em>why<\/em>, the same data turns into a disappointment. It certainly drives no change.<\/p>\n<p>I\u2019ve written about this topic before, using an example from Econsultancy and Lynchpin: <a href=https:\/\/www.kaushik.net\/avinash\/survey-results-impact-abandon-asker-puker-model\/\" target=\"_blank\">Smarter Survey Results and Impact: Abandon the Asker-Puker Model!<\/a><\/p>\n<p>Without the <em>why<\/em> your <em>last-mile gap<\/em> is a million miles wide. If you are going to be in the data regurgitation business, please consider it your job to answer the <i>why <\/i>question. Without it all this is\u2026 <i>fake news<\/i>.<\/p>\n<p><strong><font color=\"#0000ff\">A challenge for you to tackle.<\/font><\/strong><\/p>\n<p>Now that you are aware of the 11 principles that aid in closing the <em>last-mile gap<\/em>, I want you to tackle something on my behalf.<\/p>\n<p>I had not idea what to do with this slide\u2026 Can you create an after version?<\/p>\n<p><a href=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/product_service_org.png\"><img loading=\"lazy\" title=\"product_service_org_sm\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; border-top-width: 0px; margin-right: auto\" border=\"0\" alt=\"product_service_org_sm\" src=https:\/\/www.kaushik.net\/avinash\/wp-content\/uploads\/2017\/e9c1891af7b2_5B47\/product_service_org_sm_thumb.png\" width=\"625\" height=\"470\" \/><\/a><\/p>\n<p>Partly the issue is that I could not truly internalize what was being said. Partly it is that the numbers don\u2019t really seem to change much. Partly it is because I was torn between the graphic and the table on the top right. <\/p>\n<p>Regardless, I gave up. Perhaps you can teach me, and our readers, what a version with a reduced <em>last-mile gap<\/em> will look like.<\/p>\n<p>Just email me your version (blog at kaushik dot net) or comment below.<\/p>\n<p> Here\u2019s a summary of the 11 principles you can use to close the <em>last-mile gap<\/em>:<\/p>\n<div style=\"MARGIN-LEFT: 2em\">\n01<font color=red><b>.<\/b><\/font> Graphing choices can exaggerate or undersell reality. <br \/>\n02<font color=red><b>.<\/b><\/font>  False precision can cause clutter, and undercut the Analyst\u2019s brilliance.<br \/>\n03<font color=red><b>.<\/b><\/font> Remove the distractions, ruthlessly.<br \/>\n04<font color=red><b>.<\/b><\/font>  Show as much data as is required, and no more.<br \/>\n05<font color=red><b>.<\/b><\/font>  Experiment with visualization options, even in Excel!<br \/>\n06<font color=red><b>.<\/b><\/font>  Don\u2019t send a graphic to do a table\u2019s job.<br \/>\n07<font color=red><b>.<\/b><\/font>  Please, please, please keep the end-user in mind.<br \/>\n08<font color=red><b>.<\/b><\/font>  Eat Pies, Don&#8217;t Share Them!<br \/>\n09<font color=red><b>.<\/b><\/font>  Make your tables pop, guide the reader\u2019s eye.<br \/>\n10<font color=red><b>.<\/b><\/font>  Let the <i>higher order bit <\/i>be your north star.<br \/>\n11<font color=red><b>.<\/b><\/font>  Why. Your job is to answer <i>why!<\/i>\n<\/div>\n<p><\/p>\n<p><p>I wish you smaller gaps and more decisions that are data-influenced. <\/p>\n<p>As always, it is your turn now. <\/p>\n<p>In your practice, how wide is the <em>last-mile gap<\/em>? What do you think contributes to the gap the most? Which of the above principles have you used, to good effect? Do you have a favorite principle, or five, to close the gap? If you had to kill one practice when it comes to data presentation, who would be the chosen candidate?<\/p>\n<p>Please share versions of the above examples that you\u2019ve taken a crack at fixing. And, your lessons, best practices, and as always your critique via comments below.<\/p>\n<p>Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I worry about data\u2019s last-mile gap a lot. As a lover of data-influenced decision making, perhaps you worry as well. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11,475],"tags":[45,435,30],"class_list":["post-8107","post","type-post","status-publish","format-standard","hentry","category-advanced-analytics","category-data-visualization","tag-actionable-web-analytics","tag-data-visualization","tag-web-analysis"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Closing Data\u2019s Last-Mile Gap: Visualizing For Impact!<\/title>\n<meta name=\"description\" content=\"All the hard work into data collection and analysis often comes to naught due to the last-mile gap. From false precision to visualization options to higher-order bits, learn 11 principles that help close the last-mile gap and create a data-influenced organization.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Closing Data\u2019s Last-Mile Gap: Visualizing For Impact!\" \/>\n<meta property=\"og:description\" content=\"All the hard work into data collection and analysis often comes to naught due to the last-mile gap. From false precision to visualization options to higher-order bits, learn 11 principles that help close the last-mile gap and create a data-influenced organization.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/\" \/>\n<meta property=\"og:site_name\" content=\"Occam&#039;s Razor by Avinash Kaushik\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-19T09:22:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-19T22:29:44+00:00\" \/>\n<meta name=\"author\" content=\"Avinash Kaushik\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Avinash Kaushik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/\"},\"author\":{\"name\":\"Avinash Kaushik\",\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/#\\\/schema\\\/person\\\/4833e40c5e82d40b6e6d0cc37d026ad6\"},\"headline\":\"Closing Data&#8217;s Last-Mile Gap: Visualizing For Impact!\",\"datePublished\":\"2018-03-19T09:22:02+00:00\",\"dateModified\":\"2026-05-19T22:29:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/\"},\"wordCount\":2112,\"commentCount\":42,\"keywords\":[\"actionable web analytics\",\"data visualization\",\"web analysis\"],\"articleSection\":[\"Advanced Analytics\",\"Data Visualization\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/\",\"url\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/\",\"name\":\"Closing Data\u2019s Last-Mile Gap: Visualizing For Impact!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/#website\"},\"datePublished\":\"2018-03-19T09:22:02+00:00\",\"dateModified\":\"2026-05-19T22:29:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/#\\\/schema\\\/person\\\/4833e40c5e82d40b6e6d0cc37d026ad6\"},\"description\":\"All the hard work into data collection and analysis often comes to naught due to the last-mile gap. From false precision to visualization options to higher-order bits, learn 11 principles that help close the last-mile gap and create a data-influenced organization.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/data-last-mile-gap-visualizing-for-impact\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Closing Data&#8217;s Last-Mile Gap: Visualizing For Impact!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/#website\",\"url\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/\",\"name\":\"Occam&#039;s Razor by Avinash Kaushik\",\"description\":\"Marketing | Strategy | Analytics\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.kaushik.net\\\/avinash\\\/#\\\/schema\\\/person\\\/4833e40c5e82d40b6e6d0cc37d026ad6\",\"name\":\"Avinash Kaushik\",\"description\":\"Author: Web Analytics 2.0 &amp; Web Analytics: An Hour A Day | Chief Strategy Officer: Human Made Machine\",\"sameAs\":[\"https:\\\/\\\/www.kaushik.net\\\/avinash\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/akaushik\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/avinash\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Closing Data\u2019s Last-Mile Gap: Visualizing For Impact!","description":"All the hard work into data collection and analysis often comes to naught due to the last-mile gap. From false precision to visualization options to higher-order bits, learn 11 principles that help close the last-mile gap and create a data-influenced organization.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/","og_locale":"en_US","og_type":"article","og_title":"Closing Data\u2019s Last-Mile Gap: Visualizing For Impact!","og_description":"All the hard work into data collection and analysis often comes to naught due to the last-mile gap. From false precision to visualization options to higher-order bits, learn 11 principles that help close the last-mile gap and create a data-influenced organization.","og_url":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/","og_site_name":"Occam&#039;s Razor by Avinash Kaushik","article_published_time":"2018-03-19T09:22:02+00:00","article_modified_time":"2026-05-19T22:29:44+00:00","author":"Avinash Kaushik","twitter_misc":{"Written by":"Avinash Kaushik","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/#article","isPartOf":{"@id":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/"},"author":{"name":"Avinash Kaushik","@id":"https:\/\/www.kaushik.net\/avinash\/#\/schema\/person\/4833e40c5e82d40b6e6d0cc37d026ad6"},"headline":"Closing Data&#8217;s Last-Mile Gap: Visualizing For Impact!","datePublished":"2018-03-19T09:22:02+00:00","dateModified":"2026-05-19T22:29:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/"},"wordCount":2112,"commentCount":42,"keywords":["actionable web analytics","data visualization","web analysis"],"articleSection":["Advanced Analytics","Data Visualization"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/","url":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/","name":"Closing Data\u2019s Last-Mile Gap: Visualizing For Impact!","isPartOf":{"@id":"https:\/\/www.kaushik.net\/avinash\/#website"},"datePublished":"2018-03-19T09:22:02+00:00","dateModified":"2026-05-19T22:29:44+00:00","author":{"@id":"https:\/\/www.kaushik.net\/avinash\/#\/schema\/person\/4833e40c5e82d40b6e6d0cc37d026ad6"},"description":"All the hard work into data collection and analysis often comes to naught due to the last-mile gap. From false precision to visualization options to higher-order bits, learn 11 principles that help close the last-mile gap and create a data-influenced organization.","breadcrumb":{"@id":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.kaushik.net\/avinash\/data-last-mile-gap-visualizing-for-impact\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.kaushik.net\/avinash\/"},{"@type":"ListItem","position":2,"name":"Closing Data&#8217;s Last-Mile Gap: Visualizing For Impact!"}]},{"@type":"WebSite","@id":"https:\/\/www.kaushik.net\/avinash\/#website","url":"https:\/\/www.kaushik.net\/avinash\/","name":"Occam&#039;s Razor by Avinash Kaushik","description":"Marketing | Strategy | Analytics","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kaushik.net\/avinash\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.kaushik.net\/avinash\/#\/schema\/person\/4833e40c5e82d40b6e6d0cc37d026ad6","name":"Avinash Kaushik","description":"Author: Web Analytics 2.0 &amp; Web Analytics: An Hour A Day | Chief Strategy Officer: Human Made Machine","sameAs":["https:\/\/www.kaushik.net\/avinash","https:\/\/www.linkedin.com\/in\/akaushik\/","https:\/\/x.com\/https:\/\/twitter.com\/avinash"]}]}},"_links":{"self":[{"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/posts\/8107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/comments?post=8107"}],"version-history":[{"count":1,"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/posts\/8107\/revisions"}],"predecessor-version":[{"id":9913,"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/posts\/8107\/revisions\/9913"}],"wp:attachment":[{"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/media?parent=8107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/categories?post=8107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaushik.net\/avinash\/wp-json\/wp\/v2\/tags?post=8107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}