SAP BW (Business Warehouse) Certification Training

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

Ratings: 3.33 / 5.00




Description

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

  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


I. MODELING

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 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3

Lesson 7: Business Content

  1. Business Content (BCT)

Lesson 8: Administration of InfoCubes and Aggregates

  1. Managing Basic Cubes

  2. Aggregates

  3. BI Accelerators

Lesson 9: DSO (DATA STORE OBJECTS)

  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


II. DATA MANAGEMENT

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

  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


III. REPORTING

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

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

Who Should Attend!

  • SAP BI/BW Consultants & Power Users
  • SAP Reports Analyst (SAP, BW-IP, BW, HANA, BPC)
  • Anyone wishing to make a career in SAP BW and Business Intelligence
  • BI & DW Engineers, Consultants, Analysts
  • Technical Consultants and Developers
  • SAP BW HANA Architects
  • SAP ABAP BI Developers & Consultants
  • SAP Analytics Cloud Consultants
  • Newbies and beginners aspiring for a career in SAP BI
  • Technical & Business Analysts
  • SAP BW Functional Consultants
  • Engineering Managers and Tech Leads
  • Data Engineers
  • Analytics Consultants
  • SAP BW Administrators
  • Application Consultants
  • Program / Project Managers