SAP BW (Business Warehouse) Certification Training

About SAP BW (Business Warehouse) Certification Training

A warm welcome to the SAP BW course by Uplatz.

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

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

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

Attain knowledge in basic concepts of Data Extractions

Understand basics and advanced concepts of Reporting

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

Gain ability to perform Web Reporting using new Web Application Designer

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

Understand basic administration within SAP BW

Understand data flow within BW

SAP BW - course syllabus

I. MODELING

Lesson 1: The Multi-dimensional Model in SAP BI

The SAP BW Star Schema Concept

Data warehousing Workbench (DWB)PREVIEW

Info Objects

Info Cubes

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

3.x Dataflow

Overview of BI 7.3 Dataflow

Comparison of 3.x and BI 7.3 Data flows

Loading Master Data (Attributes, Texts, Hierarchies)

Loading Transaction Data

Lesson 3: New Data source Concept of BI 7.3

Overview of new Datasource

Emulation of Data source in BI 7.3

Datasource Lifecycle with In BI 7.3 NW 2004S

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

Lesson  4: Transformation in BI 7.3(ETL)

In depth coverage of Transformation

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

Transformation Groups

Unit and currency Conversions

Lesson 5: DTP (Data Transfer Process)

Overview of DTPS

Trouble shooting techniques in DTPS

Debugging ABAP routines Using DTPS

Lesson 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3

Lesson 7: Business Content

Business Content (BCT)

Lesson 8: Administration of InfoCubes and Aggregates

Managing Basic Cubes

Aggregates

BI Accelerators

Lesson 9: DSO (DATA STORE OBJECTS)

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

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

Lesson 10: SLT Configuration, MultiProviders and Extractions

Steps for performing SLT ConfigurationData Store Objects concept

Lesson 11: Virtual Cubes and Multi Providers

Virtual Cubes

Multi Providers

II. DATA MANAGEMENT

Lesson 1: Overview of ECC6.0 Extractions

Types of ECC extractions

Lesson 2: Generic Extractions

Generic Extraction using

Database Table

View

Classical Info sets

Functional Module

Lesson 3: Business Content Extractions

Overview of Business Content Extractions

Examples from Financial, Logistics, HRMS modules

Lesson 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)

Lesson 5: LO-COCK PIT Extractions (LOGISTICS)

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

SAP CRM extractions

Marketing Extractions

CRM SALES Extractions

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

Lesson 7: Delta Management

Business Content (BCT)

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

Managing Basic Cubes

Aggregates

BI Accelerators

Lesson 9: Datasource Enhancement

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

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

Steps for performing SLT ConfigurationData Store Objects concept

Lesson 11: Virtual Cubes and Multi Providers

Real time examples on process Chains (Meta Chains)

Multi Providers

III. REPORTING

Lesson 1: Introduction to BI Enterprise Reporting

The SAP BI Overview

Lesson 2: Navigating in Reports

Lesson 3: First Steps in Query Designer

Query Designer

Info providers in query Designer

Lesson 4: Key Figures

Restricted Key Figures

Calculated Key Figures

Properties of Key Figures

Structures and cells

Lesson 5: Characteristics

Properties and Attributes of Characteristics

Integrating attributes and hierarchies in reports

Lesson 6: Attributes

Characteristic Variables

Hierarchy variables

Hierarchy Node variables

Formula Variables

Text variables

Variable Processing types

Lesson 7: Exceptions and Conditions

Exceptions

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

In depth of Web reporting using New Web Application Designer

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:

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

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

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

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.

Data is extracted from the Source Systems.

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

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

Data is viewed at multiple dimensions in the InfoCube.

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

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