SAP BW-BI Online Training Course Content
Enterprise Structure
Introduction to ERP, SAP, Data Warehouse
Overview of BW, BI, Data Base.
Overview of BW Architecture, Landscape
Business Modeling
- Info Area
- Info Object Catalogs
- Info Objects
- PSA
- Application Component
- Info Source
- Data Source
- Transfer Rules
- Update Rules
- Transfer Structure
- Communication Structure
- Info Package
- Transformation
- Data Transfer Process
- Loading Transactional Data into BW info Cube
- Loading MD with TD into BW System
- BW and BI Comparisons
- Master data loading-new(BI) ETL process
- Info cube & Types
- Standard Info cube and Loading with new ETL Process
- Generate Report with BI master and Transaction Data
- Manual Uploading of MD like Attributes, Text, Hierarchy
- Delta MechanismDifferent Types of Attributes
- Transformations , Rule types
Routines
- Start Routine
- End Routine
- Expert Routine
DTP (Data Transfer Process)
- Standard DTP
- Error DTP
- Direct Access DTP
- Real time DTP
DSO (Data Store Object)
- Standard DSO
- Write optimized DSO
- Direct update DSO
- APD (Analysis Process & Design)
- Update Methods
- 1 Full updates
- 2 Initialization
- 3 Delta Updates
- Multi-Dimensional Model – The Star Schema (Classical Approach)
- Multi-Dimensional Star Schema in BW (Extended star Schema)
- The OLAP Concept and differences between OLAP and OLTP
Info Providers
- Multi Providers
- Info set
- Virtual Providers
- Re-Modeling
- Re-Partitioning
- Open-Hub Destination
- Data Marts
- Info Cube Maintenance
- AggregatesRoll-up
- Compression
- Reconstruction
- Process Management
- Process Chains, Process Types
- Scheduling
- Monitor (Header, Status, Details)
Business Content
- Business Explorer
- BEX Query designer
- BEX Analyzer
- BEX WAD
- BEX Report Designer
Functional Overview of Bex Query Designer
- Reporting
- Reusable Query Elements
- Query Controls with Variables
- Calculated Key Figures
- Restricted Key Figures
- Structures
Variable Definition in Detail
- Characteristic values variables
- Text Variables
- Formula Variables
- Hierarchy Variable
- Analysis Functions
- Conditions
- ExceptionsNew Selections
- New Formulae
Reporting Drilldown
- Drilldown to DSO from Info Cube (RRI)
- Copying Queries from Cubes
- Bex Analyzer
- Bex Report Designer
- Migration Objects from BW 3.x to BI 7.0
- Transportation
- Generic Data Extraction using MD/TD Tables
- Business Content Extractions using MD/TD SD,MM and FI
- COPA Extraction->CO
- Delta types
- Generic Extraction
- LO Extraction->SD
- Data source enhancements
- Table level enhancements
- BI Content
- Universe Designer(SAP/NON SAP)
- WEBI
- WEBI Rich client
- Live Office
- Qaws
- Import/Publishing Wizard
- Voyager
- Polestar
- Crystal Reports
- Xcelsius
- Desktop Intelligence
- Widgets
- Business View ManagerCMC
- Dashboards/Scorecards
Real-time Scenarios
- ASAP Methodology
- Live Project Explanation Live Project Preparation Live Test Cases
- Mock interviews
- Interview Questions