My first #MakeoverMonday Live came last week at Tableau Conference in New Orleans. It was an awesome experience that I’m happy to have been a part of!! As far as #MakeoverMonday’s go, in the past few months, I’ve been trying to do a better job of time-boxing myself to a one hour limit, which helped me in being more prepared for the Live version, than I would have been several months ago. So, moving forward my goal is to combine staying around that time limit while implementing the following format…For those of you who have ever read or listened to sports writer, Bill Simmons, he is a favorite of mine. I was a big fan of the NBA Draft Diary columns he used to write. In his articles, Simmons would watch the NBA Draft and simply record his thoughts, as the draft unfolded. Here’s an example…and of course, being a Minnesota Timberwolves fan, it just happened that I clicked on the 2009 draft, one that haunts Wolves fans everywhere to this day. YOU’RE WELCOME GOLDEN STATE!!!!!!!! Anyway, in 2009 Simmons writes;
Ok, so you get the point. I’ll set the timer, work through the week’s project and record some key moments as we go. With this week’s data set bound to be a fun one, why not get right to work?!!
9:11pm – Since seeing Eva’s tweet about the poopy data set, my mind instantly began thinking of ways I could work in an Austin Power’s reference, “Who Does Number 2 Work For?” Unfortunately, I didn’t come up with anything great, but hopefully somebody else does. While looking over the data a bit, it became clear to me that the aim should be to call out those people whose hand you should think twice about shaking. For the record, it blows my mind that people choose to NOT wash their hands after using the restroom, it’s just absolutely disgusting!!
9:18pm – With the decision made to call out those who fail wash their hands 100% of the time, I grouped all other responses together. This way I could incorporate some easy to understand bar charts while having just two bars for each gender, as opposed to six. One bar would represent the percentage of females/males in which you should feel confident shaking their hand, while the other would represent those where you should think twice. Reason behind this decision is if you aren’t washing your hands 100% of the time after using the restroom, I do not want to shake your hand!!
9:24pm – With the decision made on how to display the data, I was still left with three locations. In an attempt to make my visual simple and clean, I decided to focus on only the “While at work” location, as I felt it made for an interesting, albeit disturbing story line…that their are likely co-workers among you who failed to wash their hands after last using the restroom. Here’s the final bar chart, displaying the percentage of co-workers who always wash their hands. Simple and to the point…80% of females wash their hands all the time after going number 2 at work, making it ok to shake their hands. For the men, 77% do the same. The only calculations I made this week were simple text calculations that I would use to label the left side of my bar charts.
9:33pm – Probably 60-70% of my time with this viz was spent searching for and editing the two icons below, that indicate the act of shaking hands and giving knucks/fist bump. Taking a quick look back through my Tableau Public profile, I noticed that I really don’t use icons often, so this was a fun change of pace, but also fairly time consuming. For those of you who may be newer to #MakeoverMonday and Tableau Public, two great resources for finding icons are flaticon.com and thenounproject.com. For more on fonts, colors, etc. be sure to check out The Tableau Assistant Directory from Rebecca Roland.
10:08pm – Closing in on one hour, I finally had my icons edited through the use of PowerPoint and placed on my dashboard with the final visual looking like this.
10:34pm – After adding a title (I took Eva’s comment, below, to heart!!) and some text to explain the viz, I tacked on the typical info on the bottom, including the source and it was time to save to Tableau Public…after a handful of tweaks to get the formatting to display correctly on Tableau Public, I was finished. One hour and twenty-three minutes, from start to finish, not too bad for my first #MakeoverMonday Diary.
Click here for the final product…Thank you for reading!!