• Decrease font size
  • Default font size
  • Increase font size

Desktop Intelligence XI R2 Advanced Crosstabs

 Print E-mail

Course Length - 1/2 Day

Description

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop IntelligenceTM 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.

You Will Learn

The student will acquire skills 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 student will also use various features of Desktop IntelligenceTM XI R2 for accessing and reporting on information contained in data warehouses.

Prerequisites

  • Basic Windows Skills
  • Desktop IntelligenceTM XI R2 Basic Reporting (2 Days).

Who Should Attend

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 IntelligenceTM Reporting tools.

Outline

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
 

Contact Us

Interested in this course?  We deliver on-site, online, and self-paced.  If you have questions, or would like to talk with a Dashcourses representative, call us at 1-866-945-4844 or fill out the form below.
  
Course*
Please enter the Course Name.
Name*
Please enter your name
E-Mail*
Please enter a valid email address
Company*
Please enter your Company Name.
Phone
Please enter a valid phone number
Message
Invalid Input
* indicates a required field  
 
Would you like to receive our Monthly Newsletter? (You can unsubscribe at any time.)
Invalid Input
Please enter the characters below* Please enter the characters below
Refresh
Invalid Input
**Note: We keep your information private and will not share your information with any other organization.