SAP HANA is a game-changing, real-time platform for analytics and applications. While simplifying the IT stack, HANA provides powerful features like: significant SAP HANA training course is designed to cover the curriculum set forth for the HANA course by SAP and to train the attendants as associate level SAP HANA consultants.

By the end of this training you will:
– Acquire the relevant knowledge required to clear the SAP certification exam.
– Understand the core concepts of SAP’s HANA module.
– Be able to apply the knowledge learned to progress in your career as an associate level SAP HANA Technical consultant.

A good Bachelors degree in any field is required.

Awareness to database technologies and basic software knowledge is advantageous but not a must.

32 Hours

Although there is no guarantee of a job on course completion we are almost certain that you should be able to find a suitable position within a few weeks after successful completion of the course. As a part of Placement service, we offer CV reviewing in which your CV would be reviewed by our experts and essential modifications to be made would be recommended so that your CV suits perfectly to the kind of training you have taken.


- Look and Feel
- Different Perspectives
- Administration Console
- Modeller
- Application Development
- Catalogue
- Content
- Security

Data Provisioning

- Data Replication - Definition
- Data Replication Methods

Uploading Data From flat Files

- When to use Flat Files upload Functionality
- How to load data from Flat Files in Workstation

SAP-BO Data Services

- Introduction to BODS
- Data services - One stop solution
- Data integration, Data Quality, Data Profiling
- BODS Server
- Repository
- Job Server
- Management Console
- Data services Designer
- Creating Formats
- Creating Data stores
- Creating Projects
- Creating batch jobs
- Scheduling and monitoring Batch Jobs
- Creating Data flows
- Creating Connection to HANA DB

Data Provisioning

- SAP Landscape Replication server for HANA (SLT)
- SAP Business Object Data Services (BODS)

SAP HANA Modeling

- General DWH concepts
- Importance of Data Modelling
- ER Model
- Multi Dimensional Model
- Star Schema
- Implementing Data models in HANA
- Introduction to Modeller
- Levels of Modelling

Attribute Views

- Time Dimension Attribute Views
- Derived Attribute Views
- Shared Attribute Views
- Calculated Columns/Attributes
- Using Hierarchy
- Implementing Level Hierarchy
- Parent Child Hierarchy
- Applying Filters

Analytic Views

- Multi Dimensions Models with Analytic Views
- Calculated Measures
- Calculated Attributes/Columns
- Restricted Measures
- Concept variables and Input Parameters

Calculation of Views

- Graphical Calculation Views
- Scripted Calculation Views
- Using Union, Join, Projection, Aggregation
- Using Inner Join, Left Outer Join, Right Outer Join, Text Join, Referential Join


- SQL statements
- Creating tables, Alter, Drop, Insert, Update, Delete
- Creating Procedures
- Creating Table types


- Creating Users
- Creating Roles
- Assigning Privileges and Roles to Users
- Deployment:
- Import & Export HANA Models
- Developer Mode
- Delivery Unit Mode
- Generate Auto Documentation


- SAP HANA Database Connectivity options
- Using IDT creating connection, Data foundation, Business layer
- Creating Webi Reports