SAP BW Training

SAP BW Training enlightens how to enable streamlined data modelling, automated semantic portioning and efficiently reduce redundant execution of planning function.

SAP BW/BI Training Curriculum

Data Warehousing

This module will start with an overview of data warehousing concepts.

Introduction to Data Warehousing
Multidimensional Modeling
BW Architecture
Extended Star Schema
Introduction to BW Objects and Administrative Work Bench
Introduction to Characteristics and Key Figures
Texts Attributes Hierarchies for Master Data
Data Flow in BW (Info sources/Data Source)
Introduction to different Info Providers (Cubes/ODS etc)
Loading Data to a Data Target through flat files
Meta data repository
Data Extraction

Learn all the data extraction techniques in this module:

Extraction of data from R/3 system
Concept of Delta Queue, Introduction to different Delta Types in R/3
Debugging Extraction and Concept of Data Source in R/3
Extraction using Generic Extraction (Table/View/Info set/FM)
Extraction from FI (GL/AP), Extraction of COPA Data
Logistics Data Extraction (SD/MM)
Extraction Performance Tuning Techniques, BW Customization
At the end of the course you will get good expertise in below areas: Data modeling, Extraction techniques and creating data targets
BEx reporting
Data scheduling with Process chains
Performance tuning
Business Explorer

Understanding the concepts of reporting techniques in SAP BW training.

Introduction to Business Explorer
Understanding Bex Browser
Bex Query Designer
Bex Web Application Server
Advance Reporting/Web Reporting Techniques
Introduction to Reporting Agent (Pre calculation)
Overview of Reporting Authorization Objects and their Usage in Security
Performance Techniques for queries by using Aggregates
OLAP cache
Debugging queries using RSRT Tcode, Open HUB
Metadata repository

Learn all about master data reporting, metadata repository, data loading and transport methodology.

Introduction to Multi providers
Info set and Master Data Reporting
Introduction to Process Chains for optimal data load scheduling
Overview and Introduction of Metadata Repository
Business Content usage and Object Version
Introduction to the concept of delta for data loading process
Transport Methodology
Performance tuning (Aggregates, Compression etc)
Real time scenarios.