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.

Webscraping through Alteryx as if you are logged in

Here's something which might help you if you've ever needed to download a load of URLs which are only accessible if you are logged in. Normally, webscraping with Alteryx is pretty simple - you connect a text input containing the URL to a Download tool and parse out...

Dashboard Week – Letting my creativity ‘Flourish’

Today, Sophie decided that we look at UK baby name prevalence stats from the UNS website. However, we had to visualise it in a free, web-based software called Flourish. See below: https://flourish.studio/ Interestingly, Flourish seems to focus on very different things...

A quick recap of Dashboard Day 1

For our first day of dashboard week, Andy gave us the difficult task of scraping the data.gov.uk website for lots and lots of files containing large expenses by NHS trusts. See here for our brief: https://www.thedataschool.co.uk/andy-kriebel/nhs-trusts/ This was...

Tick multiple fields at once in Alteryx Select Tool

Here’s an Alteryx quick tip which might save you a lot of time in the future when using the Select tool. Have you ever had to tick box after box in Select because there is no obvious way to tick multiple boxes at once? Well, the good news is you can tick multiple...

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...