Desktop Intelligence XI R2 Advanced Crosstabs Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

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:	1 day
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
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 Breaking Break and Formula Calculations in Slice-and-Dice Ranking Ranked Variable with Break Sorting Grouping in Headings Filtering on Heading 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 95/98/NT/2000/XP skills and Desktop Intelligence XI R2 Basic Reporting course

Desktop Intelligence XI R2 Advanced Crosstabs Course

Hot Courses

Top Skills

Testimonials