Course in Business Objects XI R2

Course Content:

Introduction to Data Warehousing:

*Data Warehouse Concept
*Differences between Transactional and Warehoused Data
*Data Warehouse Architecture
*Logical & Physical Design
*Difference between Data Warehouse & Data Mart
*Source Data, Staging Data & Target Data
*Operational Data Sources (ODS)
*OLA, ROLAP & MOLAP
*Star Schema, Star FLAKE Schema & Snow Flake Schema
*Normalization and De-normalization
*Meta Data & Data Mining

Database Design and Modeling:

*Entity-Relation Model(E-R Model) for Transactional Database

*Defining Entities and their Relationship
*Distribution of Attributes under Entities
*Normalization of Entities
*Modeling Logical E-R Model using Erwin Tool
*Conversion of Logical Model into Physical Model
*Application of Business Rules
*Constraints, Triggers, Domains, Back-end Programs, etc.

*Dimensional Model (Star Schema) for Data Warehouse

*Defining Dimensions and Measures
*Defining Levers and Hierarchies
*Granularity of Data
*Introducing Star Flake Schema
*Introducing Snow Flake Schema
*Dimension Table and Fact Tables
*Fact less Fact Table
*Additive, Semi-additive and Non-additive facts
*Many-To-One-To-Many Traps

Business Objects:

* Business Objects XI R2 Architecture
* OLTP, OLAP and Data Warehousing concepts
* Administrating the Contents
* Administrating the Users and Groups
* Administrating the Servers
* Access Privileges
* Designing the Universe
* Central Configuration Manager
* Accessing the Info view
* Use of Import Wizard
* Business View

Enterprise Performance Management:

* Performance Manager
* Dashboard Manager

Report Viewers:

* Crystal Reports
* Desktop Intelligence
* Web Intelligence

OLAP & Presentation using Business Objects:

* Supervisor: Creating Repository and Supervisor
* Supervisor: Database connections
* Supervisor: Defining Groups and Users
* Supervisor: Defining Privileges and Profiles for Users
* Supervisor: Broadcast Agents
* Supervisor: Scheduling Users connection sessions
* Designer: Creating and Maintaining Universe
* Designer: Defining Tables & columns as Classes and Objects
* Designer: Creating and Maintaining measures
* Designer: Defining Relations, Formulas, etc.
* Business Object: Defining Query, Reports Type
* Business Object: Formatting Reports
* Business Object: Slicing & Dicing Reports
* Business Object: Drill-Down, Drill-up Reports, tastage