EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB485401: Configuring ESRI Map in MicroStrategy


Mateusz Mitoraj-Wojtanek

Senior Consultant • Strategy


This article describes the process of configuring ESRI Map in MicroStrategy.

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
As Strategy and ESRI continue to make improvements to the service/API's, ESRI keys provided for older versions of Strategy may stop working. Please ensure that you stay on the latest supported release of Strategy to avoid interruptions in service.  In particular, ESRI keys provided for Strategy 2021 Update 4 and earlier will cease to operate in April/May 2024. 

Briefing


ESRI Map is a visualization integrating geo services into Strategy dossier. It allows to deploy dynamic maps and perform rich analysis on geographic level. Integrating map-based query capabilities allows to filter data and spot trends and patterns.

Prerequisites


The most important thing in deploying ESRI maps in Strategy is properly prepared dataset. The main requirement is to have at least one Geo Attribute. It is an attribute with defined geography - this can be done during data preparation while adding datasets. It is essential for the visualization to show proper data.
There can be many types of Geo Attributes, such as:

  • Country
  • State
  • County
  • City
  • Zip Code
  • Area Code
  • etc.


To show data valuable for any analysis, the map visualization requires at least one Attribute (including Geo Attribute) and at least one Metric.

How to start

  1. Create a new dossier or open an existing one.
  2. Import a dataset and make sure that it contains a Geo Attribute.
  3. From Insert Visualization go to Map and select Map.
ka0PW000000295dYAA_0EM4W000004YaSV.jpeg
  1. Add a Geo Attribute to the visualization.
ka0PW000000295dYAA_0EM4W000004YaSz.jpeg

 

How to format Map and Geo Attributes

Map Styles


ESRI Map allows user to chose one of 7 styles of the map:

  • Street
  • Light gray
  • Relief
  • Topographic
  • Physical
  • Terrain
  • Satellite
ka0PW000000295dYAA_0EM4W000004YaTs.jpeg

To change the style, go to Format tab → Visualization Options → Map Layout → Map Style. Or, alternatively, go to the map itself and select the Styles dropdown located above the map.

Configuring and formatting Geo Attribute

After adding Geo Attribute, data points will be by default set to Markers in the shape of Pins. To change that, go to Format → Visualization Options → Data Points → Type. 

Marker Type

This is a default setting of the Geo Attribute after adding it to the visualization. They can be shaped as:

  • Pins 
ka0PW000000295dYAA_0EM4W000004YaU7.jpeg
  • Squares 
ka0PW000000295dYAA_0EM4W000004YaUC.jpeg
  • Diamonds 
ka0PW000000295dYAA_0EM4W000004YaUH.jpeg
  • Dynamic Pins 
ka0PW000000295dYAA_0EM4W000004YaTy.jpeg
ka0PW000000295dYAA_0EM4W000004YaUg.jpeg

When there is a high density of data, there is an option for clustering – data point will show up as one circle with an information of the number of points clustered. There is also the possibility of showing details in a ring. To enable those options, select Enable clustering and Show details in ring under Data Points.

ka0PW000000295dYAA_0EM4W000004YaUq.jpeg

 

Bubble type


The second type of Markers available on ESRI Map. The advantage of Bubble Type Data Points is that it can be sized and coloured by metrics, for example, Sales.
To do that, go to Editor tab and drag and drop a metric to the Size By/Color By section. Bubbles can also be clustered like Markers.

ka0PW000000295dYAA_0EM4W000004YaV5.jpeg

Adding metric to Size By/Color By section, will enable more options in the Data Point section, such as Threshold, Max size and Min size. The sizing allows to change maximum and minimum size of bubbles. Threshold option is meant to colour data depending on the metric’s value:

ka0PW000000295dYAA_0EM4W000004YaVF.jpeg

Area type


After selecting Area type, the visualization will automatically detect Boundaries. To change that, select Boundaries and choose a proper one. Area type also allows to add threshold based on the metric.

ka0PW000000295dYAA_0EM4W000004YaUI.jpeg

 

Density type


Locations can be displayed in a map visualization using a density type. Density maps allows to visualize patterns and trends for several geographic locations by using color gradients based on the concentration of geographic data.

ka0PW000000295dYAA_0EM4W000004YaVP.jpeg

Advanced Settings


Adding Layers
ESRI Map allows to present data for more than one Geo Attribute - to do this, it is necessary to add layers to the visualization. Go to Editor tab → Layers → Add Layer. After that, introduce second Geo Attribute to the visualization.

ka0PW000000295dYAA_0EM4W000004YaVZ.jpeg

 

Zoom Behavior


By default, the map will zoom out to show all available geographical data. This setting is called Dynamic zoom. In order to fix the view on a specific area, go to Format tab → Zoom Behavior → Static →  Remember zoom level.

ka0PW000000295dYAA_0EM4W000004YaX6.jpeg

 

ka0PW000000295dYAA_0EM4W000004YaXB.jpeg

 

Thresholds


As mentioned earlier, adding metric to the Color By section enables to threshold data on the metric’s value. There are 3 ways of configuring thresholds:

  1. Go to Format tab → Data Points → Threshold 
  2. Right click on the metric in Editor tab and select Edit Threshold.
  3. Go to Format tab → Text and Forms → Shape → Threshold


The threshold can be selected from list of built-in colors or configured manually. There is an option to break by attribute or to change on what the threshold is based on:

  • Value
  • Lowest
  • Highest
  • Lowest %
  • Highest %
ka0PW000000295dYAA_0EM4W000004YaWh.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

March 14, 2022

Last Updated:

May 10, 2024