Skip to Content
Product Information
Author's profile photo Gladys Kwok

Learn How to Use Geo Maps in SAP Analytics Cloud in 25 Minutes

Overview

The purpose of this exercise is for you to get an overview of the Geo Map feature through an end-to-end use case. Using the Geo Map widget, you can overlay multiple layers of business data on a Geo Map with detailed information to perform analyzes on your geographic data. This exercise will guide you through the preparation of real geographic data and the creation of different types of Geo Maps in a story. In this workflow, we will be using earthquake data from California, however, the goal is to provide you with the ability to apply your learnings to various geographic datasets to find answers to your questions. After this exercise, you should now be able to:

  • Import CSV files
  • Prepare a dataset and Geo Enrich your data
  • Create a Choropleth Geo Map
  • Create a Bubble Layer Geo Map
  • Add Input Controls

Instructions

This is a guided workflow with detailed instructions provided at each step. Screenshots will be presented throughout the exercise to ensure you are on track. Note that the tasks build on each other, so it’s important to verify that you have completed the steps correctly before you move on to the next section. Be sure to save your work often, especially if you are interrupted in the middle of a workflow. Good luck and have fun!

Note: Some steps may differ slightly depending on the screen resolution and zoom settings of your device.

Dataset and Exercise

Please click the link below to access the data from Github. Click “View raw”, then right click, and save as CSV. Before beginning the exercise, confirm the file is named CaliforniaEQ.csv.

CaliforniaEQ_link

Data Source: This data file is a compilation of years 2017 to 2021 found on Southern California Earthquake Data Center’s website.

SCEDC (2013): Southern California Earthquake Center.

Caltech.Dataset. doi:10.7909/C3WD3xH1

The SCEDC and SCSN are funded through U.S. Geological Survey Grant G20AP00037, and the Southern California Earthquake Center, which is funded by NSF Cooperative Agreement EAR-0529922 and USGS Cooperative Agreement 07HQAG0008.

Scenario

California is prone to earthquakes. You work for an earthquake relief organization in California as a Business Analyst. The organization wants to determine which regions experience the highest frequency and magnitude of earthquakes in order to allocate resources appropriately. You are asked to visualize California’s earthquake data from 2017 to 2021 to show the frequency and magnitude of earthquakes in Californian regions. Earthquakes with a magnitude greater than 6 should be emphasized, and magnitudes below 4 are insignificant. Your dashboard will allow the organization to make data-driven decisions relating to operational activities.

Exercise

Data Preparation

Step 1.1 – Import Data

You have successfully imported data into SAC! Your screen should look like this when you are done.

SS_1.1.png

Step 1.2 – Format and Edit Data

You have successfully prepared, and geo enriched your data! Your data is ready for building. Your screen should look like this when you are done.

Note: SAP Analytics Cloud only supports decimal degree formatting for longitude and latitude (i.e. 33.635, -116.665). These values are used to plot specific geographic locations in Geo Maps.

SS_1.2.png

Story Creation

Step 2.1 – Create New Story

You have successfully created a new story! Your screen should look like this when you are done.

SS_2.1.png

Step 2.2 – Build Dashboard: Choropleth Geo Map

You have successfully added a Choropleth Geo Map that displays Californian regions by magnitude, emphasizing earthquakes with a magnitude greater than 7! Your screen should look like this when you are done.

SS_2.2.png

Step 2.3 – Build Dashboard: Bubble Layer Geo Map

You have successfully created a Bubble Layer Geo Map that displays the frequency of earthquakes by location! Your screen should look like this when you are done.

SS_2.3.png

Step 2.4 – Filter Options

You have successfully created a date and magnitude filter for your Geo Maps! Your screen should look like this when you are done.

SS_2.4.png

Summary

Congratulations, you have completed a common Geo Map use-case in SAP Analytics Cloud! You have created a dashboard using Geo Maps to visualize California’s earthquake data. The Choropleth and Bubble Layer Geo Maps display the magnitude of earthquakes by city, which cities experienced high magnitude earthquakes between 2017 and 2021, and the frequency of earthquakes by location. Your organization will now be able to make data-driven decisions relating to operational activities.

Additional Learning Materials

 

Author: Gladys Kwok

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Pavan Golesar
      Pavan Golesar

      Very insightful thanks for this, And yes nice step-by-step illustration that I am sure would have required much efforts so thanks again Gladys Kwok! 🙂

      Best Regards,,

      Pavan Golesar

      Author's profile photo Gladys Kwok
      Gladys Kwok
      Blog Post Author

      Thank you so much for the feedback Pavan Golesar!

       

      Author's profile photo Sachin DJ
      Sachin DJ

      Thanks for the detailed info Gladys Kwok . Can we use Geo map for the data from Live connection where we are getting only Longitude and Latitude? appreciate if you can share some links for reference.

      Regards,

      Sachin

      Author's profile photo Chris (P) Jones
      Chris (P) Jones

      Appreciate your effort Gladys, really easy to follow and very clear. Well done!

       

      Regards,

       

      Chris

      Author's profile photo Young Seol Sohn
      Young Seol Sohn

      Great blog!

      Thanks for your efforts!!

      I hope that content like this will continue to be uploaded as a series~

       

      Best,

      Youngseol

      Author's profile photo Jake Philipps
      Jake Philipps

      I love this idea! Unfortunately, when I try to download the file for this exercise, it only opens the raw data in a new tab. Is there something I need to do to access the csv file for this exercise?

       

       

      Author's profile photo Deep Sharma
      Deep Sharma

      Great blog Gladys Kwok !

      Could you please confirm if the above steps works in Embedded Analytics or not?

      Regards

      Deep