SAP BI Online Training

SAP BI Online Training by Spiritsofts, Learn Live Instructor Led Classes Online SAP BI Training course with real time experts. ✓Training Material ✓24/7 Support ✓Pay in Installment ✓Job Support ✓Resume preparation

SAP BI Online training Course Content

 

Introduction

• Introduction to ERP, SAP, Data Warehouse
• Overview of BW, BI, Data Base.
• Overview of BW Architecture, Landscape

 Basic Modeling

• Multi-Dimensional Star Schema (Classical Approach)
• Multi-Dimensional Star Schema in BW (Extended star Schema)
• The OLAP Concept and differences between OLAP and OLTP 

 Business Modeling

• Info Area
• Info Object Catalogs
• Info Objects
• PSA
• Application Component
• Info Source
• Data Source
• Transfer Rules
• Update Rules
• Transfer Structure
• Communication Structure
• Info Package
• Transformation
• Data Transfer Process
• Loading Transactional Data into BW info Cube
• Loading MD with TD into BW System
• BW and BI Comparisons
• Master data loading-new(BI) ETL process
• Info cube & Types
• Standard Info cube and Loading with new ETL Process
• Generate Report with BI master and Transaction Data
• Manual Uploading of MD like Attributes, Text, Hierarchy
• Different Types of Attributes
• Transformations , Rule types

Routines

• Start Routine
• End Routine
• Expert Routine

DTP (Data Transfer Process)

• Standard DTP
• Error DTP
• Direct Access DTP
• Real time DTP

DSO (Data Store Object)

• Standard DSO
• Write optimized DSO
• Direct update DSO
• APD (Analysis Process & Design)

Update Methods

• Full updates
• Initialization
• Delta Updates

Info Providers

• Multi Providers
• Info set
• Virtual Providers
• Re-Modeling
• Re-Partitioning
• Open-Hub Destination
• Data Marts

Info Cube Maintenance

• Aggregates
• Roll-up
• Compression
• Reconstruction

Process Management

• Process Chains, Process Types
• Scheduling
• Monitor (Header, Status, Details)

Reporting

• Business Explorer
• BEX Query designer
• BEX Analyzer
• BEX WAD
• BEX Report Designer

Functional Overview of Bex Query Designer

• Reusable Query Elements
  • Query Controls with Variables
  • Calculated Key Figures
  • Restricted Key Figures
  • Formulae
  • Structures
• Variable Definition in Detail
  • Characteristic values variables
  • Text Variables
  • Formula Variables
  • Hierarchy Variable
  • Hierarchy Node Variable..

Process Types

• Manual input
• Customer exit
• Replacement path
• SAP Exit

Authorization

• Analysis Functions
  • Conditions
  • Exceptions
• Reporting Drilldown
  • Drilldown to DSO from Info Cube (RRI)
  • Copying Queries from Cubes
  • Bex Analyzer
  • Bex WAD
  • Bex Report Designer
  • Migration Objects from BW 3.x to BI 7.4
  • Transportation
• Extraction (10)
  • Generic Data Extraction using MD/TD Tables
  • COPA Extraction
  • Business Content Extractions using MD/TD
  • LO-COCKPIT Data Extraction
• Delta types For
  • Generic Extraction
  • LO Extraction
  • ASAP methodology