The Data School Blog

Passing the Alteryx Core Certification – Prep and Tips

Passing the Alteryx Core Certification – Prep and Tips

Last week, I sat the Alteryx Designer Core Certification and finally passed after many attempts. I received a lot of messages from others on how they should prepare and how to start their Alteryx learning journey. This blog post should answer just that and guide you through some things I learned to do and not to do along the way whilst providing many links to resources that helped me.

read more
How to build Bullet Graphs in Tableau

How to build Bullet Graphs in Tableau

Hey! Today we learned about bullet charts. It seemed like a great way to cram in lots of information into a single chart so I thought I’d run through the process of making it so the public can also benefit. Bullet graphs are essentially a bar chart of a single measure...

read more
Tableau Conference-ish : Interactive CV

Tableau Conference-ish : Interactive CV

I tuned into the session on how to make your own interactive resume on day 2 of Tableau Conference and then decided to use the resources provided and make my own. This was presented by Melody Cheung who is an Academic Programs Coordinator at Tableau. Follow along my process through this blog.

read more
NEW: Tableau Conference-ish Map Layers

NEW: Tableau Conference-ish Map Layers

A detailed breakdown of the session. In case you missed it, one of the anticipated releases to come that was announced at TCish was map layers! If you’re anything like me, at the moment I rely on Mapbox with anything map related and then go into Tableau. Here’s everything we learned about map layers that we all have to look forward to.

read more
#MakeoverMonday Week 37 – The Gender Pay Gap In UK State-Funded Schools

#MakeoverMonday Week 37 – The Gender Pay Gap In UK State-Funded Schools

The latest challenge we were assigned here at the Data School involved completing a #MakeoverMonday, which focused on the gender pay gap amongst teachers at state-funded schools across the UK. In this blog post, I will highlight what I liked and disliked about the original Viz, as well as elaborating on my own version of this week’s #MakeoverMonday. Here is the original Viz:

read more
Makeover Monday Week 37

Makeover Monday Week 37

Our task for today was to complete this weeks Makeover Monday, and to analyse what we liked and didn't like about the original visualisation. Here's the original viz: What I liked: Its relatively straight forward, and so easy to understand.Focused on most recent data....

read more
Makeover Monday Week 37 – Walk-through

Makeover Monday Week 37 – Walk-through

Hey Everyone!! So today I will walk-through my thought process for my latest Makeover Monday. I usually like to spend a bit of time on Makeover Monday (~3hr) to iterate on all the smallest, and probably pointless, design quirks. But not today. I gave myself a strictly...

read more
Dashboard Week: Day 3

Dashboard Week: Day 3

Day 3 was my favourite day of dashboard week. Everything seemed to fall into place and I was really happy with the outcome of the dashboard. Not only that, but the data was extremely topical and interesting as well

read more
Dashboard Week Day 1 | Major League Baseball Player Performances

Dashboard Week Day 1 | Major League Baseball Player Performances

So dashboard week has come and gone for DS20, gone by a few weeks so this blog is a little bit late. (I’m sorry!) This series of five blogs will look at the dashboards that I created over the week and what I would improve upon each one now I’ve had some time to reflect. (Maybe I’ll write some update blogs later this week or next week when I’ve made those improvements?)

read more
How to Set up an Incremental Refresh in Tableau

How to Set up an Incremental Refresh in Tableau

Setting up an incremental refresh on Tableau server is very easy. If you are wondering why you should set up an incremental refresh, have a read through this blog by Luke. First of all you will need to use a data source that has either a Unique row ID or a time stamp...

read more
Mastering the Multi-Field

Mastering the Multi-Field

The multi field tool makes it easy to carry out a function on various fields. I put it to the test with a weekly challenge and although a very basic use, it was still very useful in understanding its functionality.

read more
Mastering the Multirow: Alteryx Challenge 3

Mastering the Multirow: Alteryx Challenge 3

As part of DS21 week on alteryx we had a lesson with Chris Love on using Multirow and multifield formulas, we had come across them briefly before but went into a lot more depth. He recommended Challenge 3, so i thought id give it a go even though it was classed as...

read more
Relishing Regex – A Beginners Guide

Relishing Regex – A Beginners Guide

This week, we focused on Alteryx. Each day we were introduced to a new tool and learned about its features as well as use cases. I’ll be honest in saying that I still find Alteryx very overwhelming and so this blog post will help me re-affirm my learning and hopefully help others who are new and confused to not give up. I’ll be going through a weekly challenge with screenshots to help.

read more
Taming Transpose & Crosstab: Alteryx Challenge 49

Taming Transpose & Crosstab: Alteryx Challenge 49

The aim of this challenge was to switch the format so that the product information was shown in rows as opposed to columns. The input had the Market, Product and Type categories in the first 3 rows, so the first step was to separate the first 3 rows from the data...

read more
Relishing Regex: Alteryx Weekly Challenge 54

Relishing Regex: Alteryx Weekly Challenge 54

This week DS21 have been focusing on Alteryx, looking at several different topics across the week, we spent Wednesday learning the basics of Regex with Oliver Clarke, and today we were tasked with completing one of the Alteryx weekly challenges that required Regex....

read more

Dashboard week : Day 3

For day three of dashboard week we took on Data on the US Coronavirus Aid, Relief and Economic Security (CARES) Act. We looked at the loans for businesses across the USA. The data can be found here...

read more

Dashboard week : Day 2

This is the second part of a 5 part series of blogs on dashboard week. If you're not sure what Dashboard week is, have a look at my account of day one. For day 2 of Dashboard week we worked with climate data from the National Oceanic and Atmospheric Administration...

read more
Dashboard Week: Day 1

Dashboard Week: Day 1

It’s here, dashboard week. This is the first entry in a five part series I’m writing about my experiences, thoughts and all the other good stuff surrounding dashboard week each day.

read more
Data Viz 101 – Improving an old Viz

Data Viz 101 – Improving an old Viz

For this blog post, I will be dissecting and suggesting improvements for an old viz created by Head Coach Andy, as well as attempting to create an alternative Viz based on the fundamental principles of data visualization that we have been taught thus far.

read more
A Critical Evaluation: Who’s Winning the Cola Wars?

A Critical Evaluation: Who’s Winning the Cola Wars?

This blog will critically evaluate the visualisation ‘Who’s winning the Cola Wars?’. It is based primarily on Coke and its contenders across a variety of categories. It will explore this across certain visualisation best practice categories presenting a before and after.

read more
Critiquing and reworking Andy’s old Viz

Critiquing and reworking Andy’s old Viz

Today we were tasked with evaluating one of Andy's first tableau public posts, so here goes. I was given this dashboard about the impact of drug testing on baseball. There are a few elements that I like and think work well, there are also lots that I don't. My main...

read more
Re-designing Andy’s Viz: Vaccine-Preventable Outbreaks

Re-designing Andy’s Viz: Vaccine-Preventable Outbreaks

Today for DS21’s project, we were given the assignment of re-designing one of Andy’s old visualisations, taking into account the things we had learnt from his presentation on best practices yesterday. The visualisation I analysed and re-designed was based on preventable disease outbreaks.

read more
Dashboard Week (the easier version)

Dashboard Week (the easier version)

Hey everyone! So our task today was to analyse and evaluate one of Andy’s past visualizations across some of the dashboard practices he had taught us so far. The objective was to find areas on which we think we could improve and ultimately, produce a ‘better’...

read more

Dashboard week : Day 1

This blog is going to be a 5 part series sharing my personal experience with Dashboard week. Hopefully the challenges that I'm going to talk through and my mindset and actions in overcoming them is helpful to your your own endeavours, in both data and beyond. What is...

read more
DS21: The Beginning

DS21: The Beginning

Starting a new career in the midst of a pandemic is not something I ever thought I would do, but this has definitely been both a refreshing and exciting change!

read more

Hiding things on a Dashboard with a button

When making a dashboard with a compact design space is a precious resource. See the Dashbaord below as an example of having little room to spare without disrupting the layout If we wanted to add filters to the dashboard, it would push everything below it down and go...

read more
HIDE vs EXCLUDE dimension values in Tableau

HIDE vs EXCLUDE dimension values in Tableau

Hiding vs excluding in Tableau is not something I had really considered before, because it’s not something I had used much. But it came up in training the other day and it turns out the difference between these two is really important if you’re using table calculations!

read more
How to build a, wait, what’s it called?

How to build a, wait, what’s it called?

Ever wanted to build a chart but didn’t know where to look for advice on how to build it? I go through 5 chart types that will take your analysis to the next level as well as providing sample charts and blogs on how to build them.

read more
TOTAL( ) vs WINDOW_SUM( )

TOTAL( ) vs WINDOW_SUM( )

In our client project this week, the dashboards we were looking at had some calculations containing the TOTAL( ) function. It left me wondering, what’s the difference between TOTAL( ) and WINDOW_SUM( )?

read more

Apply for The Data School

Our application process is always open. Get started with your application today!