Introduction to BusinessObjects XI Voyager


Overview:

This course will integrate a combination of instructor-led discussions and interactive workshops to illustrate the use of BusinesObjects XI Voyager product. It is designed to give you the comprehensive skills and knowledge needed to analyze trends and patterns in your data, answer business questions, and share your results by using BusinessObjects™ Voyager. It will focus on the role of OLAP, creating workspaces, building queries, using charts and graphs, role of crosstabs, sorting and filtering, building calculations, creating sub-totals and report breaks, slicing and dicing data, use of dimensions and drill operations.

The business benefit of this course is that you will be able to efficiently and effectively analyze your corporate data to make informed business decisions.

Audience:

The target audience is analysts and business users who need to analyze data to discover trends and solve business questions.

Objectives

  • Understand the use of OLAP concepts
  • Illustrate use of multi-dimensional structures
  • Define Voyager workspaces
  • Creating queries using Voyager
  • Use of complex conditionals
  • Understand usage of charts and graphs
  • Illustrate the different types of chars
  • Demonstrate use of crosstabs
  • Use of sorts, filters and ranking operations
  • Illustrate the use of different calculations
  • Define commonly used visual totals: aggregate, sum, average and count
  • Creating visual totals on filtered data
  • Define the use of nested dimensions
  • Illustrate the swapping of dimensions in reports
  • Define the usage of drill operations for moving through relational data

Class Format

Lecture and Lab

Course duration:

2 days

Course outline:

Understanding OLAP
  • OLAP Overview
  • Multi-dimensional data cubes
  • Hierarchical data
BusinessObjects Voyagers
  • Opening a workspace and analyzing data
  • Some essential terminology
  • Create a Voyager workspace
  • Define a query
  • Add charts and more crosstabs
  • Adding a chart to the page
  • Adding another crosstab to the page
Analyze Cube Data
  • Creating and defining queries to answer your business questions
  • Defining queries
  • Modifying queries
  • Adding queries
  • Creating complex queries by nesting dimensions
Visualize data with Charts
  • Chart types
  • Cluster bar charts
  • Stacked bar charts
  • Percent stacked bar charts
  • 3D bar charts
  • Multi-series line charts
  • Multi-series pie charts
  • Adding a chart to the analysis window
  • Changing chart types
  • Adding data to a chart
  • Defining a query using an empty chart component
  • Modifying a query in a chart
  • Scrolling through large data sets in charts
  • Customizing charts
Crosstabs and charting
  • Overview of member selection
  • Selecting individual members from a list of all members
  • Selecting members by searching
  • Selecting all members at a particular level in the dimension
  • Selecting parent, child, or sibling members
  • Changing the displayed measures
  • Hiding members from view
Sorting, Filtering and Ranking
  • Sorting data columns or rows
  • Sorting within hierarchies
  • Removing a sort
  • Automatically removed sorts
  • Filtering the data in crosstabs and charts
  • Adding a second filter
  • Removing a filter
  • Automatically removed filters
  • Ranking the data in the crosstab
Defining Calculations
  • Overview of calculations
  • Visual totals
  • To add the default totals
  • To add commonly used visual totals (Aggregate, Sum, Average, and
  • Count
  • To add other visual totals
  • Changing to a different visual total
  • Removing visual totals
  • Visual totals on filtered data
  • Visual totals on axes with nested dimensions
  • Visual totals on charts
  • Basic calculations
Exploring Dimensions
  • Swapping dimensions
  • Swapping dimensions containing sorts, filters, and ranks
  • Removing dimensions
  • Nesting dimensions
  • Changing the order of nested dimensions
  • Changing the slice of data
  • Drilling down and drilling up
  • Drilling through to underlying relational data

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy