SAP BI/BW Course Curriculum

Day-1: SAP BI/BW Overview

  • Data warehouse fundamentals
  • Introduction to SAP R/3, ECC and BW
  • BW architecture
  • Multi dimensional Modeling
  • Star Schema, BW extended Star Schema
  • Administrator Work Bench
  • InfoObjects ( attributes and texts and hierarchies)
  • InfoCubes, Transactional ( Real-time ) InfoCubes

    • Day-2: ODS, PSA, Update Rules

  • ODS ( DSO) -> Standard, Transactional and Write Optimized
  • PSA, Source Systems
  • InfoSource
  • InfoPackage
  • Transfer Rules
  • Update Rules
  • Transformation
  • Data Transfer Process
  • Loading Master Data using flat files

    • Day-3: Transaction Data, Managing Delta

  • Loading transaction data using flat files
  • ODS -> Change Log, Active Table and New Table
  • Managing Delta using ODS
  • MultiProviders
  • Process Chains
  • Open Hub service
  • Data Marts
  • InfoSpokes
  • Open Hub Destination
  • Aggregates

    • Day-4: Loading Master Data, Delta Management

  • Activating the Business content
  • Loading Master data from ECC
  • Delta Management
  • Various types of R3 Extractors
  • Extraction from LO Cockpit
  • User Exits
  • SAP Landscape and Transports
  • Real Time Data Acquisition
  • BEx reporting -> BEx Query Designer, Calculated and Restricted Key
  • Figures, Variables ( Characteristic, Formula and Text Variables )

    • Day-5: Query properties

  • Query properties, Exceptions and Conditions, BEx Analyzer
  • Workbooks, Report to Report Interface ( RRI )
  • Information Broadcasting
  • Web Application Designer
  • Report Designer
  • Generic Extractors
  • InfoSets
  • Slowly changing dimensions and realignments
  • Universal Data Connect ( UDC )
  • BW and XI integration
  • BW and APO integration
  • Business Planning and Simulation ( BPS )
  • Mini Project

    • Unit 1: Introduction to SAP BW/4HANA

  • SAP HANA
  • SAP BW/4HANA
  • SAP BW/4HANA Modeling Tools in Eclipse

    • Unit 2: Migration to SAP BW/4HANA

  • Migration Strategies and Tools
  • SAP BW Migration Cockpit

    • Unit 3: SAP HANA Modeling

  • SAP HANA native Modeling
  • SAP HANA Live
  • SAP S/4HANA embedded Analytics

    • Unit 4: Optimization Areas in SAP BW/4HANA

  • HANA-Optimized Data Modeling – InfoObjects
  • HANA-Optimized Data Modeling – Advanced DataStore-Objects
  • HANA-Optimized Data Modeling – CompositeProviders
  • HANA-Optimized Data Staging and Transformations
  • HANA-Optimized Analytic Manager
  • HANA-Optimized Analysis Processes

    • Unit 5: 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/4HANA Workspaces

    • Unit 6: Hybrid Modeling in Mixed Scenarios

  • Generation of external HANA-Views for BW/4HANA Objects
  • Modeling Mixed Scenarios
  • New BI Content for SAP BW/4HANA
  • Use case for Mixed Scenarios: SAP BusinessObjects Predictive Analytics

    • Unit 7: BW/4HANA Data Management

  • Multi-Temperature Data Management
  • Optimizing Data Management based on Dynamic Tiering as well as Active/Non-Active Concept
  • Optimizing Data Management based on Nearline-Storage

    • Unit 8: Data Provisioning into SAP HANA and SAP BW/4HANA

  • Overview of Data Provisioning Methods into SAP HANA
  • SAP LT Replication into SAP HANA
  • SAP HANA Smart Data Integration for SAP BW/4HANA incl. real-time Streaming
  • Operational Data Provisioning into SAP BW/4HANA
  • The new Big Data Source System