Module -1
Introduction to Tableau and Workspace
 What is Tableau
 Features of Tableau
 Architecture of Tableau
 Installation of Tableau Desktop
 Data Window
 Toolbar, Status Bar
 Tooltips, Marks Cards and Shelves
 Reorganizing the Workspace
 Work Sheets, Dashboard and Story Board
 Changing the Repository Location
Module – 2:
Managing Data Sources
 How to Connect to a Data Source
 Extract connection & Live Connection
 Editing a Connection
 Replace Data Source
 Renaming the Connection
 Duplicating the Connection
 Refreshing the Data
 Closing the Connection
 Clipboard Data Sources
 Replacing Field References
 Connection to various data sources
 Database connectivity and tables
 ODBC and other sources connectivity
 Tableau with SAP HANA/BW

Data Types and Roles
 Data Types
 Data Roles
 Number of Records

 Latitude and Longitude,
 Measure Names & Measure values

Module – 3:

Joining Tables
 Adding Tables
 Editing Tables
 Types of joins (Inner & Right /Left/ Full Outer Joins )
Data Window Features and Functions
 Folders
 Sort
 Find Fields
 Rename Fields
 Combine Fields
 Hide or Unhide Fields
 Add Fields to the Data Window (calculation field)
Editing Field Properties
 Comments
 Aliases
 Hierarchies
 Colors
 Shapes
 Formats
 Sort
 Aggregation
 Aggregation & Disaggregation

Module – 4:
Building Data Views
 Introduction to various charts
 Introduction to Visual Analytics with Tableau
 Bar Charts, Line Graphs, Pie Charts
 Maps, Scatter Plots, Gantt Charts, Bubble Charts
 Headers, Axes
 Panes, Cells, Marks Card

 Mark Borders
 Titles, Captions
 Field Labels
 Legends
Types of Filtering
 Adding Data source Filters
 Traditional Filters
 Quick Filters
 Shared Filters / Global Filters
 Relevant Filters /Cascading
 Context Filters

Building Views Manually
 Dragging Fields
 Shelves and Cards
 Example – Building Data Views Manually
Building Views Automatically
 Show Me
 Add to Sheet: Double-Click

Module – 5:

Working with Multiple connections
 Understanding Data Blending
 Adding a Secondary Connection
 Defining/Edit Relationships
Actions
 Filter Actions
 Highlight Actions
 URL Actions
 Running Actions
 Actions on work sheets and Dashboards

 Using Field and Filter Values in Actions

Module – 6
Advanced Analysis
Creating Sets
 Statistic sets
 Dynamic sets
 Combined sets
Parameters
 Creating Parameters
 Editing Parameters
 Using Parameters in Calculations
 Using Parameters in Filters
 Using Parameters in Dim &Measures

Data Organization and Scripting
 Calculated Fields, Apply Sorting on Dimension and Measures
 Calculating Total and Subtotals
 Various Aggregated measures, Percentages
 Date and Time Functions
 Logical Functions
 Quick Table Calculations
 Custom Table Calculations
 YTD , PYTD ,MTD & PYMTD Real time Calculations
 Averages  Running totals, Window Averages
 Project real time calculations
Module – 7
Working with Multiple Measures
 Individual Axes
 Blended Axes
 Dual Axes

 Combination Charts
Forecasting
 Forecasting Constraints
 How Forecasting Works in Tableau
 To Create a Forecast
Background Images
 Adding Background Images
 Setting up the View
 Managing Background Images
Background Maps
 Geographic Roles
 Building a Map View
 Map Options
 Setting a Default Location
 Editing Locations
 Custom Geo-coding
Module – 8

Formatting
 Worksheet Level Formatting
 Formatting Specific Parts of the View
 Copying and Pasting Formatting
 Workbook Themes
 Resizing the Table
 Editing Axes
 Dashboard and Stories
 Creating a Dashboard and learning its UI component
 Changing the layout of the dashboard
 Using Device Designer to create a dashboard for devices
 Create an interactive dashboard using actions (Filter, Highlight, URL)
 Creating a story with dashboard
 Build a simple Dashboard (using Layouts and Formatting features)
 Create Interactive Dashboards using actions

Module – 9
Advance Calculations in Tableau

 Level Of Detail (LOD) Calculations
 Demonstrate calculations using Built-in Functions in Tableau
 Perform Quick Table and Level Of Detail (LOD) calculations in Tableau
 Establishing connection with R within Tableau
 Tableau with Hadoop

Module – 10

Complex Dashboards Designing
 Creating Dashboards
 Organizing Dashboards
 Understanding Dashboards and Worksheets
Saving and Exporting
 Saving Your Work
 Reverting Workbooks
 Exporting Your Work
 Copying Information between Workbooks
Tableau Online / Tableau Server
 Publishing Workbooks to Tableau Online
 Interacting with Content on Tableau Online
 Data Management through Tableau Catalog
 Powered features in Tableau Online
 Managing Permissions on Tableau Online
 Data Security with Filters in Tableau Online
 Publishing Data Sources
 Setting Permissions
 Opening Workbooks from the online/Server
 Importing Data Sources from the Server
 Exporting the Data Source Connection
 Understand Scheduling

SAP BW/BI 7.5 ON HANA

 

Unit 1: Getting Started

 

Lesson: Getting Started with our Training Environment

Lesson: Describing SAP HANA Basics

Exercise 1: Set Up SAP HANA Studio

Lesson: Getting Started with SAP BW

Exercise 2: Log On to SAP BW

Exercise 3: Use the Delta Merge in SAP BW

Lesson: Explaining SAP BW Modeling Tools in SAP HANA Studio

Exercise 4: Set Up BW Modeling Tools

Lesson: Explaining SAP HANA Modeling

Exercise 5: Create SAP HANA Information Views

Lesson: Understanding SAP HANA Live

Exercise 6: Work with the SAP HANA Live Browser

Lesson: Describing SAP S/4HANA Analytics

Unit 2:

Migration to BW on HANA

Lesson: Describing Migration Strategies and Tools

Lesson: Explaining the SAP BW Migration Cockpit

Unit 3:

BW on HANA Data Management

Lesson: Describing Multi-Temperature Data Management

Lesson: Optimizing SAP BW Data Management (Warm Data)

Exercise 7: Implement the Active/Non-Active Data Concept

Lesson: Optimizing SAP BW Data Management (Cold Data)

Exercise 8: Work with SAP BW Near-Line Storage

Unit 4: Optimization Areas in BW on HANA

Lesson: Describing Optimization Areas in SAP BW on SAP HANA

Lesson: Understanding SAP HANA-Optimized Data Modeling: InfoCubes

Exercise 9: Get Acquainted with HANA-Optimized InfoCubes

Lesson: Explaining SAP HANA-Optimized Data Modeling: Advanced DataStore-Objects

Exercise 10: Model Advanced DataStore-Objects

Lesson: Explaining SAP HANA-Optimized Data Modeling: CompositeProviders

Exercise 11: Model Composite Providers

Lesson: Explaining SAP HANA-Optimized InfoObjects

Exercise 12: Define a new InfoObject

Lesson: Explaining SAP HANA-Optimized Data Staging

Exercise 13: Work with HANA-Optimized Transformation Rules

Lesson: Describing the SAP HANA-Optimized Analytic Manager

Exercise 14: Get Acquainted with the Analytic Manager

Lesson: Introducing HANA-Optimized Analysis Processes

Exercise 15: Create a HANA Analysis Process (HAP)

 

Unit 5: Modeling with SAP’s Reference Architecture LSA++

 

Lesson: Explaining the Layered Scalable Architecture (LSA)

Lesson: Explaining the Move from LSA to LSA++: Streamlining Core Layers

Lesson: LSA++: Introducing the Open Operational Data Store Layer

Exercise 16: Create an Open ODS View on HANA Table

Exercise 17: Create an Open ODS View on Remote Data

Exercise 18: Create an Open ODS View with Association to another one

Exercise 19: Create an Open ODS View referring to InfoObjects

Exercise 20: Create an Open ODS View on BW Transformation Rule

Exercise 21: Create an Open ODS View on Advanced DataStore- Object

Lesson: LSA++: Introducing the SAP BW Workspace Layer

Exercise 22: Create a SAP BW Workspace

Exercise 23: Upload new Local Data into BW Workspace with MS Excel-lntegration

Exercise 24: Define a SAP BW Workspace Query with new Local Data

Exercise 25: Merge new local Data individually

 

Unit 6: Hybrid Modeling in Mixed Scenarios

Lesson: Generating External SAP HANA Views for SAP BW InfoProviders

Exercise 26: Create External SAP HANA Views

Lesson: Describing Mixed Scenarios

Exercise 27: Implement a Mixed Scenario

Lesson: Explaining SAP HANA-Optimized SAP Bl Content

 

Unit 7: Data Provisioning into SAP HANA and SAP BW

Lesson: Explaining Data Provisioning into SAP HANA

Exercise 28: Upload a Flat File to SAP HANA

Lesson: Describing SAP HANA Smart Data Integration Lesson: Explaining SLT Replication into SAP HANA

Exercise 29: Maintain SAP LT Replication into SAP HANA

Lesson: Explaining SLT Replication into SAP BW

Lesson: Explaining Operational Data Provisioning into SAP BW

Exercise 30: Work with ODP to SAP BW type SLT

Exercise 31: Work with ODP type SAP Extractors

Exercise 32: Work with ODP type HANA Information Views

Lesson: Explaining DB Connect and Open Hub Destination

Exercise 33: Load Data based on DB-Connect

 

Unit 8: Summary & Outlook

Lesson: Describing New Transactions and Authorizations

Lesson: Looking into the Future: SAP HANA Data Warehouse

**Please contact below undersigned for further Discussions.. Course fee, Batch Time lines, Server Access Time lines Etc

Thanks & Best Regards,

Kalyan D.

kalyan@techEtraining.com,

bolokalyan@gmail.com,

USA Desk  : +1-201 – 478 – 8484  (24 x 7)

India: +91 -800-800-4053 (whats app)

India: +91 -880-1000-880 (whats app)

Skype: techetraining

www.techEtraining.com

SAP FICO (We cover Both Finance and Controlling In-depth ) Course Content

SAP Introcution & Basic Settings

General Ledger

Creation of Accounts
Posting GL Documents
Reversal Documents
Parking Documents
Hold Documents
Recurring Documents
Foreign Currecy Valuations
Intrest Calculations

Accounts Payable & Banking
Basic Settings
Vendor Invoices
Vendor Payments
Vendor Advances( Spcl GL)
With Holding Tax
House Bank Creation
Check Management
Automatic Payment Program

Accoutns Receivable
Basic Settings
Customer Invoices
Customer Payments
Customer Advances( Spcl GL)
Intrest Calculations
Bill Discounting
Dunning
Sales Tax
Cash Journal
Bank Reconcilation

Asset Accounting
Basic Settings
Asset Master Data
Asset Transactions
Acquistions
Retirements
Scrapping
Transfers
CWIP Process

Closing Procedures

Controlling
Baisc Settings
Cost Element Accounting
Cost Center Accounting
Internal Orders
Statsticall Key Figures
Activity Types
Splitting
Planning

Integration
FI-MM Integration
FI-SD Integration

Product Costing
Basic Settings
PP Settings

SAP UI5/FIORI Course Content:

Course duration: 30 Hours

1. SAPUI5 – Introduction
2. SAPUI5 – Developing First Application
3. SAPUI5 – SAP Web IDE
4. SAPUI5 – Split Application
5. SAPUI5 – Project Structure
6. SAPUI5 – Views & Controllers
7. SAPUI5 – Models & Data Binding
8. SAPUI5 – Setting Destinations in SAP Web IDE
9. SAPUI5 – Consuming OData
10. SAPUI5 – Aggregation Binding
11. SAPUI5 – Filtering, Sorting & Grouping
12. SAPUI5 – Responsive Table
13. SAPUI5 – Internationalization
14. SAPUI5 – CSS & Images
15. SAPUI5 – Containers & Layouts
16. SAPUI5 – Mock Server
17. SAPUI5 – Formatters & Inline Expressions
18. SAPUI5 – Navigation & Routing
19. SAPUI5 – Routing in Split Screen Application
20. SAPUI5 – Fragments & Nested Views
21. SAPUI5 – Charts
22. SAPUI5 – Viz Frame Charts
23. SAPUI5 – Debugging
24. SAPUI5 – Inspector
25. SAPUI5 – Custom Controls

SAP HANA 2.0  (New Syllabus) Course Content

Course Duration :: 30 Hours

LIST OF TOPICS SAP HANA v2.0:

• Lesson 1. SAP HANA Foundation
• Lesson 2. Deployment Strategies
•                    i) On –Premise
•                   ii) On –Cloud
•                   iii) Side-Car
• Lesson 3. Architecture of SAP HANA
• Lesson 4. Replicating Data to SAP HANA
•                  i)  Business Objects Data Services (BODS)
•                  ii)  SAP Landscape Transformation (SLT)
• Lesson 5. SAP HANA Studio Interface
•                  i) Attribute View
•                 ii)Analytic View
•                iii) Calculation View
•                 iv) Catalog-Schemas,  HANALive Package
•                  v) SAP HANA-SQL Overview
•                vi) SAP HANA Transports Options
•               vii)SAP ABAP-HANA
•              viii) SAP HANA CDS Views
• Lesson 6 . SAP HANA Reporting Overview (BOBJ)
•                    i)BO WEBi
•                    ii)BO Crystal Reports Enterprise
•                    iii)BO IDT (BO UNX)
•                    iv) BO CMC (Admin-SSO)
•                     v) BO AO (Analysis Office)
•                     vi) BO Design Studio
•                    vii) SAP Lumira & Smart Business Client
•                    viii) SAP Fiori & SAP Netweaver Business Client
• Lesson 7.  SAP HANA System Monitoring & Administration
•                   i) DBA  Cockpit
•                  ii) DMO (Database Migration Option)
• Lesson 8.  SAP HANA Security & Authorization
•                  i) User Management
•                 ii) Role Management
• Lesson  9.  Advanced features Overview
•                   i) SAP HANA Web IDE
•                  ii) SAP Predictive Analytics on HANA
•                  iii) SAP BW-BPC embedded on HANA
•                  iv) SAP S/4 HANA
•                  v) Rapid Deployment Solutions (RDS) for HANA
•                 vi) SAP Activate Solution Manager  for SAP HANA
• Lesson 10. Certification Exam & Interview Preparation

Please contact
Kalyan D.
kalyan@techEtraining.com,
bolokalyan@yahoo.com,
USA Desk : +1-201 – 478 – 8484
India: +91 -880-1000-880(whats app)
Skype: techetraining
www.techEtraining.com

Bigdata(Hadoop+Spark & Scala) Course Content

Course Duration 40 Hours

BODS 4.2 Course Content

Course duration: 30 Hours
TOPICS:
Lesson 1.Architecture of BODS 4.2
 Installation
 Introduction to Repositories
 Overview of Components and Hierarchy of Objects
Lesson 2. Installation of Local Repository
 Introduction to CMC
 Registering Repository to CMC
 Adding Repository to Job Server
 Introduction to DataStores
Lesson 3.Introduction to creation of Jobs
 Create a Project, job, work flow, and data flow
 Introduction to Management Console
 Job Execution ,Scheduling using Management Console
 Understanding the Query Transform
 Use template tables
Lesson 4. Validating, tracing, and debugging jobs
 Use description and annotations
 Validate and trace jobs
 Use view data and the Interactive Debugger
Lesson 5. Defining source and target metadata
 Create a database datastore and import metadata
 Create a new file format and handle errors in file formats
 Understand extraction using Flat files,XML,Cobol Copybooks
Lesson 6. Using built-in transforms and nested data
 Use the case, merge, and validation transforms
 Use the Pivot, reverse Pivot
 Hierarchy flattening
Lesson 7. Using built-in transforms 2
 Use the SQL transform, Map Operation, and XML Pipeline
 Use the Row Generation Transform, Date Generation, Data Transfer
 MAP_CDC_Operation, Table Comparison, History Preservation
Lesson 7. Using built-in functions
 Use date and time functions and the date generation transform to build a dimension table
 Use the lookup functions to look up status in a table
 Use match pattern functions to compare input strings to patterns
 Use database type functions to return information on data sources
Lesson 8. Using Data Services Scripting Language and Variables
 Explain differences between global and local variables
 Create global variables and custom functions
 Use strings and variables in Data Integrator scripting language
Lesson 9. Change Data Capture
 Use Change Data Capture (CDC) with time-stamped sources
 Source CDC concept and working
 Target CDC concept and working
 Working with Slowly Changing Dimensions(type1,2,3)
 Create an initial and Delta load job
 Use history Preserving Transform
Lesson 9. Supporting a multi-user environment
 Describe terminology and repository types in a multi-user environment
 Introduction to Secure Central Repository and Non-Secure Central Repo
 Create and Activate the Central repository
 Create user and Privileges with Secure Central Repository
 Understand Check In,Check Out ,Get Options

Lesson 10. Profiling Data
 Set up the Data Profiler and users
 Submit a profiling task
 Monitor profiling tasks in the Administrator
Lesson 11.Handling errors and auditing
 Recover a failed job
 Create a manual, recoverable work flow
 Define audit points, rules and actions on failures
Lesson 12. Migrating Projects & Managing Metadata
 Work with projects in the central repository
 Creation of Profile Repository
 Understand Profiling
 Import and export metadata
 Use Metadata Reports
Lesson 13.Data Quality Management Lesson14.SAP Integration
 Data extraction from ECC system to File, DatabaseTables
 Extraction using ODP Extractors
 Extraction using BAPIs and Function Modules
 ABAP WorkFlows
 Extracting data from SAP BI using Openhub Services and Data services as 3rd party system.
 Working with SAP Function Modules.
 Configuration and RFC Maintenance
Lesson15.SAP Integration Part 2
 Load Data into SAP systems using IDocs
 Load Data into SAP systems using LSMWs
Lesson16. Rapid Deployment Solutions
 Understanding the AIO methodology of Data Migration
 Installation of SAP BPDM Job(best Practice Data Migration Jobs)
 Working and Architecture of the RDS
 Customizing the RDS
Lesson17.SAP Integration
 Integration of SAP HANA with BODS
 Configuring the SAP HANA Datastore
 Loading into SAP HANA(ECC,Flatfiles,Db tables)
 Working with the SAP Dataservices Workbench

SAP BPC 11.0(Embedded) Content

• Overview of BPC11.0 Embedded
  • Positioning BPC11.0, Discussing Key Terms and Components
  • Describing BPC Implementation Options
  • Introducing SAP HANA
  • Introducing BW and How it is Used for Planning
• Planning with BPC11.0 Embedded
  • Configuring advanced Data Store Objects for Planning
  • Designing Data Acquisition Solutions for Planning Scenarios
  • Designing Composite Providers for Planning
  • Designing Aggregation Levels
  • Configuring Basic Planning Functions
  • Creating Reporting and Planning Queries
  • Using Inverse Formulas
  • Using the Planning Buffer
• Using the BPC11.0 Web Client
  • Learning About the BPC11.0 Web Client Features
  • Modeling BPC Environments and Models
  • Maintaining BW Master Data
• 0 Embedded Local Planning Scenarios
  • Configuring Stand Alone Local Providers
  • Configuring Integrated Local Providers
  • Integrating Local into Global Data
• 0 Embedded Advanced Planning
  • Configuring Direct Input advanced Data Store Objects Planning
  • Setting Up Characteristic Relations
  • Creating Direct Input advanced DSO Planning Functions
  • Positioning Fox Code
  • Configuring Top Down Distribution
  • Configuring Planning Filters
  • Designing Planning Sequences
  • Loading Flat Files with Planning Functions
  • Optimizing Planning Activities including AMDPs and ABAP/4
  • Master Data on the Fly
• Analysis for Excel and Lumira Designer Edition
  • Positioning Analysis for Office
  • Learning Analysis Planning and Reporting Features
  • Using Analysis for Ad Hoc Planning and Reporting
  • Planning with Design Studio
• 0 Process Control, Administration, and Recap
  • Administering Work Status
  • Administering Data Audit
  • Administering Compression and Delta Merge
  • Positioning and Designing Business Process Flows
  • Reviewing the Key Features

Notes

• This course is revevant for the following SAP Business Planning and Consolidation (SAP BPC) applications:
  • SAP Business Planning and Consolidation, version for SAP NetWeaver. (BPC Embedded version 10.1)
  • SAP Business Planning and Consolidation, version for SAP BW/4HANA. (BPC Embedded version 11.0)

SAP HANA Administration-S/4 HANA Course Content

Course duration 30 Hours

S.No	Additional- Niche Topics as per Live Job Market Requirement which are covered in course
1	Live Hana Installation on HANA 1.0 with root user access
2	Live Upgrade from HANA 1.0 to HANA 2.0
3	Live HANA Cockpit 2.0 Installation
4	Live Tenant DB Administration
5	HANA Sizing
6	What is Suite on HANA (SOH ) and Suite For HANA (S/4H)
7	SUSE Linux Administration
8	BASIS Monitoring Sheet and Template for S4HANA
9	Understanding S4/HANA and SOH installation on HANA DB
10	SUM and SWPM Tool- DMO and approaches for conversions, Migrations and Upgrade
11	SWPM versions for products Higher than NW 7.0 and less than NW 7.0 and latest for S/4HANA
12	ODBC -JDBC Connection setup for HANA DB Integrations with SAP and Third Party Appilcations
13	ODBC -JDBC Connection setup for HANA DB -SLT Setup -Theory
14	SAP Certification Guidance Approach and Sample questions
15	SAP Certification Material HA200,HA201,HA215 ,HA240 and HA250
16	SAP Market Place Software Download , License
HA201
17	SAP HANA High Availability Features Overview
18	Explaining the SAP HANA High Availability Features
19	Exploring Disaster Recovery in SAP HANA
20	Explaining SAP HANA Scale-out
21	Scale-out and Multitenant Database Containers
22	Starting and Stopping Tenants
23	Backing up a Tenant
24	Renaming and Deleting Tenant
25	Restoring a Tenant Database
26	SAP HANA Disaster Tolerance
27	Introducing SAP HANA Disaster Tolerance
28	Setting up SAP HANA System Replication with Secondary
HA200
29	Course Overview
30	Introduction and Positioning
31	Introduction to SAP HANA
32	SAP HANA Studio
33	Architecture
34	Architecture
35	Persistence Layer
36	Installation Preparations
37	SAP HANA Sizing
38	Linux Operating System Requirements
39	SAP HANA Installation
40	Installing SAP HANA 2.0
41	Installing SAP HANA Cockpit 2.0
42	Describing Advanced Installation Options
43	Explaining a Distributed System
44	SAP HANA Multitenant Database Container Architecture
45	SAP HANA Architecture and Technology
46	SAP HANA Scenarios and Deployment Options
47	Describing SAP HANA Roadmap and Scenarios
48	Explaining SAP HANA as Primary Persistence for SAP NetWeaver-based Applications
49	Explaining SAP HANA as an Application Platform
50	Identifying Deployment Options
51	SAP HANA Cockpit 2.0
52	Introducing to HANA Cockpit 1.0
53	Using to HANA Cockpit 1.0
54	Introducing SAP HANA Cockpit 2.0
55	Configuring SAP HANA Cockpit 2.0
56	Updating SAP HANA Cockpit 2.0
57	SAP HANA Architecture
58	SAP HANA Memory Management and Data Persistence
59	Post-Installation Tasks
60	Performing Post-Installation Steps
61	Live Upgrade to SAP HANA 2.0
62	Using the Resident SAP HANA Database Lifecycle Manager Tool
63	Using SAP HANA Interactive Education
64	Explaining the Revision Strategy of SAP HANA
65	Administration Tools
66	Explaining the Administration Tools
67	Using the SAP HANA HDBSQL Command Line Tool
68	Working with the DBA/HANA Cockpit
69	Managing SAP Landscapes
70	Database Administration Tasks
71	Starting and Stopping SAP HANA
72	Checking for SAP HANA Alerts
73	Daily Database Administration Tasks
74	Configuring the SAP HANA Database
75	SAP HANA Mini Checks
76	Working with SAP HANA Traces
77	Performing SAP HANA Table Administration
78	Backup and Recovery
79	Explaining Backup and Recovery
80	Performing Data Area Backup
81	Configuring a Log Area Backup
82	Describing Additional Backup Topics
83	Performing Database Recovery
84	Creating a Fallback Snapshot
85	Explaining Backup and Recovery Using Data Snapshots
86	Explaining Database Copy
87	Security
88	Describing Security Functions
89	Explaining Encryption
90	Describing Auditing
91	Maintaining Users and Authorization
92	SAP HANA Authentication and Authorization
93	Types of Privileges
94	SAP HANA Roles
95	Administrative Tasks
96	Information Sources for Administrators
HA215
97	Emergency Analysis and Troubleshooting
98	Handling System Offline Situations
99	Handling System Hang but Reachable Situations
100	Analyzing a Suddenly Slow System
	Structural System Performance Root Cause Analysis
101	Analyzing Memory Issues
102	Analyzing CPU Issues
103	Analyzing Expensive Statements Issues
104	Analyzing Disk and I/O Issues
105	Proactive Monitoring and Performance Safeguarding
106	Configuring the SAP HANA Alerting Framework
107	Setting up SAP HANA Workload Management
108	Using SAP HANA Capture and Replay
HA240
110	SAP HANA Overview
111	Introducing SAP HANA
112	Understanding SAP HANA Implementation Scenarios
113	Describing Security Administration Tools
114	Network and Communication Security
115	Describing Communication Channels
116	Securing Data Communications
117	Certificate Management
118	Describing Certificate Management in SAP HANA
119	Data Storage Security
120	Describing Data-at-Rest Encryption
121	User Management
122	Comparing User Types
123	Describing User Administration Tools
124	Understanding User Groups
125	Authentication and Single Sign-On
126	Understanding Authentication and Single Sign-On Mechanisms
127	Authorizations
128	Describing Authorization in SAP HANA
129	Describing Privileges
130	Managing Roles
131	Analyzing Users and Authorizations
132	Viewing Information about Users and Authorizations
133	Auditing
134	Integration with SAP GRC (optional)
135	Outlining SAP GRC Integration for Governance, Risk and compliance
HA250
137	Getting Familiar with Database Migration Option (DMO)
138	Listing DMO Benefits
139	Explaining DMO Basics
140	Preparing Database Migration Option (DMO) Procedure
141	Preparing the File System for DMO
142	Examining the SUM UI
143	Configuration of Database Migration Option (DMO) Procedure
144	Starting with Roadmap Step 1 – Extraction
145	Continuing with Roadmap Step 2 – Configuration
146	Continuing with Roadmap Step 3 – Checks
147	Continuing with Roadmap Step 4 – Pre processing
148	Listing DMO Procedure Steps
149	Monitoring the Migration
150	Continuing with Roadmap Step 5 – Execution
151	Continuing with Roadmap Step 6 – Postprocessing
152	Planning Aspects of Database Migration Option (DMO)
153	Resetting the DMO Procedure
154	Tuning the DMO Downtime
155	Python Support Scripts
156	Using Python Support Scripts in SAP HANA

SAP BOBJ 4.2 with HANA Course Content

Unit 1: Overview on HANA 1.0
a. Introduction to SAP HANA Foundation
b. Deployment Options
c. Architecture
d. Understanding Columnar Data Storage
e. When to use Column store
f. When to user Row Store
g. Data Provisioning Overview

Unit 2: Overview on BOBJ 4.2
a. Into to SAP BOBJ Tools
b. Difference between Versions
c. Understanding the SAP BOBJ Architecture
d. Role of Business objects in Data Warehousing real time life cycle.
e. SAP BOBJ Admin Overview
f. SAP BOBJ Reporting overview
g. SAP BOBJ & SAP HANA Integration.

Unit 3: SAP HANA System Landscape

Unit 4: Data Provisioning Overview
Direct in HANA: Loading Data from Excel file to HANA Database without Template Tables
1. Via Business Object Data Services(BODS):
a. Loading Data from Oracle / Sql Server Database
b. Loading Data from Microsoft.DB
c. Loading Data from SAP ECC with Dataflow

2. Via SAP Landscape Transformation(SLT)
a. SAP Landscape Replication server for HANA
b. Key benefits of SLT replication server
c. Key benefits of Trigger-Based Approach
d. Architecture for SAP source replication
e. Configuration and monitoring Dashboard(T-Code:LTR)
f. Creating new Configuration for SAP Sources
g. Result of Creating new Configuration
h. Start Load/Replication
i. Stop/Suspend replication
j. Status Monitoring in HANA Studio
k. SLT based transformation Concept

Unit 5: SAP HANA Studio Overview
a. Detail overview about the options in the tool.
b. Brief about the complete dropdown menu.

Unit 6: SAP HANA Modeling
a. Data warehouse Concepts
b. Data Modeling techniques
c. Attribute Views (Standard / Derived / Time Dimension)
d. Analytical View
e. Calculation View
f. HANA Modelling Approach
g. Connecting Tables using Inner / Left outer / Right Outer / Full Outer / Text / Referential Join
h. Mass Copy
i. Migrate
j. Auto Documentation
k. Generate Time Date
l. Manage Preferences
m. Switch Ownership
n. Export and Import Models

Unit 7: SAP BO Reporting
1. Client connectivity options
2. SAP BO System Landscape Architecture.
3. MS-Excel
a. Reporting via MDX
4. SAP Lumira
a. Connect directly to SAP HANA
b. Connect through Semantic Layer (Universe)
c. Prepare Data
d. Visualize Data
e. Create Storyboards (as good as simple Dashboard)
f. Case Study to discover information
5. Semantic Layer (Universe)
a. Connect to SAP HANA using Relational Connection
b. Create Data Foundation Layer
c. Create Business Layer
d. Deep dive to Universe like resolve loops, Object Qualifications, Customizing list of values, Derived Tables etc…
e. Case Study based on Data warehouse model
6. SAP Crystal Reports and Dashboards
a. Connectivity to SAP HANA
b. Create sample reports and Dashboards
7. Webi
a. Connect to SAP HANA through Semantic Layer (Universe)
b. Create quick Ad-Hoc reports with below Functionalities
• Tables, Charts, Master Detail, Breaks, Pivot Table
• Formulas and Variables
• Apply Rankings, Conditional Formatting
• Apply Sorts
• Static and Dynamic filtering

8. Distribution to Users.
a. Send manually to various destinations like BI Inbox, Outlook Inbox, Shared Folder and FTP Destination.
b. Automate the Distribution Process to above Destinations
c. Automate the Distribution Process with data level security to above Destinations