Configuring Geographic Data in a Model

Objective

After completing this lesson, you will be able to configure data for a geo map.

Geo Enrich Your Data

Before you perform geospatial analysis in stories, you must first add coordinate data and enrich it in the modeler. This process creates a new column in the data view with an enriched format of concatenated latitude and longitude coordinates.

Note

Geo enriching is available for both live and replicated data scenarios; however, in this course we’re focusing on the replicated use case.

As a prerequisite, you must have an XLSX or CSV file with a location ID column that contains unique data, and latitude and longitude columns.

A Location dimension is 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:

  1. 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 can also enter it manually in a file.
  2. By area name: During the creation of the Location dimension you can download all the currently supported countries, regions, and sub-regions. 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 following Geo by Coordinates dialog shows how you can enrich your data by coordinates.

Geo coordinates dialog with location and latitude and longitude field assignments

Points of Interest

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

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

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.

Points of Interest will disappear soon. To prevent disruption, please use geo enriched dimensions instead.

Options to create a point of interest

SAP Analytics Cloud supports a finite number of spatial reference IDs. To avoid incorrectly displayed data or error messages, you should know the spatial reference identifier (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 where 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.

Additional Information

From the Esri website you can access Esri location data, such as Points of Interest.

Work with Geo Data

Business Example: You have some salary by location data that you need to present and you decide to use a geo map.

You have another file with the coordinates by location that needs to be combined with the salary data.

Task 1: Create a Model with Geographic Data

Task Flow: In this practice exercise, you will:

  • Import the salary by location data into a model
  • Combine the salary data with the coordinates by location
  • Geo enrich the data

Task 2: Create a Geo Map in a New Story

Task Flow: In this practice exercise, you will:

  • Create a story with a canvas page
  • Add and configure the geo map in the story

Log in to track your progress & complete quizzes