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.