SAP BW

(0 review)

Overview:

SAP BW course covers the necessary certification topics for SAP BW. It includes ETL processes, Administration, Modelling, Query Designing and Reporting, Process Chains (Automation)

As part of the curriculum, you will also be introduced to the configuration which covers BW Data Modelling, Process Chain, Data Warehouse Workbench and Reporting.

Spectators/Attendees:

  • Anyone with basic ETL, Database and Data Warehouse knowledge
  • Query/Report designers
  • Project members
  • Data Warehouse Consultants
  • Wannabe SAP Consultants
  • End Users

Objective:

  • Navigate confidently within SAP systems and understand BW Workbench.
  • Familiar with the basic concepts of Data Warehousing, Data Sources, Data Objects, Administration, Data Extraction and Reporting.
  • Acquire knowledge to set up and configure business processes in the above areas.
  • SAP Overview
    • SAP Navigation
  • Data Warehousing
    • Describing Data Warehouse Systems
    • Describing Data Warehouse Architecture
    • Using the Data Warehousing Workbench
  • Master Data Modeling in SAP BW
    • Describing InfoObjects
    • Creating Characteristic InfoObjects
  • 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
  • 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
  • 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
  • InfoProviders in SAP BW
    • Explaining the InfoProviders Used in SAP BW – Introduction
    • Creating MultiProviders
  • Query Performance Optimization
    • Optimizing Query Performance
    • Monitoring Performance
    • Creating and Filling Aggregates
  • The SAP BW Administration
    • Describing Administrative Tasks and Tools
    • Administrating the InfoCubes
    • Administrating the DataStore Objects
    • Creating Process Chains
  • BW Data Reporting
    • Restricted & Calculated Key figure
    • Filters
    • Rows & Columns
    • Free & Filter Characteristics
    • Types of Variables
    • Conditions & Exceptions
  • SAP BW Data Extraction
    • Application Specific Extractors(BW Content Extractors & Customer Generated Extractors)
    • Cross Application Specific Extractors ( Generic Extractors)
    • LIS Extraction
    • LO Extraction
    • COPA Extraction
    • Data Extraction using other tools
    • BW Data Source Enhancement
    • SAP BW Data Loading & Scheduling
  • HANA
    • SAP HANA Basics
    • SAP BW Basics
    • SAP HANA BW Modeling Tools
    • SAP HANA Native Modeling
    • SAP HANA Live
    • SAP S/4HANA embedded Analytics
  • Migration to SAP BW on HANA
    • Migration Strategies and Tools
    • SAP BW Migration Cockpit
  • BW on HANA Data Management
    • Multi-Temperature Data Management
    • Optimizing BW Data Management based on Dynamic Tiering as well as Active/Non-Active Concept
    • Optimizing BW Data Management based on Nearline-Storage
  • Optimization Areas in BW on HANA
    • HANA-Optimized Data Modeling: InfoCubes
    • HANA-Optimized Data Modeling: Advanced DataStore-Objects
    • HANA-Optimized Data Modeling: CompositeProviders
    • HANA-Optimized Data Modeling InfoObjects
    • HANA-Optimized Data Staging and Transformations
    • HANA-Optimized Analytic Manager
    • HANA-Optimized Analysis Processes
  • Modeling with SAP´s Reference Architecture LSA++
    • Review of Layered Scalable Architecture (LSA)
    • From LSA to LSA++: Streamline Core Layers
    • LSA++: Open Operational Data Store Layer based on Open ODS Views
    • LSA++: BW Workspaces
  • Hybrid Modeling in Mixed Scenarios
    • Generation of HANA-Views for BW Objects
    • Modeling Mixed Scenarios
    • HANA-Optimized BI Content
    • Use case for Mixed Scenarios: SAP BusinessObjects Predictive Analytics
  • Data Provisioning into SAP HANA and SAP BW
    • Overview of Data Provisioning Methods into SAP HANA
    • SAP LT Replication into SAP HANA
    • SAP HANA Smart Data Integration for SAP BW
    • Operational Data Provisioning into SAP BW
    • DB-Connect and Open Hub Destination

Course Features

  • Lectures 1
  • Quizzes 0
  • Duration 50 hours
  • Skill level All levels
  • Language English