Blog

Rank Percentiles and Creating Dynamic Groups

Posted by on Oct 20, 2014

In this story I will show you a method of calculating a dynamic group of the top 20, middle 30 and bottom 50 percentile customers using Sales or Profit over time. Although I am using the RANK PERCENTILE calculation in this example you could replace this for any sort of calculation you want that creates bands, groups or bins of data. The reason I have focused on this was that the Percentile function is a fairly new feature in Tableau (as a built in Table Calc) for which I could not find other examples for help. Also other methods of doing grouping or bins cannot use the greater than or less...

Read More

Monitoring your Tableau Server using Pulseway

Posted by on Oct 17, 2014

Tableau Server is one of those beautiful server applications that you just install, occasionally update, but for the most part just let it run and do its thing. Trouble is, its thing is making it super simple for people in your company with data to share their insight and develop understanding of how the company’s performing. So people tend to start using it quite a lot and begin to rely on its 100% uptime. So when the unforeseen does happen what can you do to be a step ahead of those emails complaining of problems? Detecting Underlying Issues At The Information Lab our consulting team...

Read More

Analysing Multiple Response Survey data with Alteryx and Tableau – part 1

Posted by on Oct 15, 2014

Analysing Multiple Response Survey data with Alteryx and Tableau – part 1

Multiple response survey data got you in a fix? Transform it into great analysis with Alteryx and Tableau in the first part of a series on the subject.

Read More

Tableau Boosts Marathon Runner Performance

Posted by on Oct 13, 2014

OK so the title of this blog post sounds a little like something out of the Sunday tabloids but it is something we want to shout throughout the streets. You see us data folks aren’t usually known for our athleticism, or at least that’s what people tend to think. Tom’s a regular on the squash & tennis courts, Emanuele & Andrew can be found on the 5-a-side pitch each week and we have not one but TWO marathon runners in Chris Love and Tim Ngwena with Emma Whyte poised to explore 26 miles of Manchester next year. Yorkshire Marathon 2014 This past weekend Tim took on the...

Read More

Dynamically show/hide worksheets on dashboards in Tableau

Posted by on Oct 13, 2014

In the data analysis process we soon get to the point of diving deep into the details, beyond the topline information we started from. Narrowing the analysis span from high level to the details is the so called ’drill-down’. So this post is in fact a story of drill-downs The following Tableau story tells more about the drill-down and more importantly about a very useful feature of Tableau that perfectly supports this concept. This is Tableau’s ability to dynamically show/hide worksheets on dashboards, hence laying down the analytical route for the report users. What is ’dynamic’? It means...

Read More

Health check your data using Alteryx and Tableau

Posted by on Oct 10, 2014

I often get data and need to know how clean it is before I start looking at the data, either because I’m going to be using it directly in a Tableau visualisation, or because I have some work to do it in Alteryx. Sometimes I just want a quick way of going back to the supplier and saying “Yes, that’s fine” or “There’s a problem with column X”. This is where the visualisation below comes in, I call it a “DNA profile” (Data nose-around), it shows at a glance any issues. We see each column has a profile bar and it’s rows are represented...

Read More