August 16, 2012
Hours in R vs. five clicks in Tableau
Matt Katsaros built this really cool map in R of Spotify data. From Matt: “This is a map of SF showing the % of Spotify listens of [I’m leaving the song unnamed] within each ZIP code.”
When I saw this, I left a comment and told Matt that I could show him how to do this in three clicks with Tableau. We met today over lunch.
I connected to the data in Tableau, in this case a CSV file, and was presented with this window:
Step 1: Double-click on the “zip” dimension and you get this map (NOTE: I zoomed in on the continental US for purposes of this write up):
With one click we know where all of the listeners are located. That’s right, one click!
Step 2: Double-click on the “listens” measure and you get this map:
Two clicks and I have an excellent map that shows the concentration of listeners.
Step 3: Drag “listens” onto the color shelf and you get this map:
We’re up to three clicks now and now we’ve emphasized the concentration of listeners with both size and color.
Step 4: Matt then wanted to see the map he built of San Francisco, so I lassoed those point and chose the Keep Only option. I now have this map. Notice that the colors have adjusted to reflect only the data in the view.
Step 5: To change it to a filled map, all I have to do is select the Filled Map option on the Marks card and remove “listens” from the Size shelf.
Five mouse clicks to get Matt’s map. Yes, I know I told him three clicks, but I wanted to show him what Tableau does when you simply click the dimensions and measures. You could do it in less steps using the Show Me menu.
To say Matt was excited is a huge understatement. I believe we have a new convert to Tableau.