Crowdsourcing - The World's Biggest Stadiums

OK so here's a viz I made just because I felt like it :-) No other reason at all.

Its looking at the biggest stadiums (or stadia if you like) in the world, specifically those with a capacity of at least 60,000. You can hover and filter to select different sports and regions, and a picture of each stadium should pop up.

Learn About Tableau

A few things I noticed from the data:
1. College football stadiums in America are HUGE. They make the NFL stadiums look tiny. Think about this for a second - these are teams run by institutions of higher education with unpaid players and there are some 46 teams with seating for over 60,000 people. The biggest, Michigan Stadium, is the third biggest stadium in the world. The Premier League by comparison has 2 teams that meet this criteria.
2. I was surprised by the lack of baseball stadiums. I guess it has to do with the shape and size of the field. The biggest baseball stadium is Dodger Stadium with a capacity for 56,000.
3. There are big stadiums really all over the world. There are loads in Africa and Asia, and pretty much everywhere. There are definite regional differences between the sports enjoyed, and these become obvious in the map. The UK is probably the country with the greatest diversity of sporting venues at this level.
4. I'd quite like to go to the 'Mass Games' in North Korea, its probably quite a sight!


Peter

NB - I lumped Rugby Union and League together, sorry if that bothers anyone. Also I tried to pick the 'primary' sport for each venue but may have got this slightly wrong, if you spot a mistake, please let me know.

Copy and Paste within Tableau is your friend

Ok here's an admission. Table Calculations sometimes confuse the heck out of me. However I've developed a few little tricks I use to make life easier. Here's one I utilised in my latest Tableau Public viz.

Lets say you've been using the cool new Rank feature in Tableau 8.1 on loads of fields, but then you want to filter your data and NOT have the ranks recalculate. What do you do? There are probably many ways to skin this cat, however here's the one I used. It may not be the 'best' way, but I like it. As usual I'm going to use Superstore Sales data to demonstrate.

First I'm ranking all countries by four fields:

Ok good, and I've sorted by the rank of Discount to make the order clear. Now I tidy things up a bit and add a quick filter on country:

Now you see I've de-selected a few countries, and they have disappeared from the view, but the rank has re-calculated. That's expected behaviour, but in my case I didn't want the ranks to recalculate. So here's what I do to fix the rankings (I think of this like doing a copy and paste values in Excel when you want to stop the formulas from calculating).

First, put everything back in the filter.

Then hit CTRL+C

Open a new worksheet

hit CTRL+V

and bingo I now have a new hard-coded data set from the clipboard!

This data set includes only four fields:
Country
Measure Names - Rank of Discount, Rank of Profit, Rank of Sales, Rank of Shipping Cost
Measure Values - the original 'hard-coded' ranks for each
Number of Records

So now when I filter out countries, the countries disappear from the view but the ranks stay as they were:

and then this can be easily brought into a dashboard along with the main data set by using data blending on country.

And all's well that ends well.

Comparing University League Tables

Today's Viz of the Day http://www.tableausoftware.com/public/gallery/more-net-costs by Jon Boeckenstedt of Higher Ed Data Stories, which shows the relative costs of US university tuition, got me thinking about doing a viz on UK universities. Since they all basically charge the same price I was going to have to look at something other than fees (though there is a rather sad story in the trend for increasing UK tuition fees overall, perhaps a story for another day).

Here's the viz:

The main story is that at the very top end of the tables, both newspapers are in complete agreement with each other - Cambridge, Oxford, LSE and St Andrews making up the top 4 for both. After that, the two begin to differ leading to a maximum ranking difference of some 43 places for Anglia Ruskin University.

Creating the composite rank was fairly straightforward using Tableau's new RANK function in version 8.1. I simply averaged the two ranks, and then ranked that average! A note on ranking styles - The Guardian uses 'competition ranking' (e.g. 1,2,2,4) where as The Sunday Times ranks are unique. For the composite rank I used competition ranking.

PS - do you believe for one second that St Andrews should be above UCL? Treasonous if you ask me.

Taking a little inspiration from Hans Rosling

Inspired by the recent announcement that Hans Rosling will be speaking at TCC14, a few of my colleagues at Slalom decided to have a little contest to see what Tableau vizzes we could up with inspired by the man himself.

First up we have a collaborative viz made by me and Nelson Davis (@Nelsondavis) which uses the visualization style of GapMinder and applies it to NBA franchises. Nelson did an absolutely awesome job styling the viz with NBA logo's etc... so check it out on his blog:

http://thevizioneer.blogspot.com/2013/12/if-hans-rosling-could-dunk.html

Another colleague Daniel Montgomery (@datapsientist) took subject matter inspiration from Hans in terms of social good and shows how nuclear power can help the fight against pollution and climate change.

http://datapsientist.blogspot.com/2013/12/nuclear-powers-effect-on-carbon-dioxide.html

Enjoy! And make sure you get to see Hans at TCC14, I saw him at TCCEU13 and he was hands down the best key-note speaker I have ever seen.

http://tcc14.tableauconference.com/seattle/

Console Wars

Both the Playstation 4 and Xbox One have just been released, and so I thought this would be an ideal time to look back over the history of Console Wars and see which consoles sold the most, and which games on each console were the biggest hits.

I hope you enjoy exploring the viz below, please click around to see what you can discover. As the PS4 and Xbox One continue to sell I will try and keep this updated and see how they perform relative to their ancestors. Interestingly the last battle between the PS3 and the Xbox 360 came out as a tie, with each selling 80 million units worldwide.

Learn About Tableau

(PS when i can get my hands on one of the new consoles, my viz making my slow down a bit.....)

Dual Axis Colouring of a Scatter Plot

In the Exquisite Viz I created a colour effect on a scatter plot which placed data points into quadrants based on their relationship to the mean and also showed depth of colour to highlight distance from the mean. A few people have asked me to show how I did this, so here goes:

To demonstrate I'm going to use NBA player data from the 2012-13 season, and I want to show which players are good at shooting 2 point shots, 3 point shots, both or neither. To do this in a way which will change when the data changes I need to first create a calculated field that will represent the average across all players (and act as a constant) for both shot types. The easiest way to do this, that I've found, is to place the fields out in a list and then run window averages along side. Placing them in a table in this manner is a good way to check that what you think should be happening is happening!

So I'm using window_avg calculated along Player. At this stage I then write a calculation to place each player into one of four groups depending on how they perform compared to the average, and place this calculated field onto colour to test its working:

Hitting the scatter plot icon on show me and then rearranging the fields a little results in this diagram, where you can clearly see the four quadrants:

Ok good. Now what I want to do is create an effect to show how far into each group each player is, so that players who are, for example,very deeply in the 3 specialist quadrant are represented in a darker orange. My inspiration for this idea came from Will Jones at Interworks who as far as I know was the first person to try dual axis colour http://www.interworks.com/blogs/wjones/2013/09/18/create-dual-color-axis-tableau

In my case I want to base the colour saturation on how far each player is from the overall mean in two dimensions, and so a bit of Pythagoras comes into play:

Then duplicate the rows and columns and make these dual axis, and synchronise the axes too. The key then is to make the top layer of scatter circles slightly transparent (around 70%) and then colour the bottom layer on a white to black scale based upon 'Distance from Centre', like so:

I changed the end point on the scale to account for outliers. Then add some reference lines for info and you are done! Here's what the finished product looks like, feel free to download and have a play,

Peter

Learn About Tableau

Things I've learned today about fonts.

When I first published the Tableau Viz below (DreamForce Tweets) it was heavily loaded with a font I liked that was pre-installed on my Windows 8 work PC called 'Script MT'. It looked like this:

And when I published the viz to Tableau Public, at first everything seemed fine. But I later realised that I was facing the familiar Tableau Public curse of your beautifully selected font not being compliant and so when viewed from other computers the font was reverting to Arial. I've had this happen to me many times before so decided to find out which fonts I CAN use.

This led me to this article http://kb.tableausoftware.com/articles/knowledgebase/resolving-font-discrepancy which states that because Tableau Public servers are installed on Windows 2008, only fonts that come packaged with Windows 2008 will work. So I picked one off this list http://www.microsoft.com/typography/fonts/product.aspx?PID=160 called Segoe Print. When I re-published my viz with this font everything at first seemed fine, and I checked on a different PC to double check. However I then loaded it up on my macbook:

PC Version

Mac Version

As you can see its not looking good on the Mac. And in both cases I'm viewing through Chrome. So I had a look for a list of fonts available on Mac and found this list http://en.wikipedia.org/wiki/List_of_typefaces_included_with_OS_X

So apologies if you are viewing my DreamForce viz on a Mac, its going to look a bit less exciting.

What I have learned? Well when publishing a viz on Tableau Public, the only way to be sure your fonts will render properly on all devices is to select from a very short (and boring) list of fonts like Arial, Veranda, Tahoma etc... Or be prepared to write everything out in Powerpoint and import words as picture files.

I think this is a real shame as Tableau allows so much freedom and creativity in so many ways - it would be nice if we could furnish our vizes with the fonts to match. I think there must be a way around this issue, and hope it is tackled at some point in future releases.

NB - Its worth noting this issue is only with Tableau Public, for a Tableau Server instance this is easily resolved by installing fonts onto the server machine.