SAP HANA

SAP HANA

SAP HANA ONLINE TRAINING

  •    Rating
  •   Duration 35-40 Hours
  •      Fee $ 450

Request Free Demo

SAP HANA TRAINING VIDEOS

  •    Rating
  •   Duration 30 Hours
  •      Fee $ 350

Buy Now



What is SAP HANA Training-

 SAP HANA - platform for a new class of real-time analytics and applications

Whenever companies have to go deep within their data sets to ask complex and interactive questions, and have to go broad (which means working with enormous data sets that are of different types and from different sources) at the same time, SAP HANA is well-suited. Increasingly there is a need for this data to be recent and preferably in real-time. Add to that the need for high speed (very fast response time and true interactivity), and the need to do all this without any pre-fabrication (no data preparation, no pre-aggregates, no-tuning) and you have a unique combination of requirements that only SAP HANA can address effectively. When this set of needs or any subset thereof have to be addressed (in any combination), SAP HANA is in its elements.

SAP HANA Course Content

Week-1

Introduction SAP HANA

SAP HANA Overview

SAP In-Memory Computing Overview

SAP HANA Features

Look and feel of SAP HANA

SAP HANA Architecture

SAP HANA Landscape

Structure of SAP in-memory Computing studio

Row store and column store Architecture

Multi Version Currency Control(MVCC)

Persistence Layer in In-memory Computing Engine

Back up &Recovery

High-Availability

Distributed System

Data Provisioning options in SAP HANA

Reporting options on SAP HANA

Security options in HANA

SAP HANA Appliance Model

How SAP HANA Appliance is delivered

Sizing Considerations

SAP HANA – Licensing Options

SAP HANA Project Implementation

Overview: Key Activities

Key Roles

Key Points to keep in mind

Administration

Week-2

Basic Modeling

Modeling Overview

Terminology

SAP HANA Studio Features

Information Modeler Overview

Installation and Configuration of HANA Studio

Prerequisites for Modeling

Modeling Considerations

Levels of Modeling

Attribute Views

Analytic Views

Modeling Considerations

Joins: Different types and when to use what.

Where Class Vs Constraint Filters

HANA Studio Preview(use with Caution)

Impact of Query Execution

Demo

Modeling Suggestions

Troubleshooting Modeling Issues

Export and Import Models

Week-3

Reporting on HANA with BI 4.0

HANA Reporting Layer & Connectivity Options

Reporting on HANA Clients

Reporting on HANA Open Interfaces

Prerequisites for reporting on SAP HANA

IMDB client installation

Setting up new connection

SAP Business Objects BI4.0:Overview & tool comparison

Analytical Reporting on HANA

Relational Reporting on HANA

Reporting on HANA Demo Included

Native Excel Interface via ODBO

SAP Business Object Analysis(Office Edition)

SAP Business Object Explorer

Semantic Layer Approach

IDT Vs Universe Designer

SAP BOBJ Web I

SAP BOBJ Xcelsius

SAP Crystal Reports

Enterprise Vs 2011

Front end tool reporting considerations on top of HANA

Troubleshooting common reporting issues

Week- 4

Advanced Data Modeling with SQL Script

Modeling Overview

Calculation View :Overview & Types

SQL Script :Motivation

SQL Script: Overviewv

SQL Script Processing

Data Type Extensions

Scalar Data type

Table type

Functional Extension

Concept

Procedure

Procedure Calls

Implementing Functional logic

Operators

SQL Script/Built in Function

Debugging and troubleshooting SQL Script

Restrictions for SQL Statement

Week-5

 Data Provisioning: Data Services     

Data Provisioning :Overview

Data Provision Options

Trigger Based Replication

ETL-Based Replication

Log-Based Replication

SAP Business Objects Data Services 4.0 and HANA

ODP enabled Extractor Support in Data Services 4.0

HANA and Data Service Process flow for SAP and non-SAP data

How it works for SAP System

How it works for Non-SAP System

Advanced Data Service options

Column tables creation

Bulk loader options & config

Bulk extracting options & config

Log based replication overview

Technical system landscape

User administration

Authorization

Installing log based replication

Updating the SAP host agent on source system

Installing Sybase components

Deploying the SAP HANA load controller and related components

Configuring log based replication

Configure SAP HANA load controller on SAP HANA system

Initializing replication using SAP HANA system

Initializing replication using SAP HANA load controller

 SAP HANA 6: DATA PROVISIONING: SAP LANDSCAPE TRANSFORMATION (SLT)

Data provisioning overview

SAP landscape transformation set-up

Options for SLT landscape installation

Post installation stem

Concept of SLT replication

Architecture and key building block

Technical requirement and system set-up information for LT replication server

Key benefits of LT replicating server

Transformational capabilities

Operations

Security and user management in HANA

Creation of users

Creation of roles

Assignment privileges to roles

Assignment of users to roles

Quick Enquiry