ArcGIS Map in Power BI; Simple, But Insightful

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

2017-04-13_11h21_18

I have written about 4 other types of map visual with Power BI before. In this post I want to explain how ArcGIS visual work as a map visual. There are some specific features in this visual which is simple to use, but will give you a lot of insight. With this type of map visual, you can add multiple layers of data, and use even some of existing geo location information from ArcGIS map directory. Let’s go through an example and see what are features with this visual. To learn more about Power BI, read Power BI book from Rookie to Rock Star.

Maps in Power BI

There are many ways to visualize something on Map in Power BI, some of it are as below;

I have written about them all expect last one. This post focus is on ArcGIS Map visual. Hopefully at the end I will write a post about comparison.

Sample Data Set

For this example I will be using a sample data set which includes earthquakes in New Zealand in 2015! Not all of them, but part of earthquakes. Guess how many earthquakes listed in this file? 20,000! But don’t worry, it has listing of everything even earthquakes with magnitude of less than 1. To download the CSV data set file, use link below;


Enter Your Email to download the file (required)

ArcGIS Map Visual

This visual is still preview at the time of writing this post, and for using it, you need to enable this preview feature. To enable it go through:

File Menu -> Options and Settings -> Options.

2017-03-07_10h30_42

In preview features tab, select ArcGIS Maps for Power BI.

2017-04-13_10h23_42

After clicking OK. you need to close your Power BI Desktop and re-open it again. You should be able to see ArcGIS Map visual in list of your visuals now.

2017-04-13_10h24_59

Get Data

To start with the sample data set, Get Data from Text/CSV, and select the quakes.csv file (link above in this post), Click on Edit in Navigator window, and you will see the whole data set. Only keep these columns and remove the rest: Longitude, Latitude, Magnitude, and Origintime. That means; just select these columns, an from right click menu click on Remove Other Columns.

2017-04-13_10h28_51

Close and Apply the Query Editor window. Drag and Drop a new ArcGIS map visual in the report, and assign values from latitude to latitude,  longitude to longitude, and magnitude from fields list to the Size section of the visual.

2017-04-13_10h31_38

This visual, like the basic map visual in Power BI, has a limitation on the number of data points to show. because we have 20K data points it cannot visualize them all. Let’s filter the data set, and only focus on everything with magnitude greater or equal to 6. For doing this in visual level filter expand the Magnitude filter and apply filtering. Remember to click on Apply Filter, otherwise nothing happens.

2017-04-13_10h33_53

After applying filter, you would simply see only few numbers.

2017-04-13_10h39_39

All of these earthquakes with magnitude more than 6 happened in 2015! can you imagine?!!!! anyway, let’s go back to ArcGIS map;

So far, the map is very similar to normal Power BI basic map visual with bubbles. Now let’s see what other options we have with ArcGIS visual;

ArcGIS Features

To go through features of this visual, you need to click on three dots icon on the top right corner of visual and click on Edit.

2017-04-13_10h42_11

You will be redirected to an Edit mode, where you will see the map full screen, and number of menu options at the top;

2017-04-13_10h43_21

Change Base Map

The first change you can make, it so change the base map, to be something different. You can choose from Dark Gray Canvas, Light Gray Canvas (Default), or Streets.

2017-04-13_10h45_16

This feature is good to match the map with theme of your report, or even get some street information.

Map Theme

One of the interesting features of this visual, is to change theme of Map. This type of map can give you four themes;

  • Location Only – no size difference between bubbles
  • Heat Map
  • Size – bubbles with different sizes based on measure’s value
  • Clustering – Good option for drill down

Clustering is good if you want to have high level view, and then ability to drill down into each region. Here is a view of clustering;

2017-04-13_10h52_43

Each bubble shows you the total count of data point in that region (more you zoom out, bigger your region will be). and if you double click on a bubble you will drill down into that region;

2017-04-13_10h55_58

Heat map is a good visualization for showing the severity of earthquake in each area more graphically;

2017-04-13_10h57_03

You can also use Location only or Size, which are simple to use.

Symbol Style

Depends on what Map Theme, you’ve selected, you can do the details configuration of that in Symbol Style section. For example, if you have selected heat map, you can change the color. If you have selected size, you can change the bubble sizes and etc.

2017-04-13_11h06_04

Pins

You can add your own pins. These pins can be locations of branches, hospitals, schools, or whatever else you want to use as a pin on the map.

2017-04-13_11h08_20

Reference Layer

The last feature, but not least is adding reference layer. In my opinion this is one of the best features of this visual. You can add another layer of visualization based on a map in directory of ArcGIS maps. ArcGIS has many maps that you can use, almost map of everything! if you click on Reference Layer menu option, you can see some of existing maps for USA.

2017-04-13_11h13_21

To access more maps, click on ArcGIS at the top, and there you can search for maps. For example below are some maps in New Zealand area;

2017-04-13_11h14_41

There are maps for schools, pipelines, gas stations, almost everything. Even there is a map for Traffic Camera Locations, Very useful map!

Because the current data set is for New Zealand 2015, and there was a cricket world cup in New Zealand and Australia at that time, so it might be good to bring a map of venues for that and realize are those cricket world cup venues close to the earthquake centers or not. Simply you can search for cricket world cup, and you will get the map very easily. Click on Add to add the layer to map;

2017-04-13_11h18_06

It will take few seconds for the layer to load, and now you will see locations with star mark on it. Wonderful, isn’t it?

2017-04-13_11h19_55

Now if you zoom in more to the New Zealand part of the map, you will see how close are venues. The venue in Christchurch was pretty close to one of earthquakes actually.

2017-04-13_11h21_18

Adding Time Dimension

All of above features can be much more insightful with adding a time dimension, and understanding how measure values (in our case earthquakes) happened through the time. If you bring Origintime to the Time section of this visual you will see a new time bar under the map, which you can select the time range for it, and click on play to see how earthquakes happened through the time. Similar to the Play Axis feature in Scatter Chart, Very insightful dimension to add.

2017-04-13_11h27_50

Summary

I hope demos of this post has been motivate enough to show you the power of this visual. ArcGIS map visual is not like other map visuals, it is the best of all I would say. There are obviously pros and cons (which I will cover in another post later). However this visual gives you many things; using different themes, adding reference layers from ArcGIS map directory, and adding time dimension. These features are not easy features to use with other types of maps. There is just one part which is not 100% clear, and that is the licensing part of this visual. This visual at the moment is preview and free. However, I’m not sure how long it will be available for free. Because this visual is still in preview mode, expect to see some errors and bugs in it. sometimes you get an error. and you need to close Power BI Desktop and open it, which will be fixed I believe in the general availability version.

Download Demo Files


Enter Your Email to download the file (required)

Save

Save

Save

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

2 Comments

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">