User Id:
Password:
 
Forgot password || New Here? Click to Sign Up

Call us: 419-408-3178

Email:training@verity-sol.com

SAP BI/BW – Training.

Call us :  419-408-3178

Email :   training@verity-sol.com

SAP BW- Data Warehousing-Training Outline

Unit 1: SAP Net Weaver and BI: Overview, Positioning and Fundamentals

  • Fundamentals of Data Warehousing and Business Intelligence
  • SAP NetWeaver Business Intelligence (BI) Overview
  • SAP NetWeaver Solution Delivery: IT Practice, Scenarios, and Usage Types
  • SAP NetWeaver Business Intelligence: Data Warehousing Overview

Unit 2: Objects in the BI Data Warehouse Layer

  • Data Warehousing Workbench
  • InfoProviders: Business Purpose
  • InfoObjects: Characteristics
  • InfoObjects: Key Figures
  • The BI InfoCube: An Extended Star Schema
  • Creating InfoCubes

Unit 3: Data Acquisition and Transformation from SAP Source Systems

  • Data Flow: Overview
  • Loading Master Data from an SAP Source System
  • Loading Transaction Data from an SAP Source System
  • ETL Processes and Loading Hierarchies

Unit 4: Data Acquisition from Other Systems

  • Extraction from Non-SAP Systems: Overview
  • Flat File Loading

Unit 5: Business Content

  • BI Content Discovery (Metadata Repository)
  • BI Content Activation

Unit 6: Other InfoProviders

  • DataStore Objects
  • Virtual Providers and Real-Time Data Acquisition
  • MultiProviders and BI InfoSets

 

SAP Business Intelligence – Data Staging & Extraction

Unit 1: Overview of SAP BW

  • SAP BW in SAP NetWeaver
  • Overview of Data Staging in SAP BW
  • BI Content

Unit 2: Data Transfer with the Service API

  • Connecting SAP Source Systems to an SAP BW System
  • Basic of the SAP BW Service API
  • Transfer of Business Content DataSources
  • Generic Data Extraction
  • Logistics Data Extraction
  • Enhancement of Business Content DataSources

Unit 3: Delta Management

  • Delta Management: Overview
  • Update Mode and Delta Process
  • Examples from Applications / Source Systems
  • Additional Notes

Unit 4: Transfer of Flat Files

  • Transfer of Flat Files

Unit 5: Data Transfer with DB Connect

  • Data Transfer with DB Connect

Unit 6: Data Transfer with UDC

  • Universal Data Integration

Unit 7: XML-Based Extraction

  • Using the Web AS SOAP Service
  • XML Data Load – Using a Web Service
  • XML Data Load Using SAP XI

Unit 8: Data Transfer with Third-Party ETL Tools

  • Data Transfer with Third-Party ETL Tools

Unit 9: Data Mart Interface

  • Data Mart Interface

Unit 10: Open Hub Service

  • Introduction to the Open Hub Service
  • Implementing the Open Hub Service

Unit 11: Application-Specific Extraction

  • Extracting Data from CO-PA
  • Extracting Data from FI-SL (Special Ledger)
  • LIS Data Extraction

 

SAP Business Intelligence – BW Modeling

Unit 1: Logical Model

  • Requirement Analysis
  • Logical Data Model
  • BW Data Model
  • Compare the Model with the Business Content

Unit 2: Tracking History and Hierarchies

  • Tracking History

Unit 3: Modeling Characteristics and Key Figures

  • SAP BW Star Schema
  • Characteristic InfoObjects
  • Key Figure InfoObjects

Unit 4: Modeling DSO/ODS Objects

  • Defining DSO/ODS Objects
  • Standard DSO/ODS Objects in the SAP BW Data Warehouse Layer

Unit 5: Multidimensional Modeling

  • Designing the Dimensions of the SAP BW InfoCube
  • Aggregate Modeling

Unit 6: Changing the Data Model

  • Modifying a Data Model

Unit 7: Administration of Data Targets

  • System Administration Tasks in BI: Overview
  • Administration of InfoCubes
  • Administration of Data Store Objects
  • Process Chains

SAP Business Intelligence – Reporting & Analysis

Unit 1: Introduction to BI Enterprise Reporting

  • SAP BI Overview

Unit 2: Navigating in Reports

  • Navigating in Reports

Unit 3: First Steps in the BEx Query Designer

  • Query Designer
  • InfoProviders in the BEx Query Designer

Unit 4: Key Figures

  • Restricted Key Figures
  • Calculated Key Figures
  • Properties of Key Figures
  • Structures and Cells

Unit 5: Characteristics

  • Properties and Attributes of Characteristics
  • Integrating Hierarchies into Reports
  • Creating User-defined Hierarchies

Unit 6: Variables

  • Variables

Unit 7: Exceptions and Conditions

  • Exceptions
  • Conditions

Unit 8: BEx Analyzer

  • BEx Analyzer

Unit 9: BEx Web Analyzer

  • BEx Web Analyzer

Unit 10: Information Broadcasting

  • Information Broadcasting Overview
  • BEx Broadcaster
  • Workbook Precalculation

Unit 11: Enterprise Portal Integration

  • SAP BI Portal Integration

Unit 12: Document Integration

  • Document Integration

Unit 13: Report-Report-Interface

  • Report-Report-Interface

Unit 14: Managing Query Objects

  • Managing Query Objects

Unit 15: Business Content

  • Business Content

Unit 16: Further SAP BI Reporting Tools

  • Further SAP BI Reporting Tools

Unit 17: Appendix

  • BW 3.5 Query Designer
  • BI Migration Aspects
  • Intercompany Elimination

Unit 8: Introduction to Query Performance Optimization

  • Introduction to Query Performance Optimization in BI
  • BI Aggregates
  • BI Accelerator
  • Statistics Overview