SAP BI BW Online Training Course Content

Enterprise Data Warehousing

  • Introduction and OLAP concepts
  • OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP

Data Modeling

  • Creating InfoObjects: Characteristics
  • Creating InfoObjects: Key Figures
  • Creating DataStore objects
  • Creating InfoCubes
  • Creating InfoSets
  • Creating MultiProviders

Data Extraction and Monitoring:

  • For SAP source systems: Maintaining Data Sources
  • Or for files: Creating Data Sources for File Source Systems
  • Creating transformations
  • Using the data mart interface
  • Creating open hub destinations
  • Creating data transfer processes
  • Creating process chains
  • Checking process chain runs
  • Jobs Scheduling
  • Monitor for extraction processes and data transfer processes

Business Content and Metadata Repository

  • Installing BI Content
  • Exploring the metadata

Performance optimization

  • Creating the first aggregate for an InfoCube
  • Using the BIA index maintenance wizard
  • BW Statistics: Query Analysis Tools, Performance Tables
  • Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
  • Aggregates: Creating Aggregates, Finding effective aggregates
  • Data Load Performance: Parallelism, Impact of Aggregates
  • Partitioning: Logical Partitioning, Table Partitioning

Basic Functions

  • Condition Technique
  • Pricing with Scales
  • Free Goods (Inclusive & Exclusive types)
  • Material Determination
  • Material Listing /Exclusion
  • Dynamic Product Proposal
  • Cross Selling
  • Partner Determination
  • Account Determination
  • Output Determination
  • TEXT Determination
  • Credit Management / Risk Management
  • Availability Check and TOR
  • Incompletion Log

BI SUITE: Business Explorer
BEx Query Designer

  • Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
  • Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
  • Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
  • Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key
    Figures
  • Structures: Creating Re-usable structures
  • Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

Web Application Designer

  • WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
  • Web Applications: Creating Web Applications, Settings, Style sheets, Symbols and
    Properties
  • Design: Designing the Layout of Web Templates, working with Library for Web Items
  • Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their
    attributes

Activities

  • Analyzer
  • BEx Web Application Designer
  • BEx Report Designer

Career Related Support

  • Resume Building with sample resumes
  • Frequently asked interview questions
  • Common Production Issues

Advanced Topics (Bonus)

  • Information Broadcasting
  • Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
  • User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
  • Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.
  • Overview of Planning with SEM-BPS.
  • Architecture of BPS components.

Technical Knowledge

  • Reports
  • IDOC
  • Tables

Additional Topics

  • SD Evaluation Test
  • General Discussion related to SAP SD interview.

Experiences from Implementations (Case Studies/Project)