SAP HANA Implementation, Modeling and Reporting Course
4.0 (393 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,264 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP HANA Implementation, Modeling and Reporting Course to your Wishlist.

Add to Wishlist

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.0 (393 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,264 students enrolled
Created by Junaid Ahmed
Last updated 4/2017
English
Current price: $10 Original price: $200 Discount: 95% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 6 Articles
  • 24 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 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.
Who is the target audience?
  • Consultants, Developers, Architects, Functional Team Members and students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
106 Lectures
24:35:05
+
Introduction and Positioning
7 Lectures 32:34

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

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

Lets get introduced to SAP HANA, I have collated information from authentic resources for your easy reference and benefit. Please go through the material even if its just a little before taking the quiz, We want to prepare for the certification exam right from here

Study Material
13 pages

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 Scenarios
6 Lectures 14:26

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

Please go through the chapters 2.1, 2.2, 2.3, 2.5 of the master guide for further understanding of the SAP HANA Scenarios. Get ready for the Quiz!

Note: The parts of the documentation pertains directly to this section. For a sequential and easy learning curve with out getting overwhelmed with information, try and stick to the recommended topics for reference. Experts feel free to explore as you like.

Please refer the latest version document at this location.

https://help.sap.com/viewer/eb3777d5495d46c5b2fa773206bbfb46/1.0.12/en-US/

Additional Study
86 pages

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:34

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

Please go through this document for further understanding of the SAP HANA architecture, persistence and hardware. Get ready for the Quiz

Study Material
26 pages

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
+
SAP HANA Studio
7 Lectures 24:01

Learn how SAP HANA setup

Setup
02:12

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

Walk through
12:25

Learn how the models and tables are structured in SAP HANA

Create Schema, Tables and Packages
08:59

How to get Server Access

Server Access
00:18

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

Please go through the chapters 3 and 5 of this document for further understanding of the SAP HANA studio. Get ready for the Quiz

Note: The parts of the documentation pertains directly to this section. For a sequential and easy learning curve with out getting overwhelmed with information, try and stick to the recommended topics for reference. Experts feel free to explore as you like.

Please refer the latest version document at this location.

https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.00/en-US

Study Material
184 pages

Lets see how comfortable we are with the Studio

SAP HANA Studio Check !
8 questions

Please refer to this SAP HANA Certification material and guide for the latest information .


**UPDATE** SAP HANA HA 100 SP12 GUIDE
00:06
+
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
17 Lectures 01:22:50

Understandt 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

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:59

Learn how to use Query and Case Transform

to bring data into SAP HANA

Advanced Query and Case Transform
09:57

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
07:35

Lets Implement the data provisioning for the COPA use case.

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

Please go through this document for summarizing and more information on data provisioning. You can have this as your reference guide. Get ready for the Quiz!


Additional Study
38 pages

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

Please refer to this SAP HANA Certification material and guide for the latest information .


** UPDATE ** SAP HANA HA 350 Guide SP12
00:03
+
Modeling
32 Lectures 02:30:16

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

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:04

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 05:29

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
10:33

More scenario 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:04

Please go through Chapters 6, 8 and 9 of this document for more details and prepare for the Quiz !


Note: The parts of the documentation pertains directly to this section. For a sequential and easy learning curve with out getting overwhelmed with information, try and stick to the recommended topics for reference. Experts feel free to explore as you like.

Additional study
41 pages

Quiz
19 questions

Please refer to this SAP HANA Certification material and guide for the latest information .

** UPDATE ** SAP HANA HA 300 SP 12 GUIDE
00:08
+
Reporting
18 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

Please go through this documentation to understand these products better, as mentioned we are confiding only to SAP HANA, these products are designed for variety of sources. Prepare for the Quiz!

Additional study
31 pages

Quiz
13 questions
+
Transporting models
6 Lectures 25:31

Learn how Delivery units are used to transport models

Delivery Units
03:16

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

Please go the chapter 10 of this document for more information and prepare for your Quiz!

Additional study
218 pages

Quiz
10 questions
+
Security
6 Lectures 21:47

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:14

Please go the chapters 6,8,9 of this document for more information on security in SAP HANA landscape and prepare for your Quiz!


Note: The parts of the documentation pertains directly to this section. For a sequential and easy learning curve with out getting overwhelmed with information, try and stick to the recommended topics for reference. Experts feel free to explore as you like.

Additional study
162 pages

Quiz
11 questions
About the Instructor
Junaid Ahmed
4.1 Average rating
987 Reviews
7,095 Students
7 Courses
Entrepreneur, Product Designer, Architect and Trainer

Hello there! I am Junaid Ahmed. I have a bachelors in electrical and electronics engineering and a masters in software engineering . I would like to call my self a technologist, I am excited to learn new technologies, working and teaching on them.

I come from a background of enterprise software, and I am currently also focusing on Internet of things(IOT) and building products. I have worked for over 10+ years with enterprise applications, reporting and security products from SAP and Oracle. I have consulted with large organizations in Government, Telecom, Power, FMCG sectors and start-ups.I manage projects using agile methods and tools. I hold certifications in SAP HANA and scrum master . As far as training goes I have been involved in on site and online Training for the last 6 years in different products and practices including SAP HANA, BODS, BOBJ Suite, soft skills and IOT. I have over 6000+ students enrolled in my courses on Udemy. My clients include Consulting Companies, Implementation partners and Consultants. Currently, I have also started working with firms to provide solution in the IOT space.

Happy Learning!