SAP-BW/BI Course Content

Modeling

Overview of SAP BW,
What is an application? Types of Applications:
- OLAP, OLTP
Overview of different products of SAP
- SAP R/3, SAP BW, SAP CRM , SAP SEM, SAP APO
NETWEAVER
Concept of Data Warehousing:
- What is Data Warehousing
- Layers of Data Warehousing
- Different Data Warehousing Solutions
Database designs
- Basics of Database
- Database design in OLTP System – ER Model
- Database design in OLAP System
- Start Schema
- Extended Star Schema
- Snowflake
- Hybrid
Architecture of SAP BW
Creating some basic BW Objects
- Info Area
- Info Object
- Different types of Info Objects
Creating Master data tables
Loading data into Master data tables from Flat Files
ETL Process
Transfer Methods: PSA/ IDoc
Types of Info Sources
- Direct Update
- Flexible update
Types of Data Sources
- ATTR Data Source
- TEXT Data Source
- HIER Data Source
- Transaction Data Source
Types of Source System Connection
- R/3 Automatic
- R/3 Manual
- Myself
- Flat File
- DB Connect
Types of Transfer Rules
Info Package
- Data Selection
- External Data
- Processing
- Update
- Schedule
Info Cube
- Creating an Info Cube
- Loading data into Info Cube from Flat File
- Deleting Data in Info Cube
- Some Scenario’s
- One Info Source to Multiple Cubes
- Multiple Info Source to One Info Cube
- Reference & Template
- Loading Master data/ Transactional data from a single flat file