DA180 - Explore SAP Datasphere and SAP Analytics Cloud End-to-End

Description

This repository contains the material for the SAP TechEd 2024 session called
👉 DA180 - Explore SAP Datasphere and SAP Analytics Cloud End-to-End.

Overview

This jump start session will give you the opportunity to build a scenario with exercises for SAP Datasphere and SAP Analytics Cloud.

Find out how SAP Datasphere helps line-of-business users get the job done. Discover flexible connection features, and learn how you can access data from different sources. Create an extendable business semantic model in an agile way, and connect analytics and visualization components in the context of a data warehouse.

Disclaimer

• Your screenshots may look different than those in the exercises, as new releases might include additional features or enhancements.
• Some user interface elements might differ from the screenshots used in the exercises.

Requirements

• Google Chrome Browser or Microsoft Edge based on the Chromium engine
• Access to this GitHub repository
• Access to any SAP Datasphere and SAP Analytics Cloud system. In case you do not have access you can use a basic trial. The optional exercise #23 is only working using a basic trial.
• You will also need a set of files for these exercises
  Download the ZIP-file from the GitHub site: ➡️ DA180_Resources.zip (button "download raw file")

⚠️ Once downloaded to your local machine, please unzip the file into a separate folder.
⚠️ You will need it for the exercises. So, please remember the file location of the unzipped files!

Exercises

Be aware that some of the exercises are dependent on each other and must be completed in the sequence provided below.

The Optional Exercises are relevant only if you want to dive deeper into the solution, particularly in learning how to:

• Create tables (#2)
• Build Entity-Relationship (ER) models (#3)
• Instead of importing artefacts via a CSN file (#4).

The exercises in section 4 are all optional. You can explore how to:

• Leverage Just Ask with SAP Analytics Cloud (#20)
• Enable row-level security using Data Access Controls (#21)
• Discover additional features of the Analytic Model (#22)
• Understand Transformation Flows and the use of delta tables (#23).

1. Getting Started

   • Exercise Overview
   • Overview about the Business Scenario & the Data Model
   • Get your basic trial system
   • First Log On

2. SAP Datasphere

   • Exercise 1: Get to know your own Space
   • Exercise 2: Prepare Your Data (optional)
   • Exercise 3: Creating the Entity Relationship Model (optional)
   • Exercise 4: Importing Tables
   • Exercise 5: Uploading Data
   • Exercise 6: Creating the Dimension
   • Exercise 7: Creating the Fact View and Analytic Model

3. SAP Analytics Cloud

   • Exercise 8: Top 10 Revenue Generating Products
   • Exercise 9: Revenue by Geography

4. Optional Exercises

   • Exercise 20: Identify Top Sales Managers with Just Ask
   • Exercise 21: Creating Row-Level Permissions based on External Hierarchy
   • Exercise 22: Explore the Analytic Model
   • Exercise 23: Create a Transformation Flow and the usage of delta tables

Have fun 😃

Contributing

Please read the CONTRIBUTING.md to understand the contribution guidelines.

Code of Conduct

Please read the SAP Open Source Code of Conduct.

How to obtain support

Support for the content in this repository is available during the actual time of the online session for which this content has been designed. Otherwise, you may request support via the Issues tab.

License

Copyright (c) 2024 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.