Data Training from Zomalex

Home | Power BI | Excel | Python | SQL | Visualising Data | Generative AI

Building Geospatial Maps with Power BI Course Notes

These are the course notes.

The two main map types

Point(Bubble, Circle) Maps

point map example

Example Point Map - Source: The Economist

Choropleth (Area, Shape) Maps

Use when location, size and boundaries are important.
Colour can represent either:

Technical note: Shape files come in many formats: (ESRI) shapefile, GeoJSON, TopoJSON

choropleth map example

Example Choropleth Map - Source: The Economist

Power BI Map Visuals

Power BI has several visual map types. We will use two of these in the course.

The Azure map visual is the most important map visual by far. Microsoft recommend this for new projects and they make regular improvements to its capabilities. It will at some stage have all the capabilities of all the other map visuals combined and is intended to replace them.

The Bing map visual is the classic map visual and we include it in this course since many reports existing reports use it.

Case Studies

The hands-on labs will use two case studies.

Using Map visuals with other visuals on the report page

We can combine maps with other visuals on the same page to good effect.

Building Maps – Helpful Hints

Here are some hints when building maps in Power BI. These are born of experience and frustration.

Useful Mapping Resources

ONS UK Open Geography Portal

The ONS UK Open Geography Portal – UK shape files and locations Open Geography Portal.

This contains boundary datasets, available in various formats, each denoted by specific suffixes.

The higher the resolution the larger the file and the more time needed to load. For our purposes the BSC or BUC are sufficient. The BFC file is too large to load into Power BI Desktop.

The final C indicates clipped to the coastline at the Mean High Water mark, providing detailed representations without extending into the sea. (There is also a BFE version that extends into the sea but we don’t need this.)

Other resources

mapshaper converts shapefiles into GeoJSON and TopJSON, with WGS84 projection if needed.

ColorBrewer provides colour advice for maps.

QGIS – free open source map editor (not covered in this course).

The Ordnance Survey OpenData contains OpenData geospatial datasets from OS and other data providers.