Detail kurzu
HA300 - SAP HANA SPS05 Modeling |Virtual course|In English|
EDU Trainings s.r.o.
Popis kurzu
This course teaches the core capabilities of SAP HANA for calculation view modeling, and covers mainly graphical modeling, as well as SQL-based modeling (table functions and procedures) with a focus on performance. It also introduces Core Data Services as a flexible method to model a persistence layer.
The participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.
We also provide a quick overview of advanced data processing in the areas of text, spatial, predictive and graph modeling.
Obsah kurzu
- Information Views
- Introducing Information Views
- Understanding the Different Types of Views
- Working with Common View Design Features
- Using Nodes in Calculation Views
- Using Projection Nodes
- Using Join Nodes
- Working with Data Sets
- Aggregating Data
- Creating Cubes with Star Join Calculation Views
- Extracting Top Values with Rank Nodes
- Modeling Functions
- Create Restricted and Calculated Columns
- Filter Data
- Use Variables and Input Parameters
- Create Hierarchies
- Implement Currency Conversion
- Using SQL in Models
- Introducing SAP HANA SQL
- Working with SQLScript
- Query a Modeled Hierarchy Using SQLScript
- Creating and Using Functions
- Creating and Using Procedures
- CDS in SAP HANA Modeling
- Defining the Persistence Layer Using CDS
- Creating Views with CDS
- Optimization of Models
- Using Tools to Check Model Performance
- Implementing Good Modeling Practices
- Management and administration of Models
- Working with Modeling Content in a Project
- Creating and Manage Projects
- Enabling Access to External Data
- Working with GIT Within the SAP Web IDE
- Migrating Modeling Content
- Security in SAP HANA Modeling
- Understanding Roles and Privileges
- Defining Analytic Privileges
- Defining Roles
- Masking Sensitive Data
- Anonymizing Data
- Introduction to Advanced Modeling
Cieľová skupina
- Application consultant
- Data Consultant / Manager
- Database Administrator
- Application Developer
- BI specialist
Hodnotenie
Organizátor

Podobné kurzy
podľa názvu a lokality