Desktop Intelligence 3.0/3.1 Advanced Reporting

    

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

Duration:
1 Day/Lecture & Lab

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 reports and graphs utilizing Desktop Intelligence Advanced Reporting tools.

Topics:

• Review of Basic/Intermediate Topics
• View SQL
• User Objects
• Union/Intersect/Minus Queries
• Subqueries
• Calculation Queries
• Predefined/Custom Hierarchies
• Scope of Analysis
• Drill Through/By
• Drill on Multiple Hierarchies
• Snapshot
• Outlining
• Managing Filters
• Special Fields
• Conditional Reporting
• Using Query in Query

Prerequisites:
Students should have taken the Desktop Intelligence 3.1 Intermediate Reporting course before attending.

Last Update: May 21, 2012