SAP HANA Online Training

Home » SAP » SAP HANA Online Training

+91 - 9666600093   |   +91 - 9848686581   |   info@erponlinetraining.com

SAP HANA Course Content

Module 1: Modeling

Unit 1. Introduction to SAP HANA
Unit 2. Data warehousing Concepts
Unit 3. Working with HANA STUDIO
Unit 4. HANA – Attribute View
Unit 5. HANA – Analytical View
Unit 6. HANA – Calculation View
Unit 7. Decision Tables

Module 2: SQL in HANA

Unit 8. SQL in HANA
Unit 9. Stored Procedures in HANA

Module 3: Data Provisioning

Unit 10. ETL Based Replication using SAP BODS

Unit 11. Batch Driven Replication using DXC

Unit 12. Real Time Replication using SAP LT

Module 4: Advanced Modeling

Unit 13. Hierarchies
Unit 14. Conversions
Unit 15. Analytical Privileges
Unit 16. SAP HANA TEXT Analysis

Module 5: HANA Reporting

Unit 17. Reporting using Excel
Unit 18. SAP Visual Intelligence
Unit 19. SAP BO 4.1/4.2
Unit 20. Crystal Reports

Module 5: HANA Administration

Unit 21. Creating Users and Roles
Unit 22. Security and Authorizations
Unit 23. Administration

Module 6: BW on HANA Concepts

Unit 24. Concepts of SAP BW 7.4 ON HANA

Module 7: Best Practices and Performance

Unit 25. Best Practices in HANA Modeling

Module 8: CASE STUDIES

Unit 26. COPA

Module 9:  New Enhancements

Unit 27. New Enhancements and Features in new SPS

Module 10:  CERTIFICATION GUIDANCE

 

Topics Covered

  1. MODELING

Unit 1. Introduction to SAP HANA

  • SAP HANA Introduction
  • Versions in SAP HANA
  • SAP HANA Editions
  • SAP System Landscape and Architecture

Unit 2. Data Warehousing Concepts

  • Data, Database, DBMS
  • Data Models
  • OLTP Systems
  • OLAP Systems
  • Converting ERM to MDM
  • Star Schema, Implementation of Data models

Unit 3. Working with HANA STUDIO

  • Exporting Modeling Objects and Views
  • Importing Modeling Objects and Views
  • Catalog Objects in HANA Studio
  • Content in HANA Studio
  • Packages and Sub Packages
  • Provisioning in HANA
  • Security in SAP HANA
  • Creating Package and Sub Packages

Unit 4: Creating Information Views – Attribute Views

  • Introduction to Information Views
  • Creating Attribute View
  • How data stored in SAP HANA
  • Applying Filters at the time of definition
  • Adding Calculated Columns to Attribute View
  • Creating attribute views on multiple tables

Unit 5: Creating Information Views – Analytical Views

  • Creating Analytical Views on Transaction Data
  • Creating Analytic View Representing a Multidimensional  Model
  • Apply Filtering in Analytical View
  • Creating Variables in Analytical View
  • Adding Calculated Columns
  • Creating Restricted Columns

Unit 6: Creating Information Views – Calculation Views

  • Creating Calculation Views Graphical using Projection Node
  • Creating Calculation Views using Join Node
  • Creating Calculation Views using Union Node
  • Creating Calculation Views using Aggregation Node
  • Implementing Multidimensional models using calculation views
  • Creating Decision Table with Return Values
  • Creating Decision Table with Update Values

Unit 7: Creating Decision Tables

  • Creating Decision Table with Return Values
  • Creating Decision Table with Update Values

Unit 8: SQL on HANA

  • Introduction to SQL in SAP HANA
  • SQL statement types
  • Filtering data
  • Joins in SQL
  • Sub Queries

Unit 9: Creating Stored Procedures

  • Stored Procedures
  • Parameter Types
  • Executing Procedure
  • Calculated Engine Functions
  • Creating Procedures under content
  • Scripted Calculation Views

Unit 10:  ETL Based Replication using SAP BODS

  • Extract DATA from Excel to HANA
  • Loading Data from Flat File to HANA
  • Loading Data from Flat File to HANA
  • Using Template Table as Target
  • Loading data from SQL SERVER to HANA
  • SAP ECC to HANA
  • Import Metadata of ECC to HANA
  • Loading data from SAP ECC (multiple tables ) to HANA
  • Loading Data from BW to HANA
  • Extract Data from ECC using ABAP Workflow
  • Designing Data Flow for BW

Unit 11: Batch Driven Replication using DXC

  • Overview of the DXC
  • DXC Configuration for SAP Business Suite
  • Data Replication from SAP business system using DXC

Unit 12: Real Time Replication using SAP LT

  • Overview of the SAP Replication Server
  • Configuring SAP LT Server
  • Configuring and Monitoring Dashboard
  • SLT Based Table Data Provisioning

Unit 13: Hierarchies

  • Hierarchies – LEVEL
  • Hierarchies – Parent Child

Unit 14: Conversions

  • Difference between Copy from and Derived
  • Generating Time Data in Information Views
  • Transportation (Import and Export)
  • Currency
  • Units of Measure

Unit 15: Analytical Privileges

  • Creating Analytical Privileges
  • Assigning Analytics to Users

Unit 16: Text Analysis

  • Full Search text
  • Fuzzy Search

Unit 17: Reporting Using Excel

  • Connecting SAP HANA to MS – Excel

Unit 18. SAP Visual Intelligence

  • SAP Lumira

Unit 19: SAP Business Objects Tools BOBI 4.1/4.2

  • Introduction to Business Objects
  • Analysis for Office for OLAP
  • Dash Boards
  • Creating Web Intelligence
  • Information Design Tool

Unit 20: Crystal Reports

  • Crystal Reports 2013

Unit 21. Creating Users and Roles

Unit 22. Security and Authorizations

Unit 23. Administration

Unit 24. Concepts of SAP BW 7.4 ON HANA
Unit 25. Best Practices in HANA Modeling

Unit 26. COPA

Unit 27. New Enhancements and Features

About our Best SAP HANA Trainer:

  • BO/BODS/HANA 1.0 consultant with rock solid experience in Delivery/Consulting/Assessment/Support projects with fortune 500 companies and as a Senior Consultant.
  • More than 15 years of Consulting & Teaching experience as a Corporate Trainer in BW versions (BODS 4.X), SAP BO (4.X), HANA SPS8, SPS9, SPS10).
  • With a strong background in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches around the globe.
  • Trained over 45 + batches in BODS/BO/HANA and 80% of the students accomplished in getting jobs in various domain all over the globe.





Reviews

SAP HANA Online Training Rated (5.0) based on 1 reviews.

By: Mohan Kumar - Rating: 5 ( )
SAP HANA is best course to learn and it is the feature course.


Add Your Review