Introduction to SAP BW
- Introduction to SAP BW
- What is ERP?
- What is the Data?
- What is the Business Intelligence?
- Difference between OLTP vs OLAP
- What is Data Warehouse?
- What is an ETL?
- Layers of SAP BW
- What is SAP BW?
- Why SAP BW?
- Architecture Overview of SAP BW
- Data Marting and Data Mining
- Data Warehousing Work Bench (DWW) Walkthrough
- Quiz1
BW Modeling
- What is the Source System
- How to Create Flat File Source System(Demo)
- Demo 1 : Creation of InfoArea and InfoObject Catalog?
- What is an InfoObject?
- Server Access
- Demo 2 : Creation of InfoObject
- Student Activity : Create Characteristic InfoObjects
- Demo 3 : Master Data Loading Manually in BW - Part 1
- Demo 3 : Master Data Loading Manually in BW - Part 2
- Copying InfoObjects from One Catalog to Another
- Master Data Attributes Loading from Flat File (Excel)
- Master Data Text loading from Flat File
- Master Data Hierarchies loading from Flat File
- How to check the data in PSA and other Master Data Tables
- Key Figure Part 1
- Key Figure Part 2
- What is an InfoCube
- Star Schema and Extended Star Schema
- Transaction Data Loading to Std. InfoCube with Fixed Units and Currencies
- Transaction Data Loading to Std. InfoCube with Variable Units and Currencies
- Process Chains
- Transaction Data Loading by using Process Chains Part 1
- Transaction Data Loading by using Process Chains Part 2
- Managing InfoCube and PSA (Deleting and Reloading the data)
- Virtual InfoProvider/Remote InfoCube with DTP Direct Access
- How to Test DTP Direct Access
- Error Stack DTP
- How to Allow/Loading Special Characters into BW
- Data Store Object (DSO)
- Transaction Data Loding into Standard DSO
- Overwrite functionality of DSO
- APD & Direct Update DSO
- Transaction Data Loading into Write-optimized DSO
- Delta Loading with Non-SAP Data Part 1
- Delta Loading with Non-SAP Data Part 2
- Data Extraction from Single Source into Multiple Targets - Part 1
- Data Extraction from Single Source into Multiple Targets - Part 2
- Data Extraction from Single Source into Multiple Targets - Part 3
- InfoCube Performance Tuning - Compression
- InfoCube Compression - Demo
- InfoCube Performance Tuning - Re-Partitioning
- InfoCube Re-Partitioning - Demo
- Quiz for Data Modeling
