11 Geographic Data

This episode works with the UK Index of Multiple Deprivation (IMD) data set and a data set of geo-positions for the LSOA geographic areas of the UK. It demonstrates how to combine two data sets using a join operation, and then how to plot data on the basic PowerBI mapping tool linked to a scatter plot.

 

Slides (pdf): Geographic Data

Films (streaming):

Streaming service	link
Vimeo (no adverts)	Geographic Data
YouTube (sub titles)	Geographic Data
Bilibili (in China)	Geographic Data

 

Supplementary material:

The data for this episode is in this excel spreadsheet.

and in this CSV file for geographic coordinates.

NB there is also a PowerBI quickstart film on joining data using two keys.