Tag Archives: SAP BI Online Training Institute Hyderabad

SAP BI Online training Institute Hyderabad

SAP BI Training by Spiritsofts, Learn Live Instructor Led Classes Online SAP Business Intelligence training course with real time experts. ✓Certification 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
Authorzation
  • 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.0
    • 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
Top ↑