Hi, I'm Richard
Data analyst & storyteller.
I specialise in business intelligence, visualisation, analytics, data mining and SQL wrangling. Which is a wordy way of saying I deliver insights from numbers.
This is a personal diary of data visualisations and insights I enjoyed making.
Electoral choropleths - an election is in the air, so it seemed time to bust first-past-the-post constituency maps with a fairer "share of vote" viz. Made in Tableau, with shape files from ONS Boundary Line. Dec '18
Business mountains - a Kepler.gl map showing registered office addresses. It showed up an unusual spike of business registrations in Warrington, and attracted a ton of explanations from the LinkedIn community. Jul '19
Animated heatmap showing housing affordability in England. This was a mashup of data from the house price index and ONS annual survey of hours and earnings. Visualisation in Tableau, post production animation in Photoshop. The heatmap style is simple, compelling and tells a lot of stories. Twitter seemed to like it. Feb '19
Choropleth (and PDF report) showing house prices by postcode. This deliberately breaks my rule on viz having an obvious takeaway. I like the confusion and lack of pattern, because that's the point: Contrary to the headlines, house prices simply aren't rising everywhere. Data from HM Land Registry + ONS postcode lookup. Visualisation and report in Tableau. Sep '18
Animated lollipops that try to explain correlation of the major house price indices vs. real sales figures. Data collected by hand from the Halifax, Rightmove, Nationwide and the ONS. Cleaned in Tableau Prep, figure work in plain old Excel, animation in Photoshop. Jul '18
Very short video about housing affordability in the UK. This was my first use of Adobe Spark which forces you to concentrate on simplicity. Data by Trussle.com, animated bar chart in Illustrator/Photoshop. Note the use of oversized wording, a trick when creating videos intended for small screens. Jun '18
Ranked column chart that tries to rebalance a view that Brits are critical to the Spanish property market (they actually account for 2% of sales). Data by Kyero.com, wrangled in Chartio, polished in Illustrator, animated in Photoshop. Mar '18
Why I keep this diary...
Data visualisation vexes me daily.
Over the years I've sat through lots of data presentations (and given a few) where audiences died trying to understand great analysis that was badly presented.
It's a heart breaker.
So a while ago I stepped outside of the numbers world, and took a night school class in graphic design. I can't pretend it made me a designer, but understanding a little more about colour theory, typography and grids has really helped in presenting my work.
This page is a personal diary of my favourite visualisations. I hope they're getting better?
I include notes on software and workflow mostly because I've discovered there is no perfect toolset for data visualisation.
Your method will depend entirely on the data, the point you're trying to make, where the viz is going to be presented - and the time you have available.
Critique is welcome, I try to obey just a few rules:
- If viz needs reading instructions, it's wrong
- If viz has no obvious takeaway, it's pointless
- If my mum still doesn't get it, start over
Simplifying the complex is the job.