WebIntelligence XI R2 Advanced Crosstabs Course

Course Code: BO 63
Course Abstract:


WebIntelligence XI R2  Advanced Crosstabs

Audience: This course is designed for both technical and non-technical business analysts working in a business environment who require access to information contained in a data warehouse to generate a variety of crosstab matrix reports utilizing the WebIntelligence Reporting tools.
Duration: 1 day
Learning Outcomes:

The participant will acquire skills to:
> Generate Crosstab Matrix Reports Using Variety of Techniques
> Analyze and Format the Information
> Apply a variety of Reporting Functions
> Apply Calculations, Variables and Alerters
> Create Sectioned and Drill Reports
> Create Charts
The participant will also use various features of WebIntelligence XI R2 for accessing and reporting on information contained in data warehouses. Specific topics are outlined below.

Course Topics:

Overview/Basic Formatting
Introduction to Blocks
Creating Crosstabs
Drag and Drop
Using Templates
Turn To
Pivoting Via Headers
Pivoting Via Structure Mode
Displaying Row and Column Headers
Removing/Replacing Headers
Displaying Multiple Objects in Headers
Effect of Adding Objects to the Query
Inserting/Removing Objects in Body of Block
Properties Tab

Functions and Master/Detail
Breaking:  Down/Across
Break and Formula
Break Properties
Ranking:  Down/Across
Ranked Variable with Break
Rank Properties
Sorting/Custom Sorting
Filtering on Headings
Report Filters Pane


Running Sum
If-Then-Else
Inserting Master Cells
Creating Summary Cells
Creating Master/Detail Report
Adding Summary Cells to Master
Saving Report to Excel

Alerters and Drilling and Charts
Cell Format Alerter
Text Format
Variable Format
Applying Alerters to Crosstab Body
Applying Alerters to Crosstab Headers
Editing and Reformatting Alerters
Applying Different Types of Alerters
Drilling on Crosstab Blocks
Hierarchies
Drill Mode
Single Dimension Drilling in Headings
Multiple Dimension Drilling in Crosstab Body
Drill Options Up, Down, Across
Converting to Chart

Prerequisites: Basic Windows 95/98/NT/2000/XP skills
WebIntelligence XI R2 Basic Reporting (Recommended: 1 Day)
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

“56% of IT leaders plan to train their staff this year to better manage third-party relationships, negotiate contracts, assess vendor risk, and monitor service-level agreements” (“Trends 2007: Hot IT Skill Areas”, Forrester Research, Inc., March 2007).