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