arrow_back

Explore SAP Data Foundation using Looker Dashboards

Sign in Join
Get access to 700+ labs and courses

Explore SAP Data Foundation using Looker Dashboards

Lab 1 hour 30 minutes universal_currency_alt 1 Credit show_chart Introductory
info This lab may incorporate AI tools to support your learning.
Get access to 700+ labs and courses

GSP1046

Google Cloud self-paced labs logo

Overview

In this lab, you will visualize the Google Cloud Cortex Data Foundation for SAP by viewing reports pre-installed into a Looker instance available with this lab.

If you are unfamiliar with the Google Cloud Cortex Data Foundation for SAP you can find out more information about it at the link provided.

This scenario intends to convey how a business analyst would consume reports to have a better idea of how to run the business and make informed decisions with SAP ERP data, all within Looker’s snappy, intuitive interface.

The Google Cloud Cortex Data Foundation for SAP provides Looker Blocks to monitor sales performance and order fulfillment, hone in on customers, orders and products to dig into anomalies or answer new questions. You can find the git repository to install the SAP Cortex Looker Block in your own Looker environment at the link provided.

A connection to the BigQuery instance has been pre-created to support this lab environment.

Task 1 - Enable Developer Mode

In this section, you will review the properties of the Looker Block which require configuration in order to pull data from BigQuery. If you are unfamiliar with Looker Blocks you can read more about them at the documentation site here.

  1. Select the Open Looker button on the student console of the lab and enter the credentials provided to login to the Looker instance available.

  2. Once logged in, enable Development Mode by selecting the toggle button in the bottom left corner of the landing page.

dev_mode

Task 2 - Explore Project in Looker

  1. In the left navigation menu select Develop > cortex_data_foundation.

  2. In the resulting page you will see an editor view of the Looker Block pre-installed into the Looker instance. This will look very similar to the SAP Cortex Looker Block available on GitHub with minor configuration changes.

  3. Notice that a README.md provides instructions on what configurations can be made on this block and how to make them. Open the file manifest.lkml.

  4. Observe the constants CONNECTION_NAME and DATASET defined in the file. These configurations instruct the Looker instance what connection to utilize to pull data warehousing data from (in this case a BigQuery instance) and what dataset that the block should use in the data warehouse instance connection once established.

Task 3 - View Sample Report Data

Navigate back to the Home page of the Looker instance:

  1. From the Navigation Menu > Folders

close_develop

  1. Select LookML Dashboards from the Folders landing page.
If the LookML Dashboards folder is not present, refresh the page

  1. In the resulting page, select the Sales Analytics report.

  2. Update the Document Date to is in the year 2022 by clicking in the filter box to select the option and fill in the year, and then click Update.

Note that this report may take a few minutes to populate. DO NOT refresh the page multiple times while the report is loading!

The resulting report contains Sales Analytics data which an analyst can use to compare year over year product sales and order fulfillment.

sales_analytics

  1. In the Customers By Location chart, select the United States of America map to drill into the chart data. This will surface a Query result in a popup window.

customer_by_location

  1. Find the customer TESTING and click on the three dots (...) next to the name in the Customer Name column.

customer_name

  1. From the available dashboards in the input selection, select Customer Snapshot. This will open a drill down into customer specific data related to the customer name TESTING.

customer_snapshot

As a business analyst, you can leverage the out of the box reports provided by the SAP Cortex Looker Block to understand more about the state of the business and specific customers and products. Learn more about how to deploy the underlying data at the Cortex Data Foundation GitHub Repository.

Note: If the progress check below is not successful, please wait a few minutes for Looker to populate the query data, and try again.

Click Check my progress to verify the objective. View sample report data

Congratulations!

In this lab, you learned how to leverage the Data Foundation for Google Cloud Cortex Framework to gain business insight into how your business is operating.

Next Steps / Learn More

Check out the following for more information on Google Cloud Cortex Framework:

Google Cloud training and certification

...helps you make the most of Google Cloud technologies. Our classes include technical skills and best practices to help you get up to speed quickly and continue your learning journey. We offer fundamental to advanced level training, with on-demand, live, and virtual options to suit your busy schedule. Certifications help you validate and prove your skill and expertise in Google Cloud technologies.

Manual Last Updated July 28, 2025

Lab Last Tested July 26, 2025

Copyright 2025 Google LLC. All rights reserved. Google and the Google logo are trademarks of Google LLC. All other company and product names may be trademarks of the respective companies with which they are associated.

Before you begin

  1. Labs create a Google Cloud project and resources for a fixed time
  2. Labs have a time limit and no pause feature. If you end the lab, you'll have to restart from the beginning.
  3. On the top left of your screen, click Start lab to begin

Use private browsing

  1. Copy the provided Username and Password for the lab
  2. Click Open console in private mode

Sign in to the Console

  1. Sign in using your lab credentials. Using other credentials might cause errors or incur charges.
  2. Accept the terms, and skip the recovery resource page
  3. Don't click End lab unless you've finished the lab or want to restart it, as it will clear your work and remove the project

This content is not currently available

We will notify you via email when it becomes available

Great!

We will contact you via email if it becomes available

One lab at a time

Confirm to end all existing labs and start this one

Use private browsing to run the lab

Use an Incognito or private browser window to run this lab. This prevents any conflicts between your personal account and the Student account, which may cause extra charges incurred to your personal account.