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.

Course objectives

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.

Prerequisites

Essential:
A good Bachelors degree in any field is required.

Recommended/Additional:
Awareness to database technologies and basic software knowledge is advantageous but not a must.

Duration

32 Hours

Placement

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.

Course Preview
1
SAP HANA Studio

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

2
Data Provisioning

- Data Replication - Definition
- Data Replication Methods

3
Uploading Data From flat Files

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

4
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

5
Data Provisioning

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

6
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

7
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

8
Analytic Views

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

9
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

10
SAP HANA SQL

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

11
Security

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

12
Reporting

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