BI – Enterprise Data Warehousing
- Architecture of SAP NetWeaver BI 7.0
- Introduction to SAP R/3 (ECC)
- Introduction to BI Architecture
- Multi dimensional Modeling, Star Schema, BW extended Star Schema
MODELLING:
Defining BI Data Target Objects:
InfoObjects:
InfoCubes:
- Standard InfoCubes
- Virtual InfoCubes
Data Store Objects (DSO):
- Standard DSO
- Write Optimized DSO
- Direct Update DSO
Source Systems:
- File
- SAP
- Database
- Web Service
Data Sources:
- Data Source for Flat File
- Data Source SAP Systems.
- Data Source for Data Base System.
- Data Source Web Services.
Extraction BI Objects:
- Inserting Characteristic as an info provider
- InfoPackage
- Data Transfer Process
Other SAP BI Objects:
- InfoProviders
- InfoSource
- MultiProviders
- Transformation
- InfoSets
- Aggregates
Down Stream BI Objects:
Designing Data Flow Design and Loading of Master Data into BI from FLAT FILE:
- Data Flow Design to load Master Data Attributes into InfoObject using Flat Files.
- Data Flow Design to load Master Data Texts into InfoObject using Flat Files.
Designing Data Flow Design and Loading of Transaction Data into BI from FLAT FILE:
- Data Flow Design to load Transaction Data into InfoCubes using Flat Files.
- Data Flow Design to load Transactional into InfoCube through DSO using Flat File.
SAP BI Content:
- Benefits and use of the business content
- Introduction to administration of BI data targets
- Transports and Landscapes
BEx – Reporting:
Query Design and Query Analyzer:
- Architecture and functions of the SAP BI Analysis Tools
- Creating Query Definitions with the BEx Query Designer
- Analyzing the Query in the BEx Analyzer
- Filters and
- Free Characteristics
- Exceptions and
- Conditions
- Calculated Key Figures and
- Restricted Key Figures
- Variables ( Characteristic based single values)
- Variables ( Characteristic based multiple single values)
- Variables ( Characteristic based interval values)
- Variables ( Characteristic based select option values)
- selection
- Formulas
SAP R3 ECC – BI Extraction:
SAP BI Content:
- Standard InfoObject
- Standard InfoCub
- Standard DataStoreObject
- Collecting Objects
- Grouping Objects
- Installing Objects
- Components of the data flow and extracting data from SAP Source Systems in the BI
Various types of Standard R3 Extractions:
- Master data Extraction.
- Extraction from Master Data Table.
- Transaction Data Extraction.
- Extraction from SD and FI
Generic Extractions from SAP R3 System:
- Master data Extraction.
- Extraction from Master Data table.
- Transaction Data Extraction.
- Extraction from Transaction Data Table.
BI – Performance Tuning:
- Reporting and support
- Effective query design, Compression, Partitioning
- Aggregates: Creating Aggregates.
- Infocube Partitioning,
- InfoCube Remodeling
BI – Miscellaneous Topics:
- About BI 7.3 features
- Working in a MNC company in Chennai
- Trained 30+ Students so far in SAP BI/BW.
- Strong Theoretical & Practical Knowledge
- SAP BI certified Professionals
- Life Time Support will be provided
- Implementation Support will be provided for SAP BI Real Time Projects
- Video Tutorials will be provided and SAP BI software will be provided
- After regular Class hours 24/7 support provided for Practice
- Regular assignments and sap BI implementation tasks will be provided