Course announcements

  • Course Availability as of February 2017
  • Learn the procedures within modeling of the BW Enterprise Data Warehouse and acquire deep knowledge about modeling and implementation of data warehousing with SAP BW 7.5.

Goals

  • This course will prepare you to:
    • Learn procedures within modeling of SAP Business Warehouse
    • Learn how to create a Layered Scalable Architecture

Audience

  • Application Consultant
  • Business Analyst
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Enterprise Architect
  • Program / Project Manager
  • Technology Consultant

Prerequisites

Essential

  • BW310H
  • Basic knowledge of data modeling

Recommended

  • None

Course based on software release

  • SAP BW 7.5 powered by SAP HANA

Content

  • Data Modeling with SAP Business Information Warehouse (SAP BW) Powered by SAP HANA
    • Understanding Modeling Targets and Issues
    • Understanding SAP HANA From a Modeling Perspective
    • Understanding SAP BW From a Modeling Perspective
    • Comparing SAP BW with SAP HANA
    • Understanding the Strategy for SAP BW on SAP HANA
  • Business Review
    • Mapping Current Processes
    • Getting to Know the ITelO Case Study
    • Understanding the Relevant Skills and Exercises
  • Global Decision Areas and Best Practice Standards
    • Evaluating Global Standards and Local Adaptations
    • Planning Transport Management
    • Separating Master Data and Transactional Data
    • Designing a Layered Scalable Architecture (LSA) with Virtual Layers
    • Understanding Scenarios for SAP BW on SAP HANA
    • Understanding LSADomains
    • Understanding Reporting Options
  • Process of Modeling
    • Defining the Sequence of SAP BW Projects
    • Planning the Phases of a SAP BW Project
    • Creating a Logical Data Model
    • Developing a SAP BW Data Model
  • Field-Based Rapid Prototyping
    • Getting an Overview SAP HANA Live
    • Overviewing Business Content
    • Implementing Field-Based Modeling
  • Master Data Modeling in SAP HANA Views
    • Using Hierarchies in SAP HANA Views
  • Transaction Data Modeling with SAP HANA
    • Using Measures in SAP HANA Views
  • Master Data Modeling with SAP BW Characteristics
    • Listing Tables in the SAP BW Data Model
    • Using Reference Characteristics
    • Using Hierarchies in SAP BW Characterisitcs
  • Key Figure Modeling in SAP BW
    • Defining Key Figures as InfoObjects
    • Creating Translation Types for Currency Translation
    • Creating Translation Types for Quantity Conversion
    • Creating a Data Model for Calculating Stock Coverage
    • Creating a Data Model for Non-Cumulative Values
  • Transactional Data Modeling in SAP BW
    • Modeling Advanced DataStore Objects (ADSOs)
    • Modeling a Composite Provider for Agile Data Mart Scenarios
    • Implementing Tracking History Scenarios
    • Modeling Transformations
  • Hybrid Modeling in Mixed Scenarios
    • Modeling Mixed Scenarios
    • Enhancing Views in SAP HANA
  • Areas of SAP BW Workspaces
    • Modeling a Workspace
  • Enhanced Scenarios in SAP BW
    • Implementing Enhanced Scenarios
  • Existing Model Enhancement
    • Converting Silos or LSAs to LSA
    • Using the SAP BW Remodeling Toolbox
    • Remodeling with an SPO in SAP BW
  • Optional: SAP BW Data Management
    • Implementing Dynamic Tiering
    • Implementing Lifecycle Management and Near-Line Storage (NLS)