The Data School Blog
How to make Curvy Bump Charts on Tableau
In this blog, I’m going to walk through how to improve your bump chart design by adding curvature to each line.
read more
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
Tableau Set Actions: Compare selected dimension with remaining dimensions
For this example, the data source used is Sample – Superstore data. Creating the tableau dashboard below is broken down in to 4 main steps: 1 Creating the source sheet 2 Create the target sheet 3 Create dashboard and assign set 4 Add dashboard actions (click on the...
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