30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)

Enroll Now

Request more information


This web-based training course on SAP BW functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

SAP BI BW or SAP Business Intelligence and Business Warehousing consist of increasingly important tools in data extraction, accumulation and accounting. Modeling in SAP BW, consists of the various aspects and elements of applications, architecture, data aggregation, data schema, and more. SAP BW comes with several preconfigured tools such as data extractors, analyzers, and report consolidators. Business warehouses are similar to data warehouses in that they both involves database management, but there are significant differences, which make separate training in SAP BW a valuable investment. Professionals, managers and consultants in the field of business intelligence and business warehousing necessarily encounter the need of aforementioned skills, and SAP BW course prepares them with the ability to deal with diverse challenges in their professions. The bottleneck of Business Warehousing is modeling, and SAP BW helps to a huge extent on this aspect. The backend of BW modeling, BW administration, data transfer, etc. are taken in elaboration and inculcated pragmatically.

SAPs Business Warehouse product is a detailed tool in business intelligence, and training in the domain is a great solution for those who need to become not only acquainted with, but also proficient in, all kinds of BI tools. The main purpose of this SAP BI BW training is to establish a sturdy knowledge foundation in the respective domains, prepping students before they progress to further, more comprehensive training in business warehousing. The course uses SAP NetWeaver platform for practical learning of SAP BI and BW. Data transfer, storage, and sourcing are covered in the training, alongside learning the implementation of tools such as InfoObject, InfoCube, Business Explorer andBEx Analyzer. This course does not require any specific prior skills other than fundamental idea of data warehousing, although knowledge of basic concepts of SQL, ERP, and at least one SAP course helps to a great extent.

Introduction to Data Warehousing

  • Multidimensional Modeling
  • BW Architecture
  • Extended Star Schema
  • Introduction to BW Objects and Administrative Work Benc
  • Introduction to Characteristics and Key Figures
  • Texts Attributes Hierarchies for Master Data
  • Data Flow in BW( Info sources/Data Source)
  • Introduction to different Info Providers ( Cubes/ODS etc)
  • Loading Data to a Data Target through flat files
  • Meta data repository.

Extraction of data from R/3 system

  • Concept of Delta Queue
  • Introduction to different Delta Types in R/3
  • Debugging Extraction and Concept of Data Source in R.3
  • Extraction using Generic Extraction (Table/View/Infoset/FM)
  • Extraction from FI(GL/ AP)
  • Extraction of COPA Data
  • Logistics Data Extraction (SD/MM)
  • Extraction Performance Tuning Techniques
  • BW Customization


  • Data modeling.
  • Extraction techniques and creating data targets.
  • BEx reporting
  • Data scheduling with Process chains
  • Performance tuning

Introduction to Business Explorer

  • Understanding Bex Browser, Bex Query Designer, Bex Web Application Server
  • Advance Reporting/Web Reporting Techniques
  • Introduction to Reporting Agent (Precalculation)
  • Overview of Reporting Authorization Objects and their Usage in Security
  • Performance Techniques for queries by using Aggregates. OLAP cache
  • Debugging queries using RSRT Tcode
  • Open HUB

Introduction to Multi providers , Info set and Master Data Reporting

  • Introduction to Process Chains for optimal data load scheduling
  • Overview and Introduction of Metadata Repository
  • Business Content usage and Object Version
  • Introduction to the concept of delta for data loading process
  • Transport Methodology
  • Performance tuning( Aggregates , Compression etc)
  • Real time scenarios.

This SAP BW training is designed especially to touch upon every essential associated with business intelligence and business warehousing, including learning of SAP architecture, Business Warehouse Modeling, SAP Applications, BW Data Extraction, and SAP Data Schema. The training will cover SAP concepts of InfoObject and InfoCube, and move on to teach the BI Data Transfer Process for SAP. It further takes objects of data storage, LO-Cockpit, and Data Sources into account. And, for comprehensive practical proficiency, the course trains attending students in tools such as Business Explorer for application as well as query, and BEx Analyzer for Exceptions and Restrictions. This course is especially a must for professionals in data warehousing and business intelligence; consultants of SAP and OLP; Mainframe workers and software analysts; business object employees and project managers; and any other aspirants aiming for a career in this field.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright© 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.