Beware! Killer robots swim among us

In a further sign of humanity's inevitable journey towards dystopia, live trials of an autonomous sea-based killer robot made the news recently. If all goes well, it could be released into the wild within a couple of months. Here's a picture. Notice it's cute little foldy-out arm at the bottom, which happens to contain the necessary ingredients to … Continue reading Beware! Killer robots swim among us

Characteristics of England’s secondary school teachers

In exploring the data behind England's teacher supply model, it became apparent that the split of teachers by gender and age shows certain patterns by subject. Click through and use the below viz interactively to answer questions such as: How many secondary school teachers are there in the UK? What percentage of all teachers are female? Are there certain … Continue reading Characteristics of England’s secondary school teachers

Quick tip: find location of column in a SQL database

Now we all have nice access to large sprawling relational databases, the next problem is locating in which table you need to look to find the data you're after. For instance, which of the 100 tables available contain my sales? Of course the proper way would to consult the comprehensive, accurate, well-governed and accessible data dictionary to … Continue reading Quick tip: find location of column in a SQL database

Comparing partial week-so-far data with prior year values in Tableau

Happy new year to all! And now that's over, back to work. The first drama of 2016 was opening up some spiffy new Tableau dashboards someone made to see how business is at in the first week of the year, only to find apparently catastrophic results. Sales this week were way below sales of the … Continue reading Comparing partial week-so-far data with prior year values in Tableau