90 hours

SAP HANA is a techno-functional module that provides a real-time platform that converges database and application capabilities in-memory to transform transactions and analytics. SAP HANA is built on the next generation in-memory data processing design model for faster information processing.It is considered to be a breakthrough technology that can take business performance to the next level.

Growth Path:   HANA consultant has vertical growth opportunities by elevating as team lead,   Technical Lead,  Project Manager.

  • Course completion certificate, Certification documents and materials, interview questions included.
  • Mode of Study – Online Self Learning
  • 24/7 support


USD 75

SAP HANA Course Content

Unit 1: Introduction to SAP HANA             
  1. Introduction to SAP HANA
  2. SAP In-Memory Strategy
  3. HANA compare to BWA
Unit 2: Look & Feel   
  1. In-Memory Computing Studio
  2. Administration view
  3. Navigator View                                      
  4. System Monitor
  5. Information Modeler
Unit 3: Architecture          
  1. Architecture Overview
  2. IMCE and Surroundings
  3. Row Store
  4. Column Store
  5. Loading data into HANA              
  6. Data Modelling
  7. Reporting
  8. Persistent Layer
  9. Backup & Recovery
Unit 4: Data Provisioning         
  1. Method 1 – Data Provisioning using FLAT FILES
  2. Method 2 – Data provisioning using BODS 4.2 (ETL Based Approach – Building AGILE Data Marts)
    a. Features of SAP Data Services solution for SAP HANA
    b. Process of loading data from ECC to SAP HANA using the ETL method
  3. Method 3 – Data provisioning using SLT
    a. SAP Landscape Replication server for HANA
    b. Key benefits of SLT replication server
    c. Key benefits of Trigger-Based Approach
    d. Architecture for SAP source replication
    e. Architecture for Non-SAP source replication
    f. Configuration and monitoring Dashboard
    g. Creating new Configuration for SAP Sources
    h. Creating New Configuration for Non-SAP sources
    i. Result of Creating new Configuration
    j. Launching Data provisioning UI in HANA studio
    k. Start Load/Replication
    l. Stop/Suspend replication
    m. Status Monitoring in HANA Studio
    n. SLT based transformation Concept
    o. Advanced replication settings
    p. Change of table structuring and partitioning
    q. Filtering and selective data replication
  4. Method 4 – Data provisioning using Direct Extractor Connection (DCX)
    a. Using SAP provided Business Content Extractor
    b. ABAP Data Flows for Table and Pool clusters
  5. Method 5 – SAP HANA Smart Data Access
  6. Method 6 – Remote DATA Sync
    a. Smart Data Streaming
Unit5 : Modeling            
  1. Purpose of Information Modeler
  2. Levels of Modeling in SAP HANA
  3. Attribute Views
  4. Analytic Views
  5. Calculation Views
  6. Explaining Predictive Modeling
  7. Discovering SAP HANA Live
  8. Creating Advanced Calculation Views using GUI and SCRIPT methods
  9. Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
  10. Creating Calculation Views with Dimension, Cube and STAR-Join
  11. Creating Decision Tables and Analytic Privileges
  12. Using Hierarchies (Level Based and Parent-Child Hierarchies)
  13. Creating Restricted and Calculated Measures
  14. Defining and using Filter Operations
  15. Using Variables, input parameters
  16. Explaining new aggregation function for measures
  17. SAP HANA SQL Introduction
  18. SQL Script and Procedures
  19. Using Currency Conversions
  20. Creating Hyperlinks
  21. Persistency Considerations
  22. SAP HANA Engine Overview
  23. Choosing Views for HANA
  24. Using SAP HANA Information Composer for Modeling
  25. Processing Information Models
  26. Validating Models
  27. Comparing Versions of Information Objects
  28. Checking Model References
  29. Generate Auto Documentation
  30. Understand Virtual Data Model
  31. Discovering and consuming HANA Live views
  32. Building a Virtual Data Model with CDS Views
  33. Connecting Tables
    Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
  34. Managing Modelling Content
    a. Manage Schemas b. Import and Export data Models c. Copy Information Objects
Unit 6: Reporting     
  1. HANA, Reporting Layer
  2. Connectivity options
  3. SAP Business Objects BI 4.1
  4. Designing Complex Universes in IDT based on HANA Tables and HANA Views
  5. WEBi 4.0 on HANA
  6. Crystal Report for Enterprise with HANA
  7. Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  8. SAP Business Objects BI 4.1 Explorer
  9. Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
  10. Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
  11. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
  12. Analysis edition for Microsoft Excel, Microsoft Powerpoint
  13. SAP Visual Intelligence on HANA
  14. Crystal Reports via ODBC/JDBC Connections
  15. Others & MS Excel 2010
Unit 7: User Management               
  1. Understand and Creation of Users
  2. Creation of Roles and Privileges
  3. Creation of Role Hierarchy
  4. Generating SAP HANA Live Privileges
  5. Assignment of Users to Roles
  6. Authentication
Unit 8: Security and Authorizations
  1. User Management and Security
  2. Types of Privileges
  3. Template Roles
  4. Administrative
Unit 9: Concepts of SAP BW 7.4 ON HANA
  1. BW 7.4 powered by SAP HANA
  2. In-memory optimized Infocubes            
  3. In-memory optimized DSO’s
  4. Migration concepts of BW 7.0 on traditional Database to BW 7.4 on SAP HANA
  5. Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
  6. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
Unit 10: Text Search and Analysis
  1. Implementing Full Text Search and Text analysis
  2. Defining Data Types and Full Text Indexes
  3. Using Full Text Search
  4. Developing Predictive Models
Unit 11:  new Features and Functionality
  1. SAP HANA Smart Data Access (New and Changed)
  2. SAP HANA Predictive Analysis Library
  3. SAP HANA Graph
  4. SAP HANA Client Interfaces
  5. SAP HANA XS Advanced Development
  6. SAP HANA Modeling (New and Changed)
  7. SAP Web IDE for SAP HANA and SAP HANA Runtime Tools
  8. SAP HANA Interactive Education (SHINE) for XS Advanced

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.


Priority Support

All queries are answered 24/7.


Abhilash –

A very good match. i am enjoying every bit.


Experience was quite good and it was very useful and well elaborated course.




I find that the explanation is good and also understandable.


Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.


I really like this course, it was a good match for me :))


Standard process and hands on covered nicely.



Perfect, with complete hands on. Well structured and nicely covered.


Great Content, nice and up to the mark course.



Great courses. Beginner friendly and the explanations are clear and very easy to understand.


Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.


A very detailed explanation and quite handy tips and tricks! loved it



Excellent lecture, pace of the instructor is very good, easy to understand


Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.


This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan –

A pesar de no dominar perfectamente el idioma, se entiende bien.


Yes lessons are very good. Not so fast, well explained


Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us