During last week’s data session, John let us loose in the wonderful world of Tableau, which lets you create impressive looking things without too much trouble.
I was so inspired by the experience that I decided to have a go with a dataset I’ve not looked at before.
After reading a piece in this morning’s Metro about everyone’s favourite shallow dating site beautifulpeople.com, I thought that there was potential to quickly test my mapping skills.
For those who don’t know, new users to this site are voted on and only those deemed worthy are allowed to join the other Adonises and Aphrodites.
Using a small amount of pretty old data, I wanted to create a map to show the success rates for male and female applicants from the most successful countries.
Since there was relatively little data, I wrote up a spreadsheet manually and ended up with this:
The data only covers the top 21 success rates for males and females and the list of countries for each differs slightly, hence certain countries only having one success rate.
I used Tableau Desktop, which students can use for free, but Tableau Public would have done the job equally as well.
Once I’d opened my data, the process of creating the map was fairly straightforward, as the countries were automatically recognised. I opted for pink countries since we’re dealing with a supposedly romantic site (though perhaps green would have been more appropriate).
I made two maps, one each for males and females, and made bar charts to go alongside each map. Once they were all whacked together in a dashboard, I remembered how to use the “Actions” tool well enough to link everything together, so that clicking on a country will highlight it in both maps and both bar charts.
Here’s my finished masterpiece. Click the image to play around with the interactive version.
The whole process only took around 20 minutes, which I don’t think is too bad considering it was my first time trying it alone.
True, there wasn’t much data, it was pretty old and I wasn’t overly ambitious. But it was good practise and hopefully I’ll be able to try something more complex soon.
just struggling with a sweet animated tableau viz to put in wordpress.com … will have to try an alternative route now
Nice start. Did you use Tableizer to embed that table? If so, why did you use that instead of Datawrapper?
I had the table on Google Drive so I just published it and used the HTML embed code. It seems to be one of the few things that actually works on a WordPress.com site.
Tableizer is decent but I’d definitely want to customise it if I used it. Default view tends to look shit. GDrive a good choice if you want to allow sorting (see http://www.theguardian.com/news/datablog/interactive/2012/sep/06/paralympic-games-full-list-every-medalist – works best in Firefox).
I definitely prefer embedded GDrive to Tableizer, the more interactive the better.
There are a fair number of pretty mainstream things you can get into a WordPress.com blog post. But the more esoteric stuff you use for data journalism? Good luck with that…
One good argument for going the self-hosted route.
Generally the .com is fine and we can link to non-embeddable stuff using screenshots (like I had to do here).
The total lack of plug-ins is annoying though. You definitely miss out on a lot of useful tools.