Data Viz Archive

This is the archive of things I’ve written about data visualisation (or, Things With Graphs In). Some of it from my PhD years is about R, some of it from my industry years is about Tableau and Alteryx.

Strings and roundabouts: how to label your numbers in Tableau effectively

Time is a Machine: how to create a clock in Tableau

Centre of Gravity, Metaphorically: Plotting time-based changes on maps.

Between order and (statistical) model: how the crosstab tool in Alteryx orders things alphabetically but inconsistently

Time is money, money is power, power is pizza, and pizza is knowledge.

Everything you ever wanted to know about the Mahalanobis Distance (and how to calculate it in Alteryx) [co-developed and written with Bethany Fox]

Paint your target: how to create a bullseye graph in Tableau

The relationship between away team performance and distance travelled in the English football league

The Colour Revolt: using rank calculations to get around Tableau’s colour defaults

If data is a supermarket, Tableau is a self-checkout machine

Relationship of Command Buttons: why Tableau tooltips lose functionality sometimes

Now you’re making me cross(tab)… getting around character glitches in Alteryx’s crosstab tool

I like big numbers and I cannot lie: how to make numbers pop out from KPI dashboards in Tableau

Coxcomb charts in Alteryx and Tableau: your one stop blog shop

With great data comes great responsibility

Keeping things regular: how to schedule things on Tableau Server

ASCII and ye shall receive: approximating graphs in Tableau tooltips

Using Gantt bars to fill the space between time-series lines in Tableau (or, you Gantt always get what you want)

Viridis colours in Tableau

All the small things: Tableau tips and tricks I picked up when revizzing my PhD work

Tooltips: going beyond simple information

Using dummy variables for sizing Gantt bars in Tableau

Simple filters and parameter filters in Tableau

Sets and groups and rock and roll

Getting around Tableau level of detail calculations in Alteryx

Calculating the top n % in Alteryx: different methods, different results

Alteryx for R Souls: summarize

Alteryx for R Souls: an introduction to macros

Alteryx for R Souls: a quick introduction

Quantifying three years of a long-distance relationship

Rolling form and how Arsenal lost the Premier League title

ERP graph competition!

Portugal: the worst Euro finalists ever

Visualising competition in the Premier League and La Liga

The (lack of) relation between youth playing time and later success in football

Quiz time: La Liga or Premier League?

Visualising football league tables

The gender gap in school achievement: exploring UK GCSE data

Bigger isn’t always better – the case of the first innings in cricket

Using R to stick Excel columns into individual .txt files

scatterplot / dotplot / losttheplot

Using R to calculate better cricket statistics, or how to revolutionise the way we slag off Ian Bell

Putting the graph into electroencephalography