<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Dan Gastineau on Medium]]></title>
        <description><![CDATA[Stories by Dan Gastineau on Medium]]></description>
        <link>https://medium.com/@dan.gastineau?source=rss-d7038e0907b8------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*8L-SaYEwH1BI4lza2COGuQ.jpeg</url>
            <title>Stories by Dan Gastineau on Medium</title>
            <link>https://medium.com/@dan.gastineau?source=rss-d7038e0907b8------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 09:01:56 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@dan.gastineau/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[The Goldilocks Zone of Analytics]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/the-goldilocks-zone-of-analytics-40c5345d8dd8?source=rss-d7038e0907b8------2"><img src="https://cdn-images-1.medium.com/max/2600/1*aN9GM44io418Q02R9h-FsA.jpeg" width="5842"></a></p><p class="medium-feed-snippet">Reality is too real. Data is too abstract. Visualization is just right.</p><p class="medium-feed-link"><a href="https://medium.com/data-science/the-goldilocks-zone-of-analytics-40c5345d8dd8?source=rss-d7038e0907b8------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/the-goldilocks-zone-of-analytics-40c5345d8dd8?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/40c5345d8dd8</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Wed, 23 Sep 2020 14:43:06 GMT</pubDate>
            <atom:updated>2020-09-23T14:43:06.718Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[The Interconnectedness of Visualization and Strategy]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/nightingale/the-interconnectedness-of-visualization-and-strategy-62f1560f8139?source=rss-d7038e0907b8------2"><img src="https://cdn-images-1.medium.com/max/2600/1*InRr6TwB1tCbC6XQ2MpxzA.jpeg" width="4500"></a></p><p class="medium-feed-snippet">Great visualizations are the result of clear strategic thinking, not the other way around</p><p class="medium-feed-link"><a href="https://medium.com/nightingale/the-interconnectedness-of-visualization-and-strategy-62f1560f8139?source=rss-d7038e0907b8------2">Continue reading on Nightingale »</a></p></div>]]></description>
            <link>https://medium.com/nightingale/the-interconnectedness-of-visualization-and-strategy-62f1560f8139?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/62f1560f8139</guid>
            <category><![CDATA[dashboard-design]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[strategy]]></category>
            <category><![CDATA[dashboard]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Fri, 27 Mar 2020 13:01:01 GMT</pubDate>
            <atom:updated>2020-03-27T13:01:01.015Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Less Reporting, More Visualization]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/nightingale/less-reporting-more-visualization-d5f050088ca?source=rss-d7038e0907b8------2"><img src="https://cdn-images-1.medium.com/max/2600/1*poe5LOUhJO-Wcx7syywpag.png" width="4267"></a></p><p class="medium-feed-snippet">One simple mantra that helps create data visualizations that matter to others</p><p class="medium-feed-link"><a href="https://medium.com/nightingale/less-reporting-more-visualization-d5f050088ca?source=rss-d7038e0907b8------2">Continue reading on Nightingale »</a></p></div>]]></description>
            <link>https://medium.com/nightingale/less-reporting-more-visualization-d5f050088ca?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/d5f050088ca</guid>
            <category><![CDATA[storytelling]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Tue, 03 Dec 2019 17:28:18 GMT</pubDate>
            <atom:updated>2019-12-03T17:28:18.186Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[The Five Types of People Who Use Visualization]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/nightingale/the-five-types-of-people-who-use-visualization-733d3998f6ef?source=rss-d7038e0907b8------2"><img src="https://cdn-images-1.medium.com/max/1162/1*39agz8vDrrQAZlZ3dGuvSQ.png" width="1162"></a></p><p class="medium-feed-snippet">How to create visuals for who those users are and what they want to do</p><p class="medium-feed-link"><a href="https://medium.com/nightingale/the-five-types-of-people-who-use-visualization-733d3998f6ef?source=rss-d7038e0907b8------2">Continue reading on Nightingale »</a></p></div>]]></description>
            <link>https://medium.com/nightingale/the-five-types-of-people-who-use-visualization-733d3998f6ef?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/733d3998f6ef</guid>
            <category><![CDATA[design]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Fri, 06 Sep 2019 21:18:49 GMT</pubDate>
            <atom:updated>2019-09-06T21:18:49.905Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Tableau Tricks: How to Create a Waterfall Chart]]></title>
            <link>https://medium.com/@dan.gastineau/tableau-tricks-how-to-create-a-waterfall-chart-ffd1160f853d?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/ffd1160f853d</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[tableau]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Fri, 28 Jun 2019 17:37:18 GMT</pubDate>
            <atom:updated>2019-06-28T17:37:18.984Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5abfWraMxCjPbhFsoSvrEA.png" /></figure><p>Tableau is an amazing tool that has made data visualization accessible for many who would otherwise be limited to a world of Excel and PowerPoint. For me it opened the door to a deeply satisfying career where I get to spend all day making visualizations for large companies. My slightly better than average data skills and slightly better than average design skills didn’t get me far but combining them with Tableau has allowed me to deliver value to clients in a way that was not possible 10–15 years ago.</p><p>With that said, the tool has limitations. This is isn’t a knock but rather an acknowledgment that developers for any tool must decide which type of use cases to solve, which by definition alienates all the other potential use cases. After many years of building Tableau solutions for a diverse set of clients, it was inevitable that some of those solutions would require features that Tableau is not explicitly designed to solve. Fortunately Tableau is flexible enough that a workaround can usually be found with a little creativity and a lot of googling.</p><p>A few of these workarounds repeatedly pop up in my projects, so I thought it would be useful to document them. Most are inspired or taken in full from other Tableau developers who have graciously shared their solutions with the world, so I will attempt to give credit where credit is due.</p><h3>Waterfall Chart</h3><p>First up is the waterfall chart, a familiar sight for anyone tasked with explaining year over year growth in a business. Its task is to explain how all the parts of a whole contributed to growth between time period A and time period B — essentially a disassembled stacked bar chart flowing from left from right.</p><p>While a stacked bar can deliver the same message in a more compact space, the waterfall has several advantages. First, it serves as an effective visual metaphor. The image of taking steps up and down like on a staircase is easily connected to an image of how each part of a business contributes to growth. The movement from left to right also leverages the conventional way time is visualized as a horizontal line.</p><p>Secondly, the disassembling of each part allows the viewer to focus on each part individually. This is particularly useful for the smaller parts that get squeezed in the stacked bar. Additionally, the layout allows for more detailed annotation for each part, such as name and amount. This is helpful when the chart is viewed statically, without the benefit of tooltips or other interactive features, such as when printed out for an executive meeting (yes, unfortunately printing is still an important use case to consider, particularly for executives who are more comfortable with a physical binder of reports).</p><p>Because of both the waterfall chart’s prevalence and usefulness, I hope that Tableau will eventually include it as a standard chart, but for now creating one requires a workaround of several steps. There are several walkthroughs for this on the web so not sure who came up with it, but the solution is quite clever. Here’s how it’s done…</p><h4>Step 1</h4><p>Add a dimension and comparison measure to the columns and rows shelves respectively. Keep the dimension to 10 members or less, otherwise the view will be too cluttered. A good rule of thumb is that if the x-axis labels have to be slanted or vertical to fit then you have too many. As for the comparison measure, it can show a difference of absolutes or percentages. One time period vs another time period works best, but it can be a comparison of any two discrete scenarios.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IQ6ge6TMsKjU8V_OJ9YO_w.png" /></figure><h4>Step 2</h4><p>Convert the comparison measure into a running sum table calculation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WQgkJxn017C373AWiKcpjw.png" /></figure><h4>Step 3</h4><p>Convert the chart type to Gantt.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*y-wGIl9qbZ-Vfzc8KfDtnQ.png" /></figure><h4>Step 4</h4><p>Add the comparison measure (the original one, not the converted table calc) to size in the marks shelf, and then make the measure negative by double clicking directly on the green pill and putting a minus sign in front of it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*V4SWsdaTyUrLC4OZKUmXAg.png" /></figure><h4>Step 5</h4><p>Sort the dimension in the columns shelf in descending order based on the original comparison metric. This is more of a preference, but it makes for a cleaner flow from left to right for the viewer to follow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KSQjZyHjltDgZCDeNiZRtg.png" /></figure><h4>Step 6</h4><p>Place the comparison measure on the color shelf and add a total by navigating in the menu to Analysis &gt; Totals &gt; Show Row Grand Totals.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MaqHxcYVnR9it5a1kkTpVw.png" /></figure><h4>Step 7</h4><p>Adjust color settings to suit your purpose. I prefer a simple two-color divide: a neutral color for positive changes and a highlight color for negatives. Also note the checked box for “Include Totals.” This is not selected by default so check it if you want the total bar follow the same color pattern.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Gb-NG8XWy6UPjeLiYOufaQ.png" /></figure><h4>Step 8</h4><p>Put the finishing touches on it. A few of the formatting changes I usually make include removing the y-axis and labeling the bars directly, replacing the total column lines with a light grey shading, and adding a simple header for context.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uKElzCJpGMTn-yQEJ3fCxQ.png" /></figure><p>And that’s it. As far as Tableau tricks go this is one of the easier ones to implement. It’s also one of the most useful. Every Tableau developer would be wise to have it as part of their repertoire.</p><p><em>Dan is the practice leader for Visual Analytics at Aspirent Consulting. He has over 15 years of experience in finance, business analytics, and visualization working with Fortune 500 companies such as The Home Depot, Coca-Cola, and Mattel.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ffd1160f853d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Use Storytelling Conventions to Create Better Visualizations]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/nightingale/how-to-use-storytelling-conventions-to-create-better-visualizations-45177ae517ba?source=rss-d7038e0907b8------2"><img src="https://cdn-images-1.medium.com/max/1061/1*alV4dckCe2ppCQMnH-OX3w.png" width="1061"></a></p><p class="medium-feed-snippet">Story is the best form of communication we have. To the steely eyed analyst, it may seem superfluous and manipulative&#x200A;&#x2014;&#x200A;a way to persuade&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/nightingale/how-to-use-storytelling-conventions-to-create-better-visualizations-45177ae517ba?source=rss-d7038e0907b8------2">Continue reading on Nightingale »</a></p></div>]]></description>
            <link>https://medium.com/nightingale/how-to-use-storytelling-conventions-to-create-better-visualizations-45177ae517ba?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/45177ae517ba</guid>
            <category><![CDATA[design]]></category>
            <category><![CDATA[storytelling]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[topicsindv]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Wed, 12 Jun 2019 21:43:18 GMT</pubDate>
            <atom:updated>2019-06-12T21:43:18.930Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Data Viz Manifesto Part 1: Be Interesting]]></title>
            <link>https://medium.com/@dan.gastineau/data-viz-manifesto-part-1-be-interesting-f01617f3aaf4?source=rss-d7038e0907b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/f01617f3aaf4</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[design]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Dan Gastineau]]></dc:creator>
            <pubDate>Sun, 05 Mar 2017 20:44:48 GMT</pubDate>
            <atom:updated>2017-03-07T22:15:13.376Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OVo_U6_7NIEcYZnexO26gQ.png" /></figure><p>Have something to say. Anyone can create a 20x20 table of 8 pt font data. It shows how hard you worked — it also says, “I have no idea what any of this means. Good luck!”</p><p>Data doesn’t have to be bland and confusing. Imagination and purpose can bring any subject to life. Connect with something people care about and you will be interesting. All data has a story to tell, so don’t create one pixel until you are clear about what it says and why anyone should care.</p><p>Most companies I’ve worked for expect dense visuals — whitespace is merely a placeholder for future content. You may be familiar with the well worn path to bad analytics: a decision is needed and data is gathered, visuals are created and everybody works hard, but little is learned.</p><p>With this approach, those most familiar with the data and all its nuances shift the burden of analysis to those who’ve spent little time thinking about the data. It forces decision makers to go with whatever their gut told them to do in the first place.</p><p>Plodding through several cycles of this made me care about data visualization. Seeing the power it had to influence people with a lot more authority than me made me fall in love with it.</p><p>Data visualization done well can enlighten and change minds. It can help people see things they’ve never seen before or connect ideas they’ve never thought to connect. This is an exciting proposition, but to pull it off, the first task is to convince people to pay attention. Find the story that connects with what they care about and you’ll be off to a great start.</p><h3>Telling a good story and visualizing it well is not a matter of mystical inspiration. It’s the predictable product of putting in the effort before you even think about opening your visualization tool of choice.</h3><p>If you’ve painted a room you know that prep is the vast majority of the work. Actual painting is quick and easy. People don’t pay professionals thousands of dollars because they hate painting. They pay to avoid the prep. Success in data visualization is no different. When you see a impressive visualization where the insights jump off the page, be rest assured that someone spent a great deal of time preparing to create it.</p><p>Have a process that works for you. Tinker with it until you find a method that produces consistent results. It’s amazing how many clever ideas pop into your head when you plan for it.</p><p>My process starts with a pen and paper, where I write out my answers to the questions below. If I am clear with these then creating an effective visualization is a simple matter of execution:</p><ol><li><strong>What does my audience feel angst about?</strong></li></ol><p>Any fiction writer knows that a good story starts with creating tension. A great story makes the unresolved tension unbearable. If I can tap into what my audience cares about on an emotional level they will pay attention.</p><p><strong>2. What is the ONE thing I want them to learn?</strong></p><p>Is my conclusion interesting? Does it address their pain point? Does it challenge current thinking in a meaningful way? If yes, keep going. If no, try again.</p><p><strong>3. What 3–5 ideas support the overall conclusion?</strong></p><p>No visuals yet; just ideas written on a page. If I prove these ideas, is my overall conclusion the only possible conclusion? If not, what else do I need to prove? For each supporting idea, would the conclusion change if the idea was excluded? If no, then exclude it.</p><p><strong>4. For each idea, what supporting evidence is needed?</strong></p><p>What data or relationships between certain data points drive home the points I want to make. Do I have all the data I need? Can I get more data to fill in the gaps? Having 100% of the information needed is rarely possible, but I want to keep pushing on it until I have enough to make a reasonable case.</p><p><strong>5. What type of visuals fit best with my data and conclusions?</strong></p><p>Now the fun begins. I fill up a page or two with several chart ideas for every point I want to make. I often kickstart the process by referencing a few chart choosing resources online, such as <a href="http://www.datavizcatalogue.com/">here</a> and <a href="http://anna.vc/post/112863438962/how-to-think-using-visual-analogies">here</a>. The goal is to not settle for the first idea that appears in my head. Forcing myself to draw several ideas often leads to unexpected revelations. I also want to avoid getting bogged down with drawing detailed and well refined charts. I draw only enough to get the idea. I’m going for quantity over quality.</p><p><strong>6. How do I pull it all together into a cohesive story?</strong></p><p>Once I have a bunch of good ideas I put on my editor hat and decide what stays and how to organize it. There will be more to say on this in future posts so I won’t belabor it now. But, I want a flow that clarifies why the viewer should care and what they should learn from the visual.</p><p>Now it’s time to start visualizing.</p><p>Whenever I get deep into the process of creating visuals and find that I’m struggling with clarity, it’s usually because I’ve glossed over or skipped one of the steps above. I’ve learned that being interesting is not a matter of chance but a repeatable process.</p><p>Data visualization can be a powerful tool of influence, and it will be if you choose to be interesting.</p><p><em>see more at </em><a href="http://www.dangastineau.com/"><em>dangastineau.com</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f01617f3aaf4" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>