• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 678-701-4914

About Course:

SAP-HANA

SAP HANA is an in-memory data platform that is deployable as an appliance or in the cloud. At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to increase application performance, to reduce cost of ownership, and to enable new scenarios and applications that were not possible before. With SAP HANA, you have the opportunity to build applications that integrate the business logic, control logic, and the database layer with unprecedented performance. As a developer, one of the key questions is how you can minimize data movements. The more you can do directly on the data in memory next to the CPUs, the better the application will perform. This course will introduce you to native software development on SAP HANA.


Duration : 30 hours


Fee: 697


Job Trends

Training Calender

Date Time Type Attend
12th October 2024 8:00 AM   IST Demo
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

SAP HANA Download  

Introduction

 

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

Look and Feel

 

 

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

 

Architecture

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

Data Provisioning

Method 1 - Data Provisioning using FLAT FILES

Method 2 - Data Provisioning using BODS 4.0 (ETL Based Approach � Building AGILE Data Marts)

  • BODS 4.0 Architecture in detail
  • Data Stores in BODS
  • Meta Data
  • BODS Objects and components Hierarchy
  • Building Data Flows in Designer (to Load the Data to SAP HANA)
  • Query Transform in the Data Flow
  • Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks)
    Using Merge Transforms, Date Generation Transforms, SQL Transforms, Pivot Transforms, Reverse Pivot, Match Transform, Match Results Transform, Case Transforms, Validation Transforms, KEY Generation Transform, R Generation Transform, Table Comparison Transform, History Preservation Transform, Map operation Transform with Insert, Map Operation transform with Updates in BODS Data Flow to load the data to SAP HANA
  • Creating Repository Users
  • Creating a Local Repository
  • Setup Central Management Server (CMC)
  • Setup of Data Service Job Server
  • Creating Central repository and using it
  • Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to DSAP HANA for COPA Scenarios, FI Scenarios, Sales Scenarios, Purchasing Scenarios, Marketing Scenarios and Opportunity Scenarios and Service Scenarios.
  • SMART DATA ACCESS
    Connecting to Remote SQL SERVER using SMART DATA Access.
    Creating Calculation view Using Remote DataSource.
    SAP RIVER.
  • A) Workbench User Interface
    Replication job editor
    Datastore editor
    Data Flow editor
    Monitoring editor
    File Format editor
  • B) Information Steward
  • Getting started with Cleansing Package Builder
  • About cleansing data
  • About cleansing packages
  • Cleansing package types
  • Create cleansing packages
  • Assign standard forms and variations
  • Updating a published cleansing package
  • Viewing published cleansing packages
  • Person and firm cleansing

Method 3 - Data Provisioning using SLT

Positioning and Key Concepts

Overview on Configuration Aspects

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

Modeling

  • Purpose of Information Modeler
  • Levels of Modeling in SAP HANA
  • Attribute Views
  • Analytic Views
  • Calculation Views
  • 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
  • Export & Import - Server and Client sides
  • Using Hierarchies (Level Based and Parent-Child Hierarchies)
  • Creating Restricted and Calculated Measures
  • Using Filter Operations
  • Using Variables, input parameters
  • SAP HANA SQL Introduction
  • SQL Script and Procedures
  • Using Currency Conversions, Create hyperlinks
  • Persistency Considerations
  • SAP HANA Engine Overview
  • Choosing Views For Information
  • Using SAP HANA Information Composer for Modeling
  • Procession Information Models
  • Validating Models
  • Comparing Versions of Information Objects
  • Checking Model References
  • Generate Auto Documentation
  • Connecting Tables
  • Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
  • Managing Modeling Content
  • Manage Schemas
  • Import and Export data Models
  • Copy Information Objects

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

User Management

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

Security and Authorizations

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

User Management

  • User Management (SAP BI 4.0 Integration)
  • User Management (Single-Sign-on SSO)

 

 

 

 

 

 

Who should Learn SAP HANA?

This course is designed for Data analytics professionals, Database Architects,

SAP Development &BI consultants, Data warehouse professionals

Prerequisite to learn SAP HANA

Understanding on Data Warehousing Concepts

Knowledge of Database concepts

Delivery Methodology used to deliver the SAP HANA

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

SAP HANA FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?