What is SAP BW/BI ?

SAP Netweaver Business Warehouse (SAP NetWeaver BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing solution produced by SAP AG. It was originally named SAP BIW (Business Information Warehouse), then abbreviated to SAP BW, but is now known as "SAP BI" at the end user level. In contrast, "BW" is still used to describe the underlying Data Warehouse Area and Accelerator components. It is often used by companies who run their business on SAP's operational systems.

BW is part of the SAP NetWeaver technology platform. Other components of SAP NetWeaver include SAP Enterprise Portal (EP, called SAP NetWeaver Portal as of Release 7.0), Web Application Server (WAS), SAP Process Integration (PI, or previously XI, i.e. eXchange Infrastructure) and Master Data Management (MDM). It also includes end-user reporting tools such as Report Designer, BEx Query Designer, BEx Web Application Designer and BEx Analyzer.

SAP BW/BI Course Curricullum:

I. Introduction to SAP Business Intelligence

• BI Architecture / BI Platform
• Enterprise Data warehousing / Data Modelling
• Enterprise Reporting, Query and Analysis
• Data Acquisition / Data Extraction

II. Enterprise Data warehousing

• Transaction Data Loading
• Master Data Loading Attributes, Texts and Hierarchies
• Types of Info provider
  • Info cubes
  • DSO/ODS Objects
  • Info objects as Info providers
  • Info sets
  • Multi providers
  • Virtual Providers
• Star Schema and Extended Star Schema
  • Multidimensional Modelling
  • Entity Relationship modelling
• Differentiating between 3.x version and 7.0 version.
• Open Hub Destination
• Routines
• Business Content and its Relevance
• Performance Tuning
  • Aggregates
  • Compression
  • Indexing etc.
• Analysis Process Designer
• Process Chains and other Modelling Features
• Authorization And Transportation

III. Data Acquisition / Data Extraction

• Logistics Extraction
• Generic Extraction
• Enhancing Standard Data Sources
• Delta Mechanism
• COPA Extraction

IV. Enterprise Reporting, Query and Analysis

• Introduction to BEX Query Designer/ BEX Analyser and other Reporting Tools
• Free Characteristic and Filter
• Restricted Key Figures and Calculated Key figures
• Variables and Structures
• Exceptions, Conditions, RRI
• Information Broadcasting and other Reporting Features
• Performance Tuning of Query
• Brief about Web Reporting and Report Designer
• Overview on Business Objects and BI Integration
• Introduction to Integrated Planning and BI Accelerator