BW - Enterprise Data Warehousing
COURSE OUTLINE:
This course is based on software release SAP Business Warehouse 7.4.
Certification:
- SAP Certified Application Associate - SAP Business Planning and Consolidation 10.0
- SAP Certified Application Associate - SAP Planning and Consolidation 7.5
Audience
- Application consultant
- Business analyst
- Business process owner / team lead / power user
- Program / project manager
- Technology consultant
- User
Prerequisites
- Basic knowledge of data warehousing
- Experience and sound knowledge of the subject matter in at least one SAP is recommended
- ERP application course is recommended
Learning Objectives
- Implementation and administration within a heterogeneous SAP NetWeaver BW system landscape
1. Data Warehousing
- Describing Data Warehouse Systems
- Describing Data Warehouse Architecture
- Using the Data Warehousing Workbench
2. Master Data Modeling in SAP BW
- Describing InfoObjects
- Creating Characteristic InfoObjects
3. The Loading of Master Data from SAP Data Sources
- Describing Data Flow
- Modeling a Master Data Flow
- Loading a Master Data Flow
- Modeling with the Graphical Data Flow Tool
4. Loading of Transaction Data from SAP DataSources
- Describing the Core InfoProviders
- Creating a Key Figure InfoObject
- Creating a DataStore Object (DSO)
- Loading Transaction Data into a Data Store Object
- Describing the Extended Star Schema of an InfoCube
- Creating InfoCubes
- Loading Transaction Data into an InfoCube
5. Master Data Loading from Flat File Data Sources
- Loading Data From a Flat File
- Describing the Data Flow in Detail
- Describing the Data Loading Process in Detail
6. InfoProviders in SAP BW
- Explaining the InfoProviders Used in SAP BW - Introduction
- Creating MultiProviders
7. Usage of SAP BI Content
- Using BI Content
8. Query Performance Optimization
- Optimizing Query Performance
- Monitoring Performance
- Creating and Filling Aggregates
9. The SAP BW Administration
- Describing Administrative Tasks and Tools
- Administrating the InfoCubes
- Administrating the DataStore Objects
- Creating Process Chains