Overview

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 dataViews - 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 FunctionJoins- learn all kinds of joins and Unions- Inner, outer, minus, intersect, referential, non-equiFunction- Scalar function- Table Function- ProcedureRank- Learn how to Rank- All new features of RankOptimization & Best Practices- Learn Optimization options - Learn Best practices- Union pruning: Explicit and Implicit- Parallelization- Handling of multiple filterManagement- Impact & Linage Analaysis- Copy, paste, delete and refactor- Use of NamepaceSecurity & Authoriation- Analytical Privileges- Masking- K-Anonymity- Differential PrivacySynonymous- Learn how to use SynonymousAdvance Analytics- Learn how Graph Analytics works- Learn Spatial data handlingSmart Data Integration (SDI)- Learn what is SDI- Install and Config your own DP agent- Activate adapter and load file- Create virtual table and use FlowgraphGithub- How GitHub works- Github @ local and @remoteAnd more details on various topics.

Skills

Reviews