BW/BI

SAP BW/BI Online Training Course Content

We provide best SAP BW/BI online training in Hyderabad by experienced and real time expert faculty in SAP BW/BI.

Course Duration: 45 Hours

Course Fee : Please contact admin@saptrainings.com  for pay details of this SAP ONLINE TRAINING classes

The reporting, analysis, and interpretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market.  As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BW with the toolset provided. SAP BW provides flexible reporting and analysis tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis.

The following graphic shows how the SAP BW concept is structured. Data Warehousing, BI Platform and BI Suite represent the core areas of SAP BW.

h-00100020000_image002

SAP BW/BI Course Curriculum

Overview of the SAP- BW BI

  • Module One: Enterprise Structure Introduction to ERP
  • SAP, Data Warehouse Overview of BW, BI, Data Base.
  • Overview of BW Architecture, Landscape Basic Modeling:
  • Create a valid Schema Multi-Dimensional Model – The Star
  • Schema (Classical Approach) Multi-Dimensional Star
  • Schema in
  • BW (Extended star Schema) The OLAP Concept
  • 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
  • Visual Composer
  • 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

 Analysis Functions

  • Conditions
  • Exceptions
  • Reporting Drilldown
  • Drill down to DSO from Info Cube (RRI)
  • Copying Queries from Cubes
  • Bex Analyzer Bex WAD Bex Report Designer
  • Visual Composer Migration Objects from BW 3.x to BI 7.0
  • Transportation Extraction
  • 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

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *