Alteryx Tools Part 2: Filter, Sample and Date Time

Posted by on Apr 9, 2014

Three more useful Alteryx tools: Filter, Sample and Date Time.

Read More

Assessing the Market for a BI/Analytics Tool?

Posted by on Apr 3, 2014

One thing it makes good sense to do when choosing a new BI/Analytics Tool is to check out what’s happening in the market. What tool are your peer companies choosing. What do the analysts say? With that in mind I’ve created a couple of visualisations using Tableau intended to help you. The first of these shows the growth of license revenue in recent years with particular emphasis on what are termed the ‘Business Discovery’ vendors. The second is an interactive take on the Gartner Magic Quadrant. I would suggest that there are two ways of engaging with this blog post....

Read More

Alteryx Tools in Focus: Fuzzy Match, Make Group and Unique

Posted by on Apr 2, 2014

Alteryx has a vast number of tools, and it’s easy to miss some functionality that might be useful, so for this new series of blog posts we’re going to take readers through three tools per blog post, detailing functionality as well as hints and tips for each tool. Unique The unique tool is a Data Preparation tool, and as you can imagine from the name it’s function is to return a unique dataset for the fields provided, though I think a clearer name for the tool would be “First Distinct”, because that’s essentially what the tool does. For the field(s)...

Read More

Radar Charts in Tableau – Part 3

Posted by on Mar 27, 2014

I’m going to return to the concept of Radar Charts today, with part 3 of the series – you’d never imagine that we could keep talking about such a Tableau-taboo chart type, but we have! To refresh, in Part 1 I showed how you could use a background image for the ‘web’ of the chart, whereas in Part 2, Chris used Alteryx to create the background image. I was considering showing how you could create the web in R, but Phillip Burger made that unnecessary. So, where can we go from here? The obvious step is to do away with the background images, and bring the web creation into Tableau itself. Sounds...

Read More

Extending your options with Tableau Dual Axes

Posted by on Mar 24, 2014

Often people think of Dual Axes in Tableau as a way of showing different measures on the same chart, but they can be just as effective, if not more so, in adding an an extra level of information or detail to a chart in a more interesting, or clearer way. As an example let’s take a look at the Gantt Charts below, they show predicted and actual times for several stages of a project. The second is a lot clearer and enables us to quickly look at the actual vs target/predicted times for each stage. Learn About Tableau Similarly dual axes can be used to overlay information such as averages onto...

Read More

Radar Charts in Tableau – part 2

Posted by on Feb 25, 2014

Long time followers of the Information Lab blog may remember Andrew Ball’s post - Radar Charts in Tableau – part 1 - back in May. It’s long overdue that we return to the subject and look with fresh eyes now we have Alteryx in our toolkit. We’ve been documenting a lot recently how Alteryx can help with common Tableau data cleansing tasks and creating radar charts is no different. For the Top Trumps Viz below I decided to use radar charts to compare the different characters in the set of cards and their attributes. Firstly I need to standardise the value attributes so I...

Read More