SAP BW/BI Training in Houston

Here is a great opportunity to acquire skills to enhance or change your career and become an SAP professional; we provide excellent materials and access to live systems at no extra cost.

SAP BW / BI Training Outline
ERP background
SAP Company background information & ERP systems
Data warehouse concept and Reporting concept
SAP BW solution for data warehousing and reporting
Why use SAP solution
SAP BW (backend and front-end) – Instructor lead & Hands on Training
Ø Data Warehousing

Ø Data Extraction and Staging

Ø Data Modeling

Ø Business Explorer: Reporting and Analysis

Projects : Real world SAP BW deployment scenario – Instructor lead & Hands on Training
SAP BW job opportunities and preparation approach
Duration: 5 Weekends (Saturdays) 50 Hours Total
Teaching Method: Instructor-led and Hands On

Call: 713 419 7925 or

Email: houstontraining@yahoo.com

SAP BW/BI Course Content
SAP Business Intelligence - Data Warehousing
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

Unit 7: Administration of Data Targets

· System Administration Tasks in BI: Overview

· Administration of InfoCubes

· Administration of Data Store Objects

· Process Chains

Unit 8: Introduction to Query Performance Optimization

· Introduction to Query Performance Optimization in BI

· BI Aggregates

· BI Accelerator

· Statistics Overview

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
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 & Authorization
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 ODS Objects

· Defining ODS Objects

· Standard 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: Special Modeling Aspects

· SAP BW InfoSets

· Partitioning of InfoCubes

· Intercompany Elimination

· Cumulative and Non-Cumulative

Unit 8: Summary

· Data Modeling

Unit 9: Appendix

· Standard ODS Object

· Aggregate Performance

· Data Mining

Unit 10: Data Modeling – Case Study

· Data Modeling Case Study – Introduction

· Data Modeling Case Study - Interviews

Unit 11: SAP BW Overview with regards to Authorizations

· SAP BW Architecture and Administration

· Business Explorer

Unit 12: Security Components in BW

· Comparison of OLTP and OLAP Security Needs

· Major Authorizations Objects Used in BW

Unit 13: Securing Data Access for Reporting Users

· Securing Data Access for Reporting Users

Unit 14: Securing Data Access for Administration Users

· Using Templates

· Monitoring Administration Users

Unit 15: System Security

· System –communication Security

· Maintaining Authorizations

· Structural Authorizations SAP BW/mySAP ERP HCM

Unit 16: BPS Authorizations

· Interaction between Planning and Other SAP BW Activities

· BW BPS Authorization Objects

Unit 17: Appendices

· Performance Measurement and Recommendation

Call: 713 419 7925 or

Email: houstontraining@yahoo.com