Register For Demo

Register for Demo

Live Demo Video

Live Demo Video


Watch Free Videos

Watch Free Videos


Training Calendar

Training Calender


Enrollment

Enrollment

VIDEOS TO LEARN ABOUT OUR UNIQUE TRAINING PROCESS:

ZaranTech Facebook Reviews

ZaranTech Student Certifications

ZaranTech SAP HANA Training Roadmap

Training Highlights
  • Focus on Hands on training with lot of assignments, practice exercises and quizzes
  • Assignments, Video recordings after each session posted on Training Blog
  • Quality Study material
  • Basics concepts of SAP covered for better understanding
  • Case Studies based on Real-time project based Scenarios
  • Certification Guidance
  • Certificate of Participation at the end.
Training Details
Course Duration: 45-50 hours Training + Assignments + Actual POC’s

Training Materials: All attendees will receive,

  • Assignment after each module, Video recording of every session
  • Notes and study material for examples covered.
  • Access to the Training Blog & Repository of Materials

Training Format: This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Cisco Webex Meeting center Web and Audio Conferencing tool.

Timing: Weekdays and Weekends after work hours.
How are we Different from other Training Institutes?

Role-Specific Training – Traditional training focuses on an overall business process, without regard for the individual’s role. By contrast, ZaranTech’s series of role-based courses delivers in-depth training on a specific role within the business process.

Hands-on Mentoring – Our expert trainer’s work side-by-side with each trainee and teach proven discipline and techniques for successful delivery. Mentoring is “hands-on” as part of actual projects to gain real-time experience.

Real-time Project Experience – Comprehension of practical skills is both reinforced and demonstrated in our training programs by completing Case studies of actual projects.

Certification Exams – Our trainers are all certified and provide expert industry level guidance to certification exams with tips and tricks to guarantee consistency of skills and practices for a successful completion of certification.

Ongoing Education – Zaran Tech continues to offer new courses so you can keep up-to-date on latest technologies and best practices.After reviewing your goals, and assessing your current IT skills capability, ZaranTech will tailor an after-the-training program and placement plan that will meet your needs in successful placement. This includes Resume preparation assistance, Mock interviews (technical and project based), Soft Skills and On-the-job support.
Who should Plan on Joining this program
  • Someone who has Basic computer and IT skills
  • Someone who is looking for a career in SAP HANA Database
  • Someone who is looking to start a career in SAP focussing on HANA skills
About the trainer
  • Certified HANA 1.0 consultant with exclusive experience in POC (Proof of Concept) projects with BIG 5 consulting companies and a Sr. SAP consultant.
  • More than 12 years of Consulting & Teaching experience in different modules of SAP BW versions (2.0B, 2.1, 0B, 3.1C, 3.5, BW 7.0 NW 2004S, BW 7.3), BPC 10, CRM (5.0, CRM2007), SD, ABAP/4. Primarily SAP BI with SAP Business Objects.
  • Certified SAP BO Consultant with WEBI and Crystal reports Certifications.
  • With a strong back ground in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches in US and Canada.
  • Trained over 500 students and 80% of the students accomplished in getting certification in various modules.
  • Taught more than 50 BW/BI batches in various versions 2.X, 3.0B, 3.1, 3.5, BI 7.0 NW 2004S in US and Canada for major Consulting companies like CGI, DELLOLITE, etc.
Modules Covered in this Training
Module 1. Introduction to SAP HANA
Module 2. Look & Feel
Module 3. Architecture
Module 4. Data Provisioning using Flat files, SAP BODS 4.0 and DCX
Module 5. Modeling
Module 6. Reporting
Module 7. User Management
Module 8. DATA Provisioning using SLT
Module 9. Approaching SAP HANA Modeling
Module 10. Connecting Tables
Module 11. Advanced Modeling
Module 12. Processing Information Models
Module 13. Managing Modeling Content
Module 14. Security and Authorizations
Module 15. Concepts of SAP BW 7.3 ON HANA
Module 16. SAP BI 4.0 on HANA
Module 17. Information Composer
Module 18. SAP Visual Intelligence

Attendees also learn:

1. Resume Preparation Guidelines and Tips
2. Mock Interviews and Interview Preparation Tips
   Topics Covered

Introduction

  1. Introduction to SAP HANA
  2. SAP In-Memory Strategy
  3. HANA compare to BWA

Look and Feel

  1. In-Memory Computing Studio
  2. Administration view
  3. Navigator View
  4. System Monitor
  5. Information Modeler

Architecture

  1. Architecture Overview
  2. IMCE and Surroundings
  3. Row Store
  4. Column Store
  5. Loading data into HANA
  6. Data Modeling
  7. Reporting
  8. Persistent Layer
  9. 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)

  1. BODS 4.0 Architecture in detail
  2. Data Stores in BODS
  3. Meta Data
  4. BODS Objects and components Hierarchy
  5. Building Data Flows in Designer (to Load the Data to SAP HANA)
  6. Query Transform in the Data Flow
  7. Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks)
  8. 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
  9. Creating Repository Users
  10. Creating a Local Repository
  11. Setup Central Management Server (CMC)
  12. Setup of Data Service Job Server
  13. Creating Central repository and using it
  14. 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.
  15. Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc)
  16. Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS

Method 3 – Data Provisioning using SLT

  1. Positioning and Key Concepts
  2. Overview on Configuration Aspects
  3. SLT based Transformation concepts
  4. Selective Data replication
  5. Transformation of data
  6. Extension of (target) table Structure
  7. Specific Considerations

Method 4 – Data Provisioning using Direct Extractor Connection (DCX)

  1. Using SAP provided Business Content Extractor
  2. ABAP Data Flows for Table and Pool clusters

Modeling

  1. Purpose of Information Modeler
  2. Levels of Modeling in SAP HANA
  3. Attribute Views
  4. Analytic Views
  5. Calculation Views
  6. Creating Advanced Calculation Views using GUI and SCRIPT methods
  7. Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
  8. Export & Import – Server and Client sides
  9. Using Hierarchies (Level Based and Parent-Child Hierarchies)
  10. Creating Restricted and Calculated Measures
  11. Using Filter Operations
  12. Using Variables, input parameters
  13. SAP HANA SQL Introduction
  14. SQL Script and Procedures
  15. Using Currency Conversions, Create hyperlinks
  16. Persistency Considerations
  17. SAP HANA Engine Overview
  18. Choosing Views For Information
  19. Using SAP HANA Information Composer for Modeling
  20. Procession Information Models
    1. Validating Models
    2. Comparing Versions of Information Objects
    3. Checking Model References
    4. Generate Auto Documentation
  21. Connecting Tables
    1. Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
    2. Managing Modeling Content
    1. Manage Schemas
    2. Import and Export data Models
    3. Copy Information Objects

Reporting

  1. HANA, Reporting Layer
  2. Connectivity options
  3. SAP Business Objects BI 4.0
  4. Designing Complex Universes in IDT based on HANA Tables and HANA Views
  5. WEBi 4.0 on HANA
  6. Crystal Report for Enterprise with HANA
  7. Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  8. SAP Business Objects BI 4.0 Explorer
  9. Designing Information Space based on SAP HANA Information Model using BO Explorer 4.0
  10. Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
  11. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
  12. Analysis edition for Microsoft Excel, Microsoft Powerpoint
  13. SAP Visual Intelligence on HANA
  14. Crystal Reports via ODBC/JDBC Connections
  15. Others & MS Excel 2010

User Management

  1. Creation of Users
  2. Creation of Roles
  3. Creation of Role Hierarchy
  4. Assignment of Users to Roles
  5. Authentication
  6. IMCE Authorizations

Security and Authorizations

  1. User Management and Security
  2. Types of Privileges
  3. Template Roles

Concepts of SAP BW 7.3 on HANA

  1. BW 7.3 powered by SAP HANA
  2. In-memory optimized Infocubes
  3. In-memory optimized DSO’s
  4. Migration concepts of BW 7.3 on traditional Database to BW 7.0 on SAP HANA
  5. Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
  6. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
  7. Customer Testimonials

User Management

  1. User Management (SAP BI 4.0 Integration)
  2. User Management (Single-Sign-on SSO)

HANA Certification Guidelines

  1. Sample questions and documentation for HANA certification provided (C_HANAIMP_10)

PROJECTS

  1. Designing SAP HANA Tables for Sales, Finance and Inventory scenarios
  2. Designing Attribute Views, Analytical Views and Calculations Views for Sales, Finance and Inventory scenarios
  3. Loading the Data to SAP HANA using SAP BODS (Complex BODS Dataflows)
  4. SLT Transformation of Data
  5. Reporting on Sales Data (Sales Order Header, Item, Schedule Line Reports etc.) using BI 4.0 Reporting Tools
  6. Financial Reporting (Balance Sheet Reports, Income Statements, Consolidated Income Statements, P&L Reports etc.) using BI 4.0 Reporting Tools (like Crystal Report, BO Explorer, MS Excel)
CASE STUDY # 1 – “Creation of Universe”
Creation of Universe from scratch (Manufacturing Domain):

In this Case study we will be creating a Universe from the beginning for a Manufacturing Domain. This Case Study also illustrates different types of challenges you will face while designing the Universe in the real-time working environment.

Tasks:
1. Designing the schema
2. Defining cardinalities and Joins
3. Defining Classes and Objects and setting the properties according to business requirements
4. Detecting and resolving the loops using aliases and context
5. Detecting and resolving SQL traps like chasm and fan traps
6. Applying restrictions on Objects and Using @Functions
7. Using Hierarchies and List of values and Managing Universe
CASE STUDY # 2 – “Creation of Web-i Report”
Creation of Web intelligence report with auto scheduling:

The Purpose of this Case Study is to explore all the features of Web Intelligence while working on real-time projects. Here are some of the tasks involved in creation of a Web-i report.

Tasks:
1. Creating Web Intelligence documents with queries<
2. Restricting Data returned by a Query.
3. Enhancing the presentation of data in the reports
4. Different types of Formatting Options
5. Calculating the data with Formulas and Variables.
CASE STUDY # 3 – “Creation of Corporate Dashboard”
Creation of Corporate dashboard for Supply chain mgmt (Banking Domain):

This case study is an Example of how to create the Corporate dashboard report by exploring different types of charts in Xcelcius like Line charts, Column charts, Pie Charts.