SAP BW Online Training Course Content

SAP BW Online Training Overview

SAP BW Week 1

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

SAP BW Week 2

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

SAP BW Week 3

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

SAP BW Week 4

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

Save