Overview
Power BI is a business analysis service offered by Microsoft and comes with an extensive range of data visualization options and business intelligence capabilities. With its simple and intuitive user interface, users of all levels are able to build their own reports and dashboards from one or more datasets.
Currently, there are five different tools for creating map-based data visualizations on Power BI.
Process
There are five standard map visualization options in Power BI Desktop. Click on the bullet points to find out more information about each tool:
 |
|
| |
| |
| |
|
Comparison
The table below brings together the main features, requirements and pros and cons of each map tool. For further information, take a look at the documentdocument Summary of the options for map visual in Power BI.
| Basic Map | Filled Map | Shape Map | ArcGIS Maps | Mapbox | |
|---|---|---|---|---|---|
| Visualization type | Simple or sliced points | Filled polygons | Filled polygons | All visualizations supported by ArcGIS Online | Points, heatmap, cluster map, cloropleth map (for certain locations) |
| Basemap options | Bing | Bing | No basemap | Anything from the ArcGIS Online collection | Standard or custom basemaps hosted on Mapbox |
| Data pre-requisites | GPS points or known location names | Known location names | TopoJSON file of the location in question | Publically available map on ArcGIS Online | GPS points or known location names |
| Can be used in any location? | Yes | No | Yes | Yes | Yes (with points) No (with polygons) |
| Main advantage(s) | Easy to use with GPS-tagged data | Easy to use when dealing with known location names | Allows using your own TopoJSON file | Versatile visualization options provided by ArcGIS Online. Many map control options, such as possibility to control the zoom level. | Additional visualizations and possibility to use your own custom basemaps created on Mapbox. |
| Main disadvantage(s) | Supports points only, background maps limited to Bing (not aligned with the UN mapping standards) | Not compatible with the majority of OCHA operations countries. Background maps limited to Bing (not aligned with the UN mapping standards) | Requires preparation of the TopoJSON file and matching the location names, PCodes or other unique identifiers with those in the other datasets. No background map. | Not possible to use in dashboards published or embedded online. No access to private ArcGIS Online content. | Polygon display possible for limited locations only (Global level maps, states of the USA). Limited map control options, such as no possibility to control the zoom level. |
Outputs/Resources
- Options for Map Visual in Power BI
- Introduction to ArcGIS Maps for Power BI
- Training package.zip
- OCHA trainings
Guidance
- OCHA_Getting_started_PowerBI.pdf has useful section on page 19, mapping using the Mapbox visual
- Power BI template (A4 landscape and portrait).zip