SAP HANA 2.0 Modelling Masterclass |Hands On Training

Descripción

If you want to understand the latest features of SAP HANA modeling then this course is for you. This course is completely hands-on. We will start from scratch and cover the below topics as hands-on lectures: Introductions - HANA Overview - XSA Overview - Installation of HANA express - Why modeling is needed - Create your first table and load data Views - Create your first calculation view - Use Input parameter, variable and fuzzy search - Learn all types of calculation joins ( Dim, Cube, Star) Hierarchy -Learn and create the hierarchy - Level and PC hierrachy - Hierarchy Function Joins - learn all kinds of joins and Unions - Inner, outer, minus, intersect, referential, non-equi Function - Scalar function - Table Function - Procedure Rank - Learn how to Rank - All new features of Rank Optimization & Best Practices - Learn Optimization options - Learn Best practices - Union pruning: Explicit and Implicit - Parallelization - Handling of multiple filter Management - Impact & Linage Analaysis - Copy, paste, delete and refactor - Use of Namepace Security & Authoriation - Analytical Privileges - Masking - K-Anonymity - Differential Privacy Synonymous - Learn how to use Synonymous Advance Analytics - Learn how Graph Analytics works - Learn Spatial data handling Smart Data Integration (SDI) - Learn what is SDI - Install and Config your own DP agent - Activate adapter and load file - Create virtual table and use Flowgraph Github - How GitHub works - Github @ local and @remote And more details on various topics.

Lo que aprenderás

• All HANA Modelling features
• All types of Calculation Views
• All types of Join and Union
• Analytical Privilege, Synonymous, Hierarchies
• Rank, Optimization, Best Practices, Github
• Advance Analytics with Graph and Spatial Data

Requisitos

• Basic understanding of any database is enough
• If you want to install HANA edition, then you need PC with 12-16GB of RAM and 128GB of HDD