SAP BW Modeling & Implementation

SAP BW Modeling & Implementation


Course Overview

Course Duration: 5 Days

  • Learn procedures within modeling of SAP Business Warehouse
  • Learn how to create a Layered Scalable Architecture"


Course Objectives
Course Content

Enterprise Data Warehouse (EDW) Architecture

  • Determining EDW Architecture
  • Planning the Architecture of an EDW
  • Using the EDW Layers
  • Determining the Purpose of the Data Mart Layers
  • Determining the Purpose of the Operational Data Store Layer

The Modeling Process

  • Identifying Decision Areas within SAP BW Projects
  • Performing Requirements Analysis
  • Creating a Logical Data Model
  • Developing the SAP BW Data Model
  • Creating Graphical Data Models and Templates

Data Modeling Practice

  • Drafting a Data Model
  • Summarizing Data Modeling Practice

BI Content Analysis

  • Listing the Uses of BI Content
  • Comparing a Data Model with BI Content

InfoObject Models

  • Listing the Tables in the SAP BW Data Model
  • Implementing Tracking History Scenarios
  • Using Reference Characteristics
  • Using Hierarchies
  • Using Key Figures
  • Creating Translation Types for Currency Translation
  • Creating Translation Types for Quantity Conversion
  • Creating a Data Model for Mapping Non-Cumulative Values in SAP BW

Modeling DataStore Objects

  • Modeling DataStore Objects
  • Using Real Time Data Acquisition (RDA)

Multi-Dimensional Modeling

  • Determining the SAP BW Star Schema
  • Designing the Dimensions of the SAP BW InfoCube

Enhanced InfoProvider Modeling

  • Modeling MultiProviders
  • Modeling an SPO
  • Modeling an InfoSet
  • Modeling a VirtualProvider
  • Modeling a HybridProvider
  • Explaining InfoProviders in SAP BW and the InfoProvider Decision Tree

Data Model Remodeling

  • Modifying a Data Model

Information Lifecycle Management

  • Describing Information Lifecycle Management


  • Determining the Advantages of SAP BW on SAP HANA
  • Determining the Enhancements of LSA++ with SAP HANA
Course Certifications

This course is part of the following Certifications:



  • BW310
  • Basic knowledge of data modeling


  • None
Course ID:

Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.