ArcGIS Map in Power BI; Simple, But Insightful

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

      Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
      Reza Rad
      Trainer, Consultant, Mentor
      Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit.
      Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
      He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
      Reza’s passion is to help you find the best data solution, he is Data enthusiast.
      His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

      8 thoughts on “ArcGIS Map in Power BI; Simple, But Insightful

      Leave a Reply