SAP HANA 2.0 Modelling Masterclass |Hands On Training

XSA | Calc View | Join |Union | Hierarchy | SDI| Functions | Rank | Optimization | Security | Auth|Graph|Spatial| GitHub

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.