Setting Up and Using Geo Maps

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Add geo maps in stories

Geo Maps

In SAP Analytics Cloud, geo maps offer the visualization of data on a world map. Geo maps can add a lot of value and context to your data analysis. You can choose from a variety of geographical mapping options to display your regional data, trends, flow, and so much more.

The figure Geo Map Navigation shows the geo map navigation options.

To use the map, enhance a data model with geo dimensions.

The following geo models are supported:

  • Local models using a manual upload.
  • Models by live data connection using SAP HANA as a datasource.

Geo Enrich Your Data

Before you perform geospatial analysis in stories, you must first import coordinate data and enrich it in the modeler. This process creates a new column in the data view with an enriched format of latitude and longitude coordinates. As a prerequisite, you must have a Microsoft Excel file .xslx or a .csv file with a location ID column that contains unique data, as well as latitude and longitude columns.

Geo maps are created in the modeler using location data. This acts as the foundation for the map in your story. There are two ways to geo enrich your data:

The figure Geo Enrich Data by Coordinates shows how you can enrich your data by coordinates.

Map Layers

You can use map layers and various layer types to create geo maps in your stories.

  • Bubble Layer

    Shows data as points on the map where you can control the color, opacity, and size of the bubbles.

  • Heat Map Layer

    Uses color to visualize the data density of the selected measure.

  • Choropleth Layer

    Applies blocks of shading to different geographical locations.

  • Points of Interest Layer

    Points of interest are sets of geographical data that can be added to a geo map and analyzed with reference to business data from a model.

  • Feature Layer

    Uses external data from valid service URLs. This data is layered on top of your existing geo map to provide additional context.

  • Flow Layer

    Shows the connection between two locations, such as shipping routes or flight paths.

Points of Interest

Points of interest are sets of geographical data that you can add to a geo map and analyze with reference to business data from a model.

You can add point of interest data from an Esri shapefile, a CSV or Excel file, or from an SAP HANA model with a geographical dimension.

Note
If you have a CSV or Excel file with clearly distinguishable names for latitude and longitude columns, you can simply drag and drop the file directly into your geo map.

SAP Analytics Cloud supports a finite number of spatial reference IDs. To avoid incorrectly displayed data or error messages, you should know the SRID used in your shapefile. Publicly available tools can help you recognize the shape identifier and thus determine the shapefile format.

You can view and maintain point of interest data in the Files list. You can filter on the Points of Interest file type to view the files. You can add or search points of interest, or select points of interest to delete.

You can set access permissions for point of interest data using the (Share) icon in the toolbar.

Create Stories using Geo Maps

You need to know how to create geographical visualizations with location data.

Task Flow

In this exercise, you will perform the following tasks:

  • Copy an existing story
  • Use the polygon filter
  • Use the zoom to data feature
  • Adjust the scaling factors
  • Use the drill down feature
  • Use basemap formatting templates
  • Use mapping layer types

Create and Use Geo Data

You have some salary by location data that you need to view on a Geo map. You have another file with the coordinates by location that needs to be combined with the salary data.

In this exercise you will perform the following tasks:

  • Import the salary by location data into a model
  • During the import, combine the salary data with the coordinates by location file
  • Geo enrich the data
  • Create a Geo map in a story that uses the Geo enriched data

Save progress to your learning plan by logging in or creating an account