SAP HANA Course

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

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

More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us