Pop Viz: Find your perfect dog or cat

November 26, 2014

For #TableauDesignMonth I wrote up a little blog post called “5 Easy Ways to Pimp Your Viz” which included a handy little dashboard I whipped up about dog breeds:

Learn About Tableau

The data is from Petfinder.com which I scraped with Import.io and turned all the little dot symbols into numbers by doing a crapton of find-and-replace magic in Excel.

Of course, not everyone is a dog person (in fact, we know where the cat fanciers live!):


So, here’s a cat dashboard too! The data is also from Petfinder.

Learn About Tableau

Why are dataviz people often musicians?

November 18, 2014

I’ve noticed that there’s a lot of us out there in the dataviz world that are also musicians. I’m a sax and bass player. I know many of you out there are also into playing music. I’ve always wondered what it was that draws musical people to dataviz (or vice versa).

My theory is that both dataviz and music engage both the analytical, mathematical side and artistic creative sides of your brain. I was recently sent this TED-Ed video that alludes to the same idea. Check it out. It’s a party in our brains!

Pop Viz: Grow a data mustache

October 31, 2014

Tomorrow is the first month of November so that means people everywhere will put down their razors for the month and see what happens in support of men’s health. It’s Movember! If you haven’t heard, Matt Francis is organizing a Tableau Team. Unfortunately (or probably fortunately, really…) I can’t grow a mustache. Luckily, Tableau can grow one for me!

A few other Tableau celebrities got the mustache treatment, as well. Check it out in my viz!

Learn About Tableau

Data House of Horrors Followup!

October 20, 2014

Thanks to the lovely folks at import.io for showing a super fun time last Thursday at our Halloween special webinar! If you logged on, you probably caught some of our “fancy dress” but in case you weren’t, this happened:


Loading

Getting ready to get spooky with data on our @importio webinar!

View on Instagram

If you didn’t make it, never fear! It was recorded and you can watch the whole thing here:

I wanted to go a little more into detail about how to build this dashboard, so I’ll break it down piece by piece so that you can recreate it!

Bar Chart

Building the first bar chart is pretty easy. To start, put [Costume Category] on rows. Since there are duplicate rows (due to having one row for every word in a title), instead of using [Number of Records] we are going to do a CountDistinct([Prod ID]). You can do this by right-click dragging [Prod ID] to the columns shelf and then selecting Count Distinct, or by clicking the drop down menu on the Prod ID pill and then going to Measure>Count(Distinct). This means Tableau is now only counting each costume once.

blog1

Histogram

Making the price histogram was also very simple. All you have to do is select [Price] in the Measures pane and then hit the histogram button in Show Me.blog2

If the bins that your histogram selects are too big or small you can edit them by finding [Price(Bin)] in the Dimensions pane, clicking the drop down and clicking “Edit”. This will allow you to change your bins to whatever size you’d like.
blog3

Lastly, instead of doing a count on price, which will make for duplicate rows because of the join with the words, switch out [CNT(Price)] on the Rows shelf with [CNTD(Prod Id)].

Word Cloud

To create the word cloud, drag the [Words] on to text and [Number of Records] on size. At first, you’ll get a treemap. This is a good point to filter out some of the words to keep them mucking out the word cloud. I filtered out words like costume, adult, the, of, etc. You can just over over a square and click “Exclude”. Once you do that, you can switch the marks card from “Automatic” to “Text” to get a word cloud.
blog4

Another thing I wanted to do was filter to only the top 30 words; that way nothing is too small. Since we already filtered on [Words] when we excluded “adult” and “costume” and the like, we can create a duplicate field for words and filter on that. If you click the drop down menu on [Words] you will find the Duplicate option. Click on this and drag it to the Filters shelf. Once you are there, click the tab that says “Top” and choose “By field:” and set it to the Top 30 by [Number of Records].
blog5

Table

The table is pretty simple. Drag [Item] to rows and [Price] to label. Easy peasy. I also put [Prod Id] on Detail in the Marks card (you’ll see why later) and [Description] in the tooltip.

Hover Help Ghost

This is a trick I use all the time as it’s a great way to add context to your dashboard without taking up too much space. It’s been well documented before so I won’t go into too much detail. The only real thing I did differently was change the shape to a custom shape that looks like a little ghost. Read more about utilizing custom shapes here.

The “Sexy” button

To create this, I first went through all the words and created groups so that words like “Babe” and “Flirty” fell into the “Sexy” group and all other words counted as “Everything else”
blog6

With the groups created and renamed to [Sexy Words] I created the “Sexy” button by dragging out [Sexy Words] to the text on the marks card and then editing the label by clicking on the Text button and editing it to say “Click here to bring back”. Then I put [Sexy Words] on filter and filtered to only show words in the “Sexy” group. Then, I edited the formatting to have borders and colors to make it look button like.

Dashboard Interactions

Tableau Public is great for rapidly creating a lot of different charts types like we did above, but the real power comes in making these charts interact with each other. This is done through “Dashboard Actions.” Now that all of our sheets are created, we can create a new dashboard and drag everything onto it. Then we can create a series of dashboard actions by going to Dashboard>Actions in the menu. Here’s all the actions I created:

Design considerations

I wanted the theme to be really obvious, so I did a bit of design work to make everything match the Halloween theme. First, I set the background color to all of my sheets and the dashboard to black and set the other colors to fit a theme. I based everything off of this color scheme:

Trick_or_Treat
Color by COLOURlovers

I even created custom color palettes in Tableau so that I could use those colors as a gradient in the data.

Another thing I did was create a set of custom titles out of a custom font I found on DaFont called “Scary Halloween”
blog8

I also added a little tombstone image to the dashboard for the costume picture to load on top of.

So, that’s basically it! Our finished product looks pretty neat:

Learn About Tableau

So, that’s it! I hope you enjoyed the webinar and the dashboard!

Pop Viz: Barbie N-Grams

October 14, 2014

Several months ago, I was doing some Google searching to figure out what a Barbie Dream Boat is worth these days. The Barbie Dream Boat was basically my most prized possession as a kid. I got it for Christmas when I was 7. It came in a gigantic box. It had a pool that you could fill with water. AND IT HAD A BLENDER. I made so many virgin piña coladas in there.


In searching to see how much these go for these days, I stumbled upon BarbieValues.com. Being me, I was instantly excited about this repository of Barbie data. Unfortunately, my traditional methods of web scraping couldn’t handle this beast of a dataset. Thankfully, after pleading with the audience of my “Pokemon, Porn, and Pop Culture: Using data that doesn’t suck” session at this year’s Tableau Conference, a few super smart Tableau devs, specifically Charles Vaughn and Nathan Brandes, came to my rescue! This dataset is amazing and I have all kinds of plans on things to do with it. But for the first in my series of Barbie data vizzes, I created an n-gram search. You can use this to see occurrences of words or phrases in Barbie models and accessories over time. To create the n-gram search, I used a parameter method that Matt Francis recently blogged about. Check it out below:

Learn About Tableau

In future Barbie vizzes, we will figure out who her favorite friend is (Midge? Teresa? Skipper?) and explore the many, many careers she’s had.

Data House of Horrors: Halloween special with Tableau + import.io!

October 9, 2014

For those who don’t know, I’m on a bit of an extended trip working out of our London office right now. It’s been rad and one of the things I’m really excited about doing while I’m here is hanging out with my pals at Import.io. We are putting on a special Halloween edition webinar next Thursday, October 16th (my birthday!), to show how to scrape Buycostumes.com and build this viz in Tableau:

Learn About Tableau

You can use the viz above to find the perfect animal-ears-plus-lingerie combo, a la Mean Girls.

Hope to see you next Thursday!

Pop Viz: Pumpkin Spice Analytics

October 3, 2014

Fall is in full swing, so you know what that means: pumpkin spice lattes! Pumpkin spice muffins! Pumpkin spice doughnuts! Pumpkin spice bubble baths! And now… PUMPKIN SPICE ANALYTICS!

Also...PUMPKIN SPICE KITTIES!!!!

Making fun of the prominence of pumpkin spice seems to be the cool thing to do. The silly thing is, it seems that all this vitriol towards pumpkin spice is actually making it more popular. Take a look on my story below to see what I mean.

Learn About Tableau

Dataviz Coffee Talk

September 19, 2014

The purpose of this post is really just because I came up with a dataviz related “Coffee Talk” joke and needed to share it.

Treemaps are neither trees nor maps. Discuss. @tableau pic.twitter.com/gSAtaydlT2

— Jewel Loree (@jeweloree) September 19, 2014

If you have no idea why I find this hilarious, check out this classic SNL clip of Mike Myers’ classic character “Linda Richman.” One of my favorite sketches and characters from SNL ever.

If you have any other Coffee Talk jokes, tweet them to me!

EDIT: Just in case anyone actually wants to know the origins of the term “treemap” Iron Viz contestant and data genius Jeffrey Shaffer has us covered:

@jeweloree @tableau "the term treemap described the notion of turning a tree into a planar space-filling map." – Ben Shneiderman

— Jeffrey Shaffer (@HighVizAbility) September 19, 2014

#WJEAJDay2014 and Tableau

September 18, 2014

This morning I had the extreme pleasure of talking to a group of smart, talented high schoolers about data journalism. They were at the University of Washington for the Washington Journalism Education Association’s (WJEA) Journalism day. I’m excited to see what this creative group of young journalists will come up with in Tableau Public.

Here’s a viz we made together in about 15 minutes. I used data from Maxpreps on my high school football team. An interesting finding was that Mariner actually lost their highest scoring game of the last decade.

Learn About Tableau

Data Feed: New York Times APIs

September 17, 2014

If you were at Pimp My Viz, or at least read yesterday’s summary about it, then you may recall that I spoke a little bit about using the Spotify Web API to pull data into Google Spreadsheets. My partner (and author of this excellent tutorial about bring JSON into Google Spreadsheets) alerted me to the existence of these New York Times APIs yesterday. They have APIs for a number of different things but the ones I think you could get a LOT of interesting data out of are the Best Sellers API, Campaign Finance API, Congress API, Movie Reviews API, and Real Estate API.

Now go forth and do awesome things with data!

No, not that data!

← Previous Page