SAP BIW/BI Course Content online training and class room training

SAP BW / BI (7.4& 7.5) Training course contents 
Modeling:

1. SAP Net Weaver and BI: Overview, Positioning and Fundamentals

i.       Fundamentals of Data warehousing and Business Intelligence

ii.      SAP Netweaver Business Intelligence (BI) overview

iii.     SAP Netweaver Solution Delivery: IT Practices, scenarios and usage Types

iv      SAP NetWeaver Business Intelligence: Data Warhousing Overview.

 2.  Objects in the BI Data Warehouse Layer

i      Data Warehousing Workbench

ii     Infoproviders: Business Purpose

iii     Infoobjects: Characteristics

iv     Infoobjects: Key figures

v     The BI Infocube: An extended Star Schema

vi    Creating Infocubes

 ૩   Data Acquisition and Transformation from SAP Source Systems
aData Flow: Overview
 
bLoading Master Datasource from an SAP source System

cLoading Transaction Datasource from an SAP source System

4 Data Acquisition from other systems

aExtraction from Non sap systems: Overview

bFlat file Loading

5 BI Content

aBI content discovery

bBI content Activation

6 Other Infoproviders

aDatastore objects

bVirtual providers and Real time data acquisition

cMultiprovider and BI Infoset

7 Administration of Data Targets

aSystem administration tasks in BI: Overview

bAdministration of infocubes

cAdministration of Datastore objects

dProcess chains

8 Introduction to query Performance Optimization

aIntroduction to query Performance Optimization in BI

bBI Aggregates

cBI Accelerator

Reporting

1.         Introduction to BI Enterprise reporting

2.         Navigation in reports

3.         First steps in the Bex query designer

           Query designer

            Infoprovider in the Bex query designer

4.         Key figures

a.         Restricted Keyfigures

b.         Calculated keyfigures

c.         Properties of Keyfigures

d.         Structures and cells

5.         Characteristics

a.         Properties and attributes of characteristic

b.         Integrating hierarchies into report

c.         Creating user defined hierarchy

6.         Variables

7.         Exception and conditions

8.         Bex analyzer

9.         Bex web analyzer

10.       Information broadcasting

a.         Information broadcasting overview

b.         Bex broadcaster

c.         Workbook precalculator

11.       Enterprise portal integration

12.       Document integration

13.       Report –report interface

14.       Managing query objects

15.       Business content

16.       Further SAP BI reporting tool.

Advance Modeling and Extraction
1.         Overview of BI

a.         Overview of data acquisition

b.         Bi content

2.         Data flow in data acquisition

a.         Data flow summary

b.         Transformation process

c.         Direct access to source system

d.         Real time data acquisition

3.         Data acquisition in Service API

a.         Connecting SAP source system to BI system

b.         Basic of the BI S API

c.         Transfer of Business content

d.         Logistic data acquisition

e.         Generic data acquisition

f.          Enhancement of BI content data source

4.         Transfer of flat file

5.         Data acquisition with DB connect

6.         Process chain

a.         Process chain design

b.         Managing process chain

7.         Report performance

a.         Design

b.         OLAP caching

8.         BI statistic and monitoring

9.         Aggregates

10.       BI accelerator

11.       Security component in BI

12.       Security data access for report user

13.       Saving bex object in BI roles

14.       Securing data access for advance user

15.       Maintain authorisation

Additional functions in 7.5