For those not familiar with Microsoft PowerBI, it is a dashboard application that allows users to create a plethora of views of tabular data. This is done through the use of Visualizations.
Data inputs can range from a simple CSV file to enterprise databases. Many of these Visualizations are in the form of graphs.
The usual suspects (bar, line and pie) are included. Naturally, maps are also an item of interest. Often, dashboard users want to get a sense of location for the data they are visualizing.
Generally, the pre–existing map Visualizations in PowerBI are dependent on data that aligns with certain location criteria. For example, countries or cities. They also tend to be single layers.
Comparing the basic map Visualization (Figure 2) and the Esri map Visualization (Figure 3) there are several points to note. The basic map shows the population data as discrete colours. Changing the symbology requires updating the colour of each value, one-by-one. While in ArcGIS Maps for PowerBI, the symbology options are more in line with what is seen in ArcGIS Online (see Figure 4).
- Add more reference layers to the map (see the light grey licences in Figure 3)
- Perform analysis (buffer or drive time selections)
- Use point clustering
- Add and control labelling
These capabilities combine to give you a powerful addition to your PowerBI Reports – integrating some of the spatial capabilities of the ArcGIS platform.
In future blogs, we’ll be looking at how to access and get the most out of ArcGIS Maps for PowerBI, so watch this space.
Posted by Ben Holmes, GIS Consultant.
Data sources and Links
- What’s New in ArcGIS Maps for PowerBI (https://doc.arcgis.com/en/power-bi/get-started/whats-new.htm)
- OGA Open Data (https://data-ogauthority.opendata.arcgis.com/)
- UN (https://population.un.org/wpp/Download/Standard/Population/)