Introduction
Introduction
Contents
- Introduction
- Modeling a Star Schema
- Prerequisites
Introduction
In this workshop, we will use sales data from different sources to introduce basic Modeling tasks in SAP Datasphere, add sentiment data for greater product insight, and gradually build a data model to support a SAP Analytics Cloud Story.
Key ideas to be covered here:
-
Association of Master Data Dimensions
-
Aggregation
-
Calculated Columns (Geo Coordinates)
-
Details of data outputs from modeling activities
-
Data transformation via Data Flow (adding operators, Python Script)
-
Filtering
-
Gathering disparate data from multiple sources (Google Cloud Storage, HANA Open SQL Schema, SAP HANA Cloud, SQL Server)
-
Graphic Modeling in Data Builder (Graphical Views, Entity Relationship models)
-
Hierarchies
-
Integrating multiple models (Dimensions, Relational Dataset, Analytical Dataset, E/R Model)
-
Join and Union details in context of modeling
-
Properties of modeling objects
As a result of these activities, you will have a base model to use as a foundation for Analytics during visualization.
Modeling a Star Schema
First we’ll model dimensional (“master data”) data and then turn to the fact-based, transactional data.
Prerequisites
-
Log On information and credentials should have been assigned to you. If not, please contact the workshop coordinator.
-
Each user will have access to their own space with predefined local connections and generated Data for use in the workshop.