Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Get the Power of Location-based analytics in Power BI using ArcGIS Maps

by Danish Ali Detho | O365 & Power Platform Solution Architect

In today’s world, data analytics has to become pivotal for making informed decisions and decision-makers are always keen to find new and innovative ways to improve their knowledge about their customers. One of the key facets of that information is the geographic of your customers especially when your customers are geographically scattered around the county or World. This allows organizations to know which regions are performing well and where do they need to focus more to improve their presence. The most efficient way to present such information is through a map chart and the Power BI team recognized the importance of it which is why Microsoft has teamed up with ArcGIS to integrate their digital mapping and location analytics software solution in Power BI and provide their customers an exceptional mapping solution for presenting the geographical data. In this blog, we will take a look at this new mapping solution called ArcGIS for Power BI, how to utilize it using live data coming from SharePoint Lists and what benefits it presents to the customers.

What is ArcGIS Maps for Power BI?

ArcGIS Maps for Power BI is a comprehensive and scalable digital mapping and location analytics software solution which allows you to create compelling data stories with mapping, analysis, and insight capabilities. It incorporates an additional layer of depth to data analysis within Power BI. ArcGIS for Power BI is a tool that enables you to map and visualize your data geographically. It also provides the world’s leading spatial analytics tools along with a comprehensive collection of global data which can help decision-makers to understand patterns and trends that are difficult to present and visualize in charts, tables, or spreadsheets.

AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BICrystal Reports, or SSRS.

Main Features of ArcGIS Maps for Power BI

Improved data insights

ArcGIS maps have built-in smarts to identify geolocation data. It can convert any location whether be an address, city, state, ZIP code, place-name, boundary, or latitude-longitude into points on a map. The built-in smart mapping capability helps users to choose the right style and display the associated data.

Spatial analysis on mapped data

Spatial analysis helps users to enhance their understanding of mapped data by mapping relevant locations and spotting relationships and patterns i.e. adding more relational visuals on the report. This allows us to create heat maps with a click, aggregate data into clusters, determine drive time, and reveal hidden patterns in your data with ArcGIS.

Improved data accuracy and security

Geolocation information from your dataset in Power BI is sent to Esri servers to find locations and render them on the map. The data is never saved or stored on Esri servers because any interaction with Esri servers is transient.

Contextualize your data

ArcGIS spatial analysis tool helps you to identify the spatial facets of your data like Identifying a location in relation to other critical variables such as income, population, or weather. This gives you the power to set up multiple visuals showing other critical information and then control them using the Map.

Create an ArcGIS Map Visual using data from SharePoint List

Now, let’s create an insightful map visual using a SharePoint List. You can use any list which has some sort of location info whether it be addressed or state/City/country. I will use the Programs data categorized by states in Australia. For the location, I will use a normal Choice Column which has a list of all the Australian states.

Let’s open the Power BI Desktop and connect to a SharePoint List data source that contains the mapping data. Now click on the ArcGIS map visual from Visualizations.

You will need to create a trial account by going to https://www.esri.com/en-us/arcgis/products/create-account. Once the account is created, you can then set up your organization map. Afterward, go back to Power BI Desktop and then sign in using the account you just created.

Now, I will simply drag and drop the division column to the location field. This will render the Map with data points on it for each state.

This is pretty much what we can do with OOTB Maps visual too. Now, let’s dig deeper and use some other available fields. Size field changes the size of the pointers on the map based on some specific numeric data whereas the Color field can be used to distinguish the pointers on maps by setting a different color for each pointer on the map. Lets, add the count of items to show which state has the most programs running.

We can add multiple fields in the tooltip field to show relevant data when the user hovers over the pointer on the map.

Let’s look at some cool features which make it stand out from the OOTB map visual. You can set different map themes from the map settings on the top left using Basemap. And you can also display additional info as well. For our example,  Lets select the size of population and population of educated people.

Another great feature is to show spatial data by showing relevant data in other visuals and then changing the data visualization by selecting one or multiple points on the map. Let’s add a stacked chart that shows programs in each category and then select multiple states on the map.

Final Thoughts

AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BICrystal Reports, or SSRS.

ArcGIS Maps brings a whole heap of geo-enabled data analytics goodness to Power BI which will allow power bi users to create stunning map reports that will allow the business users to visualize the geographical data in various different ways as well as being capable to perform real-time business intelligence on the data in order to make efficient decisions. They will not only be able to visualize accurately mapped data but will also be able to leverage geostatistical data coming from Esri servers to understand the demographics of areas they are interested in making the reports even more insightful. The maps will also be integrated with other visuals on the report to allow users to do some Spatial analysis on runtime by selecting different points on the map.

Latest articles

AxioWorks Newsletter November 2023: ESPC23, new partnership, and SQList update!

30 Nov 2023

Hello Reader, Welcome to this month’s edition of the AxioWorks newsletter! We’re thrilled to bring you updates on our recent […]
[read article]

Why Support Legacy SharePoint Versions Like SharePoint 2010?

16 Nov 2023

In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
[read article]

Why Companies are choosing SQList over Power Automate

30 Oct 2023

In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
[read article]

AxioWorks Newsletter October 2023: An exhilarating month.

28 Oct 2023

Hello Reader, As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
[read article]

Why Choose SQList for SharePoint Data Extraction Over DIY Solutions

16 Oct 2023

In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
[read article]

AxioWorks Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

19 Sep 2023

In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
[read article]

AxioWorks Newsletter August 2023: A month of milestones and innovation.

28 Aug 2023

Hello Reader, September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
[read article]

Use Graph API in Power Automate to read large Excel files from SharePoint

28 Aug 2023

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
[read article]

From Punch Cards to Python: Still Hitting the Keys in my 50s

16 Aug 2023

I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter