SAP BI Training

For the latest course content, please visit us at /sap-bi-training

SAP BI ( formerly known as BW ) is the enterprise data mining and reporting tool specifically suited for extracting and reporting out of SAP. SAP's business warehouse functionality acts as the framework for advanced modules like SEM, BCS, EC/CS etc that depend very heavily on data aggregation and consolidation.This training covers user transactions and customization of the entire BI toolset.

SAP BI ( formerly known as BW ) is the enterprise data mining and reporting tool specifically suited for extracting and reporting out of SAP.

Additional Freebies - Along with the training we provide the following additional services.

1. One Month of BW functional support (After training, During the practice).
2. Mock Interviews.
3. Interview Tips.
4. Resume Marketing

Intended Audience - SAP BW is intended for any of the following audience.

1. Experienced Business Users who have been working in Data Mining or as research analysts who deal extensively with data.
2. Experienced ABAP users who wish to get into Business Intelligence.
3. Less than 1 year of experience in SAP BW as a functional consultant.

Table of Contents

Basics of SAP , Business Intelligence

(Week 1 )

• Basic SAP GUI Navigation
• Installing the SAP BW Client toolset.
• Architecture of SAP NetWeaver BW 7.0
• Overview of the most important objects (InfoObjects, InfoProviders etc.) of BW and their attributes
• Components of the data flow and extraction of data from SAP source systems or additional data sources
• Benefits and use of BW Content
• Introduction to the administration of BW data targets
• Principles of optimizing query performance (BW accelerator)
• Integration of SAP NetWeaver BW capabilities in SAP NetWeaver
• Architecture and functions of BW
• BW business content and BW metadata repository
• Enterprise Data Warehousing
• Enterprise Reporting, Query & Analysis
• Business Planning and Analytical Services

Data Modeling & Data Aquisition

( Week 2 )

• Modeling
  • Creating a requirements analysis
  • Developing a BW data model
  • Modeling data marts
  • Enhancing/changing the data model, remodeling
  • Aspects of an enterprise data warehouse architecture
  • Special modeling and Data Warehousing aspects
  • InfoSets, MultiProviders
• Data Acquisition
  • Data flow in BW Data Acquisition (Data Transfer Process)
  • Transformations in BW (such as translating units of measure)
  • Direct access
  • Real-Time Data Acquisition
  • Data extraction from SAP source systems
  • Enhancing BW Content DataSources
  • Delta management
  • Transferring data from flat files
  • Transferring data using DB Connect
  • Transferring data with UD Connect
  • Transferring data using Web Services
  • Data Mart Interface
  • Define and manage Process Chains

Enterprise Reporting

( Week 3 )

• Architecture and functions of SAP BW analysis tools
• Navigating in SAP BW reports
• Creating query definitions using the BEx Query Designer
• Integrating key figures, characteristics, hierarchies, variables, properties, exceptions and conditions in the query definition
• Delivering reports and adhoc-analysis using the BEx Analyzer and the BEx Web Analyzer
• Using the BEx Information Broadcaster to distribute reports
• Integrating reports in the SAP Enterprise Portal
• Integrating documents in reports
• Configuring the report-report interface
• Using predefined reports from the SAP Business Content

Business Warehouse Performance & Administration

(Week 4 )

• InfoProvider modeling and administration for performance
• Process Chain development and monitoring
• BW Technical Content and Statistics
• Optimize and monitor query performance
• Optimize and monitor data acquisition performance
• BW Aggregates
• Archiving and near-line storage
• Transport management for BW objects
• BW Accelerator overview

BW User Management

( Week 5 )

• Architecture and strategies for a BW authorization concept
• Security requirements in SAP BW
• Setting up authorizations for reporting
• Authorizations for administrative tasks in BW
• Standard roles and templates for the authorization concept
• Authorizations for connected source systems
• Authorizations for the planning environment