SAP HANA Modeling Training

13 +

SAP HANA Modeling Training

Learn how to design and build models of native data on the platform SAP HANA for analytics, high-performance. Dominates the creation of Views of Calculation, best practices, performance optimization and the use of SQL Script for advanced logic.

Ideal for Consultants, BI/Data, Developers HANA Native and Architects of Data that seek to transform raw data into business information consumable.

Content

Basics of Modeling: the Concept of SAP HANA architecture and In-Memory. To use SAP HANA Studio and modeling tools. Tables of column and row.

Modeling Native: Creation and management of Views, Attribute Views, Analytical, and, mainly, Views of Calculation (Calculation Views). Types of nodes in the Views of Calculation (Join, Projection, Aggregation, Union). Use of variables and parameters.

Logic and Performance: Implementation of complex logic with SQL Script (Procedures and Table Functions). Optimization models to maximize the performance of the platform HANA. View of calculation as a source of data to BI tools.

Provisioning Data (Context): Description of the provisioning tools such as SAP LT Replication and SAP Data Services in connection with the modeling.

Objectives

Form developers and consultants able to: Design and build data models optimized for SAP HANA. Transform raw data into analytical models using Views of Calculation. Apply advanced techniques of business logic using SQL Script. Integrate the models HANA with Reporting tools and BI.

Target Audience

Aimed at Consultants, SAP BI/BW, Developers HANA Native, Data Analysts and Solution Architects with a focus on the persistence layer and data consumption.

Promotional price

Value to be defined

Payment method

Cash
Credit card
Bank transfer
Market Payment
Bitcoin
Check

Inquire about payment plans

Skills to be acquired

Modeling Calculation (Native)
97%
Performance optimization HANA
97%
Mastering SQL Script
95%
Design Semantic Views
83%
Integration with Platforms BI
74%

Leaders in Training and SAP Consultancy