BW - Enterprise Data Warehousing



This course is based on software release SAP Business Warehouse 7.4.


  • SAP Certified Application Associate - SAP Business Planning and Consolidation 10.0
  • SAP Certified Application Associate - SAP Planning and Consolidation 7.5


  • Application consultant
  • Business analyst
  • Business process owner / team lead / power user
  • Program / project manager
  • Technology consultant
  • User


  • 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