05

Onboarding Guide Data Modeling

What is Data Modeling?

Data modeling is the process of defining your data's structure and relationships. It's an important step in preparing data for analysis. Learn about data modeling and how it sets you up for success in SAP Data Warehouse Cloud.

Read more

How to Start Modeling Your Data Using a Graphical View

The Data Builder is where you model your data using a set of integrated and simple graphical modeling tools.

Read more

What is the Business Catalog?

Using the Business Catalog you can navigate through all of the data models that are available for you to use. You'll also see a quick summary of what's included in each model.

Read more

What is the Business Layer?

Business semantics is a consistent natural language vocabulary that makes it easy to understand your data. The Business Layer of SAP Data Warehouse Cloud applies your business semantics to all types of data, helping you to gain value faster.

Read more

How to Create Attributes in the Business Layer

Are you ready to start using the Business Layer functionality? Learn how to add attributes to your business properties.

Read more

How to Combine Data from Different Source Systems

Wondering how to model data using many different data sources? Learn how to combine data from different source systems in your SAP Data Warehouse Cloud using the Graphical Modeler.

Read more

What is Entity-Relationship Modeling?

Entity Relationship Modeling aims to establish a visual representation of system data. Learn more about Entity Relationship Modeling in SAP Data Warehouse Cloud.

Read more

How to Create an Entity-Relationship Model

In SAP Data Warehouse Cloud, you can establish a seamless connection to third-party ETL and other tools that speak SQL and use an SSL connection.

Read more

How to Create an SQL View

If you are already familiar with SQL, check out this video on how to use SQL in SAP Data Warehouse Cloud to model your data.

Read more

When to use SQL modeling vs. Graphical modeling

SQL-based modeling is available in SAP Data Warehouse Cloud as an alternative to the graphical drag-and-drop view modeler.

Read more

How to Exclude and Restore Columns

When building a graphical view in the Data Builder, you can exclude and restore columns. It allows you to select specific data that is relevant to your view.

Learn more

The Functionalities of Calculated Columns in the Data Builder

Data management capabilities in the Data Builder are key to derive the desired output in the data analysis.

Read here

Parent-Child Hierarchies

When you model data that is inherently hierarchical, it can be extremely helpful to define dependencies and relationships within data sets.

Read here

Creating a Parent-Child Hierarchy

In certain data models it makes perfect sense to create a Parent-Child Hierarchy.
For example, when you want your data model to emulate organizational structures within a company, or when you want to highlight hierarchical dependencies between products.

Read here

In Focus: Extracting Information with <​LIKE> to match leaders for sales excellence in SAP Data Warehouse Cloud

How about engaging in a more empathic way by approaching your current leads with a connection on management level?

Learn more