Blog

Planning the structure of Tableau dashboards

Posted by on Feb 26, 2015

Planning the structure of Tableau dashboards

The Information Lab consultants are involved in numerous data visualisation projects. Building corporate dashboards not only serves reporting purposes but gives users a way to interrogate their data, to explore along their user journeys and gain business insights. Tableau, being a very user friendly and versatile software makes the technical aspects easy, once we know what we want to build. In every corporate data visualisation / visual analytics project there is a phase before we even open Tableau. This is the planning phase. This blog post will be less technical as it deals with the...

Read More

Grabbing data from web based APIs using Alteryx – Part 1: Quandl

Posted by on Feb 24, 2015

Grabbing data from web based APIs using Alteryx – Part 1: Quandl

Sometimes the data you want to analyse and visualise is nice and accessible in your corporate data warehouse, cleansed, in the right format, and all the fields you need are there – a data nirvana. More often, the data that you have access to needs some TLC; a bit pre-processing before analysis can start or some re-shaping to get the most out of it. If you follow this blog and others on Alteryx, you’ll see how the tool can be used to easily complete these types of tasks. But what if the data you need isn’t readily available; it isn’t in spreadsheets or a database, it’s only accessible via the...

Read More

The Tableau Data Query Process

Posted by on Feb 19, 2015

The Tableau Data Query Process

An introduction to the Tableau Data Query Process, aimed at those who are early in their Tableau journey and want to understand a little more detail around how the magic happens in Tableau!

Read More

Map Drill-Down: a possible workaround

Posted by on Feb 17, 2015

Map Drill-Down: a possible workaround

Hello everyone, It has been now a couple of months since my last blog but I have finally found some time and I thought it would have been a good idea to show everyone this technique I have recently learned during one of my engagements. Have you ever wondered if there was a way to drill down from a country map to a city map based on a selection? What if we want to go further down in our analysis and analyse even further, let’s say at postcode level? Well I had…I spent many hours between searching on the Internet to see if someone has an answer to that query or trying to solve it myself....

Read More

What time is it Alteryx? Part 2

Posted by on Feb 15, 2015

What time is it Alteryx? Part 2

In Part 1 we addressed how to parse a series of dates using the date time Tool and extending that to the formula tool. This time we are going to look at a two of more specific computer language dates. the first is the UNIX time stamp, the second is the MySQL time stamp UNIX Time UNIX is a common computer operating system and (from my limited experience feel free to correct/expand on this in the comments) is a more common as a server hosting language. As a result UNIX (or POSIX or Epoch) time will often appear as a time stamp for server generated logs. UNIX time is defined as the number of...

Read More

Show Me How: Treemaps

Posted by on Feb 10, 2015

Show Me How: Treemaps

Treemap essentials The ‘treemap’ is a chart type that displays hierarchical or part-to-whole relationships via rectangles. In case of hierarchical (tree-structured) data these rectangles are nested. The space in the view is divided into rectangles that are sized and ordered by a measure. Nested rectangles mean that hierarchy levels in the data are expressed by larger rectangles (above in the hierarchy) containing smaller ones (below in the hierarchy). The rectangles in the treemap range in size from the top left corner of the chart to the bottom right corner, with the largest...

Read More