SAP BW

Overview:
SAP BW BI stands for the SAP Business Warehouse Business Intelligence software platform. Part of the SAP Net weaver system, the BW BI component serves as the technological infrastructure and offers various analytical technologies and functions. It can transform and consolidate business information from virtually any source system.

Training Objectives of BW:
• The SAP BW System is an enterprise wide information hub, which allows you to analyze data from R/3 and non-R/3 application and present it in an Excel-Based user interface.
• OLAP technology activates the multi-dimensional analyses according to various business perspectives

Target Students / Prerequisites
• Students must be aware of Microsoft Windows graphical user interface, Windows Operating system and Office tools and must be familiar with concepts in SAP.

Course Content
Week 1
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.

Week 2
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

Week 3
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 T code
Open HUB

Week 4
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.

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.