SAP BI
Description
SAP Business intelligence (BI) , The raw data is extracted, stored and applied with business intelligence to make the data useful for the user . This data can be presented in the form of reports to make it easier to analyse and make better business decisions.
Course Content
Introduction to SAP Business Warehouse
- SAP Net weaver BW Architecture / BI Platform
- Star Schema and Extended Star Schema
- Multidimensional modeling
- Enterprise Reporting, Query and Analysis
- SAP BW vs Other Data warehousing Tools
- Data Acquisition / Data Extraction concepts
Modeling
- Info Area ,Info Object Catalogs
- Info Objects(Characteristics & Key Figures)
- Data Source
- Transfer Rules
- Different types of Routines
- Info Package
- Transformations
- Data Transfer Process(DTP)
- Metadata Repository
Info Providers
- Master Data – Attributes, Texts, Hierarchies
- Standard DSO
- Write-optimized DSO
- Direct Update DSO
- Standard Info Cube
- Virtual Providers
- InfoSet
- MultiProvider
Business Content
- Importance of Business Content
- Business Content Installation & Activation
- Business Content Data Source, DSO’s, Cubes, Reports, etc
Data Extraction
- Flat file Extraction
- Extraction from standard sources with ECC as target
- Logistics Extraction
- Generic Data Extraction
- Delta mechanism
- Data source Enhancement
Process Chains
- Process Chain creation
- Scheduling
- Monitor
- Real time scenarios from support projects
SAP Transport Mechanism
- Basic SAP Landscape
- Collecting Objects
- Creating Transports and release
- Importing and Monitoring Transport
Reporting
- Introduction of BEx Query
- Filters, Columns & Rows
- CKF and RKF
- Exceptions, Conditions, Structures, Cell Definitions and others
Business Explorer Analyzer
- Introduction to BEx Analyzer
- Filtering Option
- Properties available in Analyzer
Performance Improvement
- Indexing and DB stats
- Aggregates
- Compression
- Read Mode & OLAP cache
- Line Item Dimension & High Cardinality
- Read Mode & OLAP cache
Projects Discussion
- Implementation Projects
- Up-Gradation project
- Enhancements to the existing Implementation project
- Support projects
