|
Desktop Intelligence XI R2 Advanced Crosstabs |
|
|
| Course Length - 1/2 Day | | | | Course 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 How To: 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. | | | Course 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. | | | | Course 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
|
|
