Blog

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

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