SAP HANA 2.0 Modelling Masterclass |Hands On Training

Focused View

Learn Anywhere,Learn Anywhere,Learn Anywhere

8:36:21

95 View

1. Introduction

1. Course Introduction.mp4

02:30

2. SAP HANA Overview.mp4

05:48

3. XSA Overview.mp4

06:38

4. Install HANA Express Edition.mp4

10:30

5. Login detail.mp4

04:01

6. Web IDE Walkthrough and mounting of DB.mp4

04:08

7. Why data Model is needed.mp4

01:13

8. First CDS Object.mp4

10:08

9.1 Training.zip

9. Code for the Project.html

10. Create Table I.mp4

07:52

11.1 Product.zip

11. Files used in Next section.html

12. Create Table and Load data.mp4

07:42

2. Views

1. Views in HANA.mp4

03:05

2. Create first calc view.mp4

19:07

3. Theory on Input Parameter and Variable.mp4

00:59

4. Use of Input Parameter in calc view.mp4

10:35

5. Use of Variables.mp4

06:36

6. Fuzzy Search.mp4

08:46

3. More options in view

1. What is Hierarchy.mp4

01:15

2. Level Hierarchy.mp4

04:32

4. Joins

1. Various Joins.mp4

04:52

2.1 ProductCategoryTexts.zip

2. Files for Next lecture.html

3. Joins & Cardinality.mp4

18:09

5. More Views

1.1 salesorderitem.zip

1. Files used in next lecture.html

2. Calculation View Cube.mp4

12:57

3. Exercise Business Partner.mp4

00:31

4.1 Businesspartner.zip

4. Files for exercise.html

5. Solution Business Partner.mp4

02:47

6.1 salesorders.zip

6. File for next section.html

7. Star Join.mp4

13:01

8. Calculated Column, Restricted Column & Counter.mp4

08:40

9.1 ConversionTables.zip

9. Currency Files for next lesson.html

10. Currency Conversion.mp4

10:16

6. More Options in Join

1.1 jointables.zip

1. File for Join tables.html

2. Joins in System.mp4

15:06

3. Referential Join.mp4

09:20

4. Non Equi Join.mp4

06:15

5. Minus Node.mp4

07:30

6. Intersect Node.mp4

03:32

7. Union

1. Union.mp4

10:52

2. Union Behaviour.mp4

05:36

3. Multijoin.mp4

06:53

8. Scalar, Table Function & Procedure

1. Theory.mp4

03:30

2. Scalar Function.mp4

04:37

3. Code used in next lesson.html

4. Table Function.mp4

07:35

5. Code for next lesson.html

6. Procedure.mp4

05:11

9. Rank

1. Rank Part I.mp4

12:05

2. Rank Part II.mp4

06:06

10. Optimization and Best practices for Modelling

1. Best Practices.mp4

03:44

2. Optimization Performance Analysis.mp4

04:53

3. Optimization Explain & Analyze Plan.mp4

07:44

4. Optimization Debugging.mp4

03:14

11. Managament

1. Impact & Linage Analysis.mp4

02:21

2. Copy,Paste, Refactoring and more.mp4

07:28

3. Namespace.mp4

06:28

12. Security & Authorization

1. Security theory.mp4

03:26

2. Analytic Privilages.mp4

14:10

3. Masking.mp4

03:53

4.1 Employee.zip

4. Files for next lesson.html

5. K-Anonymity.mp4

08:05

6. Diff Privacy.mp4

05:01

13. Connection to HDI

1.1 grants.zip

1. Code used in next session.html

2. Synonymous for HDI Container.mp4

13:12

3. Code for next lesson.html

4. Synonymous for Classic Schema.mp4

09:49

14. Advance Analytics

1. Code in next lesson.html

2. Graph Analytics I.mp4

10:32

3. Graph Analytics II.mp4

06:03

4. Graph Analytics III.mp4

07:08

5. Code in next lesson.html

6. Graph Analytics IV.mp4

07:26

7. Code in next lesson.html

8. Spatial Data.mp4

07:18

15. Hierarchy Advance

1. Code in next lesson.html

2. Hierarchy Parent-Child.mp4

06:00

3. Hierarchy Function I.mp4

05:57

4. Hierarchy Function II.mp4

03:02

16. SDI

1. SDI Overview.mp4

02:14

2. SDI Agent Install.mp4

03:14

3. SDI Agent Config.mp4

09:35

4. SDI Remote Connection.mp4

07:44

5. SDI Virtual Table.mp4

10:12

17. FlowGraph

1. Flowgraph.mp4

06:35

18. GitHub Connection

1. GitHub Overview.mp4

02:22

2. GitHub Local.mp4

06:46

3. GitHub Remote.mp4

08:15

19. More Performance improvement option

1. Multiple filter ignore.mp4

06:03

2.1 prun.zip

2. Files for next section.html

3. Union Pruning Implicit.mp4

05:07

4. Parallelization.mp4

08:14

5. Adhoc.mp4

02:20

Description

What You'll Learn?

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

Who is this for?

Anyone curious about SAP HANA Modelling

SAP Developers

Tech Architect

Solution Architect

More details

Description
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.

Who this course is for:
Anyone curious about SAP HANA Modelling
SAP Developers
Tech Architect
Solution Architect

User Reviews

Rating

average 0

Total votes0

Focused display

SAP HANA

Learn Anywhere

Instructor's Courses

You can connect to us on LinkedIn and YouTube. Our aim is to create affordable and precise educational content for everyone who wants to learn and use the skills in their professional journey. We are group of individuals with more than 20 years of experience in various field like Technology, Commerce and Art.We aim to create 'to the point' content so you don't have to put long hours in boring videos.

Learn Anywhere

Instructor's Courses

Our aim is to create affordable and precise educational content for everyone who wants to learn and use the skills in their professional journey. We are group of individuals with more than 20 years of experience in various field like Technology, Commerce and Art.We aim to create 'to the point' content so you don't have to put long hours in boring videos.

Learn Anywhere

Instructor's Courses

Our aim is to create affordable and precise educational content for everyone who wants to learn and use the skills in their professional journey. We are group of individuals with more than 25 years of experience in various field like Technology, Commerce and Art.We aim to create 'to the point' content so you don't have to put long hours in boring videos.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.