A Tableau Story: UK Regions

Tableau has some powerful geolocation data visualization options available. If you live in the USA, or want to visualise country delimited data, Tableau has you covered. For the UK, however, this seems to be a different ball game.

 


A Tableau Story: UK Regions

A Tableau Story: UK Regions

30th March 2016 in   Data Processing by Elliott Barratt


Tableau has some powerful geolocation data visualization options available. If you live in the USA, or want to visualise country delimited data, Tableau has you covered. For the UK, however, this seems to be a different ball game.

Thankfully, Tableau does have provision for UK county information. And this is great for working at that level of granularity. A problem arises when businesses want to look at their data cut into “Regions”. “Regions” is in inverted commas because the UK does not have a standardised and globally accepted region split. Regions in the UK can be defined by:

  • The BARB region breakdown
  • Ordinance Survey Regions
  • Postal Regions
  • Constituency Regions

To make this more complex, Scotland, Wales and Northern Ireland are also included as UK “Regions”, even though they are countries unto themselves within the UK. Searching for a UK regions Tableau data extract (or flat file) yields only part of the results. Most “UK Region” labelled files we encountered only contained information for England’s Regions, not taking into account Scotland, Wales or Northern Ireland.

To tackle this problem and be able to deliver to our customers a standardised Region breakdown for their data, we have merged polygonal information from multiple sources to generate a UK Region definition file. This file includes:

  • East Midlands
  • East of England
  • London
  • North East
  • North West
  • Scotland
  • South East
  • South West
  • Wales
  • West Midlands
  • Yorkshire & Humberside

To use this file in Tableau, simply add the CSV to your workbook as a data source and link the relevant fields from your data.

You can download the CSV file here.


 

Newsletter

  • Latest news
  • Industry updates
  • Tutorials
  • Market Research FAQs


Archive