SAP BI BW Online Training

SAP BI BW Online Training

SAP BI BW Online Training
SAP BI BW Online Training

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 Info Objects: Characteristics
  • Creating Info Objects: Key Figures
  • Creating Data Store objects
  • Creating Info Cubes
  • Creating Info Sets
  • Creating Multi Providers

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 Info Cube
  • 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
  • In-completion 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


  • 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, Check boxes, Drop down Box and other web items and their attributes


  • 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)

Drop your query

What my Client's Say?


  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim