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
Are You Better off Living in an Area Where People Make More Money?
Will you be living in a better socio-economic condition if you're living in an area where people make a lot of money? To many, the answer is an obvious yes. But I wanted to see a closer snapshot of how socio-economic conditions of an area is related to the level of...
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