Mapping Adventures in Power BI (part 3)

Now when have been able to place coloured pins on a map, our users wanted us to show them a map with coloured suburb shapes, as it more accurately indicated coverage for the sales process, especially in remote areas.

Phase 3 – Show a map with coloured shape for the suburbs (free, paid)

After speaking to various map vendors about their solutions and costs (cha-ching!) we because determined to attempt to use the map provided with Power BI.

This solution required us to obtain a shape map. We went for the ASGS (Australian Statistical Geography Standard) SSC (State Suburb) map provided by the ABS (Australian Bureau of Statistics). We downloaded the zip file which contains a shape file for Australia from here.

From here it is important to reduce the size of the map and convert it to Topojson format, in order to import it into Power BI. These steps are covered well in these articles

As you can see in our map, some suburbs are not picked up correctly. This occurs when a suburb with the same name exists more than once, either in the same state, or in a different state. We are planning on over coming this by using the SSC code to unique identify states in our database and mapping using this field. I will let you know how this goes…

As always let meĀ  know if you want more info and I hope this post was useful to someone…

2 Replies to “Mapping Adventures in Power BI (part 3)”

  1. John, thank you for sharing and for your series on mapping. It’s great to see what people are doing with Power BI maps, and you did a great job showcasing your work with ArcGIS Maps and the Shape Map. It’s good to see you include the link to vote on the SQL Spatial to Power BI experience. You would think it would be more tightly integrated.

Leave a Reply

Your email address will not be published. Required fields are marked *