Introducing SAP Analytics Cloud

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:

  • Set up and use Geo maps

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:

  • By Coordinates: Geo enriching your data by coordinates enables you to use longitude and latitude coordinates. Your data may already include this information, but you could also enter it manually. These coordinates are used to create a map anywhere in the world.
  • By Area Name: During the creation of Geo dimension you can download all the currently supported countries, regions, and subregions. This option does not support an area enrichment with mixed granularity. For example, if enriching an area that has locations in both Country A and Country B, but Country A does not go down do the Sub-Region level, then the enrichment can only be created to the Region level at the lowest.

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.

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 will create stories using 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

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