tag:blogger.com,1999:blog-72147702630351417032024-03-26T03:08:56.450-05:00Data PsientistThe Tableau musings of Dan Montgomery, @DanRMontyAnonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-7214770263035141703.post-40449306609870946912014-10-30T10:39:00.002-05:002014-10-31T13:21:41.278-05:00My Favorite Tableau Trick For Work: MIN(1)<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">Many of us found <a class="g-profile" href="https://plus.google.com/113442544069936941837" target="_blank">+Tableau Software</a> from the work that we do in our day jobs, and have since taken our passions to our free time. When given the ability to build visualizations we're passionate about, people come up with creative solutions like <a class="g-profile" href="https://twitter.com/datablick" target="_blank">Anya A'Hearn</a>'s <a href="http://datablick.com/2014/03/27/this-story-starts-with-an-irresistible-map/">Stairs Of The City</a>, <a class="g-profile" href="https://twitter.com/KKMolugu" target="_blank">KK Molugu</a>'s <a href="http://got-data.blogspot.com/2014/03/which-quarterback-has-most-playoff.html">Playoff Quarterback Touchdowns</a>, <a href="https://twitter.com/russellspangler">Russell Spangler</a>'s <a href="http://russellspangler.com/post/92389197225/tableau-story-points-bacon-viz" target="_blank">Bacon Viz</a> (and WAY too many more to mention). </span><br />
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">HOWEVER...</span></div>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
In our day jobs, there is much less room to be creative and more of a need to be direct. As a result, designs usually involve displaying more numbers than visualizations. And while there are best practices by <a href="https://twitter.com/nelsondavis" target="_blank">Nelson Davis</a> about <a href="https://www.slalom.com/thinking/visual-analytics-101-when-to-use-numbers-vs-visualizations" target="_blank">when to use numbers and when to use visuals</a>, numbers end up more often than us 'creative types' would prefer. </span><br />
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">FEAR NOT!</span></div>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
You can still let loose your creative side even when displaying numbers. My personal favorite trick is the <i>MIN(Number of Records)</i> trick, or simply <i>MIN(1)</i>. You can create the field like so, and then set the default aggregation to MIN</span><br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
</span><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBOr8adiVU9hqGYU4dE-B8wmvgfjs2wMjA_pWGAgMSXjAAOfC-W8-K2r5gQrjO8jYLoGd3_BuCCzcf_EYTIDg7lC8jQyZNDhybjtISiSeffEEzOD8SZHZHBu4fKitC3YYAseuIYskrqS0/s1600/1+Measure.PNG" height="124" style="margin-left: auto; margin-right: auto;" width="640" /></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif; font-size: x-small;">You can create a new field or simply use 'Number of Records' that is in default Tableau</span></td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBOr8adiVU9hqGYU4dE-B8wmvgfjs2wMjA_pWGAgMSXjAAOfC-W8-K2r5gQrjO8jYLoGd3_BuCCzcf_EYTIDg7lC8jQyZNDhybjtISiSeffEEzOD8SZHZHBu4fKitC3YYAseuIYskrqS0/s1600/1+Measure.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"></span></a></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsbjcqDq_NkrsrziHDmoy5WP_lo8qJTifJRnKuh07iJksi5cxCctOw-4lA9gqtau7GoVzbceNVn0x2cgP-ugzFJZTmndq26duAQgQSFEUGUmVovqdcryV-KjGBuXvxeQXqh3-AgzlYqjQ/s1600/1+Aggregation.png" height="180" style="margin-left: auto; margin-right: auto;" width="400" /></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif; font-size: x-small;">Set the default aggregation to Minimum to make ongoing use easier</span></td></tr>
</tbody></table>
<br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">And get results like this</span><br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span>
<script src="https://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 515px; width: 564px;">
<noscript><a href='http://datapsientist.blogspot.com/2014/10/tableau-trick-for-work-min1.html'><img alt=' ' src='https://public.tableausoftware.com/static/images/Mi/Min1BlogPost/ColorDifferentRowsofText/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="515" style="display: none;" width="564"><param name='host_url' value='https%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='Min1BlogPost/ColorDifferentRowsofText' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableausoftware.com/static/images/Mi/Min1BlogPost/ColorDifferentRowsofText/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 564px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=https://public.tableausoftware.com/views/Min1BlogPost/ColorDifferentRowsofText" target="_blank">Learn About Tableau</a></div>
</div>
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: large; text-align: center;"><br /></span>
<div style="text-align: center;">
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: large; text-align: center;">WHAT?!</span></div>
<br />
<div style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: large; text-align: center;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">
<i>MIN(1)</i> is a calculated field that you can create that give you a measure in your worksheet that acts as a place holder for other measures. You can then add whatever measure, or combination of measures, to the text charm of your field and display that in a very organized fashion.</span><br />
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">???????????</span></div>
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">An example then.</span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">Normally, if we wanted to show a series of numbers on a sheet, we put 'Measure Names' in the rows, 'Measure Values' in the Text, and it would look something like this....</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKR19KInFdaMX8xcRa95osUyL4FUDfBeDSkNOBd2Puf0jotS_uWArPrw0K0ft_7yO9n8Eg3eojaRVlNtKt6BYq1trb04e0aFRG_HaS5u9P4O2-Jw91-9l7etBDYIU3VLi4m-vS0TMbhdQ/s1600/Standard+Numbers.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKR19KInFdaMX8xcRa95osUyL4FUDfBeDSkNOBd2Puf0jotS_uWArPrw0K0ft_7yO9n8Eg3eojaRVlNtKt6BYq1trb04e0aFRG_HaS5u9P4O2-Jw91-9l7etBDYIU3VLi4m-vS0TMbhdQ/s1600/Standard+Numbers.PNG" height="396" width="640" /></span></a></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">But if you want to color just the Profit Margin line, based on a set percentage of 20%, you can't. An attempt would make your result looks something like this...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYtpo3QrijwSMjo0e8PyiPnSBYlKCwbx4BaFfYZSbBnnVyQSAfeHO-uCaMVI67F0G1cBwe6Ji8ySzH_X986WWN3y9GJ-PSkRL7swXmISK7MmTwn2FYAussYaauoNaj5gmFxRYXjlm7BB8/s1600/Standard+Numbers+Colored.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYtpo3QrijwSMjo0e8PyiPnSBYlKCwbx4BaFfYZSbBnnVyQSAfeHO-uCaMVI67F0G1cBwe6Ji8ySzH_X986WWN3y9GJ-PSkRL7swXmISK7MmTwn2FYAussYaauoNaj5gmFxRYXjlm7BB8/s1600/Standard+Numbers+Colored.PNG" height="488" width="640" /></span></a></div>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
However, using <i>MIN(1)</i>, you can set placeholders for each of the measures and then analyze them however you want. Here's the same sheet, redesigned....</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpaqifSz2aO3prqr7W1H4tFRBlcaCKRiyLYQoqciKym4yOQ3OsgmJkvRqqxh70DwicDcJlM8WeGlUCI5i-Pw4aK2uLZ4JD9gzjHdp4GFTpQa_Q-bRv-lQF-Vlbt-uTYYEr4ulQchLF4QI/s1600/New+Worksheet.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpaqifSz2aO3prqr7W1H4tFRBlcaCKRiyLYQoqciKym4yOQ3OsgmJkvRqqxh70DwicDcJlM8WeGlUCI5i-Pw4aK2uLZ4JD9gzjHdp4GFTpQa_Q-bRv-lQF-Vlbt-uTYYEr4ulQchLF4QI/s1600/New+Worksheet.PNG" height="496" width="640" /></span></a></div>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
Notice how I've dragged four copies of <i>1</i> on the screen that show up as <i>MIN(1)</i> because that is the default aggregation I have set. Every row is now on a scale of 0-2, with 1 dead in the middle, but more importantly it provides it's own measure to color, size, give level of detail, etc. Now I can just color the Profit Margin line by itself and leave the other lines alone.</span><br />
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
NOT ENOUGH, YOU SAY?!</span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">What about combination charts, a chart that shows both bars and text. If we try the traditional example again, we get something like this.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDqd8bAVGgFqGINYElTRrBoNChssLVO71CdugTnI0BN6TO4JdwMFF24QBHnFHeVBQWxg3CtE3vRUuN8-uGpCcrbaHlVxft5WKaGJ5hJ_cimkWEZ6H5MimQT_6_os4TSS5h2D1xlqhWjr0/s1600/Standard+Bar+Chart+in+Text.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDqd8bAVGgFqGINYElTRrBoNChssLVO71CdugTnI0BN6TO4JdwMFF24QBHnFHeVBQWxg3CtE3vRUuN8-uGpCcrbaHlVxft5WKaGJ5hJ_cimkWEZ6H5MimQT_6_os4TSS5h2D1xlqhWjr0/s1600/Standard+Bar+Chart+in+Text.PNG" height="353" width="640" /></span></a></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">While we are able to achieve both text and charts, the text is aligning to the value it represents thus making it hard to read the numbers. Now let's' rebuild this using <i>MIN(1)</i></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCq1iieBITQZj64hC7j0soSJPZknABSdw8PsnO5sq6CpO6mnIZWlsHGjpC1f4wDwdvXNr0Ge9Ac5oUR6udms3a8KxL6DyiSIIDn4FcvqKOVwPnSq8KFgupdkjVcPAFtSiMO7piNBq56Iw/s1600/1+Bar+Chart+in+Text.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCq1iieBITQZj64hC7j0soSJPZknABSdw8PsnO5sq6CpO6mnIZWlsHGjpC1f4wDwdvXNr0Ge9Ac5oUR6udms3a8KxL6DyiSIIDn4FcvqKOVwPnSq8KFgupdkjVcPAFtSiMO7piNBq56Iw/s1600/1+Bar+Chart+in+Text.PNG" height="356" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">The result is that the numbers are all aligned for each metric, a bar chart is in the middle for the specific metric worth highlighting, they are still separate measures which allows us to edit color, size, and level of detail, with an overall clean look.</span><br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">UPDATE: <a href="https://twitter.com/mondaymviz" target="_blank">Steven Carter</a> wrote a <a href="http://mmviz.blogspot.com/2014/10/conditional-formatting-w-min1.html" target="_blank">post to do filled cell conditional formatting with text</a>. Forcing the cell lengths and using Gantt charts you can now have a look that is similar to Excel (for helping people transition away from it)</span><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCT_iMzXYbvyR2VnlATYP0s5aGXVnlDkCFLOMm7Rnot0qKSTaJlyAdnLdPzEVREIyt4qNufViVrS_H-V2xkg7t-bv-S3scz6TZTDogS0A9itBAAMQhtOKu7h7TR9HJO0fQ9_yalWhL1c/s1600/1+Bar+Chart+in+Text+2.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCT_iMzXYbvyR2VnlATYP0s5aGXVnlDkCFLOMm7Rnot0qKSTaJlyAdnLdPzEVREIyt4qNufViVrS_H-V2xkg7t-bv-S3scz6TZTDogS0A9itBAAMQhtOKu7h7TR9HJO0fQ9_yalWhL1c/s1600/1+Bar+Chart+in+Text+2.PNG" height="328" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Way to go Steven!</td></tr>
</tbody></table>
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: large;">In addition in both cases, because this is all done in 1 chart there is one query back to the data source, and if you have too many values to fit on the screen, you can SCROLL (!!!!!) and know that one scroll will move all of the fields necessary.</span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span>
<br />
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">ONE MORE EXAMPLE</span></div>
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">I was working with a customer where on a dashboard, we wanted a way to highlight the number of alerts that people needed to pay attention to. To make it stand out, I put the number in a text box with a highlighted background and a border. </span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">Using <i>MIN(1)</i> as a bar chart and setting the range from 0 to 1, I can set the border on the bar chart, change the background color based on any value you want. All of this is happening while also never having to worry about the bar chart range. Here's what the sheet looks like.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicNUUMl8gwLasoPw0suvjaBP7EY3968TI0uryf4-lmc8B1rnkz5vIdzeUxNqGwwB6ZHInk14EwSm1SQYnWwhWz1_8-iMy86FVxaxPCFnUQhojviuueS6YqdGhhtt8h81oCDxhzu7CO3ck/s1600/Filled+Cell+With+Borders.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicNUUMl8gwLasoPw0suvjaBP7EY3968TI0uryf4-lmc8B1rnkz5vIdzeUxNqGwwB6ZHInk14EwSm1SQYnWwhWz1_8-iMy86FVxaxPCFnUQhojviuueS6YqdGhhtt8h81oCDxhzu7CO3ck/s1600/Filled+Cell+With+Borders.PNG" height="443" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
</div>
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">CONCLUSION</span></div>
<div style="text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;">If you're building a dashboard and need to display numbers in some capacity, <i>MIN(1)</i> is another tool in your Swiss Army Knife of Tableau skills. It allows you clean layouts but with all of the customization we've come to know and love using Tableau. </span><br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />
Please comment or tweet at me (<a href="https://twitter.com/danrmonty" target="_blank">@DanRMonty</a>) with other ways you've found you can use <i>MIN(1)</i>!</span><br />
<div style="text-align: center;">
<br />
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 564px;">
<div style="float: right; padding-right: 8px;">
</div>
<br /></div>
</div>
<div style="float: right; padding-right: 8px;">
<div style="text-align: center;">
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: large;">DISCLAIMER: you do need to have text fields on your dashboard now to label your measures (you can put them in a container to make it easier to manage). You can see this in the dashboard above.</span></div>
</div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com82tag:blogger.com,1999:blog-7214770263035141703.post-47163760058950666922014-09-28T21:31:00.000-05:002014-09-29T15:07:04.081-05:00How to auto-scale and auto-arrange shapes/visuals in Tableau<span style="font-family: Georgia, Times New Roman, serif;">I ran into a unique problem when I built my <a href="http://datapsientist.blogspot.com/2014/03/ready-set-ironviz.html" target="_blank">sports viz</a> a while back. I had this idea to show a picture for every value of a metric. However, when I sized the sheet to fit the maximum allowable values, any less than the maximum showed a large amount of white space. (I've since <a href="http://datapsientist.blogspot.com/2014/03/ready-set-ironviz.html">updated the sports viz with this article's trick</a>)</span><span style="font-family: Georgia, 'Times New Roman', serif;"> </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Then my friend <a href="https://twitter.com/mondaymviz" target="_blank">Steven Carter</a> released his viz titled "<a href="http://www.tableausoftware.com/public/gallery/adoption-gap" target="_blank">The Adoption Gap</a>" (and subsequently won <a href="https://twitter.com/Vizoftheday/status/514811619038482432">Viz of the Day</a>) where he took my picture idea to the next level with his household grid. Using formulas, he was able to set a grid, and then show a gradually filled in house to represent the number of adoptions needed.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">AND THEN <a href="https://twitter.com/ChrisLuv" target="_blank">Chris Luv</a> released his <a href="http://www.theinformationlab.co.uk/2014/09/29/understanding-tableau-table-calculations-using-index-size-part-1/" target="_blank">viz explaining INDEX() and SIZE()</a>, two incredibly valuable table calculations in tableau to determine size and position of a point. Using INDEX and SIZE, he was able to completely recalculate row and column values on the fly, removing a lot of constraints Steven and I had come up with. His final viz was so good, it made me rethink my entire design.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span><span style="font-family: Georgia, Times New Roman, serif;">Having been inspired by a number of sources, I present a fourth option (very close to Chris' solution but with a slight tweak). I have build a sample viz that shows how to use formulas and table calculations to autoscale and autoalign shapes (or visualizations as Chris will show) to a grid based on how many values are available. Check out the final result below.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<script src="https://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 489px; width: 424px;">
<div style="text-align: left;">
<noscript><a href='#'><img alt=' ' src='https://public.tableausoftware.com/static/images/Au/AutosizeImages/AutosizeImages/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="489" style="display: none;" width="424"><param name='host_url' value='https%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='AutosizeImages/AutosizeImages' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableausoftware.com/static/images/Au/AutosizeImages/AutosizeImages/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
</div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 424px;">
<div style="float: right; padding-right: 8px;">
<div style="text-align: center;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=https://public.tableausoftware.com/views/AutosizeImages/AutosizeImages" target="_blank">Learn About Tableau</a></div>
</div>
</div>
<h3 style="text-align: center;">
<span style="font-family: Georgia, 'Times New Roman', serif;">HOW TO</span></h3>
<span style="font-family: Georgia, Times New Roman, serif;">In my original sports viz, I was unaware that Tableau will do the sizing and arranging work for you if you have rows and columns that the images will fit in. So here's how to use a unique ID column to auto generate the links we need</span><br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;">1) Create 'Y Axis' Field</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">INT((INDEX()-1)/ ROUND(SQRT(SIZE())))</span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcPl86e5DpER_uBDP2tbzB98bR7ljZSIbDe56OHmWZNLGMzgD98-4k8_7yPUkUmmJh_2ykD4xPiNPOB0wTXumvTFUt5hhrHCzgF-v-Ky9HJuPFdGaetlaCVFc6lgJNQvYa-Di0EYbEE1w/s1600/y+axis.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcPl86e5DpER_uBDP2tbzB98bR7ljZSIbDe56OHmWZNLGMzgD98-4k8_7yPUkUmmJh_2ykD4xPiNPOB0wTXumvTFUt5hhrHCzgF-v-Ky9HJuPFdGaetlaCVFc6lgJNQvYa-Di0EYbEE1w/s1600/y+axis.PNG" height="120" width="400" /></a></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span><span style="font-family: Georgia, Times New Roman, serif;">So what is going on here? The idea is that as the number of objects to display is usually best represented in equal rows and columns. Thus, the number of rows we want (represented on the Y axis) should be the square root of the objects/dimension values. The INDEX() -1 offsets the values so they continue to line up instead of shifting out.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">2) Create 'X Axis' Field</span><br />
<br />
<span style="font-family: Georgia, 'Times New Roman', serif;">INDEX() - (INT((INDEX()-1)/ROUND(SQRT(SIZE())))) * ROUND(SQRT(SIZE()))</span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX2XqUs6LfQbwXAgJB-EHJGFyOo63Elh9NO45oDfE9SqPB7fAsoU5ZznKJ-jMt6vvpxAKnPnV3LQN2B3jc9E-cUhDHqgiJvpysLueNWesx4lu83V_b8qWT73zToyGjjWsMM8KVakiUzJk/s1600/x+axis.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX2XqUs6LfQbwXAgJB-EHJGFyOo63Elh9NO45oDfE9SqPB7fAsoU5ZznKJ-jMt6vvpxAKnPnV3LQN2B3jc9E-cUhDHqgiJvpysLueNWesx4lu83V_b8qWT73zToyGjjWsMM8KVakiUzJk/s1600/x+axis.PNG" height="93" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">This one is a bit more complicated, but is to continue to hit on the idea of displaying equal number of rows and columns. So with the 'Y Axis' figuring out a <i>bucket</i> for values for the row, the X axis needs to reassign the ID for the value so that the rows start over successfully.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">So what this formula is doing is taking the current index value, subtracting the y axis <i>bucket </i>multiplied by the bucket value to always reestablish the new set of rows.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">3) Build sheet and assign shapes</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">The setup is as follows</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">a) [ID] goes in the details</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">b) 'X Axis' goes on the columns shelf, convert to discrete</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">c) 'Y Axis' goes on the rows shelf, convert to discrete</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">d) 'Y Axis' and 'X Axis' should be addressing every field (see second screenshot for the how to)</span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-jpbgO5hckQbJFDJUTF3ptSJuBtMVF6PxzfpltDdNQLIdQpSlZTDB9GRraBDmEjSMYYdyuxyKDj4Z9P34xhQ0tLJ8ha3rmuliAwqFc3IAC4_7STLRo_PO0naIPFvcBDdnMrsI8s5_1AQ/s1600/picture+worksheet.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-jpbgO5hckQbJFDJUTF3ptSJuBtMVF6PxzfpltDdNQLIdQpSlZTDB9GRraBDmEjSMYYdyuxyKDj4Z9P34xhQ0tLJ8ha3rmuliAwqFc3IAC4_7STLRo_PO0naIPFvcBDdnMrsI8s5_1AQ/s1600/picture+worksheet.PNG" height="295" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">a), b), & c)</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="font-size: 13px;">
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiP6hrrM0RkrMX4XLIyYvkNajTSfAMBomL6m7NjTsAHinMV2K-seK2sPHEl4CbUWNEd-KQISpcqDvNUfNinrgol95_65dBOyTKx6tEPYmppBX6Afes3lOsohvDYkIJzMo1UeWCj6dvo4E/s1600/table+calc+edits.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiP6hrrM0RkrMX4XLIyYvkNajTSfAMBomL6m7NjTsAHinMV2K-seK2sPHEl4CbUWNEd-KQISpcqDvNUfNinrgol95_65dBOyTKx6tEPYmppBX6Afes3lOsohvDYkIJzMo1UeWCj6dvo4E/s1600/table+calc+edits.PNG" height="379" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">d)</td></tr>
</tbody></table>
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: small;">Let me know if this is helpful or if you have any questions. Thank you!</span></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com1tag:blogger.com,1999:blog-7214770263035141703.post-44655619484309926862014-09-10T14:00:00.000-05:002014-09-10T19:40:31.860-05:00How to Embed Streaming Web Content in Tableau<span style="font-family: Georgia, Times New Roman, serif;">Tableau is a great</span><span style="font-family: Georgia, 'Times New Roman', serif;">, if not the best,</span><span style="font-family: Georgia, Times New Roman, serif;"> tool for building data visualizations. But what the tool also includes is the ability to display content from the internet right in your viz! Here is the how to for streaming that content, and I will be using my <a href="http://datapsientist.blogspot.com/2014/07/weird-al-ftw.html" target="_blank">"Weird Al" viz</a> as the template for this.</span><br />
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><b>1. Build the Data Set</b></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">If you want an interactive viz that dynamically displays different web content, you first need to build a data set that shows the different components you want to stream. In the case of "Weird Al", I wanted to stream his individual songs and albums, so I went to <a href="http://en.wikipedia.org/wiki/%22Weird_Al%22_Yankovic_discography" target="_blank">Wikipedia for his discography</a> and copied it into a spreadsheet. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<ul>
<li><span style="font-family: Georgia, 'Times New Roman', serif;">Just like any other Viz, a content viz is still data driven, so be sure you have the most robust/cleanest data you can work with</span></li>
</ul>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIVP12eJY2b8xZZiqni4T70VE29pjxfvw9XdehOZjR5NCftSudAfsPs3ml_2BhjRGx0T84AD8jEIOw7qDzSPlKdbYUc-5MoPncrN0qEKkxFAGnSe2a6AA_b3sOAPyiI5OcqoA3f84obyY/s1600/Albums+Excel.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIVP12eJY2b8xZZiqni4T70VE29pjxfvw9XdehOZjR5NCftSudAfsPs3ml_2BhjRGx0T84AD8jEIOw7qDzSPlKdbYUc-5MoPncrN0qEKkxFAGnSe2a6AA_b3sOAPyiI5OcqoA3f84obyY/s1600/Albums+Excel.PNG" height="170" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Album data with various attributes</td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7QgDoRIg-GIQVIF6Uk6-IELMxwagGrWEsW6Q76bC8AWMh7GZ5kTtFqpOYlige6OCEXTs_02N6CQStCZ1zDjEzwyH0F1I2zydRnF4963HGaWvDb32e-tCnmDJx89_pPQdkYNA1LSQV-rU/s1600/songs+excel.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7QgDoRIg-GIQVIF6Uk6-IELMxwagGrWEsW6Q76bC8AWMh7GZ5kTtFqpOYlige6OCEXTs_02N6CQStCZ1zDjEzwyH0F1I2zydRnF4963HGaWvDb32e-tCnmDJx89_pPQdkYNA1LSQV-rU/s1600/songs+excel.PNG" height="148" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Song data with various attributes</td></tr>
</tbody></table>
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><b>2. Gather the web links</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">In a "How-To" guide that allowed me to even build out this idea, <a class="g-profile" href="https://plus.google.com/106131815748690737928" target="_blank">+Ben Jones</a> wrote about <a href="http://dataremixed.com/2013/04/embedding-youtube-videos-in-tableau/" target="_blank">embedding YouTube into Tableau</a>. The key is that regardless of your content source (YouTube, Spotify, Soundcloud, etc), you want to find the 'embed' url to leverage in your dashboard. In Spotify, these can be found by right clicking on a song and selecting 'Copy Embed Code'</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWWPl7aRUi36xRii5e8yZt1sXUg6713A_AzVMh5gML5XLLAyJZc0axQ96yRNiOWMfLBiI0vYUElezqsL8PO2NqqjxHCgzHbICGMLKZE87cwiYKBCm2uO27xYSfdZtjLFyUoOzXiAhY_UM/s1600/Spotify+Embed+Code.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWWPl7aRUi36xRii5e8yZt1sXUg6713A_AzVMh5gML5XLLAyJZc0axQ96yRNiOWMfLBiI0vYUElezqsL8PO2NqqjxHCgzHbICGMLKZE87cwiYKBCm2uO27xYSfdZtjLFyUoOzXiAhY_UM/s1600/Spotify+Embed+Code.png" height="265" width="400" /></a></span></div>
<span style="font-family: Georgia, Times New Roman, serif;">The resulting code will look something like this, and the URL that you want is highlighted in yellow: </span><i><span style="font-family: Georgia, 'Times New Roman', serif;"><iframe src="</span><span style="background-color: yellow; font-family: Georgia, 'Times New Roman', serif;">https://embed.spotify.com/?uri=spotify:track:4ZJGobiy4ayWSdKfoqMRlX</span><span style="font-family: Georgia, 'Times New Roman', serif;">" width="300" height="380" frameborder="0" allowtransparency="true"></iframe></span></i></div>
<div>
<i><span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></i></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">That URL can be copied to your Excel data like so</span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7mr96gWLefNncqI-nOSzp81QUmgLO_feuSlIMxdIVp3BPyAQWcYosmPHnnmVg-NQcq-wRs0CMp4WuZWszo8ysoCLrEIIGZSFxuKk6XWy9ymeh8dUmyarzxK_t5jW6Of5T-P74u0S4cgM/s1600/Song+list+with+embed.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7mr96gWLefNncqI-nOSzp81QUmgLO_feuSlIMxdIVp3BPyAQWcYosmPHnnmVg-NQcq-wRs0CMp4WuZWszo8ysoCLrEIIGZSFxuKk6XWy9ymeh8dUmyarzxK_t5jW6Of5T-P74u0S4cgM/s1600/Song+list+with+embed.PNG" height="160" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">It is very important to line up the correct URL to the correct record in the data</td></tr>
</tbody></table>
<br /><div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;">Regardless of web source (YouTube, Spotify, Soundcloud, etc), identify the <i>Embed</i> url the desired content, and include that in your data source</span></li>
</ul>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;"><b>3. Build a Dashboard That Will Stream the Web Content</b></span></div>
</div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">In your viz, design your dashboard however you wish. For the "Weird Al" viz, I wanted people to be able to select an image of the original artist and then be able to play that song. Here is what the resulting Tableau sheet looks like</span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiT4YeaJdyS6o_x544uJXTOBMjZhVBW4uZTNs1MUx6yfDw9n8P5i2Yd7fm6p6R5B4F-lTLKj7RdMFzgZA2uf-a6PPciynilC1wbWO8-KVkd_7uOh3PVX8Fo2VRPT__th2kQ9MYxddCVezs/s1600/song+worksheet+pp.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiT4YeaJdyS6o_x544uJXTOBMjZhVBW4uZTNs1MUx6yfDw9n8P5i2Yd7fm6p6R5B4F-lTLKj7RdMFzgZA2uf-a6PPciynilC1wbWO8-KVkd_7uOh3PVX8Fo2VRPT__th2kQ9MYxddCVezs/s1600/song+worksheet+pp.png" height="234" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">The field containing the URL needs to be in the details of the worksheet</td></tr>
</tbody></table>
In the dashboard, add the worksheet as well as a <i>Web Page</i> item. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNjXnpStdjj6drsbu_VnnrB4TywDJAithzwmTOxCjL75KrFZUwkvQo0D4sD0mLkFd73DApjKt82auSKCM8W5v6JtKAEFd9HIFm7tajBYNbERgEXu2kBRbv346-6JRa8Nq_K2hTr8fgda4/s1600/web+page+item.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNjXnpStdjj6drsbu_VnnrB4TywDJAithzwmTOxCjL75KrFZUwkvQo0D4sD0mLkFd73DApjKt82auSKCM8W5v6JtKAEFd9HIFm7tajBYNbERgEXu2kBRbv346-6JRa8Nq_K2hTr8fgda4/s1600/web+page+item.PNG" height="128" width="320" /></a></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbPnj5Eq0k_F4qYSQfKzanKj_1j_kaRyL2XpoGuMjtbHipfBdmsqrwlzsS4hnDJv3Iw0cp222w9QbnAsOeqFSVLss8KonAHnPDa-VfQW6La3IhSG8g6wEirmKyZYImCV3op5hIosOT2yI/s1600/edit+url.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbPnj5Eq0k_F4qYSQfKzanKj_1j_kaRyL2XpoGuMjtbHipfBdmsqrwlzsS4hnDJv3Iw0cp222w9QbnAsOeqFSVLss8KonAHnPDa-VfQW6La3IhSG8g6wEirmKyZYImCV3op5hIosOT2yI/s1600/edit+url.PNG" height="107" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">After adding <i>Web Page</i>, select 'OK' to continue. It's okay to leave it blank</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: left;">
With the URL is part of the details, the URL can be triggered from the dashboard via an <a href="http://kb.tableausoftware.com/articles/knowledgebase/combining-sheet-links-and-dashboards" target="_blank">action</a>.</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvG0ZdqdZqQKQg5OPvZLQqw_mQEhyphenhyphentnH4yho5Ed7nBQMkrfKS6VkCFA-YLHDTh-QSOl83D78Cr5ey28OxwugdTOsQymFyjl_jo7zx_yHMxBkH05xbiKWzM1xcfvukRp3rLVq3PL2BAhMw/s1600/Dashboard+action.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvG0ZdqdZqQKQg5OPvZLQqw_mQEhyphenhyphentnH4yho5Ed7nBQMkrfKS6VkCFA-YLHDTh-QSOl83D78Cr5ey28OxwugdTOsQymFyjl_jo7zx_yHMxBkH05xbiKWzM1xcfvukRp3rLVq3PL2BAhMw/s1600/Dashboard+action.png" height="275" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Add the sheet to a dashboard, then select Dashboard -> Action</td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4mSh5INgm9KfMFCvFYBFhyphenhyphenAhNuk18iI5lJHNb49aKRCSfxTQ8zEd9nyCpVRInm9Wvkp7NY3vHzjYrXrjYQFR_jnlFfNyDuD-ZZ66YbcsSQKrJ2FrKT_jYbKNYiZ4T34CCzgFvGdhWdcU/s1600/URL+action.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4mSh5INgm9KfMFCvFYBFhyphenhyphenAhNuk18iI5lJHNb49aKRCSfxTQ8zEd9nyCpVRInm9Wvkp7NY3vHzjYrXrjYQFR_jnlFfNyDuD-ZZ66YbcsSQKrJ2FrKT_jYbKNYiZ4T34CCzgFvGdhWdcU/s1600/URL+action.png" height="120" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">The type of Action to add is a URL action</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: left;">
Check off the sheets you want the action to work from, and then select the field that contains the URL you wish to stream.</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-u7gTMi9V4ymUyhXQ9WFkReIKV2GDinXOYYIIj8t2OhKFAtCNJA0ufcBFr-YBIJQ2PFWLUVwADoXG9PtJdiThN75RmI5wA-z4BRsimZK_4uTwLCuGef-gUozVFl8m9yVOUMwI3TyJkC8/s1600/Dashboard+Action+actua+2l.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-u7gTMi9V4ymUyhXQ9WFkReIKV2GDinXOYYIIj8t2OhKFAtCNJA0ufcBFr-YBIJQ2PFWLUVwADoXG9PtJdiThN75RmI5wA-z4BRsimZK_4uTwLCuGef-gUozVFl8m9yVOUMwI3TyJkC8/s1600/Dashboard+Action+actua+2l.PNG" height="434" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Select the arrow, then select the field that has the URL</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
After that, you can now stream by making a selection on the specified sheets (in this case <i>Parody Song - Images</i> and <i>Parody Song - Lists</i>) and the url listed in the data will appear in the web part.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLzRkr8gQi4t4LhwW7awwa7EAIYuA7QxSA-wq1MiP3gs_5rCMmmELHuCTqFHtaCA5UMtSNXi-MWBQrhkc0-p74uh93ZEjdW6zPeWXv_kCQU6-hpMEO_jdLJF5dOigIyq55Hyhsi461v8M/s1600/url+action+in+action.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLzRkr8gQi4t4LhwW7awwa7EAIYuA7QxSA-wq1MiP3gs_5rCMmmELHuCTqFHtaCA5UMtSNXi-MWBQrhkc0-p74uh93ZEjdW6zPeWXv_kCQU6-hpMEO_jdLJF5dOigIyq55Hyhsi461v8M/s1600/url+action+in+action.PNG" height="160" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<ul>
<li>After placing a Web Page part on your dashboard, you can use a URL Dashboard Action to pull the streaming content from the selected data point.</li>
</ul>
<div>
<b><br /></b>
<b>BONUS POINT. Custom Hyperlink Text</b></div>
<div>
<b><br /></b></div>
<div>
In the section above, the url action was delivered using a 'Select' URL action. That means when a component of the specific worksheet is <i>clicked on</i> then the action will take place.</div>
<div>
<br /></div>
<div>
Tableau also offered 'Menu' actions, meaning that when you hover a specific data point, a URL link appears in the tooltip for you to select. The advantage here is that you can variablize the text in the tool tip. For example, the links could looks something like this...</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpKoMZ5wnjL4wkQbUWgYd_DmvqZyVwu9jhee5sGUEQVWIiBrzNTdu9fUEnO1FWPhcfcesv99XszrRmL738WHtVBWlSFWni4BeywOrSmEMocQih7f-23zI1tFRVhDHTAeWTSbBv48gjFZY/s1600/custom+url+tooltips.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpKoMZ5wnjL4wkQbUWgYd_DmvqZyVwu9jhee5sGUEQVWIiBrzNTdu9fUEnO1FWPhcfcesv99XszrRmL738WHtVBWlSFWni4BeywOrSmEMocQih7f-23zI1tFRVhDHTAeWTSbBv48gjFZY/s1600/custom+url+tooltips.png" height="202" width="640" /></a></div>
<div>
<br /></div>
<div>
This is easy enough to do. Start with the URL action just like before</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwdv6LW1RRF-RJskMUnXrlR03I1h1XS8oEHiE3tiblw2QCJhfAe4OE1D1TnlsJWG7cWcFjaCrkOnEqS1lfWrw0ixZvbHe8dEU5qiYy6CtNiogBNR0N2lk5uYoES12OTCBT3urBaF-2BmM/s1600/URL+action.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwdv6LW1RRF-RJskMUnXrlR03I1h1XS8oEHiE3tiblw2QCJhfAe4OE1D1TnlsJWG7cWcFjaCrkOnEqS1lfWrw0ixZvbHe8dEU5qiYy6CtNiogBNR0N2lk5uYoES12OTCBT3urBaF-2BmM/s1600/URL+action.png" height="120" width="320" /></a></div>
<div>
<br /></div>
<div>
Select the 'Menu' action, and whatever you put in the Name will be what's displayed to the user. You can even variablize the name by including values from the data, in this case Song title.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2cmCawy3uarHqG8lQTWDAK5hJNxB9nVzjXBKqPPH-fMRefNbCLNjOr181jms6jYF4alrr8gAgeStVO4Ro-U3TZH5uf-S5bfraTk_K864cdb3OUCuV7o9pG8F2ZG6CqtYaPg_5-rShT4M/s1600/menu+url+upload.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2cmCawy3uarHqG8lQTWDAK5hJNxB9nVzjXBKqPPH-fMRefNbCLNjOr181jms6jYF4alrr8gAgeStVO4Ro-U3TZH5uf-S5bfraTk_K864cdb3OUCuV7o9pG8F2ZG6CqtYaPg_5-rShT4M/s1600/menu+url+upload.PNG" height="552" width="640" /></a></div>
<br />
<ul>
<li>Actions can be selection or text based. The text based actions, however, can be customized to display a message to the user relevant to the data point they are hovering on.</li>
</ul>
<br />
<b>Conclusion: Steaming Web Content is Easy and Awesome in Tableau!</b><br />
So there you have it, a breakdown of the how to embed steaming web content in your Tableau dashboard. Check out the original viz for the interactive experience.<br />
<script src="https://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 819px; width: 754px;">
<noscript><a href='http://datapsientist.blogspot.com/2014/07/weird-al-ftw.html'><img alt=' ' src='http://public.tableausoftware.com/static/images/PJ/PJMFCB2M3/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="819" style="display: none;" width="754"><param name='host_url' value='https%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='path' value='shared/PJMFCB2M3' /> <param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/PJ/PJMFCB2M3/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /><param name='showVizHome' value='no' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 754px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/shared/PJMFCB2M3" target="_blank">Learn About Tableau</a></div>
</div>
<br />Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com167tag:blogger.com,1999:blog-7214770263035141703.post-63457867129846497142014-09-10T01:30:00.000-05:002014-09-15T18:02:00.313-05:00Making a Viz That Stops Traffic<span style="font-family: Georgia, Times New Roman, serif;">I was honored to be asked to speak at <a class="g-profile" href="https://plus.google.com/113442544069936941837" target="_blank">+Tableau Software</a>'s <a href="http://tcc14.tableauconference.com/" target="_blank">Customer Conference</a> this year with the extremely talented <a class="g-profile" href="https://plus.google.com/105535973171945545823" target="_blank">+Anya A'Hearn</a> and <a class="g-profile" href="https://plus.google.com/102806807032364597526" target="_blank">+Paul Banoub</a> at a feature presentation entitled "<a href="http://tcc14.tableauconference.com/schedule/wednesday#session-1034" target="_blank">Making a Viz That Stops Traffic</a>" hosted by the ever amazing <a class="g-profile" href="https://plus.google.com/103881834811414942288" target="_blank">+Jewel Loree</a>. I gave the following presentation, which compiles my thoughts and process for how I approach building dashboards and visualizations.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Enjoy and feel free to comment to let me know your thoughts. Thank you.</span><br />
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="480" marginheight="0" marginwidth="0" scrolling="no" src="//www.slideshare.net/slideshow/embed_code/38907167" style="border-width: 1px; border: 1px solid #CCC; margin-bottom: 5px; max-width: 100%;" width="750"> </iframe> <br />
<div style="margin-bottom: 5px;">
<strong> <a href="https://www.slideshare.net/datapsientist/making-a-viz-that-stops-traffic" target="_blank" title="Making a Viz That Stops Traffic">Making a Viz That Stops Traffic</a> </strong> from <strong><a href="http://www.slideshare.net/datapsientist" target="_blank">Dan Montgomery</a></strong> </div>
<br /></div>
<div style="margin-bottom: 5px;">
<div style="text-align: left;">
--><a href="http://datapsientist.blogspot.com/2013/12/mike-ditka-look-back-on-chicago-bears.html" target="_blank">Ditka Viz</a></div>
<div style="text-align: left;">
--><a href="http://datapsientist.blogspot.com/2014/03/ready-set-ironviz.html" target="_blank">Show Me The Money</a></div>
<div style="text-align: left;">
--><a href="http://datapsientist.blogspot.com/2014/07/weird-al-ftw.html" target="_blank">"Weird Al" Viz</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-45497282689737493962014-07-31T17:00:00.000-05:002014-07-31T17:00:20.398-05:00Weird Al FTW<span style="font-family: Georgia, Times New Roman, serif;">My enthusiasm for <a href="http://en.wikipedia.org/wiki/%22Weird_Al%22_Yankovic" target="_blank">"Weird Al"</a> started back in 1996 when I was at a friends house and he played the "<a href="http://www.amazon.com/Bad-Hair-Day-Weird-Yankovic/dp/B008DVJKEA/" target="_blank">Bad Hair Day</a>" album for me. I didn't know any of the regular songs, but I thought everything he did was super funny and also made me dance around the house. As time went on, I was able to see him live twice (a must do for anyone) and somehow at every stage of life, I've found other people who enjoy listening to Al as well. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">To celebrate his latest album, "<a href="http://www.amazon.com/Mandatory-Fun-Weird-Al-Yankovic/dp/B00L6GKD36/" target="_blank">Mandatory Fun</a>" and it's climb to <a href="http://www.billboard.com/articles/news/6187435/weird-al-yankovic-tom-green-billboard-no-1-album" target="_blank">#1 on the Billboard charts</a>, I have created a viz to show off how much Al has accomplished and give the user a way to interact with his music like never before. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Hope you enjoy!</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<script src="https://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 845px; width: 754px;">
<noscript><a href='#'><img alt=' ' src='https://public.tableausoftware.com/static/images/We/WeirdAl/Intro/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="845" style="display: none;" width="754"><param name='host_url' value='https%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='WeirdAl/Intro' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableausoftware.com/static/images/We/WeirdAl/Intro/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='tabs' value='no'/><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 754px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=https://public.tableausoftware.com/views/WeirdAl/Intro" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-36492178457970169802014-04-24T17:15:00.000-05:002014-04-25T18:34:30.727-05:00Tableau Data Blending with No Common Dimensions<span style="font-family: Georgia, Times New Roman, serif;">Sometimes when you're working with data, there is a need to compare datasets that don't really have anything in common. This issue came up with my Sports Viz <a href="http://datapsientist.blogspot.com/2014/03/ready-set-ironviz.html" target="_blank">Show Me The Money</a>: I had a dataset that contained the top 100 earning athletes in 2013 and I wanted to show what their pay could buy for them </span><span style="font-family: Georgia, 'Times New Roman', serif;">at an individual item level</span><span style="font-family: Georgia, Times New Roman, serif;"> with out creating an unnecessary Cartesian product.. <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlM4NsUNtOIkGl7XeB09wJLbLjskGT1CfyY7LR-AhFJ_e7t_A6WV99SxjZK5oxzz5NEbPrLy_2gO6qq6Vy6KZWR70PvEIuU-TDva7TCkoMinKqn8ut8uZYhge_9EBcKUk0Z-DOqhzdgyg/s1600/Athlete+Data.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlM4NsUNtOIkGl7XeB09wJLbLjskGT1CfyY7LR-AhFJ_e7t_A6WV99SxjZK5oxzz5NEbPrLy_2gO6qq6Vy6KZWR70PvEIuU-TDva7TCkoMinKqn8ut8uZYhge_9EBcKUk0Z-DOqhzdgyg/s1600/Athlete+Data.PNG" height="208" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Athlete data: a single row per athlete</td></tr>
</tbody></table>
As <a href="https://www.youtube.com/watch?v=p2_lJ2bGltE" target="_blank">Gru</a> would say: Light bulb! If I create a data set containing a row for each purchasable item repeated the maximum amount of times it would appear (aka the number of times the top earning athlete, in this case Tiger Woods, would be able to purchase it), then I could write a calculated field that blended the two sources and did my filtering for me.</span><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ-4KjIxQ-fmKqO0ujuP055DziX4Svj4xG-PgirAp9JsLVSiMU6izS4AN8bpqUqWANhOTXBkSgF4N-_pNbn-mpgnr3Y2jIUdmRMyjhRv3qaH6w2qhyyQjSCPo0hsx0-4pNkjgJAPPI0rQ/s1600/Stuff+to+buy+data.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ-4KjIxQ-fmKqO0ujuP055DziX4Svj4xG-PgirAp9JsLVSiMU6izS4AN8bpqUqWANhOTXBkSgF4N-_pNbn-mpgnr3Y2jIUdmRMyjhRv3qaH6w2qhyyQjSCPo0hsx0-4pNkjgJAPPI0rQ/s1600/Stuff+to+buy+data.PNG" height="286" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Stuff to buy data: note there is no column mentioning athlete</td></tr>
</tbody></table>
Doing this gave me two data sets: one that was 100 rows deep and the other just over 5,000 rows deep.<br />
<div>
<br /></div>
<div>
Next, after bringing in both data sets into Tableau, I created a cross dataset calculated field on the 'Stuff to Purchase' dataset that would allow me to filter out when the number of items exceeded the athletes pay.</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCSiGviH7NYPc0k13vufqet08pGycjnMcNvrr1wAlwYqZ1z8v2PnnkZIvUxnQMDnOHVF4e9f37NF4_vuJebc77ebe3ig8PEUYqgF6keHWI2zCAtRrMkeq8f1rlbHWuVhdD2BNq9_bf108/s1600/Running+Sum+True+False.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCSiGviH7NYPc0k13vufqet08pGycjnMcNvrr1wAlwYqZ1z8v2PnnkZIvUxnQMDnOHVF4e9f37NF4_vuJebc77ebe3ig8PEUYqgF6keHWI2zCAtRrMkeq8f1rlbHWuVhdD2BNq9_bf108/s1600/Running+Sum+True+False.PNG" height="137" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">running_sum(sum([Cost]))<=sum([Forbes 100 Athletes].[Pay $])</td></tr>
</tbody></table>
This way when I add the purchase able items at a data level, it will continue to referenced the accumulated value of the purchases and restrict them to only total that is less than the salary of the specified athlete.</div>
<div>
<br /></div>
<div>
Finally, I added<br />
- RowID into the details<br />
- 'How Many' true false filter to the filter section<br />
- IMPORTANT: Change the 'Compute Using' to use RowID<br />
- Add the purchase category and item to the filter section<br />
- Added the object's description to shape<br />
- Filtered it for the specified athlete (from the secondary source).<br />
- This ultimately ended up being a quick filter that allowed me to select different athletes<br />
<br />
Now I had my sheet that showed each of the items that the person could buy.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5UrkN0Jagyc7rTNbZBte4pv5T12Mx6npZMs9Jf64V_OTsVWaOdMfkaLFY4kcRj0tDBamPvt9G9TR4vbfNiCJNdMAkxQxdnq8N8ZYF6qOHxM9b2D0VTzvARMvVgivTI0Yfv_S_I88D4us/s1600/website.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5UrkN0Jagyc7rTNbZBte4pv5T12Mx6npZMs9Jf64V_OTsVWaOdMfkaLFY4kcRj0tDBamPvt9G9TR4vbfNiCJNdMAkxQxdnq8N8ZYF6qOHxM9b2D0VTzvARMvVgivTI0Yfv_S_I88D4us/s1600/website.PNG" height="306" width="320" /></a></div>
<div>
</div>
<div>
If I had joined them ahead of time, I would have had a Cartesian product of over 160,000 rows! This not only saved me data space, but also cut down on the data prep I needed to get dashboard built. </div>
<div>
<br /></div>
<div>
So the answer all along (to the question that was never asked) was yes, it will blend...even if there are no common dimensions. Let me know if you have any other questions and feel free to comment. Thank you!</div>
<div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com2tag:blogger.com,1999:blog-7214770263035141703.post-90379281895179083542014-03-19T04:55:00.000-05:002014-12-15T14:26:58.358-06:00Ready, Set, #IronViz<span style="font-family: Georgia, 'Times New Roman', serif;">March is </span><a href="http://www.tableausoftware.com/public/blog/2014/03/sports-viz-month-2360" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">Sports Blogging Month</a><span style="font-family: Georgia, 'Times New Roman', serif;"> at </span><a class="g-profile" href="https://plus.google.com/113442544069936941837" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">+Tableau Software</a><span style="font-family: Georgia, 'Times New Roman', serif;">. If you have ever visited my blog before, you know that's definitely the kind of blogging I can get behind (all but 2 of my vizzes have related to sports).</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">So here is my official submission for the sports blogging month and #IronViz sports blogging challenge. Forbes publishes a list of the <a href="http://www.forbes.com/athletes/list/" target="_blank">top 100 earning athletes</a> and in addition to finding insight into HOW these athletes earn their money (endorsements vs salary/winnings), I tried to put a picture around what exactly $78 million dollars translates to (answer: a lot!). </span><br />
<div>
<br /></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">So enjoy and feel free to comment or let me know if you have any questions. Thanks!</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<script src="https://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 1669px; width: 754px;">
<noscript><a href='http://datapsientist.blogspot.com/2014/03/ready-set-ironviz.html'><img alt=' ' src='https://publicrevizit.tableausoftware.com/static/images/Sp/SportsEndorsements/ForbesTop100Athletes/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="1669" style="display: none;" width="754"><param name='host_url' value='https%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='SportsEndorsements/ForbesTop100Athletes' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://publicrevizit.tableausoftware.com/static/images/Sp/SportsEndorsements/ForbesTop100Athletes/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /><param name='showVizHome' value='no' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 754px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=https://public.tableausoftware.com/views/SportsEndorsements/ForbesTop100Athletes" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com5tag:blogger.com,1999:blog-7214770263035141703.post-57659644031490115442014-03-12T11:11:00.000-05:002014-05-14T11:41:40.410-05:00PowerShell and Tableau Server: Automating User Creation and Group Population<span style="font-family: Georgia, Times New Roman, serif;">UPDATE: I corrected the link to enable secure password storage and recovery in PowerShell. Apologies for the incorrect link.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">As long as Tableau Server runs on Windows machines, an admin's best friend is to leverage <a href="http://technet.microsoft.com/en-us/library/bb978526.aspx" target="_blank">PowerShell</a> to automate some everyday tasks. </span><span style="font-family: Georgia, 'Times New Roman', serif;">There have been other great articles on combining Tableau and PowerShell, like </span><a href="https://www.interworks.com/blogs/tladd/2013/08/22/automated-pdf-email-distribution-tableau-views-using-powershell-and-tabcmd" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">Automated PDF Email Distribution</a><span style="font-family: Georgia, 'Times New Roman', serif;"> by the talented folks at </span><a class="g-profile" href="https://plus.google.com/108975392261019832708" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">+InterWorks</a><span style="font-family: Georgia, 'Times New Roman', serif;">. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">But what, for whatever reason, you need to take down a Tableau Server configured for Active Directory Authentication, restore it as Local Authentication, and recreate the existing users (because the users from a directory will not translate to local authentication). </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Why it just so happens that I have a sample script for that! To do this, you will need the following items</span><br />
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;">An admin login and password for Tableau server </span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">A csv file with the existing users, their names, and potentially email address'</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">A csv file with the groups and their users</span></li>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;">Both csv's can be generated using data from the PostgreSQL. Read <a href="http://onlinehelp.tableausoftware.com/current/server/en-us/adminview_postgres_connect.htm" target="_blank">here</a> for how to enable that (and search the forums for how to enable read access for all tables/views, not just the default ones!!!)</span></li>
</ul>
<li><span style="font-family: Georgia, Times New Roman, serif;">A will and desire to WIN! or just take an otherwise tedious task off your plate.</span></li>
</ul>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><a href="https://drive.google.com/folderview?id=0B-y3x6WUbTkyRE5iVGpMLW5oQzQ&usp=sharing" target="_blank">CLICK HERE</a> for a working powershell script and sample documents. This method stores the password in the script, though there is a secure method of accomplishing this</span><span style="font-family: Georgia, 'Times New Roman', serif;"> listed </span><a href="https://www.interworks.com/blogs/trhymer/2013/07/08/powershell-how-encrypt-and-store-credentials-securely-use-automation-script" target="_blank">here</a><span style="font-family: Georgia, Times New Roman, serif;">.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">KEY TAKEAWAYS FOR POWERSHELL</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><a href="http://technet.microsoft.com/en-us/library/hh849891.aspx" target="_blank">Import-CSV</a>: A very power cmdlet to read data from a csv and allow the script to 'play with the results'</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><a href="http://technet.microsoft.com/en-us/library/hh849895.aspx" target="_blank">select-object</a>: Manipulate the results of a data set (perhaps coming from Import-CSV), much like you would with SQL</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><u>.\</u>: This</span><span style="font-family: Georgia, 'Times New Roman', serif;"> forces PowerShell to run traditional command prompt commands without prompting the user to accept it</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><a href="http://technet.microsoft.com/en-us/library/ee176828.aspx" target="_blank">foreach</a>: Exact what the name suggests, iterate through every line of a dataset and run a series of commands</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Thanks everyone. Take care and let me know if you have any questions.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com5tag:blogger.com,1999:blog-7214770263035141703.post-53845773121285985842014-02-27T20:05:00.002-06:002014-02-27T20:05:38.232-06:00#VizYourLife: Moving to San Francisco<span style="font-family: Georgia, Times New Roman, serif;">Not that anyone's holding their breath, but it's been over a month since I posted any content on my blog. In that time, I did the following</span><br />
<br />
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;">Said goodbye to the city I've lived in for 28 years (minus college)</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Packed up almost of my belongings that would fit into my car.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Drove across the country to San Francisco</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Started working the day after I've arrived</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Slept or looked for an apartment nearly every minute I haven't been working</span></li>
</ul>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">So needless to say I have been very busy, or just exhausted enough that I've put the blog on the back burner. </span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">However, here are some viz's based on my last month.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif; margin-left: auto; margin-right: auto;"><a href="https://www.google.com/maps/" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_CpTtll3zsg4QrIBKTbNgOArILkLI-i407sPxAzfh_Q5h4XOmdfQ8-tJR6BU6XOzDVqrUaYfpczPhpda7i-k8VwW5Un71L2RIhpQ0JVF2DIaUDSGORJtOMuGJkkvP03Tlz1AQsn0SpIk/s1600/google+maps.PNG" height="245" width="640" /></a></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif;"><a href="https://www.google.com/maps/" target="_blank">This is my 3 (really 4) day drive from Chicago to the Bay, stopping Nebraska, Utah, and Sacramento</a></span></td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif; margin-left: auto; margin-right: auto;"><a href="http://droughtmonitor.unl.edu/Home/StateDroughtMonitor.aspx?CA" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL5R4ClvvOzu0w6s-S9lbFzD14rCF05HNnkr9O3XXWO6aIYjcnFOCDmYdoy9Vds5KbzNQvCqd8Ip_3yjMX48paW6vXXoWikTVeKHtT3XHkhncuIBgCHRV-dIStIhnuDJ8N8GSPzMJqBWY/s1600/California+drought.PNG" height="492" width="640" /></a></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif;"><a href="http://droughtmonitor.unl.edu/Home/StateDroughtMonitor.aspx?CA" target="_blank">California is currently experiencing a crazy drought, though it was down pouring when I got into Tahoe</a></span></td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://www.zillow.com/visuals/negative-equity/#4/39.98/-106.92" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipg2qtlGk-eekEcxdQOk7Ppl2ANWXMENS3NmWq9sO9rjcIsYgjay8R-ztU1YtmJXOFhSHvorIwrtVEoKIVAjKwm3O2klkFYWmB35KYoEzxo-3V6Ek_-AjOlVUf8NmUNevJOu2PalfpJSI/s1600/Chicago+real+estate.PNG" height="272" style="margin-left: auto; margin-right: auto;" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://www.zillow.com/visuals/negative-equity/#4/39.98/-106.92" target="_blank">Chicago has more negative equity...</a></td></tr>
</tbody></table>
<div style="text-align: left;">
</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://www.zillow.com/visuals/negative-equity/#4/39.98/-106.92" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb1iHHYf0QLTxRfRYFAz_0ZYj77v3f-eP8S_5yjh4qDGZ_CV_La5QnID14-OkcAO0OuzilAUkkBn7crrV2GO8dCV0m33T_eaUunbU1oDMcyKAKT-H8Xwk7lt9dEAHH5oMFYqFOkmBsQxw/s1600/San+Francisco+real+estate.PNG" height="273" style="margin-left: auto; margin-right: auto;" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://www.zillow.com/visuals/negative-equity/#4/39.98/-106.92" target="_blank">...and SF is just insanely expensive.</a></td></tr>
</tbody></table>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Chicago real estate is in higher foreclosure, California real estate is just insanely expensive.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">And while Chicagoans are very proud of their food, San Francisco is not as hippie-dippie vegan/vegetarian as people seem to think they are.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://allrecipes.com/Recipes/American-Recipes/American-Recipes-by-State/Main.aspx?evt19=1&src=hn_parent" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7fz7W0es2jv91uuMBy7KP4Co94UcQQGFvEF-894th5tnbUHAvE1k2MREUY1cvDMT4puDoYylyleQ2ERAUep1r5tYuEU8XxgJTx6MtRJE2dc336elfMEgaeuOXXe0OQ7Ieg5OtP4v_a9w/s1600/Chicago+foods.PNG" height="400" style="margin-left: auto; margin-right: auto;" width="368" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://allrecipes.com/Recipes/American-Recipes/American-Recipes-by-State/Main.aspx?evt19=1&src=hn_parent" target="_blank">Pizza, hot dogs, chili...yeah that sounds right</a></td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://allrecipes.com/Recipes/American-Recipes/American-Recipes-by-State/Main.aspx?evt19=1&src=hn_parent" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7_XwMl5x31dHOVHduDsQlWPY-LJMT4831r8CziOrUUqLv7XaoSG4LPV5SMc7OkYcmtHf2i-of182tuGmNnb6qYc5NqucAO910B5C6mMujrGhTfGJ8_FdOMCdROgXKwrTwg6cRt8LDHlw/s1600/san+francisco+food.PNG" height="400" style="margin-left: auto; margin-right: auto;" width="360" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://allrecipes.com/Recipes/American-Recipes/American-Recipes-by-State/Main.aspx?evt19=1&src=hn_parent" target="_blank">A burger right off the bat, follow by a Cioppino, which looks like an awesome seafood dish.</a></td></tr>
</tbody></table>
<div>
<br /></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">In short, sorry for the delays. I'm still getting settled but I'm so glad to be out in the Bay and looking forward to blogging and meeting up with Tableau users. </span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Take care, everyone.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Links:</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><a href="https://www.google.com/maps/" target="_blank">Google Maps</a></span></div>
<div>
<a href="http://droughtmonitor.unl.edu/Home/StateDroughtMonitor.aspx?CA" target="_blank">Drought Monitor</a></div>
<div>
<a href="http://www.zillow.com/visuals/negative-equity/#4/39.98/-106.92" target="_blank">Zillow Negative Equity Infograph</a></div>
<div>
<a href="http://allrecipes.com/Recipes/American-Recipes/American-Recipes-by-State/Main.aspx?evt19=1&src=hn_parent" target="_blank">All Recipies American Recipies by State</a></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-25871784846618268932014-01-22T14:36:00.000-06:002014-01-28T10:04:34.172-06:00New To Data Blogging: 3 Lessons 3 Months In<span style="font-family: Georgia, Times New Roman, serif;">When <a class="g-profile" href="https://plus.google.com/106131815748690737928" target="_blank">+Ben Jones</a> announced <a href="http://www.tableausoftware.com/public/blog/2014/01/data-blogging-month-2280" target="_blank">Data Blogging Month</a>, I thought about if I should write anything on the subject or not. I've only started blogging about 3 months ago, so I'm still very new to this space. Plus, after learning more about the Tableau Public community, I'm continually humbled by what I see the community put out and feel like I always have things I can be learning.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">But this may also be an opportunity to turn an apparent weakness into a strength: I have the perspective of someone new to the game who is trying to establish a voice and presence while encountering some early bumps in the road. I've probably learned more in the past 3 months than I had in my previous 3 years of using Tableau (kicked off with a schooling by <a href="https://twitter.com/Nelsondavis" target="_blank">Nelson Davis</a>), and maybe these are the same things that others are going through in their early experience of getting into <a class="g-profile" href="https://plus.google.com/113442544069936941837" target="_blank">+Tableau Software</a> Blogging.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br />
<h3>
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;">1. The Story Being Told Is Paramount</span></h3>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">This may seem like the most fundamental concept of data visualization, but is also the very thing that is easiest to lose sight of. In the midst of getting your worksheet perfect and leveraging Tableau's capabilities (not to mention thinking about getting views/retweets/reposts), it becomes very easy to resort to "this will look cool" or "look at how smart I am" types of worksheets that ultimately end up confusing the user and turning people away from the viz... </span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">...and the tool won't get in your way from doing it. </span><span style="font-family: Georgia, 'Times New Roman', serif;">Tableau is so developer friendly, there is no disincentive to complicate. </span><span style="font-family: Georgia, Times New Roman, serif;">I can't count the number of times I've been building and thought along the lines of "It'll look better when I color the line with this metric, or size it with another metrics, or throw in a table calc". Only later, when showing it to someone and </span><span style="font-family: Georgia, 'Times New Roman', serif;">they can't understand what in the hell is going on</span><span style="font-family: Georgia, 'Times New Roman', serif;">, does this come back to bite you.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">The story you are telling grounds you. Even when you are absolutely lost, are suffering writers block, or aren't feeling creative, the story you are telling is what re-engages and brings you back to focus. An engaging story, even if it doesn't have as many bells and whistles, is will keep users looking and sharing. Don't be a <a href="http://images6.fanpop.com/image/photos/33100000/Sheldon-Cooper-the-big-bang-theory-33179503-500-642.jpg" target="_blank">Sheldon</a> and push people away with how smart you think you are.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<h3>
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;">2. Great Design Takes Time (And Lots Of Iteration)</span></h3>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">A goal in the next month is to film how long it takes me to make a dashboard that I publish on Tableau Public. The idea being that even with the ability to create insight in <a href="http://3minutewin.tumblr.com/" target="_blank">3 minutes</a>, I would guess that I spend about 15-30 HOURS of development, and countless more hours even thinking about it, before I get to a Viz that I post up. The dashboards that win <a href="http://www.tableausoftware.com/public/community/viz-of-the-day" target="_blank">Viz of the Day</a> probably go through the later process more so than the former process.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">I may be on the slower end (it's not really something I've polled other developers about), but all of that time is spent in a number of different ways</span></div>
<blockquote class="tr_bq">
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;">I probably create 8-12 worksheets to investigate my data before getting to the 3-4 worksheets in my final viz</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">I'll wish I had more data to answer a question, so then I need to research and find that additional data and bring it into my workbook</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">I'll play with the layout of my dashboard in numerous different combinations</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">I add too much content and now I need to pear it down</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">If there's text, I'm constantly rewording to hit the message while taking up as little space as I can </span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">I'll mess with different color pallets to see if there are better color combinations (FYI: Cyclic is the bomb!)</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">I share drafts with peers and iterate based on their notes </span></li>
</ul>
</blockquote>
<span style="font-family: Georgia, Times New Roman, serif;">It may be inefficient, but I reassure myself with a quote from the #TCC13 keynote: <span style="background-color: white; color: #666666; line-height: 21.993999481201172px;"><a href="http://www.tableausoftware.com/about/blog/2013/9/theory-discovery-tableau-customer-conference-2013-keynote-24894" target="_blank">"The great discoverers are jazz artists— they combine logic with intuition." Discoverers feel, they chase, they shift perspectives and they relate different ideas."</a></span> My overall time may be longer than others, but I would put money that the great final products didn't come together exactly as you see them. Rather, they were the result of exploration, revision, and polish.</span><br />
<h3>
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;">3. Your Blog Is About You, Not Your Audience</span></h3>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">The beautiful thing about the internet is the ability to instantly share your thoughts and receive feedback with a global audience in near real time. I can publish a post, tweet it, and start hearing from others in less than 10 minutes. That tight feedback loop can <a href="http://www.psychologytoday.com/blog/the-athletes-way/201306/social-media-s-dual-edged-sword-narcissism-vs-self-esteem" target="_blank">dig into our own image of ourself</a>. Early on, I fell into the trap of being crushed when I didn't instantly have thousands of retweets or get a million comments. Even after winning Viz of the Day with my <a href="http://www.tableausoftware.com/public/gallery/mike-ditka" target="_blank">Mike Ditka</a> Viz, life moved on and the next day there was a new <a href="http://www.tableausoftware.com/public/gallery/console-wars" target="_blank">Viz of the Day</a> (won by my very talented colleague <a class="g-profile" href="https://plus.google.com/108059547488450918310" target="_blank">+Peter Gilks</a> none the less).</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Now, I'm not saying that being recognized isn't a big deal. W</span><span style="font-family: Georgia, 'Times New Roman', serif;">inning Viz of the Day was a huge honor; something I'm still very proud of and grateful for.</span><span style="font-family: Georgia, Times New Roman, serif;"> I'll never forget jumping up and down when someone who I didn't know (ended up being </span><a class="g-profile" href="https://plus.google.com/110345843768193657254" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">+Steph Stradley</a>)<span style="font-family: Georgia, 'Times New Roman', serif;"> </span><a href="https://twitter.com/StephStradley/status/408717655864918017" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">retweeted </a><span style="font-family: Georgia, 'Times New Roman', serif;">one of my first posts. But getting lost in the idea that "</span><i style="font-family: Georgia, 'Times New Roman', serif;">everything I do has to win/be retweeted/get views</i><span style="font-family: Georgia, 'Times New Roman', serif;">" became more important than "</span><i style="font-family: Georgia, 'Times New Roman', serif;">design something that efficiently tells a story and relays my passion for a topic</i><span style="font-family: Georgia, 'Times New Roman', serif;">".</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Refocusing my efforts back to the process of telling stories that I'm passionate about, and less about the results of those efforts has made the experience enjoyable again. I still reach out for feedback from my talented colleagues at <a class="g-profile" href="https://plus.google.com/100811913970113505109" target="_blank">+Slalom Consulting</a> and I look at what the <a class="g-profile" href="https://plus.google.com/113442544069936941837" target="_blank">+Tableau Software</a> community, especially the <a href="http://www.tableausoftware.com/ZenMasters" target="_blank">Tableau Zen Masters</a>, are producing (my current favorite being <a class="g-profile" href="https://plus.google.com/113937867463799374781" target="_blank">+Kelly Martin</a> and her <a href="http://vizcandy.blogspot.com/" target="_blank">VizCandy</a> blog) to continue to refine my skills. But at the end of the day, my blog is mine; something I do to share my interests in a way that maximizes/sharpens not only my Tableau skills, but also my design skills.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<h3>
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;">Conclusion</span></h3>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">Maybe I'm wrong. Maybe I'm the only guy who gets lost in rabbit holes of features instead of story. Maybe I'm the only one who takes <i>forever</i> to get my viz's together. Maybe I'm the only self deprecating narcissist on the internet. Either way, these all were lessons that I had to learn (and continue to relearn) to be confident and okay with putting myself and my passions out for the world to look at (or ignore). I've improved my Tableau skills beyond where they were before I started and I'm looking forward to what the Tableau Public community (myself included) can produce in the time to come. Thank you.</span></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-91755632100322754342014-01-14T14:03:00.002-06:002014-01-15T17:11:58.409-06:00Defense vs Offense: A Chicago Bears Coaching Transition<span style="font-family: Georgia, Times New Roman, serif;">In January 2013, the <a class="g-profile" href="https://plus.google.com/104795877160670814342" target="_blank">+Chicago Bears</a> made the largest coaching philosophy transition when they <a href="http://espn.go.com/chicago/nfl/story/_/id/8795815/chicago-bears-fire-lovie-smith-missing-playoffs" target="_blank">fired Lovie Smith</a> after a 10-6 season and <a href="http://espn.go.com/chicago/nfl/story/_/id/8848801/chicago-bears-hire-marc-trestman-former-cfl-coach-year-montreal-alouettes" target="_blank">hired Marc Trestman</a> from the CFL. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">How did their back-to-back seasons compare? Check out the viz below for more information.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><span style="font-family: Georgia, Times New Roman, serif;">UPDATE: As pointed out by my brother <a class="g-profile" href="https://plus.google.com/109571745009268178632" target="_blank">+Matt Montgomery</a> , there are two other reasons to be excited for the <a class="g-profile" href="https://plus.google.com/104795877160670814342" target="_blank">+Chicago Bears</a> that I will try to incorporate into the viz.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1. <a href="http://www.advancednflstats.com/2011/01/top-offenses-top-defenses.html" target="_blank">Top Offenses > Top Defenses</a> via AdvancedNFLStats</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. <a href="http://www.footballoutsiders.com/info/FO-basics" target="_blank">Offense is more consistent than Defense, year to year</a> via FootballOutsiders</span><br />
<div class="tableauPlaceholder" style="height: 719px; width: 754px;">
<noscript><a href='#'><img alt='Dashboard 1 ' src='http://public.tableausoftware.com/static/images/Ch/ChicagoBears2012-2013/Dashboard1/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="719" style="display: none;" width="754"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='ChicagoBears2012-2013/Dashboard1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/Ch/ChicagoBears2012-2013/Dashboard1/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 754px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/ChicagoBears2012-2013/Dashboard1" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-87687279603561506442013-12-23T13:14:00.003-06:002013-12-23T13:22:42.220-06:00Tableau #3minwin<span style="font-family: Georgia, Times New Roman, serif;">I created an entry for the Tableau #3minwin competition. I built this dashboard in under 3 minutes using NFL <a href="https://twitter.com/darenw/status/410456065138888704" target="_blank">weather</a> data (and some data from <a href="http://www.pro-football-reference.com/years/2012/games.htm" target="_blank">Pro-Football-Reference</a>) and I've included the youtube video to prove it. Enjoy!</span><br />
<div>
<br /></div>
<iframe allowfullscreen="" frameborder="0" height="315" src="//www.youtube.com/embed/5Q3Gp6FGCjg" width="560"></iframe><br />
<br />
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 869px; width: 1004px;">
<noscript><a href='#'><img alt='NFL Home Weather ' src='http://public.tableausoftware.com/static/images/Ta/Tableau3minwin/NFLHomeWeather/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="869" style="display: none;" width="1004"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='Tableau3minwin/NFLHomeWeather' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/Ta/Tableau3minwin/NFLHomeWeather/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 1004px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/Tableau3minwin/NFLHomeWeather" target="_blank">Learn About Tableau</a></div>
</div>
<br />Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com3tag:blogger.com,1999:blog-7214770263035141703.post-85674829967177608772013-12-18T13:47:00.000-06:002013-12-18T13:49:02.055-06:00Nuclear Power's Effect On Carbon Dioxide Emissions<span style="font-family: Georgia, Times New Roman, serif;">Some may know this, but my undergrad was actually in Nuclear Engineering. While I do not necessarily practice it day to day (as I'm sure most people say of their undergrad education), I certainly walked away with a real passion for the benefits of nuclear energy. It has the ability to generate electricity on the hundred megawatt or even gigawatt level (on par or better than existing fossil fuel plants), produces no carbon dioxide, and properly maintained plants produce no additional radiation to the surrounding area, among many other benefits.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Inspired by <a class="g-profile" href="http://plus.google.com/112283417621009767834" target="_blank">+Hans Rosling</a> (the <a class="g-profile" href="http://plus.google.com/113442544069936941837" target="_blank">+Tableau Software</a> TCC14 keynote speaker) and the work at <a href="http://www.gapminder.org/" target="_blank">Gapminder</a>, I built a dashboard that tells the story of how countries that embrace nuclear energy (especially <a href="http://www.world-nuclear.org/info/Country-Profiles/Countries-A-F/France/" target="_blank">France</a>) have seen a reduction in their carbon dioxide emissions, while countries that have little or no nuclear presence are seeing large increases in their carbon dioxide emissions. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">If you would like to learn more about nuclear power, there was also a documentary that was shown on <a href="http://www.cnn.com/SPECIALS/world/cnn-films-pandoras-promise/index.html" target="_blank">CNN</a> called <a href="http://pandoraspromise.com/category/news#/see-the-film" target="_blank">Pandora's Promise</a>, which interviews well known environmentalists that now support nuclear energy and investigates nuclear power from a variety of different angles.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Enjoy and feel free to comment below.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 719px; width: 754px;">
<noscript><a href='#'><img alt=' ' src='http://public.tableausoftware.com/static/images/Ha/HansRoslingInspiration/NuclearEnergyImpact/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="719" style="display: none;" width="754"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='HansRoslingInspiration/NuclearEnergyImpact' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/Ha/HansRoslingInspiration/NuclearEnergyImpact/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 754px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/HansRoslingInspiration/NuclearEnergyImpact" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-26390252706920842662013-12-16T10:43:00.002-06:002013-12-17T10:00:41.182-06:00A Single Pixel (Or Hide) Can Save Your Tableau Viz<span style="font-family: Georgia, Times New Roman, serif;">UPDATE: After posting this in the <a href="https://plus.google.com/u/0/communities/117263035535334364605" target="_blank">Tableau Tips and Tricks</a> community, <a class="g-profile" href="http://plus.google.com/117351565541307159617" target="_blank">+Shawn Wallwork</a> pointed out an alternative to my solution that is built right into Tableau. It was a lesson for me, so I wanted to share it here as well.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">While working on my Mike Ditka dashboard (<a href="http://datapsientist.blogspot.com/2013/12/mike-ditka-look-back-on-chicago-bears.html" target="_blank">here </a>and on <a href="http://www.tableausoftware.com/public/gallery/mike-ditka" target="_blank">Tableau Public</a>), I had an interesting idea for 'Da Coach' viz: While showing a timeline of a particular coaches season records over time, I would also indicate if the coach had won a Super Bowl that year.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br />
I had found a <a href="http://www.sportslogos.net/logos/list_by_team/593" target="_blank">great site</a> that had images of the Super Bowl logos and used a <a href="https://chrome.google.com/webstore/detail/image-collector-extension/fhffefhdkeibnkdldinbncimlojchnie" target="_blank">Chrome extension</a> to download all of the them. After making a shapes folder for the Super Bowl images in my Tableau Repository, I mapping the images to the coach-season combination that was appropriate. This layered on top of a line chart started to become....</span><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif;"><img border="0" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDGh5JVSsVCY_oCC8Ee3t28DD9aTGXR4KKDXD8F5wb0NqpTxv-9vPdN-u6ipTfYUDH03Qky2rDVvGKfygl1Wwla0PPYzhOU_8QxiMDJATXb16UG7Eb18P4qHiZ0scz7V3p37yhx14-pf8/s1600/Coach+vs+Ditka+Upload.PNG" style="margin-left: auto; margin-right: auto;" width="400" /></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif;">Ugh...so close, yet so far away</span></td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">not what I was hoping for. There were far more 'Null' values than images to display, and if I made the sizing smaller, the Super Bowl logos would not show up.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">NEW METHOD: Tableau builds in a way to accomplish hiding the unwanted shapes. </span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">First, select (left click) the shape you want to hide. This is CRITICAL because jumping this step will not get you the menu options you want.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">Second, right click on the object you want to hide and check 'Hide'</span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-pD1J9RQ4LMAj01itgQ6rNGFniSsoKOF3a2FhxVeQwCmjpuChUJDWwf_a2HETVdVwo8sNgOZXwPGZAPigaHBaVjHJLR33o_S3OPoTAncsbuVjP-nDVjhEDxT_b3QXCQvBjfdbXn1Gh6k/s1600/hide+object.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-pD1J9RQ4LMAj01itgQ6rNGFniSsoKOF3a2FhxVeQwCmjpuChUJDWwf_a2HETVdVwo8sNgOZXwPGZAPigaHBaVjHJLR33o_S3OPoTAncsbuVjP-nDVjhEDxT_b3QXCQvBjfdbXn1Gh6k/s1600/hide+object.png" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">REMEMBER: You will only see this option if you select the object to hide first!</td></tr>
</tbody></table>
<br />
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">If you ever need to see the data that you have hidden, you can select the drop down of the shape card, and select 'Show Hidden Data'</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv7kLkuXfHWKsV4Q5FFbfBmC0ln7-L3_ELflZOSlIuqYrUkk-0BjVU7SE2Z0n35EVcBxMzxY7vUSRwM2nCmATJBGBYJ43AjcUtpLDudJz4vptQjlVOqG5PQb9JJhPnkNk7xHvIDy_HRz4/s1600/Show+Hidden+Data.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv7kLkuXfHWKsV4Q5FFbfBmC0ln7-L3_ELflZOSlIuqYrUkk-0BjVU7SE2Z0n35EVcBxMzxY7vUSRwM2nCmATJBGBYJ43AjcUtpLDudJz4vptQjlVOqG5PQb9JJhPnkNk7xHvIDy_HRz4/s1600/Show+Hidden+Data.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif;">This accomplishes the same task as the original method, while also providing some additional space in the Viz. But be sure to remember what you've hidden so you don't loose track of your data. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">ORIGINAL METHOD: Epiphany: what if I made the image for 'Null' values a single pixel? That way, it will be so small it won't be seen as an image, and even if I need to make it bigger, it still will not be noticed. </span></div>
<div class="" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">Sure enough, a website hosts an <a href="http://runescape.wikia.com/wiki/File:1x1-pixel.png" target="_blank">image of a transparent single pixel</a>. After downloading the image and saving it to my shapes folder, it was easy enough to assign: just hovering over they general area Tableau gave me a easy-to-select box.</span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeQ2vXYBShQhaHhNUlSzI2hzRSF2xzGxSZEOtQwd1bja6y-XUQvn6SPqAdSQRjgpuXGoZb7e0xAcxEC3O_mEfjX9St6I4Yorc48uAil1rH6GKmjbqK0J4LSJ1S6NXoxT2XxdcHDTB3muE/s1600/single+pixel.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><span style="font-family: Georgia, Times New Roman, serif;"><img border="0" height="254" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeQ2vXYBShQhaHhNUlSzI2hzRSF2xzGxSZEOtQwd1bja6y-XUQvn6SPqAdSQRjgpuXGoZb7e0xAcxEC3O_mEfjX9St6I4Yorc48uAil1rH6GKmjbqK0J4LSJ1S6NXoxT2XxdcHDTB3muE/s1600/single+pixel.png" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif;">Selecting a transparent single pixel inside of Tableau</span></td></tr>
</tbody></table>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5in7j56Rr6AxxVF17j3GMTF-cgt-HNkKB29aZORef9Kw__tQgvygGcs7x4Wa10sDmiXbVjQeAv4tG5tpFpq0vf04mhxnqE4VQi1JSzS6OHMPgxkv7vERlDwYHutDpzY6U6NL68rFwGck/s1600/Coach+vs+Ditka+Upload+Single+Pixel.PNG" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Georgia, Times New Roman, serif;"><img border="0" height="270" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5in7j56Rr6AxxVF17j3GMTF-cgt-HNkKB29aZORef9Kw__tQgvygGcs7x4Wa10sDmiXbVjQeAv4tG5tpFpq0vf04mhxnqE4VQi1JSzS6OHMPgxkv7vERlDwYHutDpzY6U6NL68rFwGck/s1600/Coach+vs+Ditka+Upload+Single+Pixel.PNG" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Georgia, Times New Roman, serif;">Worksheet updated!</span></td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">In the end this gave me the worksheet I was hoping for all along. Maybe this will help you too in your next viz! Take care.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com1tag:blogger.com,1999:blog-7214770263035141703.post-67160441284250880332013-12-12T15:11:00.000-06:002013-12-12T15:11:10.434-06:00How Does Your Favorite NFL Team Spend Its Salary Cap?<span style="font-family: Georgia, Times New Roman, serif;">NFL Teams are allotted a certain amount of money every year to spend on its players; that money is referred to as the <a href="http://en.wikipedia.org/wiki/Salary_cap#National_Football_League" target="_blank">salary cap</a>. A teams spends its salary cap on players base salaries, various bonuses, severed contracts, practice squad players, and penalties to the team. Each team has to weigh the existing contracts with valued positions and potential contract extensions before hiring and releasing players. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Use the visualization below to better understand how your favorite NFL spends its salary cap. You can select a team, a position, or a player to learn more about the respective team expenses. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Enjoy and feel free to comment below.</span><br />
<br />
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 745px; width: 654px;">
<noscript><a href='#'><img alt=' ' src='http://public.tableausoftware.com/static/images/NF/NFLSalaryInformation/NFLSalaryCap-Team/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="745" style="display: none;" width="654"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='NFLSalaryInformation/NFLSalaryCap-Team' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/NF/NFLSalaryInformation/NFLSalaryCap-Team/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 654px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/NFLSalaryInformation/NFLSalaryCap-Team" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-61815612726071352052013-12-10T16:27:00.000-06:002013-12-10T16:27:17.262-06:00Viz of the Day!<span style="font-family: Georgia, 'Times New Roman', serif;">Today I was very honored to find out I had won Tableau Public's <a href="http://www.tableausoftware.com/public/gallery/mike-ditka" target="_blank">Viz of the Day</a>, a daily selection of cool dashboards built and hosted on Tableau Public. </span><span style="font-family: Georgia, 'Times New Roman', serif;">I am very excited to get the </span><a href="http://datapsientist.blogspot.com/2013/12/mike-ditka-look-back-on-chicago-bears.html" style="font-family: Georgia, 'Times New Roman', serif;" target="_blank">Mike Ditka</a><span style="font-family: Georgia, 'Times New Roman', serif;"> dashboard up and in front of people, showing the impact of a Chicago Bears legend.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">I even got to go to the game last night to watch his number get retired at the game with my dad! It was bitterly cold, but a fantastic 45-28 win over the Cowboys.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivCom8MNIM2JM293I5Fkk4vwibQintFk3REYNLUPf1IPjjaUVnKJO5BtEDtMDdD4LwOdH6ityuhuKxtGogvimwrr1n_hnSlu-cSPfoQkm0IWou4QdzaZCw1CU1CQgQUN_d4G1Uhz8JsDQ/s1600/V__E2BF.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivCom8MNIM2JM293I5Fkk4vwibQintFk3REYNLUPf1IPjjaUVnKJO5BtEDtMDdD4LwOdH6ityuhuKxtGogvimwrr1n_hnSlu-cSPfoQkm0IWou4QdzaZCw1CU1CQgQUN_d4G1Uhz8JsDQ/s400/V__E2BF.jpg" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">My Dad and I at the Bears-Cowboys game, 12/9/2013. Ditka's number was retired at halftime.</td></tr>
</tbody></table>
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">Thank you everyone who liked and shared the viz. It has been a crazy couple of days, but very exciting. Take care.</span></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-21903889285962831032013-12-08T04:37:00.000-06:002013-12-08T05:49:46.636-06:00Mike Ditka: A Look Back On A Chicago Bears Legend <span style="font-family: Georgia, Times New Roman, serif;">With the latest round of commercials of the Super-fans raving about <i>"Dit-ka" </i>and the seemingly never ending stream of advertisements with his face on it, it can be easy to forget how much of a dominant force Mike Ditka was when he was on the field: both revolutionizing playing the Tight End position and coaching one of the most well know Super Bowl teams in the history of the NFL, the 1985 Chicago Bears.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Ditka's triumphs have stood the test of time, and he will be recognized of that on Monday December 9th, when the Chicago Bears organization will retire #89 in honor of his lasting achievements in football. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">While no one post/article/interview can ever quite capture what Mike Ditka meant to the Chicago Bears and the NFL, I have taken an attempt to showcase some of what he has accomplished and how it is still competitive with modern day talents.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">To a Chicago Bears legend from a life-long Chicago Bears fan: Thank you!</span><br />
<br />
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 745px; width: 754px;">
<noscript><a href='#'><img alt=' ' src='http://public.tableausoftware.com/static/images/Di/Ditka/DaPlayer/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="745" style="display: none;" width="754"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='Ditka/DaPlayer' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/Di/Ditka/DaPlayer/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 754px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/Ditka/DaPlayer" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-42672670702324526852013-12-06T16:56:00.000-06:002013-12-06T16:57:34.751-06:00How Does Your Favorite NFL Team Spend Its Salary Cap, Part 2<span style="font-family: Georgia, Times New Roman, serif;">With the original salary cap posts, fans could look at how their favorite team spent its salary cap across different positions. In Part 2, fans can see how the spend of their team compares to other teams for specific positions. For instance, the <a href="http://www.spotrac.com/nfl/atlanta-falcons/matt-ryan/" target="_blank">Atlanta Falcons</a> are spending more money on 1 quarterback (<a href="http://www.spotrac.com/nfl/atlanta-falcons/matt-ryan/" target="_blank">Matt Ryan</a>) than the <a href="http://www.spotrac.com/nfl/minnesota-vikings/" target="_blank">Minnesota Vikings</a> are spending on 3 quarterbacks (<a href="http://www.spotrac.com/nfl/minnesota-vikings/matt-cassel/" target="_blank">Matt Cassel</a>, <a href="http://www.spotrac.com/nfl/minnesota-vikings/christian-ponder/" target="_blank">Christian Ponder</a>, and <a href="http://www.spotrac.com/nfl/minnesota-vikings/josh-freeman/" target="_blank">Josh Freeman</a>), though both are 3 win teams.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The original spend dashboard is also included on a separate tab if you want to go back and check the original data.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Enjoy!</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 745px; width: 654px;">
<noscript><a href='#'><img alt=' ' src='http://public.tableausoftware.com/static/images/NF/NFLSalaryInformation-TheSequel/NFLSalaryCap-Position/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="745" style="display: none;" width="654"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='NFLSalaryInformation-TheSequel/NFLSalaryCap-Position' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/NF/NFLSalaryInformation-TheSequel/NFLSalaryCap-Position/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 654px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/NFLSalaryInformation-TheSequel/NFLSalaryCap-Position" target="_blank">Learn About Tableau</a></div>
</div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com5tag:blogger.com,1999:blog-7214770263035141703.post-31843968814661274592013-11-20T12:38:00.000-06:002013-11-20T12:51:39.218-06:00Dreamforce Conference Visualized<span style="font-family: Georgia, Times New Roman, serif;">Dreamforce is a the new product announcement from Salesforce and is being announced as of this moment in San Francisco. To help understand what is being tweeted out at the conference, I have visualized some of the data being tweeted out (with the help of <a href="http://www.linkedin.com/pub/nelson-davis-msce-eit/7/ab6/4b0" target="_blank">Nelson Davis</a> on data gathering) and organized it so you can see the different types of languages people are tweeting in about Dreamforce.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Enjoy.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><br />
<div class="tableauPlaceholder" style="height: 869px; width: 1054px;">
<noscript><a href='#'><img alt='Dreamforce Analysis Dashboard ' src='http://public.tableausoftware.com/static/images/Dr/DreamforceDashboard/DreamforceAnalysisDashboard/1_rss.png' style='border: none' /></a></noscript><object class="tableauViz" height="869" style="display: none;" width="1054"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='DreamforceDashboard/DreamforceAnalysisDashboard' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/Dr/DreamforceDashboard/DreamforceAnalysisDashboard/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div>
<div style="color: black; font: normal 8pt verdana,helvetica,arial,sans-serif; height: 22px; padding: 0px 10px 0px 0px; width: 1054px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/DreamforceDashboard/DreamforceAnalysisDashboard" target="_blank">Learn About Tableau</a></div>
</div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com0tag:blogger.com,1999:blog-7214770263035141703.post-56203410442644864262013-11-16T13:21:00.001-06:002013-12-28T01:11:09.041-06:00Football Outsiders DVOA Visualized<h2>
<span style="font-family: Georgia, Times New Roman, serif;">Football Outsiders DVOA Visualized</span></h2>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">UPDATE: The visualization has been updated for Week 16.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><a href="http://www.footballoutsiders.com/" target="_blank">Football Outsiders</a> is a website dedicated to statistically understanding how different football teams perform when adjusted for the strength of their opponents. The specifics of <a href="http://www.footballoutsiders.com/info/methods#DVOA" target="_blank">DVOA</a> can be found on their site, but in general, the stat shows how a team will perform on each down and whether they will be able to move the ball progressively down the field (or stop the ball on defense). A positive DVOA is better than a negative DVOA, except on defense where a negative DVOA is better than positive. </span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">However, a team's performance is not always reflected in their record. A team (Team A) with few losses may have that record because they are winning close games and playing weak opponents. On the other hand, a different team (Team B) that has a worse record may have faced tougher opponents but lost close games, but are winning big when they do win. In this case Team B would probably have a better DVOA than Team A, and would be more likely to beat Team A in a game.</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">I have taken that data that Football Outsiders has prepared and visualized it in <a href="http://www.tableausoftware.com/public/" target="_blank">Tableau Public</a>, which allows users to interact with the data to find out more information about their team. Feel free to select your favorite team and learn more about their performance.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<script src="http://public.tableausoftware.com/javascripts/api/viz_v1.js" type="text/javascript"></script><span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br />
<div class="tableauPlaceholder" style="height: 719px; width: 654px;">
<noscript><a href='#'><img alt='DVOA Rankings ' src='http://public.tableausoftware.com/static/images/Fo/FootballOutsidersVisualization_0/DVOARankings/1_rss.png' style='border: none' /></a></noscript><span style="font-family: Georgia, Times New Roman, serif;"><object class="tableauViz" height="719" style="display: none;" width="654"><param name='host_url' value='http%3A%2F%2Fpublic.tableausoftware.com%2F' /> <param name='site_root' value='' /><param name='name' value='FootballOutsidersVisualization_0/DVOARankings' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='http://public.tableausoftware.com/static/images/Fo/FootballOutsidersVisualization_0/DVOARankings/1.png' / > <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></span></div>
<div style="color: black; font-size: 8pt; font-style: normal; font-variant: normal; font-weight: normal; height: 22px; line-height: normal; padding: 0px 10px 0px 0px; width: 654px;">
<div style="float: right; padding-right: 8px;">
<a href="http://www.tableausoftware.com/public/about-tableau-products?ref=http://public.tableausoftware.com/views/FootballOutsidersVisualization_0/DVOARankings" target="_blank"><span style="font-family: Georgia, Times New Roman, serif;">Learn About Tableau</span></a></div>
</div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/17003592691347803479noreply@blogger.com4