Welcome to Nakshatra Software Training
SAP BW Online Training
Course Duration : 55 Hrs
SAP BW Course Content
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
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. If you are staying in Hyderabad, Bangalore, Chennai, Pune, Delhi, USA, UK, Australia, Singapore etc. and unable to attend regular class room training programs then contact our training institute for information on online training. For more details on SAP BW Online Training please call to 9290971883 / 9247461324 or drop a mail to nakshatraonlinetraining@gmail.com
SAP BW online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India