SAP BW Online Beginner level by IICT

SAP BI Training Syllabus

BI - Enterprise Data Warehousing
*Architecture of SAP NetWeaver BI 7.0
*Introduction to SAP R/3 (ECC)
*Introduction to BI Architecture
*Multi dimensional Modeling, Star Schema, BW extended Star Schema

MODELLING:
Defining BI Data Target Objects:
InfoObjects:
* Attributes
* Texts

InfoCubes:
*Standard InfoCubes
*Virtual InfoCubes

Data Store Objects (DSO):
*Standard DSO
*Write Optimized DSO
*Direct Update DSO

Source Systems:
*File
*SAP
*Database
*Web Service

Data Sources:
*Data Source for Flat File
*Data Source SAP Systems.
*Data Source for Data Base System.
*Data Source Web Services.

Extraction BI Objects:
*Inserting Characteristic as an info provider
*InfoPackage
*Data Transfer Process

Other SAP BI Objects:
*InfoProviders
*InfoSource
*MultiProviders
*Transformation
*InfoSets
*Aggregates

Down Stream BI Objects:
*Open Hub Destination

Designing Data Flow Design and Loading of Master Data into BI from FLAT FILE:
*Data Flow Design to load Master Data Attributes into InfoObject using Flat Files.
*Data Flow Design to load Master Data Texts into InfoObject using Flat Files.

Designing Data Flow Design and Loading of Transaction Data into BI from FLAT FILE:
*Data Flow Design to load Transaction Data into InfoCubes using Flat Files.
*Data Flow Design to load Transactional into InfoCube through DSO using Flat File.

SAP BI Content:
*Benefits and use of the business content
*Introduction to administration of BI data targets
*Transports and Landscapes

BEx - Reporting:
Query Design and Query Analyzer:
*Architecture and functions of the SAP BI Analysis Tools
*Creating Query Definitions with the BEx Query Designer
*Analyzing the Query in the BEx Analyzer
*Filters and
*Free Characteristics
*Exceptions and
*Conditions
*Calculated Key Figures and
*Restricted Key Figures
*Variables ( Characteristic based single values)
*Variables ( Characteristic based multiple single values)
*Variables ( Characteristic based interval values)
*Variables ( Characteristic based select option values)
*selection
*Formulas

SAP R3 ECC - BI Extraction:
SAP BI Content:
*Standard InfoObject
*Standard InfoCub
*Standard DataStoreObject
*Collecting Objects
*Grouping Objects
*Installing Objects
*Components of the data flow and extracting data from SAP Source Systems in the BI

Various types of Standard R3 Extractions:
*Master data Extraction.
*Extraction from Master Data Table.
*Transaction Data Extraction.
*Extraction from SD and FI

Generic Extractions from SAP R3 System:
*Master data Extraction.
*Extraction from Master Data table.
*Transaction Data Extraction.
*Extraction from Transaction Data Table.

BI - Performance Tuning:
*Reporting and support
*Effective query design, Compression, Partitioning
*Aggregates: Creating Aggregates.
*Infocube Partitioning,
*InfoCube Remodeling

BI - Miscellaneous Topics:
*About BI 7.3 features