| Course Code: |
BO 64 |
| Course Abstract: |
This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop Intelligence XI R2 advanced crosstab reporting concepts. Topics to be covered include creating crosstab reports, using the Slice-and-Dice Panel, formatting techniques, breaking, sorting and filtering, formulas and variables, creating master and summary cells, drill-down reports, creating and applying alerters.
This is a 1/2 day course |
| Audience: |
This class 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 Desktop Intelligence Reporting tools.
|
| Duration: |
4 hours |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> Generate Crosstab Matrix Reports
> Analyze and Format the Information
> Slice and Dice Data
> Apply Calculations, Variables and Alerters
> Create Sectioned and Drill Reports
> Create Charts
The participant will also use various features of Desktop Intelligence 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
Using the Crosstab Wizard
Using Slice-and-Dice
Displaying Row and Column Headers
Pivoting/Swapping Headers
Removing Headers
Replacing Headers
Displaying Multiple Objects in Headers
Effect of Adding Objects to the Query
Inserting Objects in the Body of the Block
Removing Objects from the Body of the Block
Functions and Master/Detail
Breaking
Break and Formula
Calculations in Slice-and-Dice
Ranking
Ranked Variable with Break
Sorting
Grouping in Headings
Filtering on Headings Variances
Sum of the Variance
Creating Variables
Running Sum
If-Then-Else
Inserting Master Cells
Creating Summary Cells
Creating Master Cells
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 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 skills and Desktop Intelligence XI R2 Basic Reporting course are required. |