Business Objects

OLTP vs. OLAP

Types of OLAP

Dimensional modeling

Data mart/Data warehouse Life cycle

Star/Snow/Extended Star schema design

Joins & Cardinality

Views/Materialized Views

Date/Time Functions

Conversion functions

Package

Derived table & Stored Procedure

Architectural overview

Client tier components

Application tier components

Intelligence tier

Processing tier

Data tier

Security management

Information flow

Universe Design

Creating the Course Universe

Building the Universe Structure

Creating Dimension Objects

Creating Measure Objects

Resolving Loops in a Universe

Using List of Values

Applying Restrictions on Objects

Using @Functions with Objects

Using Hierarchies

Deriving Tables & Indexes

Designing Advanced Objects

Creating Predefined Condition

LOVs & Joins

Securing Universes

Implementing Universe Life Cycle Management

Maintaining & Optimizing Universes

Creating Universe from Other Data sources

Understand concepts of Web intelligence

Create Web Intelligence documents with Queries

Restrict data returned by a query

Design a report

Enhance the presentation of data in reports

Creation of Web intelligence report with auto scheduling

Creation of Corporate dashboard for Supply chain mgmt/Banking Domain

Format a report

Calculate data with formulas and variables

Use multiple data sources

Analyze data

Manage and share Web Intelligence documents

Work with Advanced Query techniques

Work with calculation contexts

Create formulas with character & date string functions

Use "If" logic

Work with additional reporting techniques

Create hyperlinks

Desktop Intelligence

Scope of analysis

ZABO

Report creation

Saving the reports in local repository

Publishing the report

Report conversion (desktop) to (Webi)

Creating a Model

Producing interactive visualizations of your data

Getting around in Xcelsius

Working with your Excel workbook

Visualizing data with charts

Using Xcelsius Components

Distributing your Xcelsius Visualization

Applying best practices for designing models

Formatting a Model

Using themes and templates to apply formatting

Adding Interactivity to a Model

Using selectors

Adding dynamic visibility

Troubleshooting

Creating a Connected Model

Using live data sources

Connecting to data using an existing Web Service

Connecting to Crystal Reports data

Connecting to Business Objects Universes using Query as a Web Service

Installing BI Widgets

Using BI Widgets to Access BI Content

Working with widgets

BI Widgets Content Authoring Guidelines

Auto refresh of Widgets

Installing Web Intelligence Rich Client

Web Intelligence Rich Client working modes

Launching Web Intelligence Rich Client

To set user preferences in Web Intelligence Rich Client

Working with documents

Working with universes in Web Intelligence Rich Client

Accessing Web Intelligence from InfoView

Working with queries in Web Intelligence Rich Client

Working with reports

Describe the benefits of using Live Office

Connect to the repository

Navigate the Live Office menu

Insert charts, crosstabs, and fields from a Crystal report

Insert report parts from a Web Intelligence document

Insert a new query based on a Universe

Insert Live Office objects into an email

Navigate and refresh Live Office objects

Enable consolidated prompts

Set refresh settings for objects

Set parameter binding

Take a snapshot

Save Live Office documents to the repository

Open and view Live Office documents from the repository

Configuring the QWS with BO System

Creating Web service report from Universes

Creating WSDL reports

Using WSDL reports in external application

Getting Started with Business Objects Voyager

Using Queries to Analyze Cube Data

Using Charts to Visualize Data

Selecting Members to Display in Crosstabs and Charts

Sorting, Filtering, and Ranking Data

Highlighting Exceptions in Data

Saving and Sharing Voyager Workspaces

Creation of Semantic layer for Crystal reports

Creation of Dynamic list of values in Crystal reports

Creation of Cascading list of values in Crystal reports

Creating Data connection and Dynamic data connection

Creation of Data foundation

Creation of Business Element

Creation of Business View

Creation of LOV

Saving the Business view to repository

Accessing the Business View in Crystal reports using Database expert

Creation of Crystal reports using Business view

Planning a Report

Selecting Records

Formatting a Report

Representing Data Visually

Distributing Reports

Creating Basic Formulas

Organizing Data on a Report

Applying Section Formatting

Applying Conditional Reporting

Using the Repository

Using Report Templates

Creating Formulas

Building Parameterized Reports

Summarizing Data with Cross-Tabs

Using Report Sections

Managing Reports

Presenting Data Visually

Add hyperlinks to a report

What is Business Objects Enterprise?

Describe Business Objects Enterprise

Use InfoView and the Central Management Console to view content

Configure the Central Management Console

Describe the Business Objects Enterprise Architecture

Managing Business Objects Enterprise Content

Add objects to the Repository

Manipulate objects in Business Objects Enterprise

Securing Business Objects Enterprise Content

Create users, groups, folders and categories

Understand the Business Objects Enterprise security model

Describe guidelines for planning security

Application Security

Secure Business Objects Enterprise applications

Scheduling Content

Schedule objects

Schedule with business calendars

Manage instances

Publishing and Publications

Publish personalized reports and documents to multiple recipients

Describe the process of publishing personalized reports to dynamic

Recipients

Manage profiles

Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 – Level One

Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 –Level two

Creation of Universe from scratch (Manufacturing Domain)

Creation of Web intelligence report with auto scheduling

Creation of Corporate dashboard for Supply chain mgmt/Banking Domain