SAP BW (Business Warehouse) Training

Become a top SAP BI/BW Consultant by learning core concepts, architecture, components, tools & features of SAP BW module

2.43 (7 reviews)


11.5 hours


Jul 2020

Last Update
Regular Price

What you will learn

Deep-dive into SAP BW/BI with demonstration of practical scenarios

Become an Technical/Analytics Consultant with command over SAP BW

Prepare for SAP BW Certification exam

Data Warehouse fundamentals

Introduction to SAP R/3, ECC and BW

BI/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

ODS ( DSO) -> Standard, Transactional and Write Optimized

PSA, Source Systems

InfoSource, InfoPackage, InfoSpokes, InfoSets

Transfer Rules, Update Rules

Transformation and Data Transfer Process

Loading Master Data using flat files

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

Open Hub Destination


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)

Query properties, Exceptions and Conditions, BEx Analyzer

Workbooks, Report to Report Interface (RRI)

Information Broadcasting

Web Application Designer

Report Designer

Generic Extractors

Slowly changing dimensions and realignments

Universal Data Connect (UDC)

BW and XI integration

BW and APO integration

Business Planning and Simulation (BPS)


SAP BW (Business Warehouse) is an end-to-end data warehousing solution from SAP with multiple features and functionality. The emerging requirements for storage and use of huge and important data has resulted in great demand for certified SAP BW professionals.

SAP BW is a data warehouse tool/application. In simple terms, it integrates data from different sources, transforms and consolidates, cleanse and stores data as well. It also includes data modeling, administration and staging area. The content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance because it’s pre-configured with intelligence about a company’s business process, providing a faster return on information. SAP BW remains open to the different source systems and is known for its ease of introduction and maintenance.

SAP Netweaver Business Warehouse (SAP NetWeaver BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing solution produced by SAP AG. It was originally named SAP BIW (Business Information Warehouse), then abbreviated to SAP BW, but is now known as "SAP BI" at the end user level. In contrast, "BW" is still used to describe the underlying Data Warehouse Area and Accelerator components.

In simple words, SAP BW/BI is leading data warehousing and reporting tool which helps transforms raw data into information and business insights. SAP BW supports better business decision-making and can be called a decision support system (DSS). Though the term SAP business intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, SAP BW (Business Warehouse) uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors.

Organizations have different kinds of data such as finance, Human resource, customer, supplier data etc., which can be stored on different kinds of storage units such as DBMS, Excel sheets, SAP R/3 systems etc. Even the company's internal data is often distributed across many different systems and is not particularly well formatted. A Data Warehouse can help to organize the data. It brings together heterogeneous Data Sources which are mostly and differing in their details. Using BI Tools one can derive meaningful reports.

The demand from end user companies needing expertise in the integration of ERP data into corporate data warehouses is growing exponentially. Thus has resulted in great opportunities for certified SAP BW professionals in defining their career path.

Uplatz provides this end-to-end training on SAP BW module. This training will put you on the path to becoming a highly proficient SAP BI/BW Analyst. Through this SAP BW course, you will master data modelling, Data Warehousing, Data Extraction, Business Explorer and Metadata Repository, Multidimensional Modeling, Data Flow in BW, Extraction of data from R/3 system, and more. This training program will help you achieve SAP BW Certification.

In SAP BW course, you will be learning the core as well as advanced concepts of SAP BW like Data Extractions, Reporting, Hybrid Providers and Data Transfer Process.

Course Objectives

  1. Gain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscape

  2. Expertise skills in Modelling concepts like DSO, DTP, and Multi-dimensional model

  3. Attain knowledge in basic concepts of Data Extractions

  4. Understand basics and advanced concepts of Reporting

  5. Enhance their knowledge in new features of SAP BW like Hybrid Provider, Open Hub Services, etc.

  6. Gain ability to perform Web Reporting using new Web Application Designer

  7. Be able to design and implement an end to end BW project

  8. Understand basic administration within SAP BW

  9. Understand data flow within BW

SAP BW - course syllabus


Lesson 1: The Multi-dimensional Model in SAP BI

  1. The SAP BW Star Schema Concept

  2. Data warehousing Workbench (DWB)PREVIEW

  3. Info Objects

  4. Info Cubes

Lesson 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S

  1. 3.x Dataflow

  2. Overview of BI 7.3 Dataflow

  3. Comparison of 3.x and BI 7.3 Data flows

  4. Loading Master Data (Attributes, Texts, Hierarchies)

  5. Loading Transaction Data

Lesson 3: New Data source Concept of BI 7.3

  1. Overview of new Datasource

  2. Emulation of Data source in BI 7.3

  3. Datasource Lifecycle with In BI 7.3 NW 2004S

  4. Migration of 3.x data source to BI 7.3 data source

Lesson  4: Transformation in BI 7.3(ETL)

  1. In depth coverage of Transformation

  2. Routines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examples

  3. Transformation Groups

  4. Unit and currency Conversions

Lesson 5: DTP (Data Transfer Process)

  1. Overview of DTPS

  2. Trouble shooting techniques in DTPS

  3. Debugging ABAP routines Using DTPS


Lesson 7: Business Content

  1. Business Content (BCT)

Lesson 8: Administration of InfoCubes and Aggregates

  1. Managing Basic Cubes

  2. Aggregates

  3. BI Accelerators


  1. DTP and its role in loading data to InfoCube in Extraction mode

  2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

Lesson 10: SLT Configuration, MultiProviders and Extractions

  1. Steps for performing SLT ConfigurationData Store Objects concept

Lesson 11: Virtual Cubes and Multi Providers

  1. Virtual Cubes

  2. Multi Providers


Lesson 1: Overview of ECC6.0 Extractions

  1. Types of ECC extractions

Lesson 2: Generic Extractions

  1. Generic Extraction using

    1. Database Table

    2. View

    3. Classical Info sets

    4. Functional Module

Lesson 3: Business Content Extractions

  1. Overview of Business Content Extractions

  2. Examples from Financial, Logistics, HRMS modules


Lesson 5: LO-COCK PIT Extractions (LOGISTICS)

Lesson 6: FI-SL Extractions (Financial special purpose ledger)

SAP CRM extractions

  1. Marketing Extractions

  2. CRM SALES Extractions

  3. CRM SERVICE Extractions (CRM Extractions are Very High in demand)

Lesson 7: Delta Management

  1. Business Content (BCT)

Lesson 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)

  1. Managing Basic Cubes

  2. Aggregates

  3. BI Accelerators

Lesson 9: Datasource Enhancement

  1. DTP and its role in loading data to InfoCube in Extraction mode

  2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

Lesson 10: Process Chains in Detail covering all process Types

  1. Steps for performing SLT ConfigurationData Store Objects concept

Lesson 11: Virtual Cubes and Multi Providers

  1. Real time examples on process Chains (Meta Chains)

  2. Multi Providers


Lesson 1: Introduction to BI Enterprise Reporting

  1. The SAP BI Overview

Lesson 2: Navigating in Reports

Lesson 3: First Steps in Query Designer

  1. Query Designer

  2. Info providers in query Designer

Lesson 4: Key Figures

  1. Restricted Key Figures

  2. Calculated Key Figures

  3. Properties of Key Figures

  4. Structures and cells

Lesson 5: Characteristics

  1. Properties and Attributes of Characteristics

  2. Integrating attributes and hierarchies in reports

Lesson 6: Attributes

  1. Characteristic Variables

  2. Hierarchy variables

  3. Hierarchy Node variables

  4. Formula Variables

  5. Text variables

  6. Variable Processing types

Lesson 7: Exceptions and Conditions

  1. Exceptions

  2. Conditions

Lesson 8: RRI (report to report interface)

Lesson 9: Bex Analyzer

Lesson 10: Bex Web Analyzer

Lesson 11: Overview of Information Broadcaster

Lesson 12: Web Reporting using new Web Application Designer

  1. In depth of Web reporting using New Web Application Designer

  2. Detail Coverage of Dash Board Reports and each and every Web item of new WAD

Detailed-level Topics

  • Introduction to the SAP Business Warehouse

  • Importance of BI Content

  • The impact of SAP HANA on BW

  • Loading ECC data into BW

  • InfoProvider types and uses

  • Understand the BW Transport and Migration Process

  • Important Transaction Codes in BW

  • Create Source Systems and DataSources

  • Navigating the Data Warehousing Workbench (RSA1)

  • Understand OLTP vs OLAP

  • Describing Data Warehouse Architecture

  • Data Modeling in SAP BW

  • Create Key Figure InfoObjects

  • Create Unit InfoObjects

  • Create Characteristic InfoObjects

  • Create InfoObject Catalogs

  • Create InfoAreas

  • Create DataStore Objects (DSOs)

  • Create InfoCubes

  • Learn SAP BW Table Structures

  • Fact tables

  • Dimension tables

  • Line-Item Dimensions

  • SID tables

  • Understand how Master data is shared

  • DSO tables (active, new data, change log)

  • PSA tables

  • Load Master Data into BW

  • Load Transactional Data into BW (DSO and Cube)

  • Describe the Extended Star Schema of an InfoCube

  • DSO activation

  • Transform your data

  • Assign an InfoObject to be an InfoProvider

  • Modeling a Master Data Flow

  • Learn various Data Flows

  • Create InfoPackages and Data Transfer Processes (DTP)

  • Learn to Optimize Query Performance (Transaction RSRT)

  • Monitor BW System Performance (SM37 / SM51 / SM66)

  • Understand Aggregates

  • Learn about the Business Warehouse Accelerator (BWA)

  • In-memory data acceleration

  • BW Administration and Monitoring

  • Explore the differences between Delta and Full DTP loads

  • Create Process Chains

  • Managing your InfoCubes and DataStore Objects

  • Administrative Tasks and Tools

Key Components of SAP BI System

Business Intelligence is a core component of SAP NetWeaver.

  • Data warehousing – This is mainly to Extract, Transform and Load data from Source systems.

  • BI platform – The BI platform layer contains BI services to support complex analysis tasks and functions. It contains the Analytic Engine, which processes the data requested through BEx analysis navigation. Its interface allows entry and manipulation of data as part of BI Integrated Planning. It also has special analysis tools such as the Analysis Process Designer (APD) and the Data Mining which provide analysts at your company with the tools to merge, mine, pre-process, store, and analyse data.

  • BI Suite – These tools helps in creating reports for analysis purpose.It contains the Business Explorer (BEx) which provides flexible reporting and analysis tools.

    The following areas in the Business Explorer can be used for Data Analyses:

    1. BEx Analyser (Microsoft Excel-based analysis tool with pivot-table-like features)

    2. BEx Web Analyser (Web-based analysis tool with pivot-table-like features)

    3. BEx Web Application Designer (customer-defined and SAP BI Content provided)

    4. BEx Report Designer (highly formatted Web output)

SAP BI/BW Architecture

Database Server: Where data is physically stored.( ODS, PSA, Infocube and metadata repository).

Application Server: The application server is based on the OLAP processor. It is used to retrieve data stored in the database server.

Presentation Server: Manages reporting and data access.

  1. Data is extracted from the Source Systems.

  2. Data is staged at the Persistent Storage Area(PSA). This holds Source like data.

  3. Data is cleansed, loaded and stored in Data Store Object.

  4. Data is viewed at multiple dimensions in the Infocube.

  5. Data is available by the OLAP processor to the Business Explorer to display data as per Analysis requirements of the Business.

  6. Data can be made available to SAP/Non-SAP, Data Marts by the Open Hub Service (InfoSpoke).

SAP BW 7.3 Certification

SAP BW 7.3 certification verifies the knowledge in the area of the SAP NetWeaver Business Intelligence solution for the consultant profile in SAP NetWeaver Business Intelligence. This certificate builds on the basic knowledge gained by a BI Consultant and preferably refined by practical experience within a BI team. The BW Consultant can implement this knowledge in the specialized areas practically in the projects.

SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 and SAP BI 4.0

SAP Certified Application Associate certification validates a professional’s ability to work on SAP BW 7.3. The trainee can apply the knowledge to implementation activities as an Application Consultant under expert supervision.

Exam Details

1. Exam duration is 180 minutes

2. There are 80 Questions

3. Passing mark is 69 percent

4. This is Associate level Certification Exam


SAP BW (Business Warehouse) Training
SAP BW (Business Warehouse) Training
SAP BW (Business Warehouse) Training
SAP BW (Business Warehouse) Training


Overview of SAP BW

Overview of SAP BW - Part 1

Overview of SAP BW - Part 2

Working on the ETL process

Working on the ETL process - Part 1

Working on the ETL process - Part 2

Practical Demonstration

Practical Demonstration

Working with the ETL Process

Working with the ETL Process - Part 1

Working with the ETL Process - Part 2

Working with the ETL Process - Part 3

How to load data in SAP BW system

How to load data in SAP BW system -Part 1

How to load data in SAP BW system - Part 2

How to load data in SAP BW system - Part 3

Creating InfoObject in BW

Creating InfoObject in BW

Creating Data Source and Loading Transaction Data

Creating Data Source and Loading Transaction Data - Part 1

Creating Data Source and Loading Transaction Data - Part 2

Working with DSO

Working with DSO - Part 1

Working with DSO - Part 2

Working with Joined Operation

Working with Joined Operation

Loading data in BW system

Loading data in BW system - Part 1

Loading data in BW system - Part 2

Creating Data Source for InfoObject

Creating Data Source for InfoObject - Part 1

Creating Data Source for InfoObject - part 2

Working with Tables in Cube

Working with Tables in Cube - Part 1

Working with Tables in Cube - Part 2

Star Schema in Data Warehousing Model

Star Schema in Data Warehousing Model


Sumit13 June 2021

How can Udemy allow such a third grade course. The teacher is teaching a student who is equally new as the teacher in the BW.

Lisa4 December 2020

This course was not a good match for me at all. It is like being stuck in a room with two men talking amongst themselves about a subject you know absolutely nothing about.


Udemy ID


Course created date


Course Indexed date
Course Submitted by