• SAP BW a centralized tool for developing data warehouses that accurately and effectively support critical business decision making. It facilitates easy-to-use and high-performance extraction, transfer, transformation, and loading of data from a variety of data sources, including such comprehensive business management systems as SAP R/3.

• Unit 1 BI

• - Enterprise Data Warehousing Overview
• Lesson: Fundamentals of Data Warehousing and Business Intelligence
• Data Analysis Demands a Historical Perspective
• Requirements of Information Systems Software
• Closed Loop: Operative/Informative Environment
• Properties of a Data Warehouse
• Comparison: OLTP Systems and OLAP Systems
• Lesson: SAP NetWeaver Business Intelligence (BI) Overview
• Key Components and Features of BI
• BI Business Explorer
• BI and SAP NetWeaver
• Lesson: SAP NetWeaver Solution Delivery: IT Practices, Scenarios, and Usage Types
• IT Architecture (SAP NetWeaver) to IT Implementation Focus (IT Practices)
• SAP NetWeaver Solution Map - Overview of IT Practices
• IT Practice 'User Productivity Enablement' with IT Scenarios, and Scenario Variants: An

• Example

• Lesson: SAP NetWeaver Business Intelligence: Data Warehousing Overview
• A BI Landscape: Many SAP Products Involved
• Architecture of the BI Platform Services and Warehouse Components
• Simplified BI Architecture: Warehouse Focus
• Source System Types
• Data Acquisition
• Basic Transformation in SAP NetWeaver 2004s BI
• BI Data Warehouse: Physical Storage

• Unit 2:

• Objects in the BI Data Warehouse Layer
• Lesson: Data Warehousing Workbench
• Data Warehousing Workbench: A Central Tool
• Functions of the Data Warehousing Workbench (DWWB)
• Modeling (Design) Vs. Administration (Day-to-Day Tasks)
• Data Warehousing Workbench: Modeling
• Data Warehousing Workbench: Administration (Running the Warehouse)
• Lesson: InfoProviders: Business Purpose
• InfoProvider: A Definition
• Basic Concept of an InfoCube
• DataStore Object: A Simplified Functional View
• Integration of InfoProviders in the EDW
• InfoProvider-Related Folders in the DWWB
• Lesson: InfoObjects: Characteristics
• InfoObject – A definition:
• InfoObjects in BI are important for the following reasons:
• How InfoObjects are Used in BI
• Master-Data-Bearing Characteristics Examples
• Characteristics: Tab
• Compounding Business Example
• Characteristics InfoObjects: Master Data/ Text Tab
• Characteristics: Tab
• Attributes can have different properties/uses:
• Characteristics: Tab page
• Version-Dependent Hierarchy
• Time-Dependent Entire Hierarchy
• Time-Dependent Hierarchy Structure
• Master-Data-Bearing Characteristic Tables
• Lesson: InfoObjects: Key Figures
• Folders in BI: InfoObject-Related
• KeyFigure InfoObject: Type/Unit Tab
• Key Figures InfoObject: Tab
• Lesson: The BI InfoCube: An Extended Star Schema
• Normalized OLTP Database Schema
• Classic Star (Sequential Assigned Machine Generated DIM)
• Star Schema: Functional View
• Populated Dimension Table: Cost Center Transactions
• Populated Cost Center Transaction Star Schema
• Master-Data-Bearing Characteristics InfoObjects
• BI InfoCube: An Extended Star Schema
• A Bigger Example of an Extended Star Schema
• A Complete BI InfoCube: Extended Star Schema
• Shared Master Data Across Basic InfoCubes
• Terminology Comparison: Basic Star vs. BI Extended Star
• The BI Extended Star's Advantages Over a Basic Star Schema
• Lesson: Creating InfoCubes
• Components of an InfoCube (Review)
• BI Extended Star Schema: Cost Center Transactions
• Options for Master Data Attributes
• InfoProviders (including InfoCubes) are Organized in Folders Called InfoAreas
• InfoCube Creation GUI
• Lesson: DataStore Objects
• DataStore Objects: Purpose
• Features and Functions of DataStore Objects
• Three Different Types of DataStore Objects
• Lesson: Other Objects
• Infosets
• Multiproviders

• Unit 3:

• Data Acquisition and Transformation from SAP Source Systems
• Lesson: Data Flow: Overview
• Generic Data Warehouse Positioning of the Data Flow
• BI Architecture: Positioning of the ETL Process
• BI Data Flow Details
• Source System: A Definition
• DataSource: A Definition
• Source System Types and Interfaces
• The Persistent Staging Area (PSA)
• BI 2004s Transformation
• Optional BI InfoSources
• InfoPackages and Data Transfer Processes Initiate the Data Flow
• More Complex ETL: Multiple InfoProviders and InfoSource Use
• Lesson: Loading Master Data from an SAP Source System
• SAP R/3 Source System creation
• Creation of Datasource in SAP R/3
• Replicate Datasource
• Loading SAP source system Master Data Scenario
• SAP Source System Extraction
• DataSource Creation Access and the Generic Extractor
• DataSource in BI After Replication
• Access Path to Create a Transformation
• Transformation GUI Master Data
• InfoPackage: Loading Source Data to the PSA
• Creation and Monitoring of the Data Transfer Process
• Successful Master Data Load
• Your Exercises Will Follow the Steps in This Figure
• Lesson: Loading Transaction Data from an SAP Source System
• Complete Scenario: Transaction Load from mySAP ERP
• Emulated DataSources
• Issues Relating to 3.x DatasSources
• Using the Graphical Transformation GUI
• The Transformation Process: Technical Perspective
• Start Routine
• Start Routine (2)
• Transformation Rules: Rule Detail
• Transformation Rules: Options and Features
• Rule Types Summary
• Transformation Rule Type Formula
• Formula Builder
• Time Broadcasting
• Transformation: Rule Groups
• Transformation Groups: Details
• Rule Groups Example #2
• End Routine
• View Data in Your InfoCube Administration
• Data Flow for Transaction Data from an mySAP ERP System

• Unit 4:

• Data Acquisition from Other Systems
• Lesson: Flat File Loading
• Loading Data from Flat Files: Complete Scenario
• Flat File Sources
• Features of the BI File Adapter and File-Based DataSources
• File System DataSource: Tab
• File System DataSource: Tab
• File System DataSource: tab
• File System DataSource: Tab
• BI Flexible InfoSources
• A New BI InfoSource in the Data Flow
• Complex ETL: DataSource Objects and InfoSources
• DTP: Filtering Data
• Error Processing
• Features of Error Processing
• More Error Handling Features
• DTP Temporary Storage Features
• Access to the Error Stack and Temporary Storage via the DTP Monitor
• Lesson: Extraction from Non-SAP Systems: Overview
• Data Acquisition Layer
• Extraction using DB Connect and UD Connect
• UD Connect Extraction Highlights
• DB Connect Extraction
• Technical View of DB Connect
• XML Extraction
• XML Purchase Order Example
• XML Extraction Highlights

• Performance in depth

• Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
• BW Statistics: Query Analysis Tools, Performance Tables
• Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
• Aggregates: Creating Aggregates, Finding effective aggregates
• Data Load Performance: Parallelism, Impact of Aggregates
• Partitioning: Logical Partitioning, Table Partitioning.

BW Reporting

• Introduction to BI Enterprise Reporting
• Navigating in Reports
• First Steps in Bex Designer
• Query Designer
• InfoProviders
• Key Figures
• Restricted key Figure
• Calculated Key Figure
• Propertis of Key Figures
• Structures and Cells
• Characteristics
• Properties and Attributes of Characteristics
• Integrating Hierarchies
• Creating User Defiled Hierarchies
• Variables
• Exceptions and Conditions
• Exceptions
• Conditions
• Bex Analyser
• Bex Web Analyser
• Report-Report Interface
• Managing the Queries
• Web Application Designer