TBW60 BW Operations & Performance

Description:

In this course, participants getting enrolled will learn Basic knowledge about SAP Administration and Performance. The skills required to work in this sector is understood by students and professionals taking up this course. This in turn evokes the interest in participants towards learning the course with more interest.  

Target Audience:

• Technology Consultant
• Database Administrator
• Solution Architect

Prerequisites:

• BW310
• TBW10
• SAP Data Warehouse Experience

Software Release:

• SAP NetWeaver BW 7.4
  

Course Content:

Lesson 1: SAP Business Warehouse (BW), Business Warehouse Accelerator (BWA) and SAP HANA (High Performance Analytic Appliance) Overview

In this lesson participants learn

1.1: Identifying Components

a) Working Components

b) Updates in Components preferred in Technology

1.2: SAP BW Architecture

a) Basic Architecture

b) Levels of Components and systematic representation of hierarchy

Lesson 2: InfoProvider Administration

In this lesson participants learn

2.1: Info Cubes

a) The process of managing Info Cubes

2.2: Data Store Objects

a) The process of managing Data Store Objects

2.3: Multi Providers

a) The management of Multi providers

2.4: Hybrid Providers

a) Management of Hybrid Providers

2.5: Semantically Partitioned Objects (SPOs)

a) Management of Semantically partitioned objects

2.6: Transient Providers

a) The management process of Transient Providers

2.7: Analytical Indexes

a) Managing Analytical Indexes

2.8: Virtual Providers

a) The process of managing Virtual Providers

2.9: Real-Time Providers

a) The process of developing real time Info Cube for the purpose of storing Planning data

2.10: Creating Data Store Object for Direct Update

a) The process of newly creating a Data Store Object for Updating directly.

Lesson 3: Process Chain Administration

In this lesson participants learn

3.1: Designing Process Chain

a) The process of designing Chain

3.2: Maintaining Process Chain

a) Process Chain Maintenance

3.3: Monitoring Process Chain

a) Process Chain Monitoring

Lesson 4: Data Acquisition Administration

In this lesson participants learn

4.1: Starting Data Load Cycle

a) Data Extraction

b) Data Loading

4.2: Technical Aspects of Data Acquisition

a) Data Flow

b) Loading

4.3: Master Data Loading

a) Loading Master Data

4.4: Using Transformations

a) Source Data Conversion to load transformations

4.5: Data Load Monitoring

a) Monitor the Data Load

Lesson 5: Trace Creation with BW Trace Tool

In this lesson participants learn

5.1: Performing Traces with BW Trace Tool

a) Using BW Trace Tool

Lesson 6: Information Lifecycle Management

In this lesson participants learn

6.1: Archiving Data in Information Lifecycle Management

a) Archiving Data

b) Classical Archiving

6.2: Querying Archived Data using BW Near-Line Storage

a) Archived Data query near Line Storage

b) Data Query using BW

Lesson 7: BW Transports

In this lesson participants learn

7.1: Describing BW Transport System Landscape

a) BW Transport Structure

7.2: Determining Object Versions and Metadata

a) Meta Data description

b) Object Version

7.3: Managing BW Transport

a) Transport Management

7.4: BEX Object Transporting

a) The process of transportation of BEx Objects

7.5: Roles Transporting and Workbooks

a) Transport role description

b) Workbook description

7.6: Troubleshooting Transport Strategies

a) Identifying and assessing transport related problems

Lesson 8: Performance Management with BW InfoProvider Indexes

In this lesson participants learn

8.1: Determining Relational Data Base Management System

a) Info Cube Increase

b) Performance enhancement strategies

8.2: DBMS Indexes

a) Indexing Database

8.3: Indexing Info Providers

a) Segregating retrieved information from Database

Lesson 9: Performance Optimization for Info Providers

In this lesson participants learn

9.1: Optimizing Performance for Data Store Objects

a) Reading from Data Store Object

9.2: Optimizing Performance for Info Cubes

a) Info Cubes performance optimization.

9.3: Optimizing Performance using Semantically Partitioned Objects

a) Performance Optimization according to semantics

9.4: Optimizing Performance Using Analytical Indexes

a) Performance optimization using analytics indexing

9.5: Optimizing Performance Using Transient Providers

a) Performance optimization using querying source

9.6: Improving Query Performance with Aggregates

a) Query performance improvement

9.7: Optimizing Performance using Multi Providers

a) Performance optimization using Multi Providers

9.8: Optimizing Performance using Hybrid Providers

a) Performance optimization using Hybrid Providers

Lesson 10: Data Acquisition Performance Optimization

In this lesson participants learn

10.1: Configuring Data Acquisition Parallel Processing

a) Data Configuration

b) Parallel Processing

10.2: Improving Data Acquisition Performance

a) Methods available to increase Data acquisition

10.3: Loading and Activation Data Store Objects

a) Data Store Objects Loading

Lesson 11: Performance through Partitioning

In this lesson participants learn

11.1: Performing Table Partitioning

a) Perform Table Partitioning

Lesson 12: Performance in Reporting

In this lesson participants learn

12.1: Designing queries for Optimal Performance

a) Query designing for optimal performance

12.2: Optimizing query Performance using Online Analytical Processing (OLAP) Cache

a) Query performance optimization

12.3: Maintaining Query Read Mode Properties

a) Read Mode maintenance

Lesson 13: Performance Management with BW Statistics

In this lesson participants learn

13.1: Optimizing Performance with BW Statistics

a) Performance optimization

b) BW Statistics control

13.2: Implementing Technical Content for BW Statistics

a) Technical Content Implementation

13.3: Administering and Analyzing BW Statistics Data

a) BW Statistics settings maintenance

13.4: Monitoring with BW Administration Cockpit

a) Performance monitoring with BW Administration

Lesson 14: Performance Management with BWA

In this lesson participants learn

14.1: Optimizing Performance with BWA

a) Query optimization with BWA

14.2: Analyzing BWA Architecture

a) Listing the components

b) Explaining process

c) Architecture study

14.3: Increase Query Read Performance using BWA Indexes

a) Query Read Performance

14.4: BWA Monitoring

a) BWA Environment

Course Delivery Mode:

• Classroom Training
• Online Training – Instructor led
• Online Training- Self-paced

Course Duration:

• 25 Hours

Course Fee:

• $ 3750 USD