Introduction to ERP/SAP
General Introduction ERP/SAPs

Enterprise Data Warehousing
Data warehousing/ BW/ BI Introduction - Master data; Attributes, Texts, and Hierarchies - Standard naming conventions in SAP and BI

Data Modeling
InfoObjects: Definitions - Types: Characteristics, Key Figures, Time, and Unit. - InfoCube: Definitions. - Types: Standards, real time, remote. - Design of InfoCube: Star Schema concepts. Precautions. - Data Store objects (DSO): Types: Standards, Real time – InfoSets MultiProvider: Scenarios to create
Multiproviders. - InfoCube VS DSO

Metadata and Document Management
BI Content - Definitions and how to install BI contents

Defining Extraction for SAP source systems
Creating Generic dataSource and maintaining SAP delivered dataSource - Creating DataSource for File Source Systems

Defining transformation - Creating Transformations - Transformation scenarios

Data Transfer Process
Defining the data flow - Creating data transfer processes

Process Chain
Defining Process chain - Creating Process chains

Scheduling and Monitoring
Checking process chain runs - Monitor for extraction processes and data transfer processes

Performance optimization
Creating the first aggregate for an InfoCube - Using the BIA index maintenance wizard

User Management
Setting up standard authorizations - Defining analysis authorizations

Real business scenarios knowledge on different system environments - Moving objects from one system to another

Business Explorer - BEx Query Designer

New queries, Restricting Characteristics, Formulas and Exception Cells - Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures - Variables: The Variable Wizard, Variable Types and Processing Types, query Properties - Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures

Creating Re-usable structures - Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

Web Application Designer
WAD: Functions of WAD, Web Items Window, Template Window, Properties Window

Web Applications
Creating Web Applications, Settings, Stylesheets, Symbols and Properties - Design: Designing the Layout of Web Templates, working with Library for Web Items - Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes - Activities

BEx Analyzer
BEx Web Application Designer - BEx Report Designer

BI Platform
Information Broadcasting
Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal - User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings - Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.

OLAP v OLTP - The OLAP Concept and differences between OLAP and OLTP

OLAP Functions
Aggregation, Currency Translation, Report-to-Report Interface - Metadata Repository: Searching for Metadata