SAP Business Objects Certification Course

SAP BO Online Training

Introduction

• Data Warehouse Introduction
• BW / BI Introduction
• SAP Landscape
• OSS
• Standard Naming convention in SAP- BI
• Discussion Groups

Part I: Data warehousing
Unit 1: Data warehouse concepts and Overview

• OLTP Vs OLAP
• ETL
• Star Schema
• Snow Flake Schema
• Data Warehouse and Datamart
• Measures, Dimensions and Facts
• Level and Hierarchy
• Slowly Changing & Confirmed Dimensions
• Aggregates, Aggregation Strategy, Compression Ratio, Indexing Strategy

Unit 2: Business Warehouse Concepts and Overview

• Business Warehouse ArchitectureExtended Star Schema
• DIM / SID Tables
• Data Storage
• Data Acquisition
• Reporting and Analysis Tools

Part II: Data Modeling
Unit 3: Info Objects of Business Warehouse

• InfoArea ,Info Object ,InfoObjectCatalog
• Info Object Definitions : Characteristics , Key Figures, Time and Unit
• Dimension / Key Figures

Unit 4: Data Storage of Business Warehouse

• Basic Cube / Transactional Cube
• Virtual/Remote Cube
• Multi-Provider
• ODS / Data Store Object ( DSO )
• PSA
• Aggregates
• InfoSets
• Non-R3 Data Module
• Compression
• Indexes and Partition

Unit 5: Understanding Business Content

• Business Content, How to install BI contents.
• FIGL/FIAP/FIAR Business Contents

Part III: Extraction, Transformation and Loading
Unit 6: ETL Overview

• R/3 Data ETL Process
• Flat File ETL Process
• Monitor
• Source System
• DB connect

Unit 7: Master Data Process

• Master Data ( Attributes , Texts and Hierarchies )
• Extract Structure – DataSource/Transfer Structure
• Communication Structure
• Transfer / Update Rules / Transformations
• Hierarchies
• Info Package

Unit 8: Transaction Data Process

• R3 / Flat File Data
• Delta Extraction
• Standard BC
• Custom Table Extraction
• Creation of Data Transfer Process ( DTP )
• Info Package
• Process Chain
• InfoSpoke

Part IV: Reports and Analysis Tools
Unit 9: BEx Query Designer

• Queries, Tabular Queries
• Query Properties
• Variables: variable wizard , variable types and processing types.
• Restricted Key Figures
• Calculated Key Figures
• Structures: creating re-usable structures
• Cell Definition
• Conditions and Exceptions
• Query Copy/Delete between cubes.

Unit 10: BEx Web Application Designer

• WAD: Functions, web item window, template window, properties window
• Role Menu
• Creating web applications, settings, style sheets , symbols and properties.
• Web Items: Tables, Text Box, Filters, Drop down box, Graph, etc.
• Web Analyzer
• Information Broadcasting
• Report to Report Interface – RRI

Hierarchy Reporting

Unit 11: BExAnalyzer

• Workbook
• QueriesPersonalize Variables
• Data Area and Query Area

Unit 12: BEx Report Designer
Unit 13: Portal Interface

• Web Template iView Creation
• Publish Web Template in the portal

Part V: Admin & Security
Unit 14: Admin & Security

• User Management
• Roles & Responsibilities
• Authorization Object
• Performance Tuning : Data Loading Performance ,Query Performance
• Transports Organizer : Real business scenario on system Environment and moving
• objects from one system to another.
• BW Statistics / Admin Cookpit

UNIT 15: Advanced / general topics

• ASAP Methodology, Implementation methods for SAP and Typical project Management
• OSS Notes
• Service marketplace
• Business Analysis techniques