|
Desktop Intelligence XI R2 Advanced Reporting |
|
|
| Course Length - 1 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 advanced reporting concepts. Topics to be covered include advanced query features, sub-queries, combination queries, hierarchies, variables, outlining, managing filters, inserting special fields, and conditional reporting. | | | | You Will Learn How To: The student will acquire skills to: - Create Complex Queries
- Work with Hierarchies
- Perform Advanced Drilling
- Use Advanced Query Techniques
- Use New Reporting Tips and Techniques
- View SQL
- Create User Objects
| | | Course Prerequisites Desktop IntelligenceTM XI R2 Intermediate Reporting (1 Day). | | | 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 reports and graphs utilizing Desktop IntelligenceTM Advanced Reporting tools. | | | | Course Outline | | Desktop IntelligenceTM Overview | - Corporate Information Factory
- Data Warehousing
- Desktop IntelligenceTM Data Sources/Providers
- Objects Overview
- Blocks Overview
- Report Creation Overview
- Query Building Overview
- Block Creation Overview
- Multiple Data Providers Overview
- Variables and Formulas Overview
| | Advanced Query Features | - Viewing/Using SQL
- User Objects
- Duplicating Data Providers
| | Subqueries | - Create A Subquery (All) Operand
- Create A Subquery (Any) Operand
- Create A Subquery Operand
- Calculation Operand
- Using Query on Query Capability
| | Combination Queries | - Union Queries
- Intersect Queries
- Minus Queries
| | Hierarchies and Advanced Drilling | - Predefined Hierarchies
- Creating Custom Hierarchies
- Scope of Analysis
- Drill Through
- Drill By
- Drilling on Multiple Hierarchies
- Drilling on Charts
- Snapshots
| | Tips & Techniques | - Formula Examples (ForEach, ForAll, In, If-Then-Else)
- Outlining
- Managing Filters
- Inserting Special Fields
- Conditional Reporting
|
|
