SAP HANA Implementation, Modeling and Reporting Course
4.1 (2,281 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,062 students enrolled

SAP HANA Implementation, Modeling and Reporting Course

Learn how to build a Real Time Platform using SAP HANA the best selling product in the history of SAP.
4.1 (2,281 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,062 students enrolled
Created by Junaid Ahmed
Last updated 4/2020
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 8 articles
  • 16 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • At the end of the course you will have a strong understanding and practical knowledge about SAP HANA and you will be able to develop an end to end scenario on SAP HANA.
Requirements
  • Recommended Knowledge Areas: SAP ERP, Reporting, Modeling and Data Bases. This is not Required you can start from scratch
  • Get Server Access
Description

SAP HANA is a game changing and best selling product in the history of SAP. Helping companies solve data,reporting,latency challenges and unleash their potential with a real time platform. Learn it by implementing real time use cases, get started with the new and exciting world of real time reporting, analytics and big data.

Key Learnings:

  1. 80+ lectures of Professionally authored content

  2. Understand why SAP HANA, Concepts, Architecture and Use cases

  3. Get Comfortable with SAP HANA  landscape, associated tools and Studio

  4. Learn the different methods and tools to get data from SAP and Non-SAP Sources

  5. Learn In-Memory modeling techniques

  6. Learn to Build reports on SAP BOBJ reporting stack

  7. Certification simulation after each topic

  8. Immediately usable skills, put it to use in your current project or join a new project.

Engaging Teaching:

  1. Expressive and immersive teaching with demonstrations and learning tools

  2. Small, purposeful videos, packed with information, designed specifically for a virtual self paced audience.

  3. Exercises, Tailored reading material and quizzes.

Credits:I have used SAP Manuals, Slides, SCN blogs as reference. Credits are due to the corresponding parties.

Who this course is for:
  • Consultants, Developers, Architects, Functional Team Members and students
Course content
Expand all 112 lectures 13:05:38
+ Introduction and Positioning
9 lectures 44:32

Welcome to the Course. If you have already watched the promo and have a good idea get going ahead. Always a good point to start.

Preview 03:37

As HANA has grown tremendously, has added a great number of features and also released many application level products like S/4 HANA, B/W4 HANA this video aims to revisit the fundamentals and highlight the big picture solution proposition of the latest HANA 2.0 data platform.

HANA 2.x High Level Preview **Latest
10:42

Learn information explosion, Big and Unstructured data, The need for real time reporting.

Whats the Problem
07:59

Learn the positioning of SAP HANA

Preview 05:39

Learn the fundamental differences between a classical database and in-memory SAP HANA Database

Main Features of SAP HANA
07:14

Learn SAP HANA solution proposition and customer success stories

SAP HANA Solution+ Proof Points
03:53

Learn the different modes a company can deploy SAP HANA

SAP HANA Deloyment Options
04:12
Additional Study
00:03

Changes in HANA 2.x from HANA 1.x for modelling activities

**HANA 2.0 Update**
01:13
+ SAP HANA Scenarios
6 lectures 14:29

Understand the Agile Data Mart use-case and where it applies in a project

Preview 02:17

Understand Operational Data marts what they are and how they are different

SAP HANA Operational Data Mart
01:41

Understand what are accelerators and where it applies in a project

SAP HANA Accelerators
01:35

Understand how SAP HANA RDS can help in accelerating the Implementation

SAP Business Suite, BW and Apps on HANA
04:33

Understand how SAP HANA live content can help in the implementation

SAP HANA Live & Rapid Deployment Solutions (RDS)
04:20
Additional Study
00:03

Your hypothetical or real customer wants to deploy SAP HANA to improve performance. Lets give a try to suggest the right options to your customers.

SAP HANA Scenarios
5 questions
+ SAP HANA Architecture
4 lectures 21:37

Learn the different engines, inter-operability and impact.

SAP HANA Landscape Architecture
07:16

Understand the Persistence layer and how it Manages the recovery process during the hardware or software failure

SAP HANA DB Architecture
05:36

Learn what kind of persistence and hardware options come with SAP HANA

Persistence & Hardware
08:42
Additional Study
00:03

Your customer wants to if SAP HANA is enterprise grade and how it handles failures. Give it a try to help them.

Architecture
8 questions

Please try these 10 questions which are relatively easy to get you started but still useful for your understanding and the certification

What do you know about SAP HANA ?
10 questions
+ SAP HANA Studio + Development Workbench + Web IDE
8 lectures 55:52

Learn how SAP HANA setup

HANA Studio Setup
02:12

Understand the eclipse based work space, the different panels and perspectives in SAP HANA Studio

HANA Studio Walk through
12:25

Learn how the models and tables are structured in SAP HANA

Create Schema, Tables and Packages
08:59

So you are beginning your SAP HANA journey with the studio and this exercise will help you get your basics and navigation in place.

Exercise 1
4 pages

Lets see how comfortable we are with the Studio

SAP HANA Studio Check !
8 questions

Changes in HANA 2.x from HANA 1.x for modelling activities

Introduction to Web Development workbench

How to access browser based Web Development workbench for HANA .

Information about URL , Perspectives and other cool stuff.

**HANA 2.0 Update** Web Development work bench and access url
10:45

In this video we will see how what is Web IDE .

How to access and url

How to add a system

How to build and identify a HDI container

**HANA 2.0 Update** Web IDE Walk through, connecting to a system
08:41

In this video we will see

Entry points for creating tables

Identifying location of persistence

Importing data

**HANA 2.0 Update** Web IDE Create table, Import data
08:19

In this video we will see

Entry point for creating views

The change in the process of validating and activating a view

**HANA 2.0 Update** Web IDE Creating calculation views
04:31
+ Introduction to CO-PA Report
3 lectures 11:40

We will learn what is Profitability Analysis (CO-PA).

What is CO-PA ?
07:57

In this lecture we will learn the end to end activities to be performed for the CO-PA use case

CO-PA Implementation overview on SAP HANA
03:43

Please refer to this SAP document for a deep dive on CO-PA.

Additional Study
135 pages

You have a meeting with your Customer/Client in the near future on migrating their CO-PA report on HANA, Lets see if you can help them.

Are you comfortable with CO-PA ?
5 questions
+ Data Provisioning
16 lectures 01:27:58

Understand what is data provisioning and why do we need it.

What is Data Provisioning and types of DP
05:47

CSV files play an important role in gathering information. Lets learn to bring flat files inside SAP HANA using an In-Built feature.

Uploading Data from flat files
09:48

Try your hand in bringing flat files inside SAP HANA

Exercise 2
3 pages

Welcome to an important tool in SAP HANA eco system. This tool allows us to bring data into SAP HANA from SAP and Non-SAP sources in Real-Time , that's right. SLT is a crucial tool for the Data Mart Use Case. Lets learn how the internals work.

Introducing and Architecture SAP Landscape Transformation (SLT)
08:05

Learn to create a connection between source system and SAP HANA

Setup SLT
08:55
Load a Table using SLT
03:40

Your customer wants to understand when and how to use SLT in a SAP HANA scenario. Surprise him.

Exercise 3
4 pages

Get introduced to BODS(Business Objects Data Services) an ETL tool. This is a credible tool with full capabilities to Extraction, Transformation and Loading. We will see features in the context of SAP HANA and our use case.

Introducing BODS
03:52

Learn how to setup SAP BODS and use query transform to bring data into SAP HANA

Preview 09:56

Learn how to use Query and Case Transform

to bring data into SAP HANA

Advanced Query and Case Transform
09:56

Your customer want to understand when and how to use BODS in a SAP HANA scenario. Help him out

Exercise 4
3 pages

Learn to use DXC (Direct Extractor Connection) to bring in data from SAP ERP Systems

Import data from SAP ERP to HANA using DXC Part 1
07:59
Import data from SAP ERP to HANA using DXC Part 2
07:31

Learn how Sybase Replication Server works and when to use it.

Introduction to SAP Sybase Replication server
03:09

Learn to build virtual data models using SDA

Introduction to Smart Data Access
09:12

Lets Implement the data provisioning for the COPA use case.

Exercise : Implementing Data Provisioning for COPA Use Case
00:08

Your customer has important data coming in CSV's, she has many questions. Do well.

Loading CSV's
5 questions

What do you understand about data provisioning and its different types

Data Provisioning ?
15 questions
+ Modeling
37 lectures 03:30:34

Did you say Star !

Understand what this star is all about and its implications on a report

Say hi to Modeling and Star Schema/Cubes
06:20

Welcome to SAP HANA modeling, its slightly different how we model on SAP HANA. Lets see how we achieve building a cube here.

Levels of Modeling in SAP HANA
05:18

Learn the different types of joins and their implications

Joins- connecting tables
08:08

Learn how we will build the COPA scenario in the HANA world

Modeling for COPA
03:18

In this video we will discuss the changes in the modelling format in the HANA 2.0

**HANA 2.0 Update** Changes in the Modelling Approach in HANA 2.0
03:41

Demonstration of how to create attribute views

Create Attribute View --- Product
09:58

Demonstration of how to create attribute views

Create Attribute View Customer
06:05

This Exercise will help to implement what you learnt about Attribute views

Exercise 6
15 pages

Learn to create the different types of hierarchies in SAP HANA

Build Hierarchies
06:18

Learn to create attribute view and how we can use them to add time granularity

Time Attribute views
06:21

This Exercise will help to implement what you learnt about Time Attribute views

Exercise 8
2 pages

Learn what are derived attribute views and how to create them

Derived Attribute Views
02:03

Demonstration of how to create analytic views

Simple Analytic Views
07:34

Learn what are calculated columns and when to use them

Create Filters and Calculated colums
08:46

This Exercise will help to implement what you learnt about Analytic views

Exercise 9
18 pages

Learn the functionality and need for restricted columns

Restricted colums
03:49

Learn what are Input Variables and how to use them for dynamic filtering

Input variables
03:08

A very useful feature in a reporting scenario, lets see how to create and use them

Currency conversion
09:52

Learn what are Input Parameters and how to parameterize a view

Preview 06:26

This Exercise will help to implement what you learnt about Input Parameters

Exercise 10
5 pages

Learn calculation views and how to create cubes reusing objects

Graphical Calculation Views
13:25

More scenarios for better learing

More Graphical Calculation Views Scenarios
04:52

This Exercise will help to implement what you learnt about Graphical Calculation views

Exercise 11
9 pages

Learn how to create decision tables and when to use them

Create Decision Tables
08:29

Learn how to use Decision tables in a a calculation view to bring business logic to the Data Base

Use Decision Tables in Calculation Views
05:43

Welcome to SQL script HANA's native language, an extension of ANSI SQL.

Introduction to SqL script
04:58

Learn the functions and demonstration of how to use them to build advanced views

Working with SQL script - Procedures
08:55

This Exercise will help to implement what you learnt about SQL Script

Exercise 12
3 pages

Demonstrations of how to use SQL Script n Calculation views

Implementing Scripted Calculation Views
06:06

This Exercise will help to implement what you learnt about Scripted Calculation Views

Exercise 13
2 pages

Lets understand whats the right approach to SAP HANA modeling, what are the questions you can ask and best practices to keep in mind.

Approach to Modeling in SAP HANA
08:01
Additional Study
00:03
Quiz
19 questions

In the video we will create the attribute view as a calculation view . This will be for a customer dimension area. In this video we will take a look at the layered join approach

**HANA 2.0 Update** Attribute View as a Calculation View ( Customer Data)
15:25

In the video we will create the attribute view as a calculation view . This will be for a Material dimension area. In this video we will take a look at the layered join approach

**HANA 2.0 Update** Attribute View as a Calculation View ( Material Data)
06:14

Lets see how to create a cube with the Transaction table and master data

**HANA 2.0 Update** Analytic View as a Calculation View ( Actual)
14:06

Lets see how to create a cube with the Transaction table and master data

**HANA 2.0 Update** Analytic View as a Calculation View ( Projected)
08:14

In this video we will bring all the artifacts(calculations views) under one cube(calculation). This will consist of the multiple cubes(Calculation views) which bring information from different transaction tables.

The cubes in turn extend information from other master data views(calculation views)

We will take a look at how to union two calculation views with in a calculation view.

**HANA 2.0 Update** Calculation View with only underlying calculation views
08:58
+ Reporting
17 lectures 01:16:27

Well lets hit the basics and learn what is a report.

Preview 03:24

A walk through the different products in the BOBJ Reporting stack and Use Cases

Introducing business objects Reporting stack
06:22

Learn what is an universe and IDT

Information Design Tool(IDT) and Universe
02:57

Create a Connection to SAP HANA

IDT: Create a Relational Connection to HANA
05:11
  • Learn how to build a universe on HANA Models using IDT
IDT: Build a universe on top of HANA Models
05:46

This Exercise will help to implement what you learnt about Creating a Connection

Exercise 14
5 pages

Learn how SAP Business Objects Web Intelligence is positioned its audience and benefits

Web Intelligence: Connect to HANA Universe
05:41

Learn how to create a simple report with standard reporting elements

Web Intelligence: Build Report on top of hana Universe
08:05

Create a Report on Web Intilligence

Exercise 15
3 pages

Learn how to connect to SAP HANA and how to consume hierarchies

MS Excel: Report on HANA Cubes with Hierarchies
04:43

Learn how SAP Business Objects Design Studio is positioned its architecture and benefits

Design Studio: Architecture
02:17

Understand Design elements and scripting and learn how to create a report on Design studio

Design Studio: Create Report on SAP Models PART 1
08:54

Understand Design elements and scripting and learn how to create a report on Design studio

Design Studio: Create Report on HANA Models PART 2
08:47

This Exercise will help to implement what you learnt about Creating a Desktop Report on Design Studio

Exercise 16
4 pages

Learn how to connect to a SAP HANA cube

Preview 03:56

Learn how to build powerful visualizations and effects

SAP Lumira: Visualize Data
08:15

Learn how to build stories

SAP Lumira: Consume, build stories and Share
02:09
Quiz
13 questions
+ Transporting models
6 lectures 25:33

Learn how Delivery units are used to transport models

Delivery Units
03:15

Learn how to Export models to a local or a server location

Exporting SAP HANA Models
05:02

Learn how to Import SAP HANA Models in between environments

Importing SAP HANA Models
05:32

Learn how to import BW models from BW into SAP system

Importing BW Models and SAP ERP meta data into HANA
04:30

Learn the maintenance features

Useful Supplementary features
07:11
Additional Study
00:03
Quiz
10 questions
+ Security
6 lectures 21:52

Learn the user life cycle and how to maintain Users in SAP HANA

Create Users
02:30

Learn about how to use privileges and roles to build a user securty model

Privileges and Roles
07:37

Learn how to give and restrict access to a SAP HANA Cube

Analytic Privileges
06:40

Learn how to build the end to end security by mapping a BOBJ use to a SAP HANA user

End to End security: Mapping HANA and BOBJ User
04:46

Learn how to create an end to end security profile from the database to the reporting layer

Exercise 17
00:15

Please go through this document for more information on security in SAP HANA landscape and prepare for your Quiz!


Additional Study
00:03
Quiz
11 questions