SAP BW/ BI Course Content

Course Overview:


Course Name               SAP BW/BI
Demo Classes On Demand
Mode of Classes         Online
Course Duration 40-45 Hours
Class Availability Weekdays & Weekends
Demo Training Email ID : info@greenboardlearninghub.com


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
  • Pld
  • Sql
  • Crystal Report
  • FMS
  • DTW
  • Query Generator
  • UDF ,UDT,UDO
  • All Install setting.

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

Business Content

  • Importance of Business Content
  • Business Content Installation & Activation
  • Business Content Data Source, DSO’s, Cubes, Reports, etc
  • MultiProvider

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