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
|Vimeo (no adverts)||Geographic Data|
|YouTube (sub titles)||Geographic Data|
|Bilibili (in China)||Geographic Data|
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.