Posts by Robin Kennedy

The Information Lab is hiring!

Posted by on Mar 24, 2013

As Tableau’s popularity in the UK increases, so has demand for our training and consultancy services! Plenty of repeat business with our existing clients, along with engagements from many new Tableau users means we are now actively looking for additional people to join our team. If you’re as enthusiastic about Tableau and Business Intelligence as we are then take a look at the job description below. If you want to know more or make an application drop us a line at info@theinformationlab.co.uk   Tableau Consultant – The Information Lab A Tableau Consultant at The Information Lab has a...

Read More

5 things I wish I knew about Tableau when I started

Posted by on Jan 28, 2013

From day one of using Tableau, I found it to be a fantastic and easy way to visualise my data and produce great reports and analysis. 3 years on, I have come to learn and understand a few of the more advanced features and concepts about Tableau which have really enhanced the way I use it today. If I could visit myself 3 years ago and teach 5 Tableau concepts, this is what I’d cover. Green vs Blue Green data fields are continuous and blue data fields are discrete. Tableau behaves differently depending on which of these different types of fields are used in a view. I’m not going to go into too...

Read More

Maintaining percent of total whilst filtering

Posted by on Jan 14, 2013

Tableau makes it really easy to switch from showing absolute figures to a percent of total figure by using the Quick Table Calculation option. However, if you want to filter out one or more of your dimensions, the percent of total figure changes because the ‘total’ which is used in the computation changes too to reflect the loss of the dimension members. In some cases, you will want to maintain the original percentage (of the whole underlying data) whilst just displaying the dimension members you are interested in. This post examines 3 different ways to accomplish this, along with why you...

Read More

Why is my Tableau viz slow?

Posted by on Nov 19, 2012

We all know and love Tableau to be the best BI tool to enable you to quickly and easily see and understand your data. It enables fantastic ‘speed of thought’ analysis, super-fast data visualisation on giant data sets and is often heard in the same sentence with many other superlative prefixed buzzwords. But sometimes, just sometimes, you can get stuck in a rut with a slow workbook if you’ve been overzealous on the features or have configured things in the wrong way. This post is about what you can do to help get your viz back up to the ludicrous speed you expect. There are several separate...

Read More

Charting account balances in Tableau

Posted by on Oct 22, 2012

I’ve seen a couple of questions recently on how to visualise account balance data whilst still being able to use the date aggregation in Tableau. Because balance represents a snapshot in time, it is nonsense to sum up all the balance values over a year or a month. The average or maximum or minimum over a period might be useful but what was really wanted was the balance at the end of a certain time frame – i.e. balance at the end of 2009, balance at the end of February 2010, the balance at the end of Q3 2007 etc. This post looks at one way to achieve this using a table calculation called...

Read More