BW - Enterprise Data Warehousing

Goals

Participants will gain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscape The knowledge you will acquire will form the basis for more advanced courses in the BW curriculum

Module 1: Data Warehousing

Describing Data Warehouse Systems. Describing Data Warehouse Architecture

Using the Data Warehousing Workbench

Module 2: Master Data Modeling in SAP BW

Describing InfoObjects

Creating Characteristic InfoObjects

Module 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

Module 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

Module 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

Module 6: InfoProviders in SAP BW

Explaining the InfoProviders Used in SAP BW – Introduction

Creating MultiProviders

Module 7: Usage of SAP BI Content

Using BI Content

Module 8: Query Performance Optimization

Optimizing Query Performance. Monitoring Performance

Creating and Filling Aggregates

Module 9: The SAP BW Administration

Describing Administrative Tasks and Tools

Administrating the InfoCubes

Administrating the DataStore Objects. Creating Process Chains