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 a data source that contains 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 things to keep in mind when geo-enriching your data:

  1. 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 with a file.
  2. 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

Work With Geo Data

Business Example: You have salary by location data that you need to present. You have a second file with the coordinates by location. You decide to use a geo map to present your data but before you can create the story, you must create a model with geo-enriched 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.
  • Create a simple geo map in a story, using the geo-enriched data.

Working with geographic data in stories is covered in the Configuring and Interacting with Geo Maps lesson of the Designing Stories in SAP Analytics Cloud course.