John Carr

Joe decided he wanted to pursue a more technical career whilst studying for a Masters in Applied Biosciences and Biotechnology at Imperial College London. However he wasn’t sure exactly what he wanted to do. By chance he came across an ad for The Data School, and upon using Tableau, he immediately realised that a career in data analysis at The Information Lab was perfect for him.

How to recreate Tableau’s INDEX function in Alteryx

In Tableau, table calculations are a quick and easy way to manipulate data in the view to gain insights and also organise the data. The INDEX function is one example of the latter. Essentially, INDEX() ranks each row. Crucially, as it is a table calc, the ranking can...

Using FIND, LEFT and MID to format names

What do you do if you require names in a different format to what you have? For example… All of your names are in the datasource as follows: And you want Well, the key is to use string functions to find the gap between the first name and surname. However, the relative...

How does Tableau Web Editor compare to Tableau Desktop?

Last week we (DS13) spent a day running through the basics of Tableau Server with JMac. We also had a go on Tableau Web Editor to understand how it compares to Tableau Desktop. This involved building graphs with all sorts of features e.g. filters, dual axis, to see...

So far so good!

I just want to preface this by saying I have no idea how to write a blog so apologies in advance. Anyway. as it’s my first blog, I’ll start with a little bit about me. It’s fair to say I’ve followed a pretty normal life so far, coming from the Home Counties to study...