The Data School Blog

My trips in Sydney – Part 1

In this blog post, I'll be taking you through the steps that I took to parse data from a series of PDF files containing records from my public transport trips in Sydney. A second post that I will publish next week will be showing a Tableau visualisation of that data...

read more

Tableau in Motion

Animation in Tableau is mainly used for analyzing seasonal trends or simply placing measures over a period. Using time series such as months, days, and minutes will give you the ability to set each interval as an individual page. A motion chart, as its name suggests,...

read more

Using a Parameter To Find Top N

Parameters are dynamic values that can replace constant values in calculations, filters and reference lines. Let’s say you want to show top product by sales. One way is to use the dimension as a filter and fix the number of products to say 10. With this solution you...

read more

Quick and easy date parsing in Alteryx

Dealing with time series is a huge part of data analytics. A date field that’s well formatted and consistent will typically transition seamlessly into whatever reporting tool you’re using. A date field that is consistent, but incorrectly formatted, can normally be...

read more

Exploring Crime Data with a Tableau Dashboard

One of my favorite things about Alteryx is its allows us to automate a repetitive process very easily. This blog takes you through a data set that I otherwise would not have been able to generate in a reasonable time frame. Prior to Tableau, I don't think I would have...

read more

How to learn RegEx (the painless way)

If you suddenly need RegEx to solve a problem, it can be tempting to google a syntax list and start awkwardly crafting the pattern that will (hopefully) match whatever string you need.  This can be time consuming, however, and it’s likely that your solution is not the...

read more

Tableau tips and tricks

It has now been four months since I first learned that there was a data visualisation tool called Tableau. Like a kid who has just been given the newest gadget on the market, I started exploring what I could do with it and immediately it blew my mind away. 'Just drag...

read more

Extract data from an API using Alteryx

On Week 3 of our training, we were introduced to API’s. So, in this blog I will demonstrate how I used Alteryx to extract data from an API. The data covered in this blog is the list of Asteroids based on their closest approach date to Earth, from NASA's website. The...

read more