SAP BW 7.4 Online Training Institute in Hyderabad India
We are providing SAP BW Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality SAP BW online training all over India. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our SAP BW online training from their home in their convenient timings. For more details on SAP BW Online Training please call to 9290971883 / 9247461324, or drop a mail to nakshatraonlinetraining@gmail.com or Whatsapp to us on : 9290971883
SAP BW Course Content
Course Duration : 56 Hrs
Introduction
- Data Warehouse Introduction
- BW / BI Introduction
- SAP Landscape
- DSS
- Standard Naming convention in SAP- BI
- Discussion Groups
Part I: Data warehousing
Unit 1: Data warehouse concepts and Overview
-
-
- OLTP Vs OLAP
- ETL
- Star Schema
- Snow Flake Schema
-
Unit 2: Business Warehouse Concepts and Overview
-
- Business Warehouse Architecture
- Extended Star Schema
- DIM / SID Tables
- Data Storage
- Data Acquisition
- Reporting and Analysis Tools
Part II: Data Modeling
Unit 3: Info Objects of Business Warehouse
-
-
- InfoArea ,Info Object ,InfoObject Catalog
- Info Object Definitions : Characteristics , Key Figures, Time and Unit
- Dimension / Key Figures
-
Unit 4: Data Storage of Business Warehouse
-
-
- Basic Cube / Transactional Cube
- Virtual/Remote Cube
- Multi-Provider
- ODS / Data Store Object ( DSO )
- PSA
- Aggregates
- InfoSets
- Compression
- Indexes and Partition
-
Unit 5: Understanding Business Content
-
- Business Content, How to install BI contents.
Part III: Extraction, Transformation and Loading
Unit 6: ETL Overview
-
-
- R/3 Data ETL Process
- Flat File ETL Process
- Monitor
- Source System
-
Unit 7: Master Data Process
-
-
- Master Data ( Attributes , Texts and Hierarchies )
- Extract Structure – DataSource/Transfer Structure
- Communication Structure
- Transfer / Update Rules / Transformations
- Info Package
-
Unit 8: Transaction Data Process
-
- R3 / Flat File Data
- Delta Extraction
- Standard BC
- Custom Table Extraction
- Creation of Data Transfer Process ( DTP )
- Info Package
- Process Chain
Part IV: Reports and Analysis Tools
Unit 9: BEx Query Designer
-
-
- Queries, Tabular Queries
- Query Properties
- Variables: variable wizard , variable types and processing types.
- Restricted Key Figures
- Calculated Key Figures
- Structures: creating re-usable structures
- Cell Definition
- Conditions and Exceptions
- Query Copy/Delete between cubes.
-
Unit 10: BEx Analyzer
-
-
- Workbook
- Queries
- Personalize Variables
- Data Area and Query Area
-
Unit 11: BEx Report Designer
Unit 12: Portal Interface
-
- Web Template iView Creation
- Publish Web Template in the portal