This hands-on instructor-led course will give students the skills to create comprehensive BusinessObjects Web Intelligence reports. Students will learn how to analyze information, distribute information, and use the major reporting features of Web Intelligence.

Audience: This course is designed for business users who need to generate effective reports using BusinessObjects Web Intelligence XI R2 and XI 3.x.
Course Duration: 2 days
Prerequisites:

No prior reporting experience is required. Familiarity with Microsoft Office is helpful.

Course Objectives:

After completing the course, student will be able to:

  • Understand BusinessObjects terminology and features
  • Build complete BusinessObjects reports
  • Restrict data using conditions and filters
  • Use various presentation styles
  • Analyze data
  • Use advanced query techniques
  • Use report functions
  • Create report variables
  • Use the If Then Else statement
  • Use calculation contexts
  • Report from multiple data sources
  • Share information with colleagues
Course Outline:
  • Introduction
    • Training Objectives
    • Overview of BusinessObjects Tools
    • The Island Resorts Marketing Universe
    • Course Book Overview
    • Conventions Used In This Book

 

  • The InfoView Portal
    • Viewing Documents
    • Managing Documents
    • Customizing the Portal

 

  • Creating Your First Report
    • Starting Web Intelligence
    • Accessing the Data Provider – Your Universe
    • Classes and Objects
    • Result Objects
    • Conditions Area
    • Creating Your First Report
    • Selecting Toolbars
    • Arranging Objects on the Page

 

  • Selecting and Filtering Data
    • Query Filters
    • Creating Complex Query Filters
    • Precedence with And/Or Conditions
    • Creating User Prompts
    • Report Filters
    • Precedence with And/Or Conditions

 

  • Evaluating Data
    • Sorting
    • Grouping
    • Calculations
    • Breaks
    • Ranking

 

  • Formatting Your Report
    • Formatting Cells
    • Special Fields
    • Setting Alerts
    • Working with Report Tabs

 

  • Working With Data
    • Saving the Report in Different Formats
    • Exporting Data to Microsoft Excel
    • Printing Your Report

 

  • Charting
    • Displaying Data in Charts
    • Formatting Charts

 

  • Analyzing Data
    • Slice and Dice
    • Drill Through Analysis

 

  • Advanced Functions and Variables
    • Using Formulas
    • Creating Variables
    • Working with Functions
    • Aggregate Functions – Running Calculations
    • Using Context
    • Date Functions – DayName
    • Character Functions – Concatenation
    • Report Variable – Average Revenue
    • Using If( ) Functions

 

  • Advanced Queries
    • Creating Multiple Queries
    • Synchronizing Data
    • Using Sub-queries

 

  • Viewing Your Reports
    • Interactive Viewing
    • Report Scheduling
    • Sharing Reports

 

  • Additional Resources
  • Appendix 1 – Student Labs