1 Reply Latest reply on Jul 17, 2018 3:53 PM by Alan Huddart

    Deprivation data on map

    Catherine White

      Hi all

       

      I'm looking to plot some geographical / demographic deprivation data on a map and then overlay that data with a separate database of existing postcodes.

       

      The data I have is a list of postcodes with a percentile of deprivation related to the postcode (i.e. 1% most deprived, 40% most deprived etc)

       

      I want to try and colour code the postcodes based on their deprivation percentile. The postcodes should cover an entire region of the UK so every area within that region should be coloured. Not sure if I would need spatial data to ensure that though?

       

      I've attached the full dataset but some advice would be gratefully received.

       

      Many thanks,

       

      Catherine

        • 1. Re: Deprivation data on map
          Alan Huddart

          Hi Catherine,

           

          Firstly, in the Data Source tab in Tableau (or in your source data) you need to split the postcode based on the " " (space) separator, to get the first half of the postcode (e.g. NG6 from NG6 8AX). This is because mapping can only happen with the first half of UK postcodes, after that the detail is too granular to map.

           

          Secondly, add this new field (named Geo Postcode in my attached workbook) to the chart and add Percentile of Deprivation to the Color mark. Change the chart to a Filled Map. If all of your geo-locations come up as Unknown (small note at the bottom-right of the chart), click on the note and Edit Locations, ensure the Country is set to United Kingdom.

           

          I've attached my workbook for you to take a look at, let me know if you have any other questions. I think the missing section is NG11... postcodes as they had no space when I did the initial split. You can add the space in your source data and everything should come through.

           

          Alan