Modules Covered in SAP HANA Online, Classroom Training

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

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 50 + batches in BODS/BO/HANA and 80% of the students accomplished in getting jobs in various domains.