SAP HANA Training in Hyderabad Ameerpet


Share it now!

 

 

Training Details:

Course Duration: 50-60 hours Training + Assignments + Project Based Case Studies

Training Materials: All attendees will receive

  • Assignment after each module.
  • Notes and study material for examples covered.
  • Repository of Materials.

Pre-Requisites:

  • Basics of SQL, Database & Data Warehouse.

Who Should Join this Training?

  • Looking to start their career in SAP.
  • Looking for a career in SAP HANA Database.
  • Working as a SAP Functional consultant and wants to Change to Technical.
  • Working as a SAP BW consultant and wants to migrate to SAP HANA skills.

Education Qualification Required:

  • Any Graduate.

Training Format

  • This course is delivered as a highly interactive with extensive live examples. This course is Instructor led Class Room / Online training delivered.

Timings: All Weekdays and Weekends

Training Highlights

  • Focus on Hands on training with lot of assignments, practice exercises and quizzes
  • Assignments after each Module
  • Quality Study material
  • SQL Concepts covered for better understanding of SQL Scripting.
  • Data Replication Techniques like SAP BODS, SAP LT and DXC.
  • Various reporting Tools on SAP HANA Information Views.
  • Case Studies based on Real-time project based Scenarios
  • Certification Guidance.
SAP HANA Training institute in Ameerpet hyderabad

SAP HANA Training

Modules Covered in this Training


Module 1: Modeling

Unit 1. Introduction to SAP HANA
Unit 2. Data warehousing Concepts
Unit 3. Working with HANA STUDIO
Unit 4. HANA – Attribute View
Unit 5. HANA – Analytical View
Unit 6. HANA – Calculation View
Unit 7. Decision Tables
Module 2: SQL in HANA

Unit 8. SQL in HANA
Unit 9. Stored Procedures in HANA
Module 3: Data Provisioning

Unit 10. ETL Based Replication using SAP BODS

Unit 11. Batch Driven Replication using DXC

Unit 12. Real Time Replication using SAP LT
Module 4: Advanced Modeling

Unit 13. Hierarchies
Unit 14. Conversions

Unit 15. Analytical Privileges

Unit 16. SAP HANA TEXT Analysis

Module 5: HANA Reporting

Unit 17. Reporting using Excel

Unit 18. SAP Visual Intelligence
Unit 19. SAP BO 4.1/4.2
Unit 20. Crystal Reports
Module 5: HANA Administration

Unit 21. Creating Users and Roles
Unit 22. Security and Authorizations
Unit 23. Administration

Module 6: BW on HANA Concepts
Unit 24. Concepts of SAP BW 7.4 ON HANA
Module 7: Best Practices and Performance

Unit 25. Best Practices in HANA Modeling
Module 8: CASE STUDIES

Unit 26. COPA

Module 9:  New Enhancements

Unit 27. New Enhancements and Features in new SPS

Module 10:  CERTIFICATION GUIDANCE

 

Topics Covered

  1. MODELING

Unit 1. Introduction to SAP HANA

  • SAP HANA Introduction
  • Versions in SAP HANA
  • SAP HANA Editions
  • SAP System Landscape and Architecture

Unit 2. Data Warehousing Concepts

  • Data, Database, DBMS
  • Data Models
  • OLTP Systems
  • OLAP Systems
  • Converting ERM to MDM
  • Star Schema, Implementation of Data models

Unit 3. Working with HANA STUDIO

  • Exporting Modeling Objects and Views
  • Importing Modeling Objects and Views
  • Catalog Objects in HANA Studio
  • Content in HANA Studio
  • Packages and Sub Packages
  • Provisioning in HANA
  • Security in SAP HANA
  • Creating Package and Sub Packages

Unit 4: Creating Information Views – Attribute Views

  • Introduction to Information Views
  • Creating Attribute View
  • How data stored in SAP HANA
  • Applying Filters at the time of definition
  • Adding Calculated Columns to Attribute View
  • Creating attribute views on multiple tables

Unit 5: Creating Information Views – Analytical Views

  • Creating Analytical Views on Transaction Data
  • Creating Analytic View Representing a Multi Dimensional Model
  • Apply Filtering in Analytical View
  • Creating Variables in Analytical View
  • Adding Calculated Columns
  • Creating Restricted Columns

Unit 6: Creating Information Views – Calculation Views

  • Creating Calculation Views Graphical using Projection Node
  • Creating Calculation Views using Join Node
  • Creating Calculation Views using Union Node
  • Creating Calculation Views using Aggregation Node
  • Implementing Multi dimensional models using calculation views
  • Creating Decision Table with Return Values
  • Creating Decision Table with Update Values

Unit 7: Creating Decision Tables

  • Creating Decision Table with Return Values
  • Creating Decision Table with Update Values

Unit 8: SQL on HANA

  • Introduction to SQL in SAP HANA
  • SQL statement types
  • Filtering data
  • Joins in SQL
  • Sub Queries

Unit 9: Creating Stored Procedures

  • Stored Procedures
  • Parameter Types
  • Executing Procedure
  • Calculated Engine Functions
  • Creating Procedures under content
  • Scripted Calculation Views

Unit 10: ETL Based Replication using SAP BODS

  • Extract DATA from Excel to HANA
  • Loading Data from Flat File to HANA
  • Loading Data from Flat File to HANA
  • Using Template Table as Target
  • Loading data from SQL SERVER to HANA
  • SAP ECC to HANA
  • Import Metadata of ECC to HANA
  • Loading data from SAP ECC (multiple tables ) to HANA
  • Loading Data from BW to HANA
  • Extract Data from ECC using ABAP Workflow
  • Designing Data Flow for BW

Unit 11: Batch Driven Replication using DXC

  • Overview of the DXC
  • DXC Configuration for SAP Business Suite
  • Data Replication from SAP business system using DXC

Unit 12: Real Time Replication using SAP LT

  • Overview of the SAP Replication Server
  • Configuring SAP LT Server
  • Configuring and Monitoring Dashboard
  • SLT Based Table Data Provisioning

Unit 13: Hierarchies

  • Hierarchies – LEVEL
  • Hierarchies – Parent Child

Unit 14: Conversions

  • Difference between Copy from and Derived
  • Generating Time Data in Information Views
  • Transportation (Import and Export)
  • Currency
  • Units of Measure

Unit 15: Analytical Privileges

  • Creating Analytical Privileges
  • Assigning Analytics to Users

Unit 16: Text Analysis

  • Full Search text
  • Fuzzy Search

Unit 17: Reporting Using Excel

  • Connecting SAP HANA to MS – Excel

Unit 18. SAP Visual Intelligence

  • SAP Lumira

Unit 19: SAP Business Objects Tools BOBI 4.1/4.2

  • Introduction to Business Objects
  • Analysis for Office for OLAP
  • Dash Boards
  • Creating Web Intelligence
  • Information Design Tool

Unit 20: Crystal Reports

  • Crystal Reports 2013

Unit 21. Creating Users and Roles

Unit 22. Security and Authorizations

Unit 23. Administration

Unit 24. Concepts of SAP BW 7.4 ON HANA
Unit 25. Best Practices in HANA Modeling

Unit 26. COPA

Unit 27. New Enhancements and Features

About Trainer :

  • BO/BODS/HANA 1.0 consultant with rock solid experience in Delivery/Consulting/Assessment/Support projects with fortune 500 companies and as a Senior Consultant.
  • More than 15 years of Consulting & Teaching experience as a Corporate Trainer in BW versions (BODS 4.X), SAP BO (4.X), HANA SPS8, SPS9, SPS10).
  • With a strong background in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches around the globe.
  • Trained over 50 + batches in BODS/BO/HANA and 80% of the students accomplished in getting jobs in various domains.

 


Share it now!