SAP BI BW Online Training

About SAP BI BW

SAP BI BW Online Training Course touches upon all the important aspects of the SAP Business Intelligence and Business Warehousing domains. You will be trained in SAP Architecture, SAP BW Modeling, Application of SAP, extracting data from SAP BW, and study of SAP BW Data Schema

Prerequisites

  • Business Intelligence professionals, Business Analyst, SAP BO ETL & SAP BO SQL
  • ETL and SQL developers and administrator data warehousing specialists

Terms And Conditions

  • We will Provide Supporting to resolve Student practical Issues.
  • We will provide server Access and 100% Lab Facility.
  • Resume Preparation.
  • Interview Questions & Answers.
  • We will conduct mock interviews. Student also gets 100% supporting before and after getting job.

Course Content

SAP BI BW Course Content

  • Architecture of SAP

Introduction to SAP, the SAP architecture, understanding the SAP BI landscape, understanding the SAP BI/BW, overview of SAP BW Works, the description of BW works model, understanding PSA data sources, data transfer process, Char and Key Figure Model.

  • End to end Data warehousing module and Architecture of SAP-BW

Understanding the data warehousing module, ETL and Reporting, introduction to data warehousing work bench, complete SAP BW Architecture, concepts, and description.

  • Sap BW Modelling

Introduction to SAP BW data modelling, understanding the source system, learning about SAP Source and Non SAP Source, PSA Info Providers like cubes, info, char, do modelling.

  • Transformation and Scheduler

Learning about the SAP BW Data Transformation, and Scheduler, extracting data from flat files to  SA P BW, changing data sources, difference between internal and external sources, editing info object catalog, creating and working with meta data of target, creating of company application, and working with Scheduler.

  • Data Schema

Understanding of SAP BI/BW data schema, understanding Master Data Table, learning about Extended Star Schema, master data load, attribution of master data, hierarchies and text of master data.

  • SAP BW-Info providers

Understanding the SAP BW info providers, introduction to data store object, designing and working with standard data store object, editing and displaying data store object, loading of data in DSO as an info provider, display and change transformation in DSO.

  • Data store object (DSO)-Direct object

Functionality of DSO, advantages, drawbacks and creation of DSO.

  • Data store object (DSO)-write optimized

Understanding the concept of write-optimized data store objects, learning to create write-optimized data store objects, the basic characteristics and rules.

  • Infoset

Introduction to Infoset, a specific kind of Info providers, learning about the rules of Infoset, deploying Infoset for data modelling, the Join Concept and knowing when to use Infoset.

  • Info Cubes

Understanding the multidimensional data structure, the various types of info cubes, creating a standard info cube, characteristics and key features, the most important rules for designing an info cube, understanding Star Schema, Extended Star Schema and fact tables.

  • Multi provider and Infoset

Introducing the concept of Multi provider, combining data from various info providers, the rules of updating, learning about Virtual and Hybrid providers.

  • Routines in transformations(Start & end routines)

Understanding the concept of routines in transformation, local ABAP classes, learning about the Data Transfer Process, troubleshooting techniques, process chain and business content in BI.

  • What is Extraction in BW

Learning about Data Extraction in BW, extracting data from various tables in BW, learn how to extract data from R/3 systems to BI, various types of SAP extracts – cross-application, application-specific, creating a generic data source and standard extraction procedure, creating BI Side Info Package.

  • Lo-Cockpit Description

Introduction to Logistics Cockpit data extraction, the standard extract procedure, the various concepts like event, delta initialization and extraction, the methods and modes of update, understanding Delta Queue, setup table and LUV.

  • CO-PA Extractor

Introduction to CO-PA Extractor, working with COPA data source, delta mechanisms, challenges faced while extracting data during implementation.

  • SAP BW Reporting

Introduction to SAP BW Reporting, understanding the Business Explorer, BEx query designer, the query designer panel, standard tool bar, the various query elements, query properties, filter in query designer.

  • Restriction and Exceptions

Learning about the SAP BW restrictions and exceptions, defining exceptions in BEx query designer, restricting characteristics to single value, hierarchy nodes, or value variables, understanding conditions, exceptions, restricted key figures, structure, new selection and formula.

  • Sap BI BW Project

Project – BExAnalyzer

Learning about BExAnalyzer, analytical, reporting and design tool, performing drill down operations, applying filter on tables, table to chart format conversion, workbook and reporting broadcast.

 

 

share this
Top ↑