This course will provide you with basic and fundamental skills in data modeling with SAP HANA Cloud.
Google, IBM & Microsoft Certificates — All in One Plan
Get 20% off all career paths from fullstack to AI
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Syllabus
- Preparing the Modeling Environment
- Getting Started with SAP Business Application Studio
- Working with Development Spaces
- Creating a New Project in SAP Business Application Studio
- Importing an Existing Project in SAP Business Application Studio
- Navigating SAP Business Application Studio
- Preparing the Modeling Environment
- Creating Calculation Views
- Understanding Basic Concepts and Terminology
- Creating Dimension Calculation Views
- Creating Cube Calculation Views
- Creating Time-Based Dimension Calculation Views
- Choosing a Data Source for a Calculation View
- Checking the Output of a Calculation View
- Working with Common Features of Calculation Views
- Top View Node
- Creating Calculation Views
- Working with Common Nodes in Calculation Views
- Using Projection Nodes
- Working with Aggregation Nodes
- Working with Common Nodes in Calculation Views
- Joining Data Sources in Calculation Views
- Using Join Nodes
- Filtering on Join Nodes
- Optimizing Joins
- Joining Data Sources in Calculation Views
- Working with Union Nodes in Calculation Views
- Working with the Union Node
- Implementing Union Pruning
- Working with Union Nodes in Calculation Views
- Creating Data Slices
- Implementing Minus and Intersect Nodes
- Creating Data Slices
- Ranking Data
- Implementing Rank Nodes
- Ranking Data
- Embedding Functions in Calculation Views
- Generating Restricted Columns
- Generating Calculated Columns
- Filtering Data
- Implementing Currency Conversion
- Embedding Functions in Calculation Views
- Creating Dynamic Calculation Views
- Implementing Variables
- Implementing Input Parameters
- Mapping Variables and Input Parameters
- Creating Dynamic Calculation Views
- Implementing Hierarchies in Calculation Views
- Modeling Hierarchies
- Implementing Hierarchies in Calculation Views
- Developing Custom Logic using SQL
- Introducing SAP HANA Cloud SQL Console
- Implementing SQL in Calculation Views
- Querying a Modeled Hierarchy Using SQL
- Working with SQLScript
- Creating and Using Functions
- Developing Custom Logic using SQL
- Applying Best Practices for Modeling
- Implement Recommended Modeling Practices
- Implement Best Practices in calculation view nodes
- Applying Best Practices for Modeling
- Using Tools to Check Model Performance
- Validating calculation views with Performance Analysis mode
- Debugging Calculation Views with the Debug Query Mode
- Analyzing executions with the SQL Analyzer
- Using Tools to Check Model Performance
- Implementing Features to Improve Performance
- Controlling Parallelization
- Partitioning Tables
- Implementing Features to Improve Performance
- Storing Calculation View Results
- Implementing Static Cache to Improve Performance
- Creating Snapshots
- Defining MDS Cubes
- Storing Calculation View Results
- Using Additional Modeling Productivity Tools
- Productivity Aids for Efficient Calculation View Development
- Working with Modeling Content in a Project
- Using Additional Modeling Productivity Tools
- Working in a Modeling Project
- Project Structure
- Deploying Models
- Manage modeling content
- Working in a Modeling Project
- Managing the Lifecycle of a Modeling Project
- Creating a Project
- Enabling Access to External Data
- Using Git to Manage Source Code
- Deploying an Application
- Managing the Lifecycle of a Modeling Project
- Implementing Security in SAP HANA Modeling
- Defining Analytic Privileges
- Defining Roles
- Masking Sensitive Data
- Implementing Security in SAP HANA Modeling
- Getting Started with SAP HANA Cloud Knowledge Graph Engine
- Overview of Knowledge Graphs
- SAP HANA Cloud Knowledge Graph Engine
- Use Cases and Demo
- Getting Started with SAP HANA Cloud Knowledge Graph Engine