SAP HANA Technology Overview

1. SAP HANA Introduction
2. Understanding the need of In Memory Technologies
3. Understanding High performance Analytics
4. In-Memory Computing
5. Hardware-Innovations
6. Software –Innovations
7. HANA Columnar Store
8. SAP HANA row store vs Columnar store
9. Understanding Columnar Storage
10. Finding SAP HANA Information Sources

SAP HANA Versions

1. HANA1.0 SPS03..... SPS12
2. HANA 2.0 SPS00 ... SPS01

SAP HANA Editions

Software Packaging

1. SAP HANA Platform Edition based Scenarios
   Software components offered
2. SAP HANA Enterprise Edition
   Software components offered

SAP HANA Deployment Scenarios

1. HANA as DataMart
2. Non-Native HANA Applications
3. Native HANA Applications
4. HANA Accelerator
5. HANA Big Data Solutions
6. HANA Edition Applications
7. Describing SAP HANA Roadmap and Scenarios

SAP HANA Studio

1. Look and Feel
2. Different Perspectives
3. Administration Console
4. Modeler
5. Application Development
6. Catalog
7. Content
8. Security

SAP HANA Implementation Landscape

1. HANA Database
2. HANA Client
3. HANA Studio
4. Data sources
5. Replication Technologies
6. Reporting Tools

SAP HANA Architecture

1. Simplified Architecture of SAP HANA
2. SAP HANA Memory Management and Data Persistence

DATA PROVISIONING

1. Data Replication –Definition
2. Data Replication Methods

Uploading Data from Flat files

1. When to use Flat file upload Functionality
2. How to load data from Flat file in Workstation
3. How to load data from Flat File in server

SAP BO-Data services

1. Introduction to BODS
2. Data services –One stop solution
3. Data Integration ,Data Quality , Data Profiling
4. Metadata management and Text data analysis
5. Working with BODS
6. BODS server
7. Repository
8. Job server
9. Management Console
10. Data services Designer
11. Creating Formats
12. Creating Datastores
13. Creating projects
14. Creating batch jobs
15. Scheduling and monitoring Batch jobs
16. Creating Dataflows
17. Creating Connection to HANA Db

Implementation Scenarios

Scenario-1

1. Loading Data from Excel File to HANA Database table
2. Loading Data from Flat File to HANA Database table
3. Using Template tables

Scenario-2

1. Loading Data from Oracle Database to HANA Database

Scenario-3

1. Loading Data from SAP ECC to HANA Database with Dataflow

Scenario-4

1. Loading Data from SAP ECC to HANA Database With ABAP Dataflow

Scenario-5

1. Loading Data from SAP BW to SAP HANA Database

Scenario-6

1. Loading Metadata from SAP ECC to HANA Database

Data Provisioning Using SLT

1. SAP Landscape Replication server for HANA
2. Key benefits of SLT replication server
3. Key benefits of Trigger-Based Approach
4. Architecture for SAP source replication
5. Architecture for Non-SAP source replication
6. Configuration and monitoring Dashboard for HANA(LTR)
7. Creating new Configuration for SAP Sources
8. Creating New Configuration for Non-SAP sources
9. Result of Creating new Configurations
10. Launching Data provisioning UI in HANA studio
11. Start Load/Replication
12. Stop/Suspend replication
13. Status Monitoring in HANA Studio
14. SLT based transformation Concept
15. Advanced replication settings
16. Change of table structuring and partitioning
17. Filtering and selective data replication

Data Provisioning using SAP Direct Extractor Connection (DXC)

1. Overview
2. DXC Concept
3. Challenges
4. DXC benefits
5. Activation mechanism for handling Delta Processing
6. Data source Extractor Concept
7. SAP Business Content Data source Extractors
8. SAP HANA DXC Connection setup and Configuration
9. Activating Data sources in Source system
10. Understanding the tables of IMDSO
11. Creating info package and Scheduling data load
12. Monitoring Data loads
13. Comparisons with other data acquisition techniques
14. DXC sidecar approach

SAP HANA Modeling

1. General DWH concepts
2. Importance of Data Modeling
3. ER model
4. Multi-Dimensional Model
5. Star Schema
6. Implementing Data models in BW
7. Implementing Data models in HANA
8. Introduction to Modeler
9. Levels of Modeling

Attribute Views (Deprecated)

1. Time Dimension Attribute Views
2. Derived Attribute Views
3. Shared Attribute Views
4. Calculated Columns
5. Hidden Attributes
6. Using Hierarchies
7. Implementing Leveled Hierarchies
8. Parent Child Hierarchies
9. Applying Filters

Analytic Views (Deprecated)

1. Multi-Dimensional Model with Analytic views
2. Calculated Measures
3. Calculated Attributes
4. Restricted Measure
5. Concept Variables and Input parameters

Calculation views

1. Graphical Calculation views
2. Create Dimension and Cube Calculation Views
3. Using Union, Join, Projection, Aggregation, Rank Nodes
4. Scripted Calculation views
5. Approaching HANA modeling
6. Choosing Views for the Information Model
7. Connecting Tables
8. Using Inner Join, Left outer Join, Right Outer Join
9. Full Outer Join, Text Join, Referential Join, Dynamic Joins

SAP HANA SQL

1. Introduction
2. SQL Elements
3. Comment and Code page
4. Functions
5. SQL Statements
6. Create table, Alter, Drop
7. Insert, Update, Delete
8. Select Statement
9. SQL script and procedures
10. Creating procedures
11. Creating Table types
12. Calling Procedures
13. Using CE-Functions
14. Control Statements

Using Currency Conversions

1. Understanding Currency Conversions in SAP HANA
2. Applying Currency Conversions

Create Decision Tables

1. Decision table for implementing Business rules
2. Decision table for What-If Analysis

Working with Web IDE

1. Creating Content procedures
2. Creating calculation views
3. Processing Information Objects
4. Validate Models
5. Compare Versions of Information objects
6. Checking Model references
7. Generate Auto Documentation
8. Managing Model Content
9. Manage Schemas
10. Import & Export Models
11. Developer Mode
12. Delivery unit mode
13. Support mode
14. Translating Metadata Text

Security and Authorizations

1. HANA privileges
2. Creating users
3. Creating Roles
4. Assigning privileges and Roles to users
5. Creating Analytic privileges
6. Migrating Analytic privileges

Reporting

1. SAP HANA Database Connectivity options
2. Relational Connection with HANA Db
3. OLAP Connection with HANA Db
4. Microsoft Excel
5. Lumira (Visual Intelligence)
6. SAP BO Analysis for Office
7. Using IDT
8. Creating Connection, Data foundation, Business layer
9. Creating Webi Documents
10. Dashboards
11. Crystal Reports for Enterprise

Virtual Data Models in SAP HANA

1. Use SAP HANA Live
2. Overview of Virtual Data Models built with Core Data Services (CDS)
3. Exploring SAP supplied virtual data models (HANA Live and CDS)
4. Getting Started with SAP HANA Live
5. Understanding the Virtual Data Model
6. Discovering and Consuming SAP HANA Live Views
7. Modifying SAP HANA Live Models
8. Building a Virtual Data Model with CDS Views
9. Define Spatial Processing, Text Search and Analysis, Predictive modeling, Graph modeling

Management and administration of Models

1. Validate Information Models
2. Transport Information Models
3. Rename, copy move models
4. Define schema mapping
5. Convert Deprecated Modeling artifacts using migration tools

Optimization of Models

1. Apply Best Practices to Model Design
2. Introduction to Plan Visualizer and Explain Plan tools