Attend our Instructor Led Live OnLine Interactive Training
30000 Enroll now
Attend our Video Based Selfed Paced Training
36 Hours Enroll now


SAP HANA is an on-premise application that gathers real-time insights which comprises of modern hardware capabilities and memory-centric database which yield high-performance engine to process and store data. SAP HANA provides services that match the requirements as well as enhance the productivity of the organization. SAP HANA is a mature enterprise solution with enhanced capabilities like simplify IT, innovate modern applications, and accelerate insights to run mission critical business processes.

Did you know?

  • SAP HANA supports new programming languages like JavaScript on Node.Js, Java on Apache TomEE, C++ runtime – and the availability of standard code management tools – Git, GitHub and Maven. These enhancements facilitate the creation of applications based on a microservices architecture, where separate components might use different programming languages.
  • SAP has acquired SyBase in 2010 to accelerate the reach of its solution and drive forward the realization of in-memory computing vision on mobile platforms.This innovative platform can connect both applications and data (SAP and non-SAP) to reach 4 billion mobile subscribers through more than 850 operators using SyBase’s messaging network.
  • SAP Web IDE for SAP HANA, a browser-based integrated development environment (IDE) for SAP HANA-based application (which comprises web-based or mobile UIs, business logic, and extensive SAP HANA data models) development. This functions simultaneously with SAP HANA Runtime Tools (HRTT), SAP HANA Deployment Infrastructure (HDI), Application Lifecycle Management tools (ALM), and the XS Advanced runtime platform.

Why learn SAP HANA 1.0 SP12?

  • SAP HANA is one of the hot trends in the job market as the in-memory architecture and efficiency of SAP HANA has already drawn the attention of fortune 500 companies leading to a drastic change in the growth curve of installing animplementing HANA thus there is a great demand for certified HANA consultants.
  • Most popular companies implementing SAP HANA are Asian Paints, Mercedes-AMG, Vodafone, EMC, eBay, Colgate Palmolive, Coca-cola, Accenture, Sandisk, Unilever, Lenovo, Infosys, Cisco and many more need HANA experts. As a result the companies would need certified SAP consultants with niche skills who can adapt and get the platform going.
  • There are various job profiles for HANA consultants and most popular ones on demand are SAP HANA Cloud Experts, SAP HANA Modeler, SAP HANA Consultant and SAP HANA DB Admin.
  • As the demand is more and the number of good HANA resources are comparatively very less, the pay scale of a certified SAP HANA expert is 15 to 40 percent more than an average IT Salary.

Course Objective

After the completion of this course, Trainee will:

  • Get end to end knowledge on implementing SAP HANA Solution
  • Understand the best practices for SAP HANA modeling and implementation, support or migration of SAP HANA Project
  • Gain Knowledge on SAP BI, SAP BO and data provisioning tools
  • Learn how to convert business requirement to technical requirement
  • Understanding different components of SAP (ECC, S/4 HANA)
  • Configure, report, monitor and dashboard creation using SAP HANA
  • Learn SAP HANA administration activities like managing users, storage and security
  • Writing SAP HANA queries and performance HANA tuning


  • Basics of SQL, Database & Data Warehouse
  • Knowledge about SAP BW preferred
  • Basic understanding of any ERP business process would be an added advantage
  • Pre-requisites Materials provided: SQL Tutorial, Data Modeling and DW concepts.

Who should attend this Training?

The SAP HANA platform is on demand due to its result oriented approach. This training is suited for:

  • BW Application Consultants
  • Business Analysts
  • Developers
  • Technical/functional Consultants

Unit 1: Introduction to SAP HANA

  • Introduction to SAP HANA
  • SAP In-Memory Strategy
  • HANA compare to BWA

Unit 2: Look & Feel

  • In-Memory Computing Studio
  • Administration view
  • Navigator View
  • System Monitor
  • Information Modeler

Unit 3: Architecture

  • Architecture Overview
  • IMCE and Surroundings
  • Row Store
  • Column Store
  • Loading data into HANA
  • Data Modeling
  • Reporting
  • Persistent Layer
  • Backup & Recovery

Unit 4: Data Provisioning

Method 1 – Data Provisioning using FLAT FILES

Method 2 – Data provisioning using BODS 4.2 (ETL Based Approach – Building AGILE Data Marts)

  • Features of SAP Data Services solution for SAP HANA
  • Process of loading data from ECC to SAP HANA using the ETL method

Method 3 – Data provisioning using SLT

  • SAP Landscape Replication server for HANA
  • Key benefits of SLT replication server
  • Key benefits of Trigger-Based Approach
  • Architecture for SAP source replication
  • Architecture for Non-SAP source replication
  • Configuration and monitoring Dashboard
  • Creating new Configuration for SAP Sources
  • Creating New Configuration for Non-SAP sources
  • Result of Creating new Configuration
  • Launching Data provisioning UI in HANA studio
  • Start Load/Replication
  • Stop/Suspend replication
  • Status Monitoring in HANA Studio
  • SLT based transformation Concept
  • Advanced replication settings
  • Change of table structuring and partitioning
  • Filtering and selective data replication

Method 4 – Data provisioning using Direct Extractor Connection (DCX)

  • Using SAP provided Business Content Extractor
  • ABAP Data Flows for Table and Pool clusters

Method 5 – SAP HANA Smart Data Access

Method 6 – Remote DATA Sync

  • Smart Data Streaming

Unit5 : Modeling

  • Purpose of Information Modeler
  • Levels of Modeling in SAP HANA
  • Attribute Views
  • Analytic Views
  • Calculation Views
  • Explaining Predictive Modeling
  • Discovering SAP HANA Live
  • Creating Advanced Calculation Views using GUI and SCRIPT methods
  • Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
  • Creating Calcuation Views with Dimension, Cube and STAR-Join
  • Creating Decision Tables and Analytic Previleges
  • Using Hierarchies (Level Based and Parent-Child Hierarchies)
  • Creating Restricted and Calculated Measures
  • Defining and using Filter Operations
  • Using Variables, input parameters
  • Explaining new aggregation function for measures
  • SAP HANA SQL Introduction
  • SQL Script and Procedures
  • Using Currency Conversions
  • Creating Hyperlinks
  • Persistency Considerations
  • SAP HANA Engine Overview
  • Choosing Views for HANA
  • Using SAP HANA Information Composer for Modeling
  • Processing Information Models
  • Validating Models
  • Comparing Versions of Information Objects
  • Checking Model References
  • Generate Auto Documentation
  • Understand Virtual Data Model
  • Discovering and consuming HANA Live views
  • Building a Virtual Data Model with CDS Views
  • Connecting Tables Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
  • Managing Modeling Content
  • Manage Schemas b. Import and Export data Models c. Copy Information Objects

Unit 6: Reporting

  • HANA, Reporting Layer
  • Connectivity options
  • SAP Business Objects BI 4.1
  • Designing Complex Universes in IDT based on HANA Tables and HANA Views
  • WEBi 4.0 on HANA
  • Crystal Report for Enterprise with HANA
  • Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  • SAP Business Objects BI 4.1 Explorer
  • Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
  • Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
  • Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
  • Analysis edition for Microsoft Excel, Microsoft Powerpoint
  • SAP Visual Intelligence on HANA
  • Crystal Reports via ODBC/JDBC Connections
  • Others & MS Excel 2010

Unit 7: User Management

  • Understand and Creation of Users
  • Creation of Roles and Privileges
  • Creation of Role Hierarchy
  • Generating SAP HANA Live Privileges
  • Assignment of Users to Roles
  • Authentication

Unit 8: Security and Authorizations

  • User Management and Security
  • Types of Privileges
  • Template Roles
  • Administrative

Unit 9: Concepts of SAP BW 7.4 ON HANA

  • BW 7.4 powered by SAP HANA
  • In-memory optimized Infocubes
  • In-memory optimized DSO’s
  • Migration concepts of BW 7.0 on traditional Database to BW 7.4 on SAP HANA
  • Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
  • Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool

Unit 10: Text Search and Analysis

  • Implementing Full Text Search and Text analysis
  • Defining Data Types and Full Text Indexes
  • Using Full Text Search
  • Developing Predictive Models

Unit 11: SP12 new Features and Functionality

  • SAP HANA Smart Data Access (New and Changed)
  • SAP HANA Predictive Analysis Library
  • SAP HANA Graph
  • SAP HANA Client Interfaces
  • SAP HANA XS Advanced Development
  • SAP HANA Modeling (New and Changed)
  • SAP Web IDE for SAP HANA and SAP HANA Runtime Tools
  • SAP HANA Interactive Education (SHINE) for XS Advanced




Application Fees INR 0
Total Program Fees INR 30,000
The Program Fees can also be paid in installments
Registration  Fees INR 5000 (Non-Refundable)

First installment of the Program Fees

(Needs to Paid One Week Before the Batch Start Date)

INR 12,000

Second installment of the Program Fees

(Needs To Be Paid in the 6th Class)

INR 13,000

Discount on Program Fees: 10% Early Bird Discount valid till 10/02/19

10%  Extra discount on Lumsum Payment

Batch Closed:             27th Jan 2019

New Batch Starting:  15th Feb 2019 (Few Seats Left)

2nd Batch:                   01st March 2019

Admission Open Till: 10th Feb 2019 ( If Required Seats Filled, the admissions will be closed even before the Closing Date)

Drop us a Query