Course	: Business Information Warehouse (BIW)
Type	: Instructor-led training
Duration	: 50 Hrs

Topic 1: Data Warehousing   
                              
Data Warehousing                                                                         
OLTP Vs OLA
Logical Model
Multi Dimensional modeling & Star Schema
SAP’ Extended Star Schema
Multidimensional objects modeling
SAP BW Architecture
Administrative Workbench
Components of ADW
Info Objects: Characteristics, Key Figures
Master Data – Attributes, Texts, Hierarchies
Master Data - Display vs. Navigational attributes
Info objects, Info sources, Info providers.
Info cubes – Basic, Remote
ODS Objects
Miscellaneous objects needed for data flow into BW
Data extraction from SAP source system & data flows in SAP BW
Extraction from Additional Data Sources and Data Flow in BW  
Business Content
Administration of Info Cubes and Aggregates
Data loading mechanism (Info Package groups, Process Chains)
Scheduler & Monitor
Multi Providers 
Infosets

Topic 2: BW Data Staging

BW Data staging scenarios (PSA and ODS) 
Delta type and delta methods 
Flat file extraction via the ODS

Topic 3: SAP components Extraction .  

BW Overview-SAP R/3 Extraction 
LO Data extraction using Cockpit 
CO-PA Extraction
Generic Extraction
Enhancements

Topic 4: Reporting and Analysis     

Introduction to BW Reporting 
Business Explorer Suite 
First Steps in the BEx Analyzer
Designing reports using BEx Analyzer 
Calculated and Restricted Key Figures 
Characteristics 
Variables 
Query Properties 
Exceptions and Conditions
BEx Web Application Designer 
Structuring the Layout of Web Templates
Report-Report-Interface 
Reporting on infosets, master data 

Topic 5: Important Topics

Aggregates
Compression
Roll-up
Indices
DB Statistics
Authorizations
Line Item Dimensions
Change Run
Discussing errors and how to fix them

Topic 6: SAP BI 7.0                                                                                  
Major differences between SAP BW 3.5 and SAP BI 7.0, and also hands on training on complete data flow.