Configuring geographic data in a model

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

After completing this lesson, you will be able to:

  • Configure data for a geo map

Geo enrich your data

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 Geo Enrich Data by Coordinates dialog below 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 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.

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.

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 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.

Reference:

From the ESRI website you can access ESRI location data, such as Points of Interest: https://www.esri.com/en-us/arcgis/products/data/data-portfolio/places

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

Task 1: Import location data into a model and create a geo map in a story

Business example

You have some salary by location data that you need to present. 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 flow

In this practice 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

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

Login or Register