Blog

The Volvo Ocean Race Alteryx and Tableau Challenge

Posted by on Oct 31, 2014

The Challenge It started with an internal post within The Information Lab from our colleague Robin Kennedy that went something like this… “Challenge for the week for everyone with a bit of spare time … Build a version of the Volvo Ocean Race dashboard.http://www.volvooceanrace.com/en/dashboard.html You can get the data from here: http://www.volvooceanrace.com/en/rdc/VOLVO_WEB_LEG1_2014.json Build your own Alteryx modules and Tableau dashboards and we’ll have a Viz-off on Friday!”   The JSON Problem The first problem encountered was the data format,...

Read More

Photographic Composition and its applications to Data Visualisation

Posted by on Oct 31, 2014

I’ve long been a keen photographer, though these days I’m more likely to be seen in front of a data visualisation than behind the camera. An appreciation of both “arts” led me to write this blog post about the parallels between the “rules” involved in the composition of each. Creating a Javascript Webpage \ Blogpost Before I sat down to write this post about photography and data visualisation then I thought carefully about the format of the message i wanted to get across. A blog post would be effective, but with so many nice images and visualisations to...

Read More

Tableau layout containers: Part 2 – A Tableau Menu Interface

Posted by on Oct 29, 2014

In the first part of this series we covered the basics, today we’re taking it up a level and geeking out on that knowledge by using the behaviour we know about layout containers to create a semi- responsive menu system that looks a little something like this.   You can just watch the video (best full-screen) or follow along with your own workbook or download mine  (Tableau 8.2 required) which mirrors what I’m doing.     One thing I didn’t cover in the video is that often, Tableau reacts straight way to layout decision or action you make and intuition urges...

Read More

Highlight Table & Heat Map: The “Total” Problem

Posted by on Oct 28, 2014

As an Accredited Tableau Trainer, in any course I run, I always come across different and new questions from students. In one of my recent training runs, a student came up with a question about colour and size of Highlight Table and Heat Map. What he basically wanted to know if there was a workaround to having grand total and sub-total in Highlight table or Heat Map not affecting the colour shading or the size of the marks within them. At that time, the only answer I could think was to split the table from the total using 2 separate worksheet and then  join them together in a dashboard. Not...

Read More

Order of the day – aggregation and weighted average in Tableau

Posted by on Oct 22, 2014

I start this post with a very theoretical definition of the weighted average, where instead of each of the data points contributing equally to the final average (as with the simple arithmetic mean), some data points contribute more than others. These ’contributions’ are called weights. That is clear but how does it link to Tableau and aggregating data? Let me start from a bit farther away…. What is aggregation? Before defining ’aggregation’, let’s see when we use it. Our data sources usually / optimally contain disaggregated data, meaning each row in the data file refers to the...

Read More

Viz: The Changing Language of Freedom

Posted by on Oct 21, 2014

In between our regular posts on Alteryx and Tableau tips and tricks we also like to get our hands dirty with public datasets to put those tips into action for ourselves and show what is possible. Freedom of Information in the UK – an Overview The UK’s Freedom of Information (FOI) legislation is formed of two Acts: Freedom of Information Act 2000 and Freedom of Information (Scotland) Act 2002. It gave the private individuals, campainers, companies and journalists “general right of access” to information held by government, councils and schools. It affects over 100,000...

Read More