TRAINING

Enroll Now

SAP BI BW Training  

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

What you will learn in this Training Course?

• Learn about InfoObject and InfoCube in SAP
• The Data transfer process in SAP BI
• Data store objects functionality
• Learn LO-Cockpit description and Data Sources
• Business Explorer web application and query
• Using BEx Analyzer for Restrictions and Exceptions

Who should go for this Training Course?

• Business Intelligence and Data Warehousing professionals
• SAP Technical & OLAP Consultants
• Software Analysts and Mainframe professionals
• Project Managers and Business Objects Professionals
• Those aspiring for a career in SAP BI/BW

What are the prerequisites for taking this course?

Anybody can take this course without the need for any specific skill sets. Having a basic knowledge of SQL can help.

SAP BI BW Course Content

Module 1-Architecture of SAP

• SAP Landscape
• SAP Sources
• Non SAP source
• Application of SAP
• SAP Landscape SAP (AG)
• SAP BW 7.3
• Query Designing and Reporting
• SAP BOB 14.0
• SAP Hana
• SAP BODS 4.0
• Business objects of SAP LANDSCAPE
• OW BW WORKS?
• SAP BW Works
• SAP BW Works Model description
• PSA data sources
• Info provider
• Transformation & DTP
• Modeling Char & KF

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

• End to end Data warehousing module
• Modeling
• ETL
• Reporting
• SAP BW TERMS
• SAP easy access
• Data warehousing work bench
• SAP BW Simple Architecture
• Description of architecture

Module 3-Sap BW modelling

• Sap BW modelling
• CHAR and KEYE
• Source system
• SAP Source and NON SAP source
• Data source
• PSA
• INfo Providers (Info, cubes, DO, Char)
• Modelling

 Module 4-Transformation and Scheduler

• How to extract data from Flat File to SAP BW (DS) PSA
• Transformation
• ETL sources
• Internal source
• External source
• Load
• How to change data sources ZDS_EMP (FFSS-ABC)
• How to edit figure salary
• How to edit info object catalog
• Creating a Meta data of target
• How to create an application of company
• How to change Data source ZDC_D (Z file)
• Scheduler (Maintain info Package)

Module 5-Data Schema

• SAP BW-Master Data
• SAP BW-Master Data Cable
• SAP BW- Extended star schema
• SAP BW-Master data load
• Attribute of Master Data
• Text of Master data
• Hierarchies of Master data

Module 6-SAP BW-Info providers

• Characteristics of info provider
• Overview of data store object (DSO)
• Standard data store object
• Designing a standard DSO
• How to load data in DSO as an info provider
• Edit data store object
• Display data store object
• Display transformation in DSO
• Change transformation in DSO

Module 7-Data store object(DSO)-Direct object

• Functionality of DSO
• Advantage of DSO
• Drawback of DSO
• Creation of DSO

Module 8-Data store object(DSO)-write optimized

• Start and Stop SAP
• Post installation
• Hosts and Services files
• Directory Structure of SAP

Module 9-Infoset

• How to creat infoset
• Do’s and Don’ts for Infoset
• Data Models using for Infoset
• When to use Infoset?
• Join Concepts

Module 10-Info cube

• Real time info cube
• Golden rule
• Info cube structure
• Type of info cube
• How to create standard info cube
• Characteristic of info cube
• Key feature
• Info cube additional points
• Info cube design golden rules
• Star schema
• Fact table
• Extended star schema

Module 11-Multi provider and Infoset

• Virtual provider and hybrid provider
• Updates rules
• Hybrid provider

Module 12-Routines in transformations(Start & end routines)

• Trouble shooting techniques in DTPS
• Business contents (BI)
• Process chain

Module 13-What is Extraction in BW

• What is SAP ECC
• Types of SAP Extrace
• Application-Specific
• Cross-Application
• Step To Create Generic Data Source
• Procedure to Extract Data From R3 to BI
• Generic Extraction Process
• BI Side Info Package Creation

Module 14-Lo-Cockpit Description

• Lo Data Extraction
• What is event?
• Delta Initialization
• Delta Extraction
• Update Method
• Update Modes
• Setup Table
• LUV
• Delta Queue
• Lo-Cockpit Extraction
• Process of Extract

Module 16-SAP BW Reporting

• Bex Query Designer
• How to Design a Query in Bex Query Designer
• Bex Query Designer Panel
• Bex Query Designer Standard Tool Bar
• Query Element
• Other Query Element
• Query Properties
• Filter in Query Designer

Module 17-Restriction and Exceptions

• Characteristics Restriction
• New Selection
• Restricted Keyfigure
• New formula
• Structure
• Conditions
• Exceptions

Module 18 – Project – Bex Analyzer

• Drill down operation
• Apply filter on the table
• Convert the table not the chart format
• Broadcast the workbook
• Reporting etc.