SAP BW HANA Training Chennai

SAP BW HANA Training Chennai

  • Course Overview
SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is a revolutionary platform that’s best suited for performing real-time analytics, and developing and deploying real-time applications. At the core of this real-time data platform is the SAP HANA database which is fundamentally different than any other database engine in the market today

  • What You will Learn
Implement information models in SAP HANA Replicate data using SAP Landscape Transformation (SLT) Load data using SAP Data Services

Participants will gain the knowledge to participate in implementing, administering, and managing data integration projects. The knowledge you will acquire will form the basis for more advanced training in BW on HANA.

  • who should attend
This course is for consultants, project team members and data modellers seeking to optimize reporting performance using SAP HANA. It builds on the introduction provided in the HA100 course and teaches more advanced modelling and structuring techniques. The objective is to enable students to create ever more efficient reporting applications.

  • Application Consultants
  • Project team members
  • Data Modelling Consultants

  • Pre-requisites

  • A basic knowledge of database technology, especially relational databases and SQL query language
  • A general understanding of how columnar, in-memory databases work
  • Someone who is looking for a career in BW on HANA Platform.
  • Someone who is working as a SAP BW consultant and wants to learn SAP HANA skills.

SAP BW HANA Training Chennai

Key features

  • 40 hours of instructor-led training
  • 40 hours of high-quality eLearning content
  • 5 simulation exams (250 questions each)
  • 8 domain-specific test papers (10 questions each)
  • 30 CPEs offered
  • 98.6% pass rate

SAP BW HANA Training Chennai                 Duration :- 5 DAYS

Day 1

1.) Introduction & Overview of SAP BW Architecture based on SAP HANA DB

  • Introduction to SAP HANA
  • HANA – In Memory Computing
  • Technology overview
  • HANA – In Memory Strategy
  • HANA Architecture
  • HANA with BW
  • HANA with ECC
  • HANA administration & Security

2.) SAP Hana Studio – Basic Admin, Modelling & other studio perspective views

  • Row Store
  • Column Store
  • Persistency Layer
  • HANA Modeling studio
  • Modeling Process flow
  • Levels of Modeling in SAP HANA
  • Schema and Overview
  • Creating Tables in Data
  • Loading some sample Data from Local File
  • Normal View concept


SAP Hana – Data Provisioning – using SLT, DCX and Data services, data provisioning from non-SAP data source, persisting to non-SAP storage area ( Azure Data Lake and VORA .

  • SAP HANA database
  • HANA Data loading process
  • Loading and replication process: cont..
  • Data loading mechanism
  • Data replication process
  • Replication Server
  • Replication Architecture
  • BO Data Services data extraction
  • Introduction to Data Services


  • Data provisioning overview
  • Load, Replicate, Stop Replicate, Suspend, Resume
  • SAP landscape transformation set-up
  • Concept of SLT replication
  • Architecture and key building block
  • Technical requirement and system set-up information for LT replication server

5.) SAP HANA Modelling – Creating different kind of view( e.g. attribute,calc ),Procedures

  • Attributes Views
  • Attribute Time Based View
  • Attribute Hierarchy
  • Analytical Views
  • Calculation Views
  • Export & Import
  • Currency Conversion
  • Units Conversion
  • Procedure
  • Sequence
  • Trigger
  • Synonyms
  • Functions

 6.) SAP HANA Reporting – Reporting using MS Power BI & Lumira

  • Creating Reports on Business Objects
  • Information Desing Tool
  • WEBI
  • Lumira
  • MS Power BI
  • Using HANA Views


7.)SAP BW – Introduction , architecture (on SAP HANA), SAP BW Workbench.

8.) SAP BW – BW data warehousing, creating analytics layer(VDM) ,Info cubes and running them in SAP HANA

  • Advance DSO
  • Composite Provider
  • Open ODS View
  • Hybrid Provider
  • Transits Provider
  • SPO
  • New Data flow Feature


9.) SAP BW – OLAP preprocesser,Metadata repository,DSO ,DSO architecture.

  • Advance DSO
  • Open ODS View

10.) SAP BW –  User Authorization & information security.

  • User Management
  • Authorization
  • Groups
  • Rights

11.) SAP BW – Semantics layer, Reporting using MS PBI &LUMIRA, BO Explorer.

  • IDT
  • WEBI
  • Lumira
  • BO Explorer
  • BI launch Pad


LAB Setup for HANA:

  1. We Need to Purchase the HANA Online server.
  2. With 4GB RAM.
  3. High Speed Internet.


SAP BW HANA Training Chennai

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

1. Online ,By deposit the mildain bank account

2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.
Venue is finalized few weeks before the training and you will be informed via email. You can get in touch with our 24/7 support team for more details. Contact us Mob no:- 8447121833, Mail id: [email protected] . If you are looking for an instant support, you can chat with us too.
We provide transportation or refreshments along with the training.
Contact us using the form on the right of any page on the mildain website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

Find This Training in Other Cities:-

Kolkata,Chandigarh,Bangalore,Gurugram,Kochi ,Delhi,Tamil Nadu,

Drop Us A Query

Your Name (required)

Your Email (required)

Contact Number





good session..!!
will be useful to improve my technical Knowledge..
The concepts of the Instructor was mind-blowing…Lots of Industry examples…Very well organized…
Ajay Nunna
Nice session…!! enjoyed learning new things
Really good training. It helped me to clear a lot of doubts which were present in my mind for a long time.
“ The course content is very good and satisfactory. The trainer is also good with his teaching abilities.”
Apply the knowledge in understanding the new 11b framework setup in our system.
Apply the skill in day to day operational maintenance of our IT infrastrututre.

Related Courses

Popular Courses