The Data School Blog

Building Dynamic Bar Charts with Time Period Selections

Recreating dashboards is a very good way to practice Tableau skills. This blog post is about the key take away from Workout Wednesday week 2 in 2020 - how to create date selection parameters with last 12 months, last 13 weeks and last 14 days based on today’s date –...

read more

Parsing data with RegEx

Before the Christmas break I did Alteryx Challenge 188 on parsing data. In the challenge, we are asked to extract relevant tax data from a text file and present it as shown in the screenshot below. This looks like a daunting task, but with a bit of RegEx magic and a...

read more

Format Shading Tableau

Inspiration for this post came from doing replications of visualisations from Craig Dewar. Whilst everyone in my cohort could get the final solution, what very few of us could do was to format correctly. One of the issues was shading and how to make the graph/viz...

read more

Cross Tab – My New Best Friend

If I can give myself in the past a piece of advice about Tableau, that would be to use crosstab. This is especially the case when you have a lot of calculations going on in your Tableau workbook. During those days preparing for the Data School application, I often...

read more

Order of Operations – Context Filter

We learned Level of Detail (LOD) in Tableau before Christmas holiday. During the whole training, Peter, our trainer, kept strengthening the importance of ORDER OF OPERATIONS (Click for more info). Because I want to figure out what each operation represents, I did some...

read more

Feature Engineering – Cyclical Variables

What's the difference between 23 and 1? If we're talking about time, it's 2. A cyclical variable is a fancy name for a feature that repeats cyclically. I'll write a future blog post on the importance of feature engineering, but in short, it aims to improve the...

read more

Data School Team Member Viewer

Intro For this blog post I decided to use the information available to me on the UK and Australian Data School Websites. I wondered how employers and partners of the Data School view and select people to work for them. I decided to make a Viz to make it easier to view...

read more

Autocorrelation in the Alteryx Time Series Tab

What is Autocorrelation?   Simply put autocorrelation is a pattern that repeats itself over a time period. Or the degree of similarity of a given time series and the lagged version of itself over a specified time interval. A common example of this is temperature,...

read more

Three weeks at The Data School

The first three weeks at the Data School has flown by! I have learnt tons, learnt a bit more, met a lot of great people and had lots of fun. For this blog post I thought it would be good to take a step back and reflect on my first few weeks at the Data School. I will...

read more