Overview:

This course utilizes an instructor-led lectures and discussion format coupled with progressive hands-on exercises designed to illustrate the following topics in the BusinessObjects XI environment; query selection and creation, use of data manipulation tools, sorting of report data, creation of data filters, drill down capability, report presentation and formatting and distribution techniques.

Audience:

Individuals in the client community that will be accessing information in a corporate data warehouse and need to utilize BusinessObjects’ XI interactive reporting abilities to create, view, save and print customized reports.

Prerequisites:

Student should be familiar with basic Windows concepts and be able to function efficiently in Windows 2000/XP environment. Each student should have completed Introduction to Data Warehousing or understand the basic role of a Data Warehouse structures.

Objectives

• Understand the role of BusinessObjects for accessing corporate data.
• Illustrate the critical path for developing and executing BusinessObjects queries.
• Define the capabilities of filters for defining conditional selection properties via; conditional IF’s, relational operators, string searching and range testing.
• Incorporating sort functions to manipulate report sequences.
• Insertion of calculations and aggregate functions into queries to generate derived data columns.
• Illustrate the role of the grouping and sorting operations in report formation, additionally recognize the impact on query performance.
• Ability to customize and modify the report layout to add headers, footers and other customized information to the report template.
• Use of the drill down function to provide in-depth analysis of report information.
• Depict the capabilities of UDO (user defined objects).
• Illustrate techniques for report distribution and sharing.
• Use of the Slice & Dice panel to provide further delineation of corporate data.