joel-lbth/pbi-mapping

pbi dashboard demoing use on showing spatial data

mapping in pbi

a "shape map" demo combining a topojson ward map and census data from the nomis api

contents

• map - lbth-wards-2022.topo.json
  • 2022 wards queried from geoportal as geojson and converted to topojson with mapshaper
• data - lbth-ward-population-2021.csv
  • population data queried from the nomis api and linked to map areas by wardcode
• report links together map+data - mapping-in-pbi.pbix
  • the source report (binary file format)
• ./mapping-in-pbi/
  • the source report unpacked with pbi-tools (command pbi-tools extract mapping-in-pbi.pbix) to a folder of source code (maping-in-pbi) that can be edited, version controlled, and recompiled back to a binary .pbit file which in turn can be "re-dydrated" with data, and recompiled as a binary .pbix report
• theme.json
  • the theme file: sets the corporate slide background image; implements the colour-blind safe viridis palette reversed as the main palette (on a light background, light colours map to low values; dark colours map to high values). the colours were generated with a pbi friendly colormap generator