Jason Bonello

Jason's blog

ArcGIS Maps for Power BI – Further capabilities and other information

The ArcGIS Maps for Power BI is also useful when used in conjunction with other visualizations, through Interactions. When selecting any location feature on the map, the filters will be communicated to the other visualizations which will in turn consider the same filtering.

The perfect map blends art and science into an effective tool of visual communication.

In the previous blog posts (that can be accessed from the following links: https://bit.ly/2PnIgR3 and https://bit.ly/2PnegWk),we have gone through the ArcGIS Maps for Power BI tool and had an overview of its use.

To wrap up this series, we will build on the description of most of the features in the previous posts, available when editing the ArcGIS Maps for Power BI.

S1

The remaining features currently available in this tool will be shortly described to wrap up the features section:

  • Pins – These provide the option of adding locations that are important to you on the map. For instance, if you are analyzing supply chain and distribution, the warehouse/s might be useful as pin/s, since these do not change no matter the changing dataset and need to be considered in most analysis.
  • Drive time – Once pins are set-up, drive time tool could be used to highlight distances within specified radius or drive time. For instance, if you are analyzing orders that are being delivered late in a particular area, the pin and drive time tools could help in analyzing the possibility of opening a new store in a nearby area (in comparison to the coverage it will offer to the client sites that are having the orders delivered late).
  • Reference layers – These can be either demographic layers or ArcGIS reference layers. Out-of-the-box demographic layers are US based and 10 of them are provided freely, which give data such as average households incomes. ArcGIS layers is data being published by other authoritative partners, customers and users that use ArcGIS online like weather services related data. Such data can be loaded and used in Power BI, without the need to spend time collecting regional data, cleaning and modelling it. For instance, an insurance company using Power BI and which might need to analyze the impact of a storm and the insurance policies within an area, might utilize ArcGIS storm surge information alongside with their own dataset for prediction and effect on policies.
    S2
  • Infographics – This tool provides information such as population and age that could also be used alongside the data. So, taking the same insurance use case above, this information could help identify how many people (irrelevant whether customers or not) are likely to be affected. This might hence be a good indication for selling and marketing departments.

Different selection options

There are different select methods available when using ArcGIS Maps for Power BI. These can be accessed through the map visual beneath the zoom in and out buttons (+ and -), as highlighted below:

S3

  • Select individual location – This enables the selection of only a single individual location at a time. Once another location is clicked the previous selected one will be automatically unselected, and the last selection retained with the reporting data refreshed and re-filtered accordingly.
  • Select multiple location – This enables the selection of multiple locations by drawing a box over multiple locations that need to be selected simultaneously. This provide a good way of comparing the data of various locations.
  • Select locations using reference layer – This enables the selection by area on a reference layer or within a defined radius / driving time from a specific location. This selection method will only be available if the map contains a reference layer or a drive-time area layer. If the map contains both a reference layer and a drive-time area layer, then both options will be available to choose from. The Reference layer selection tool will select all map features within the reference polygon – for instance if a state in US is selected, all location-based features located in that state on the data layer will be selected on the map. If the Drive time areas is chosen, data features will be selected within the defined area.
  • Find similar – This latest added feature helps the user to swiftly pinpoint any locations that have similar attributes to the selected locations on the map (through the data layer only). For instance, in a map showing the GDP per country, the Find similar would allow the easy identification of those countries/ locations that have the same/ closest GDP. The numerical field (like GDP in this case) that is to be used as a basis for comparable values, needs to be dragged in the Find Similar data well.
    S4
    Then, after choosing the location to have the GDP compared to – in this case US – the GDP for the other locations will be compared and a rank for the most similar GDPs will be shown. In this case, Canada has been ranked as the closest for that year when filtering on the North and South American regions, with Dominican Republic being marked as the 10th most similar.
    S5

Basic vs Plus subscriber/ ArcGIS account

By default, the ArcGIS Maps for Power BI tool is available in basic version. This brings with it some limitations when compared to the same tool accessed through the Plus Subscription.

In order to login or signup for Plus Subscription, or even connect to ArcGIS directly, the yellow circle with the plus sign on the ArcGIS Map for Power BI could be used – as per below:

S6

But what is exactly different between the Basic and Plus subscription? Following is a summarized comparison of the main features that differ between both:

ArcGIS Maps for Power BI features

Free (incorporated within Power BI with no cost)

Plus subscription (monthly fee per user - currently $5 pp)

US demographics only Global and richer demographics including Age, Behaviours, Healthcare etc.
Public maps Validated, at the ready data, organized and collected from reliable and trustworthy sources
Map and visualize locations: 1.5K features (geocoded locations) per map; 100K features per month Map and visualize further locations: 5K features per map; 1 million features per month
Carry out spatial analysis including heatmaps, drive-time etc. Execute the same spatial analysis as the basic incorporated
4 basic basemaps

4 basic basemaps + 8 others including satellite imagery, oceans and terrain

One point that remains evident from the above is the limit that still exist in the features that could be included in a map. Hence if one is trying to geocode locations or street addresses, in Basic, only the first 1500 will be considered in one map, whilst 5000 will be taken into account for the Plus subscription. This cap mainly exists to retain a good user experience for both visualization and performance, yet might be something to keep in mind especially if targeting large datasets.

However, this is not a restriction for Power BI overall – since it offers other mapping tools that might be used in large datasets like for instance MapBox. The different mapping tools present different capabilities and features that might appeal and apply to different users depending on their use-case, scope, complexity and functionality sought.

Performance enhancement and other improvements

In one of the latest updates (September 2018), performance of ArcGIS Maps for Power BI has been improved drastically, and is cited to be about 50% better. This is mostly visible when navigating through the map or through interactions done and its benefits make live presentations of such maps less nerve-wracking. The improvement does not only apply for new maps or new reports, but will also be experienced by existing reports that are already using an ArcGIS Map for Power BI.

In December 2018, other improvements were released for ArcGIS Maps for Power BI. In addition to the Find Similar feature that has been referred to already above, there were other features enhanced covering both the basic and plus subscription. One other improvement worth highlighting is the boundary data in the Location Type (which had been described in the previous blog on this series). In this latest release, more boundary data has been made available to help increase accuracy in data analysis. Likewise, the Plus subscribers have access to lot more curated infographic data for various demographics.

Concluding remarks

All of this shows that GIS and mapping tools are being given the required attention by Power BI and Microsoft in general. With their increased popularity in recent years, they have now become essential in decision making and business, and through proper data visualizations – the data could become much more meaningful. This ties up with what Dr. Keith Harries suggests, that “The perfect map blends art and science into an effective tool of visual communication.” And thanks to Power BI mapping tools this is being enabled!

ArcGIS Maps for Power BI – Editing and available features

This blog post builds up on the previous post that covered an introduction to ArcGIS Maps for Power BI – which can be re-accessed through the following link: https://bit.ly/2PnIgR3

We will start by looking at the editing features that are available within ArcGIS Maps for Power BI.

Jack Dangermond said, “the application of GIS is limited only by the imagination of those who use it.” So, let’s try to get a glimpse of the range of features, with the hope of being inspired and applying them in an imaginative way Smile

Editing an ArcGIS map in PowerBI

Clicking on the Edit of the visualization map would allow you to change various map contents through different tabs and tools – as shown below:

clip_image002[4]

Following is some information on each of the tools:

  • Basemap – This lets you choose from four different basic basemaps (unless you are a Plus subscriber or have an ArcGIS account which then gives you access to more options of basemaps). Through such changes, one can ensure that the focus will remain on the data importance rather than caused visual distractions within the map. If different basemaps use different projections, there might be the need to save, close and re-open (or change between report pages) for the map features to reflect the new projection. In such cases, the Attention icon will probably show stating that the basemap will be updated next time visual loads.        

                               clip_image004[4]

  • Location Type – This will allow the locations to either show as points or boundaries as can be seen below. It can be specified whether the data pertains to one country or many countries. For the boundaries the location type could be changed from a dropdown list including countries, districts, postcode areas, region etc. (available list changes depending on the country selected). The method to be used in matching locations could vary between:
    • Closest match—This can be used when the exact spelling cannot be guaranteed (with errors like Frence), if there might be a mismatch with the spelling in Esri's data services, or if an exact match search will not add all your data to the map (even if this might not be the best solution to data accuracy). This might obviously lead to inaccuracy and wrong assumptions.
    • Exact match—This is the most accurate method and is to be used when boundaries are defined by codes or abbreviations, or when one is sure that the dataset spelling is correct and matches Esri's data services.
      clip_image006[4]
      clip_image008[4]

      The Location Type might be a good place to start with if a “Failed to locate [x] features error” is encountered as follows:
      clip_image010[4]

      This might be a result of incorrect settings in the location type, like adding a list of states in Brazil without setting the Locations are in one country setting, choosing Brazil and changing Location Type to States. The error might also be a result of an improper match between a value in the dataset and Esri’s data services (or a spelling mistake).

  • Map themes – This allows a change in the style for the map and once can choose from location only, heatmaps or clustering (the last two are only available for point layers, that is when you select Points in the Location Type). Through the clustering option, one could group individual location points into larger circular clusters that fall within a cluster radius – giving a high level view and then the ability to drill down into each region. If heatmaps are chosen any values in the Size or Color will be ignored and the tooltips will not be available.
    clip_image012[4]
    If numerical data exists in the Size and/ or Color field wells, there will be a further 3 map themes available – being Size (showing bubbles with different sizes based on the measure’s value), Color and Size & Color:
    clip_image014[4]

  • Symbol style – This provides the option to do changes in appearance that are immediately reflected in the map including symbol shape and size, colours (and defining the colour ramp), transparency level and classification types. The available options in the Symbol Style screen depends on the map theme selected and the nature of the data being analyzed. For example for heat maps formatting options like Transparency and Area of Influence will be available.

    Classification types will provide different options to classify the data and defines the way ArcGIS is going to create the clusters from your data, namely:
    • Natural Breaks (sometimes referred to as Jenks) – The fluctuated data values are clustered in naturally occurring data categories. Class breaks take place where a gap between clusters exist. This method is suitable for unevenly distributed data. For instance, streets are clustered based on their length (short vs long), or cities based on their size (small vs large).
    • Equal Intervals – Value ranges are set equally in size in every category. The entire range of data values (max - min) is divided equally into the number of categories that have been chosen. One will specify the number of classes, and ArcGIS Maps for Power BI will automatically determine how to divide the data.
    • Quantile – Classification of data is done within certain number of categories having equal number of units in every category.This might be suitable for evenly distributed data.
    • Standard Deviation – Shows how much a feature’s attribute value varies from the mean – whether above or below mean. This might be a good way of pointing out the extremes.
    • Manual Breaks – Enables one to define own classes, class breaks and ranges.

As one can see, such features and functions not only offer different options to the creator to give context to the geographic data visualization but will also help the end-user in understanding and adapting to the data better and enhance comparison. I hope the information in this post was useful in some way or another. In the next blog, we will continue building further on this. Stay mapped!

What is ArcGIS Maps for Power BI – and why you want to use this

In this and other following blog posts over the coming weeks, I’ll be compiling some information gathered from some research done on a capability in Power BI which has increased in popularity and usage: ArcGIS Maps.

As Jimmy Buffett said “Without geography you're nowhere” – so hopefully this capability will help us get to somewhere

So… what is ArcGIS?

In a nutshell, ArcGIS is a software-as-a-service platform that allows the creation, discovering, management, sharing, analysis and visualization of location-based and geographic data through maps, applications and reports. Esri (Environmental System Research Institute), which developed, hosts and administers ArcGIS, has partnered with Power BI and as of 2016 ArcGIS Maps for Power BI has been included and is now a built-in feature in Power BI to provide enhanced mapping capabilities. GIS (Geographical Information Systems) analysis is beneficial to different domains or industries including, but not limited to business, urban planning, crime mapping, resource optimization, transport planning/ management (public & private), education, assessment of natural disasters/ hazards, healthcare etc.

What is possible with ArcGIS?

The following is just a glimpse of some simple map-related visuals that may be acquired through ArcGIS Maps for Power BI.

clip_image002clip_image004clip_image006clip_image007

How does ArcGIS differ from the previous map visualizations?

ArcGIS has various features and capabilities, which are to be summarized and explained further in the upcoming blogs. Prior to the ArcGIS Maps for Power BI introduction, Power BI had limited mapping capabilities through its own map function, especially when compared to other suppliers and platforms such as Tableau. Apart from the enhanced visual appearance (such as changes in themes, ability to add layers of demographic data etc.), this tool allows comparability between location-based data and features mainly through the selection methods of points on the map (the different selection methods also to be explained further). It helps provide context to geographic data and provide accurate spatial analysis. It’s worth keeping in mind that ArcGIS is intended to display and interact with data that is managed by Power BI. Hence, it’s not intended to provide data enrichment in the form of adding data from ArcGIS Maps for Power BI itself to your own business data.

You excited? Let’s do this…

Enabling ArcGIS in Power BI service

If you’re using Power BI through app.powerbi.com, you might need to enable ArcGIS Maps for Power BI. This can be done by clicking on the cog icon in the top right section of the menu bar and open Settings. Under the General tab, select ArcGIS Maps for Power BI checkbox.

clip_image009

Power BI will have to be restarted after that, and the ArcGIS Maps for Power BI icon will then be available in the Visualizations pane when opening a report in Editing view.

When using Power BI Desktop, ArcGIS Maps is normally enabled by default, however it has an option which could still control the enabling and disabling of this capability, under the Security tab in Options & Settings > Options, as follows:

clip_image011

ArcGIS Maps is unavailable in Power BI Embedded edition and Power BI service embedding (PowerBI.com).

Creating an ArcGIS map in PowerBI

To add a map to the report, use the ArcGIS Map for Power BI Visualization from the visualization pane – icon shown below:

clip_image013

This will add a new ArcGIS Maps for Power BI visualization on the report page.

clip_image015

The dataset in the Fields pane can then be used to populate the field wells and add data to the report.

The following are the location field wells that can be used:

  • Location – Values dragged within this field well should be location-based like single field address, postcode or country name to display the features on the map.
  • Latitude – Values dragged here will define part of a map coordinate (north to south position). If this is used, the corresponding longitude field must also be used. In the modelling tab, a data category with the same name also exists to transform the column in the data set.
  • clip_image017
  • Longitude – Values dragged here will define part of a map coordinate (east to west position). If this is used the corresponding latitude field must also be used. The data category Longitude also exists.

The same data categorization can also be applied on the City, Country, Province/State and other data to be considered location based. When done, a globe icon will show next to fields’ name to show that the field is marked by Power BI as containing geographic information – as follows:

clip_image019

For accurate plotting of data on the map, latitude and longitude values are suggested to be used if these values are available. If you fill all of the Location, Latitude and Longitude field wells, only the Latitude and Longitude will be considered by ArcGIS Maps for Power BI to map data and the Location field will be ignored. The country will still however be considered for the information that is to be shown when hovering over the mapped point - as per below:

clip_image021

In addition to these, the Size, Color, Time and Tooltips can be used as non-location fields that will affect how features look on the map. As best practice it is suggested to first add the location-based data before adding these to render the points on the map.

  • Size – Numerical values could be added to this field well to show map features based on size. For instance, when analyzing earthquake data, dragging the magnitude value here will show the extent of the scale. Similarly, by dragging the population field, the location symbols on the map will be automatically rendered in proportional sizes based on the population value.
  • Color – This field well could be used for both numerical and categorical values to differentiate the map features according to the colour ramp. For instance, a light-to-dark colour ramp will help identifying low-to-high numerical data values like sold quantity, whilst different colours could be used for categorical data like brand preference. Size and Color could be used together both for different or same attributes in the same map.
  • Time – This field well could be used to animate the features on the map for temporal data fields according to date, time or date and time. It helps understand how measure values occurred through the time, and will prompt the time slider.
  • Tooltips – As for other visualizations, this can be used to provide definitions of information that appears in tooltips, and multiple fields can be used here.

It seems quite straight forward, doesn’t it? Well, in the next blog post we will be going deeper into how to edit the ArcGIS map and how to utilize some of the beneficial functions this tool offers!