Desktop Intelligence 3.1 Advanced Reporting Course

Course Code: BO 81
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 advanced reporting concepts. Topics to be covered include; advanced query features, sub-queries, combination queries, advanced conditions, hierarchies, variables, multiple data providers, formulas, outlining, managing filters, inserting special fields, and conditional reporting.
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.
Duration: 1 day
Learning Outcomes:

Upon completion of this course, the participant will be able 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 Topics:

BusinessObjects Overview
Corporate Information Factory
Data Warehousing
BusinessObjects' 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
View SQL
User Objects
Duplicating Data Providers

Subqueries
Create a Subquery (All) Operand
Create a Subquery (Any) Operand
Create a Subquery Operand
Calculation Operand
Using a 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
Drill on Multiple Hierarchies
Drill on Charts
Snapshots

Tips & Techniques
Formula Examples
(ForEach, ForAll, In, If-Then-Else)
Outlining
Managing Filters
Inserting Special Fields
Conditional Reporting

Prerequisites: Desktop Intelligence 3.1 Intermediate Reporting
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning