GSP1046

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.

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

2. Select LookML Dashboards from the Folders landing page.

3. In the resulting page, select the Sales Analytics report available. Make sure the Document Date is set to is in the last 3 years.

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

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

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

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

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.

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 Cortex Framework
• Cortex Data Foundation GitHub Repository

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: Jan 24, 2024

Lab Last Tested: Jan 24, 2024

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