This hands-on workshop will give you the opportunity to build a model in SAP Data Warehouse Cloud and SAP Analytics Cloud. Find out how the SAP Data Warehouse Cloud solution helps the line-of-business user to get the job done. Discover flexible connection features. Learn how you can access data from different sources. Create an extendable business semantic model in an agile way. Connect analytics and visualization components in the context of a data warehouse.
MyCompany provides fleet management services for large enterprise customers. They are organizing the procurement of cars from multiple manufacturers for their customers. They would like to understand where there is potential for additional car sales with their existing customer base. Their goal is to achieve a 20% market share.
Question to answer: Which brand has a market share lower than 20%?
- Learning Goal: Learn how to join messy data and create a multifact model.
- Time: 2-4 h
- Provided data tables: TechEd_2022_DA262.zip
- Finished Product: Dashboard showing number of cars by manufacturer by county/state.
- Google Chrome
- Access to this GitHub repository
- Access to a Guided Experience system of SAP Data Warehouse Cloud tenant (if you don't have one yet, please follow the instructions of exercise 0)
- This ressource archive will be required in exercise 1
- Overview on Exercises and Object Model (also as DA262.pdf for classroom training)
- Exercise 0 - Preparations
- Exercise 1 - Load data from SAP HANA Cloud
- Exercise 2 - Map external car registration data to internal product master data
- Exercise 3 - Preparing Analytic Data Consumption via the Business Layer
- Exercise 3.1 - Create a Dimension for Product
- Exercise 3.2 - Create Analytical DataSet for My Company Sales
- Exercise 3.3 - Create Analytical Dataset for Car Registration Data
- Exercise 3.4 - Create Multifact Consumption Model that brings together the numbers for car registrations and internal sales
- Exercise 3.5 - Add key figures
- Exercise 4 - Create an SAC Story (optional)
- TechEd 2022 DA160 - Explore SAP Data Warehouse Cloud from A to Z
- All TechEd 2021 materials on SAP Data Warehouse Cloud
Some user interface elements may differ from the screenshot used in the exercise. Be aware that some of the exercises are based on each other, therefore flagged as mandatory. Other parts can work based on prebuilt parts to save you some time, marked as optional. This gives you the flexibility to decide which exercises you would like to focus on.
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.
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.