WebIntelligence 3.1 Intermediate Reporting Course

Course Code: BO 89
Course Abstract:

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach WebIntelligence. Topics include using templates, using Turn To, vertical, horizontal, forms and crosstab reports, master/detail, complex conditions, charts, advanced crosstabs, alerters with crosstabs, and formulas and variables.

Audience:

This course is designed for WebIntelligence users and/or anyone using Desktop Intelligence Reporting.

Duration: 1 day
Learning Outcomes:

Upon completion of this course, the participant will be able to:

> Create a variety of report format types
> create a variety of charts
> create complex conditions with prompts, create complex crosstabs
> apply formatting options and alerters to crosstab blocks
> create and edit formulas and variables
> utilize functions in formulas and variables

Course Topics:

Crosstabs, Forms, Sections
Drag and Drop
Using Templates
Using Turn To
Creating Crosstabs
Creating Forms
Creating and Formatting Crosstabs
Using Turn To
Creating Sectioned Reports
Section Formatting

Creating Charts 
Using Templates
Turn To Charts
Using Properties Tab
Formatting Charts
Color Formatting
Measure Values Orientation
Filtering On Dimensions
Changing Chart Variables

Creating Complex Conditions
Using Prompts
Setting Default Values For Prompts
Creating Filters Based On Cascading LOV
Creating Multiple Filters
Using Ands/Ors 
Using Brackets

Crosstabs 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 Panel
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:

WebIntelligence 3.1 Basic Reporting course is required.

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