Impetus is dedicated to provide unique,
pragmatic and innovative career solutions


SAP HANA into five key components

Architecture:- Building a framework for storing, parsing and accelerating reporting and analytic.
Data Provisioning:- Identifying, transferring and storing source data for modeling and reporting.
Modeling:- Manipulating data for optimal analytic and performance.
Reporting:- Extracting data and translating it into meaningful information to drive business decision-making.
User Management:- Managing access and activities to protect the sanctity and privacy of data.

Introduction to SAP HANA

  • Overview of SAP HANA
  • SAP In-Memory Strategy
  • HANA compare to BWA

SAP HANA - Look and Feel

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

SAP HANA - Architecture

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

SAP HANA Data Provisioning

  • Replication Server
  • Replication Process
  • Replication Architecture
  • Data Services
  • Basic Data Service Connection Types
  • New to Data services 40
  • Full Extractor though ODP
  • Configure Import Server
  • Create and Execute a Data Service
    Job to Populate HANA

SAP HANA - Modeling

  • Purpose of Information Modeler
  • Levels of Modeling in SAP HANA
  • Attribute Views
  • Analytic Views
  • Calculation Views
  • Export and Import

SAP HANA - Reporting

  • SAP HANA, Reporting Layer
  • Connectivity Options
  • Business Objects BI 40 Explorer
  • Crystal Reports via ODBC/JDBC Connections
  • Others and MS Excel

SAP HANA Module - User Management

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


  • Data warehouse fundamentals
  • Introduction to SAP R/3, ECC and BW
  • BW architecture
  • Multi dimensional Modeling
  • Star Schema, BW extended Star Schema
  • Administrator Work Bench
  • InfoObjects ( attributes and texts and hierarchies)
  • InfoCubes, Transactional ( Real-time ) InfoCubes

ODS ( DSO) -> Standard, Transactional and Write Optimized PSA, Source Systems

  • InfoSource
  • InfoPackage
  • Transfer Rules
  • Update Rules
  • Transformation
  • Data Transfer Process
  • Loading Master Data using flat files

Loading transaction data using flat files

  • ODS -> Change Log, Active Table and New Table
  • Managing Delta using ODS
  • Multi Providers
  • Process Chains
  • Open Hub service
  • Data Marts
  • InfoSpokes
  • Open Hub Destination
  • Aggregates

Activating the Business content

  • Loading Master data from ECC
  • Delta Management
  • Various types of R3 Extractors
  • Extraction from LO Cockpit
  • User Exits
  • SAP Landscape and Transports
  • Real Time Data Acquisition
  • BEx reporting -> BEx Query Designer, Calculated and Restricted Key Figures, Variables ( Characteristic, Formula and Text Variables )

Query properties, Exceptions and Conditions, BEx Analyzer

  • Workbooks, Report to Report Interface ( RRI )
  • Information Broadcasting
  • Web Application Designer
  • Report Designer
  • Generic Extractors
  • InfoSets
  • Slowly changing dimensions and realignments
  • Universal Data Connect ( UDC )
  • BW and XI integration
  • BW and APO integration
  • Business Planning and Simulation ( BPS )


  • Office Manager Package

    This course gives hands on knowledge of the office management cycle including book keeping, accounting...

    › read more
  • Business Accounting / Book Keeping

    This course gives hands on knowledge of the accounting cycle including recording and analyzing accounting...

    › read more
  • Business Office Admin Specialist

    This Program prepares the participants users for basic administrative jobs in all fields of Office Admin and Data entry ...

    › read more
  • Project Management Professional ( PMP)

    This course gives hands on knowledge of the project management cycle from analyzing business structure ...

    › read more
  • Certified Clinical Medical Assistant

    A medical assistant performs routine administrative and clinical duties in medical offices ...

    › read more
  • Certified Medical Administrative Assistant

    Medical administrative assistants are responsible for a wide range of secretarial tasks to ensure the office...

    › read more
  • Certified Medical Coder ( ICD-10)

    ICD – 10 is a medical classification list by the World Health Organization which codes for diseases, signs, symptoms...

    › read more
  • Electronic Medical Records Specialist

    An electronic health records specialist is responsible for protecting the privacy and security of patient information....

    › read more
  • Certified Phlebotomy Technician

    A phlebotomy technician is responsible for drawing blood from patients and preparing it for further testing. This course...

    › read more
  • EKG Technician

    An EKG technician is responsible for monitoring and recording electical impulses transmitted by the heart...

    › read more
  • Web Development

    • Web pages design
    • Web development
    • Portal integration...
    › read more
  • Cyber Security (IT Security Management)

    Understand and think like the attacker – the methods and tools they will use to attack the application being designed...

    › read more