Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SAP HANA Implementation, Modelling and Reporting Course

Learn how to build a Real Time Platform using SAP HANA the bestselling product in the history of SAP (1.x + 2.x+ Cloud)

Created byJunaid Ahmed

Last updated 8/2025

English

What you'll learn

Develop a strong understanding and practical knowledge about both SAP HANA 1.x and 2.x
Be able to develop an end to end scenario on SAP HANA including modelling, reporting and data provisioning
Use advanced features specific to SAP HANA database such as HDI, SDA , SDI
Understand how to build coarse and granular security
Understand how to implement change management using GIT
Be able to extract data from various SAP and NON SAP source systems using BODS, SDA, DXC, File import and more methods
Get introduced to BOBJ business intelligence and build reports using tools such as Lumira, Webi, IDT and more
Understand the modelling levels, concepts and best practices
Understand how to improve model performance using performance tuning methods

Course content

24 sections • 263 lectures • 23h 49m total length

Welcome to the New SAP HANA 2.x Course structure8:56
New Addition - Get Started with Hana Cloud (from section 19 onwards)2:21
Accessing resources and planning your learning journey0:06
SAP HANA 2.0 50,000 feet Summary8:59
Additional Study Materials and Documentation0:04

Introduction to the section0:44
Register and Download SAP HANA express edition6:06
Link to access SAP HANA Express edition
https://www.sap.com/products/technology-platform/hana/express-trial.html
System Requirements0:05
Setup Virtual box and Import VM image3:46
Setup VMWare and Import + Install VM image9:30
Install SAP HANA Express on VMware
Configure and Start the Database12:09
Host Mapping and Test WebIde3:21
Mount DB on WebIDE2:09
Selecting the Target tenant for persistence7:30
Stopping the DB0:09
Section Quiz

Section Introduction4:51
Modelling Fundamental Idea (Over simplified)9:02
WebIDE Walkthrough (getting ready for the project)2:36
Project Data Model and Model Design2:29
Import Data and do your own modeling6:28
Import the whole project with Data and Models10:28
Introduction to SAP HANA Joins(Regular) - Theory4:08
Inner Join 1-1 (Theory and Hands-on)9:22
Inner Join 1-n (Theory and Hands-on)5:54
Left Outer Join (Theory and Hands-on)3:31
Right Outer Join (Theory and Hands-on)2:35
Full Outer Join (Theory and Hands-on)2:18
Referential Join (Theory and Hands-on)2:28
Build Employee Dimension Calculation View6:44
Build Partner Dimension Calculation View12:50
Build Product Dimension Calculation View7:05
Build Purchase Insights Cube Calculation View9:00
A closer look at the Semantic Layer12:11
Introduction to SAP HANA Nodes (Part 1)6:01
Implement Restricted Column6:04
Section Quiz P1

Section Introduction3:21
Install SDI Components on the Hana Server5:46
Install SDI on VMware Using the Shared Drive7:34
Install SDI on VMware using the shared drive.
With this method you can download the SDI or any other additional component on your local host and then use that path to install it in the VM
Importing Data and Build your own models6:39
Create Remote Connection1:35
Create MTA Project2:20
UAA Setup (Access between Tenant and HDI)2:08
Updating YAML file and Creating a .hdbgrants file2:41
Create Virtual Table2:34
Test an empty SDI FlowGraph4:14
Import the Data Flows5:49
Project Base cube design - Walkthrough2:21
Create projection 112:34
Create projection 213:44
Use a Case Transform to Split the Data7:52
Use a Union Transform to combine similar datasets5:26
Use a Join Transform6:46
Use a Aggregate Transform to Roll up the measures6:51
Project CDC(Change Data Capture) Design - Walkthrough3:24
Current Source Table Analysis4:07
Setup Source table for the project3:01
Create Virtual Table for CDC2:19
Setup Namespace1:57
Setup Capture Table for CDC6:18
Build Surrogate Key7:09
Use Table Comparison for CDC10:29
Use History Preserving for CDC8:37
Section Quiz SDIA

Section Introduction2:02
Section Intro - Project Data Model and Model Design11:34
Importing Data and do your own modeling5:00
Import the whole Project with Data and Models4:37
Build Partner Dimension Calculation View8:05
Build Cube Calculation view for 2014 Data7:19
Build Cube Calculation view for 2015 Data3:08
Union 2014 and 2015 datasets5:29
Implement a filter to restrict data3:36
Implement an Input Parameter to collect user selection2:26
Create an extra column for Currency Conversion7:12
Implement Currency Conversion3:47
Rank Feature Introduction0:45
Implement Rank Functionality (Absolute)9:33
Implement Rank Functionality (Percentage)2:22
Implement a Temporal Join to make a time bound selection10:52
Implement Spatial Join to operate on Geo data6:59
Implement Hierarchies3:42
Documentation2:59
Section Quiz

Section Introduction2:02
Fundamentals9:01
Performance Analysis - Test Features2:33
Debug Mode - Test Features6:14
Explain Plan - Test Features4:17
Visualize Plan - Test Features14:02
Performance Improvement by reducing data vertically and horizontally8:49
Performance Improvement by Avoiding Join when not required5:21
Performance Improvement by Union Pruning(avoiding a sub set when not required)10:07
Maintaining Accuracy7:47
Data Lineage4:51
Section Quiz

Section Introduction2:53
Using Git for version control and Management6:21
Setting up and Initializing a local Git repository4:16
Managing changes in the main branch of the Local Git Repository6:47
Merging changes from local branch to main branch in a Local Git Setup4:02
Clone a Project from GitHub6:20
Setting up and initializing a Remote Repository6:02
Managing changes between the Local and Remote Git Repositories4:29
Pushing changes from a branch in the local Git to the Remote Repository2:47
Section Quiz

Welcome3:37
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.
HANA 2.x High Level Preview **Latest10:42
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.
Whats the Problem7:59
Learn information explosion, Big and Unstructured data, The need for real time reporting.
What is SAP HANA ?5:39
Learn the positioning of SAP HANA
Main Features of SAP HANA7:14
Learn the fundamental differences between a classical database and in-memory SAP HANA Database
SAP HANA Solution+ Proof Points3:53
Learn SAP HANA solution proposition and customer success stories
SAP HANA Deloyment Options4:12
Learn the different modes a company can deploy SAP HANA
Additional Study0:03
**HANA 2.0 Update**1:13
Changes in HANA 2.x from HANA 1.x for modelling activities

SAP HANA Agile Data Mart2:17
Understand the Agile Data Mart use-case and where it applies in a project
SAP HANA Operational Data Mart1:41
Understand Operational Data marts what they are and how they are different
SAP HANA Accelerators1:35
Understand what are accelerators and where it applies in a project
SAP Business Suite, BW and Apps on HANA4:33
Understand how SAP HANA RDS can help in accelerating the Implementation
SAP HANA Live & Rapid Deployment Solutions (RDS)4:20
Understand how SAP HANA live content can help in the implementation
Additional Study0:03
SAP HANA Scenarios

Requirements

Recommended Knowledge Areas: SAP ERP, Reporting, Modeling and Data Bases. This is not Required you can start from scratch

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:

200+ Professionally authored Lectures.
Immediately usable skills, put it to use in your current project or join a new project.
Quizzes after each topic

1.x Topics:

Understand why SAP HANA®, Concepts, Architecture and Use cases
Get Comfortable with SAP HANA® landscape, associated tools and Studio
Learn the different methods and tools to get data from SAP and Non-SAP Sources
Learn In-Memory modeling techniques
Learn to Build reports on SAP BOBJ® reporting stack

2.x Topics:

Setup up your own SAP HANA® Instance on your Local System
Build SAP HANA® Models for Purchase Insights ( Level: Beginner)
Smart Data Integration and Access (SDI/A) (Level: Beginner, Intermediate)
Build SAP HANA® Models for Sales Insights (Level: Intermediate)
Model Optimization and Accuracy
Model and Data Security
Version Control and Model Operation using Git

Getting Started with Cloud:

What is SAP HANA Cloud and why now?
Get your own Trial SAP HANA Cloud Instance
How to Import data using HDB table data and CTL methods.
Get your initial project setup and curated data to get up and running quickly
Overview of database, modelling, design functionalities and features of the SAP HANA Cloud solution
Understand how this is different from On premise HANA solution
SAP HANA Cloud use cases and scenarios
Inter connectivity between your main DB instance and your project HDI, Security and much more.

Engaging Teaching:

Expressive and immersive teaching with demonstrations and learning tools
Small, purposeful videos, packed with information, designed specifically for a virtual self paced audience.

Course Resources:

2.x: Guidance for server setup on your Local System, Data, Models and Quizzes

1.x: Exercises, Tailored reading material and quizzes.

Disclaimer:

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

SAP HANA® is a Product of SAP®.

Explicitly mentioned or otherwise.

I am not associated with SAP.

Who this course is for:

Consultants, Developers, Architects, Functional Team Members and students

SAP HANA Implementation, Modelling and Reporting Course

What you'll learn

Explore related topics

Course content

2.x - Course Structure and Guidance for best Outcome (MUST)5 lectures • 20min

2.x - Setting up your own SAP HANA Instance10 lectures • 45min

2.x - Building SAP HANA Models for Purchase Insights ( Level: Beginner)20 lectures • 2hr 6min

2.x - Smart Data Integration and Access (SDI/A) (Level: Beginner, Intermediate)27 lectures • 2hr 28min

2.x - Build SAP HANA Models for Sales Insights (Level: Intermediate)19 lectures • 1hr 41min

2.x - Model Optimization and Accuracy11 lectures • 1hr 15min

2.x - Model and Data Security8 lectures • 37min

2.x - Version Control and Model Operation9 lectures • 44min

1.x - Introduction and Positioning9 lectures • 45min

1.x - SAP HANA Scenarios6 lectures • 14min

Requirements

Description

Who this course is for: