SAP HANA Classes in BTM Layout Bangalore

IT Networks offers the best SAP HANA Training in BTM Layout with most experienced professionals. We conduct all our students from the Basic Level of SAP HANA Classes to Advanced level. All these Classes are undergone not only theoretically, but also are executed on the real-time basis. Our Trainers are Real-time Working professionals in the SAP HANA Field from many years with hands on real time SAP HANA Project Knowledge.

IT Networks is a highly experienced SAP HANA Training Institute in BTM Layout. This has helped students to get placed in top MNCs. We Offer SAP HANA Classes in BTM Layout for working professionals and students. we offer Regular training classes in Morning Batches and Evening Batches we also offer Weekend Training classes and Fast-track Training Classes for SAP HANA Course.

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

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