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
5c06359009da2-min