Google+

Google+

+SAP HANA Training ( School Of HANA )

SAP HANA TRAINING in Pu

ne>, Maharashtra, India , 411014, 

Best SAP HANA Training institute in Pune.

SAP HANA Project in Pune.

SAP training institute , sap HANA training institute 

HANA( High Performance Analytic Appliance)

We are proud for being one among the very few Institutes worldwide who are well equipped and Proficient in  teaching  HANA.

What is SAP HANA?

---

• SAP HANA ( High performance Analytic Appliance. ) is the latest and the fastest growing SAP technology in the market. It is based on a new type of Database which is built on In-Memory technology for generating the speedy and simple reports.

• The reports generated on HANA are up to 10,000 times faster than the regular reports. This drastic improvement is the reason why HANA is rapidly occupying world's Data-warehousing Market.

• HANA professionals are the Highest Paid ones in the IT sector. Usage of SQL scripts in HANA makes it easier to learn for those who are working in other technologies like C++, JAVA, ORACLE, .NET, MAINFRAMES etc.

Our trainer has been in SAP over past 7 years and worked on most of the technical modules of SAP and did a thorough research on SAP HANA.

HANA Consultants are the Highest Paid ones in the market and has a Huge Demand,

We are proud for being one among the very few Institutes worldwide who are well equipped and Proficient in  teaching  HANA. BI-BO-HANA is the proven successful combination. Because, simply learning HANA doesn't make sense until unless you have knowledge on where to apply your HANA skills.We teach you from the fundamentals of Data-Warehousing till the most proficient level of HANA and its associated Reporting Technologies.

Course Content

Advanced HANA Modeling 

Introduction 

• History and Fundamentals of Data-warehousing in Depth.
• Star Schema And Extended Star Schema Methodology.
• Clear picture on OLTP and OLAP systems.

SAP ABAP

• Introduction to SAP-ABAP
• ABAP programming Basics & Fundamentals of DDIC
• Understanding the ABAP Function modules and BAPIs
• Creating RFC Destinations & Remote Function Calls

SAP BI

• Introduction to SAP BI 
• Creating InfoObjects 
• Master data Upload 
• InfoCubes & DSOs
• Loading Data Into DSO and Cube From Flatfiles.
• Data Extraction From SAP ABAP tables Using Generic Extraction
• LOC Extraction
• Introduction To BI reporting
• BEx Query Designer
• BEx Analyzer & BEx Web analyzer.
• BEx reporting In depth.

Introduction to SAP HANA.

• SAP In-Memory Strategy
• HANA compare to BW 
• Architecture 
• Architecture Overview 
• IMCE and Surroundings (In memory Computing Engine)
• Row Store & Column Store 
• Installation and deployment scenarios 

Navigation

• Introduction to HANA Studio
• HANA Administration Prospective
• Modeler Prospective
• System monitoring.

LT (Landscape Transformation) OR Trigger Based Replication.

• Remote Function Calls
• Creating RFC Destinations in SAP ABAP
• Replicating SAP tables from OLTP Server using Trigger based Replication
• Real time Replication
• Job Scheduling and monitoring.
• Parallel and Multi-Thread processing.

SQL Scripts

• Data Types
• Table Creation, Modification, Updating and Deletion operations.
• SQL Select Statements
• Joins and Unions 
• String Operations
• Stored procedures
• CE (Calculation Engine) Functions.
• Aggregations and lot more.

Modeling

• Applying star schema technique in SAP HANA
• Attribute Views (Using Hierarchies and Joins in Attribute views in Depth)
• Analytic Views (Using Aggregations)
• Calculation Views
• Using Stored procedures in Calculation Views
• Aggregations in Calculation Views
• Hierarchies in Calculation Views.
• Calculation Engine Concepts in Depth.

HANA -ETL Replication Methodology

• BODS (Business Object Data services)
• JDBC & ODBC connectivity.
• Replicating data from SAP OLTP Server Using BODS
• Replicating data from Flat File Source systems
• Replicating data from BI System
• Backward replication technique.

Working with HANA on BI Platform

• Data Extraction form SAP BI into Hana-Server 
• Reporting on BI Infocubes
• BI and BODS connectivity

Transformations using BODS 

• Merge Transform
• Pivot & Reverse Pivot Transformations
• SQL Transformation
• Key Generation Transform
• Validation Transform
• Case Transform

Business Objects Central Management Console

• Creating Repository 
• Creating Data Services Repository User

SAP HANA Reporting Using MS Excel

• SAP HANA MDX Provider
• Creating ODBC Connection
• Reporting Fundamentals
• Using Filters and Hierarchies
• Graphical Reporting
• Advanced Reporting Techniques.

Reporting Using Business Object Explorer 4.0

• Creating HANA Source Systems
• Managing Info-Spaces
• Configuring & Indexing the Views
• Creating Exploration Viewset
• Creating URLs for Web-based Reporting
• Reporting with BOEx in Depth

Crystal Reports With SAP HANA

• Creating Relational Database Connection
• Reporting on HANA tables
• Reporting Against HANA Views
• Reporting Against Stored Procedures

HANA Administration

• Creating Users
• Assigning Roles 
• Authorizations
• Backup and Recovery