I must admit I got a bit stuck with this week's dataset. It was very straightforward and I didn't like how anything turned out. With some ideas from the live audience on YouTube, I started comparing exports, imports and the trade balance. I then thought about a trick I had taught the Data School about using a timeline to filter.

Great, that's it! Wrong! The layout I had in my head was all wrong. I had to move some things around and then getting everything to line up took ages! Why or why isn't formatting easier???

Then, after creating the BANs, someone suggested that it would be good to show a zoomed in version of the line chart for the dates selected. I added those as sparklines with each BAN and it turned out so much better.

Check out and download the viz here.

Today at the Data School the team was supposed to present Tableau Server adminstrator views, but given yesterday’s historic decision by the citizens of the U.K. to leave the EU, we pivoted and focused our day on visualisation data about the referendum.

I wanted to participate as well, and quickly found this survey on YouGov.UK. This poll was taken just before the vote, seemingly a good proxy for the next day’s vote.

Click the image for the interactive version

Brexit is a hot topic in the news these days over here in the UK. The ramifications are far and wide. Leaving the EU would mean a LOT of lost jobs, impacting even the Data School and the Premier League.

Back in September, The Guardian wrote an article and created this visualisation to show which teams in the Premier League would be impacted the most.

Click the image to view the interactive version

I like the layout of this, but what it lacks is a simple way to see where the players that are impacted come from. I also wanted an excuse to practice the new Union feature in Tableau 9.3. It took me a couple of hours to recreate the data set and then another hour or so to create the interactive viz below.

Find your team and see how many players they could lose if Brexit happens!