SAP-BI (7.0) online training with ECC (6.0)

Introduction
General Introduction. 
SAP introduction. 
Data warehousing/ BW/ BI Introduction 
Data Modeling 
OLAP v OLTP: The OLAP Concept and differences between OLAP and 
OLTP 
ERM, MDM, Star schema, extended star schema
Data warehouse workbench functions: Characteristics, Key 
Figures, Data Sources for 
 File Source Systems, Info Package, PSA, Transformations, data 
transfer processes
InfoCubes: Standards, real time, Virtual Providers
Data Store objects (DSO):  Standards, direct update, write 
optimized
Infocube VS DSO 
Master data- texts, Attributes, Hierchies.
Remodeling
Infosets
Multiprovider
Open hub destination
Process chains 
Metadata and Document Management 
BI Content: Definitions, How to install BI contents
Defining extraction 
For SAP source systems: Creating Generic dataSource and 
maintaining SAP delivered dataSource. 
Or for files: Creating DataSources for File Source Systems 
User management: 
Authorizations
Transports: 
Real business scenarios on different system environments, 
Moving objects from one system to another.  

Data Extraction:
Business flow: SD, MM, PP, FI, HR.
BW overview –R/3 extraction
Generic data extraction 
Data Extraction from LIS
Data Extraction from LO cockpit
Data Extraction from CO-PA
Data Extraction from FI

BEx Query Designer 

Introduction to BW-Bex reporting 
BEX Analyzer & Bex Browser
Reporting features & properties
Free Characteristics, Filters, Exceptions, Conditions, 
Calculated and Restricted Key Figures, structures.
Cell Definition New selection, new formula.Column&row 
properties.
Report-to-Report Interface
Variables: Characteristic value variables, Hierarchy Variables, 
Hierarchy node variables, Text variables, Formula variables 
Report designer
Information broadcasting
Design mode (web items)
Performance 
Line item dimension 
High cardinality
Aggregation, Rollup.
Partition
Compression
Indexes
Reconstruction
Overview:
ABAP (related to BI)
BI-IP (Integrated Planning)
Differences between 3.5 and 7.0 version.