Become a SAP HANA consultant



Overview of the SAP HANA course


This SAP HANA training will ensure you get a good grasp of SAP HANA fundamentals, learn and deploy real-time analytics. HANA is an on-premise application that is used for gathering real-time insights. In this SAP HANA training you will learn about SAP HANA Studio, Modeling, Security features and various other aspects. You will understand why SAP HANA is a fundamentally different database engine.

Get SAP HANA certified

Become a SAP certified SAP HANA consultant

Enquire now
  • SAP Development &BI consultants, Data warehouse professionals
  • Data analytics professionals, Database Architects, Project Managers

Introduction to SAP HANA

  • Introduction to SAP HANA
  • In-Memory Computing and SAP HANA
  • Row Vs Column store in SAP HANA
  • SAP HANA as an In-Memory Computing Solution
  • Does SAP HANA Replace BWA
  • Pros and Cons of BWA
  • Pros and Cons of SAP HANA
  • Versioning in SAP HANA

Introduction to SAP HANA Architecture

  • Architecture Overview
  • Look and feel of SAP HANA
  • In-Memory Computing Studio
  • Administration View
  • Navigator View
  • System Monitor
  • InformationModeller
  • IMCE and surroundings
  • Row Store
  • Column Store
  • Loading data into HANA
  • Data Modelling
  • Reporting
  • Partitioning
  • Parallelizing

Data Provisioning

  • Basics of Data Provisioning
  • what is Data Provisioning
  • BODS Look and Feel
  • Using BODS to load data from Flat file to SAP HANA
  • Using BODS to load data from ECC to SAP HANA
  • SLT and SAP HANA

Understanding SAP HANA Basic Modelling

  • Data: Types of data
  • Modelling with Attribute Views
  • Hierarchy Types
  • oParent child
  • oLevel hierarch
  • Modelling with Attribute Views
  • Modelling with Analytic Views

Advanced Concepts in SAP HANA Studio

  • Package
  • Calculated Attributes
  • Restricted and Calculated Measures
  • Filter and Variable Operations
  • Filters
  • Variables and Input Parameters
  • Currency Conversion
  • Personalizing Studio
  • Model Validation
  • Versioning
  • Checking Model References
  • Customizing Perspectives

Advanced Modelling


  • Understanding CE Functions -- Union, Left outer Join, Right outer Join, Inner join, Projection and Aggregation
  • SAP HANA Modelling using Calculation Views with SQL Script
  • Loading a flat file using flat file wizard to SAP HANA


  • 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
  • MS Excel 2010

User Management

  • Creation of Users
  • Creation of Roles
  • Assignment of Users to Roles
  • Authentication

Security and Authorizations

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

Persistence in SAP HANA

  • Persistent Layer
  • Back up & Recovery
  • User Management
  • Transportation



There are no prerequisites for taking up this course. Basis knowledge of SQL can help.
  1. Practical Approach
    This course includes hands-on practical exercises on the tool/Software apart from theoretical session.
  2. 24/7 system support
    EvolvingIT's support team will provide support for any issues you face with the SAP system access
  3. Real Time Use cases
    Trainers will guide you how to address real time business problems using the knowledge they have gained through their experiences.


Don’t worry we can help you make that decision, call us with your, questions, concerns and our consultants will be on hand to offer you the right course of direction.

Our career counsellors are all from SAP backgrounds, therefore this enables them, through years of their experience to advise you on the various courses we offer in developing your career.

Get Free Counselling
Become a certified SAP consultant @EvolvingIT
Seeing is believing ! Please fill in your details for a free one day demo class.