WebIntelligence 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 WebIntelligence(. Topics include: formulas, variables and functions, multiple data providers, advanced query filters, subqueries, drilling on reports, crosstabs and charts, combination queries, and revising SQL.
Duration:
1 Day/Lecture & Lab
Audience:
This course is designed for WebIntelligence users and/or anyone using Desktop Intelligence reporting.
Topics:
- Creating/Editing Formulas
- Creating/Editing Variables
- Converting Formulas to Variables
- Utilize Functions in Calculations
- Adding New Queries
- Duplicating Queries
- Deleting Queries
- Merging Dimensions to Link Data Providers
- Creating Single Report Blocks From Multiple Data Providers
- Object To Object Filters
- Creating Subqueries (Any/All)
- Query within Query
- Setting Drill Preferences
- Hierarchies
- Drilling Down/Up/By/Through
- Using Scope of Analysis
- Snapshots
- Union Queries
- Intersect Queries
- Minus Queries
- Viewing SQL
- Editing SQL
- Saving Changes
- Resetting Changes
Prerequisites:
Students should have taken the WebIntelligence 3.0/3.1 Intermediate Reporting course before attending.
Public Schedule: | ||
| Virtual Classroom, EL | 02/15/12 - 02/15/12 | ( register ) |
| Virtual Classroom, EL | 02/15/12 - 02/15/12 | ( register ) |
| Virtual Classroom, EL | 04/04/12 - 04/04/12 | ( register ) |
| Toronto, ON | 04/04/12 - 04/04/12 | ( register ) |
| Kansas City, MO | 04/04/12 - 04/04/12 | ( register ) |
| Pittsburgh, PA | 04/04/12 - 04/04/12 | ( register ) |
| St Petersburg, FL | 03/09/12 - 03/09/12 | ( register ) |
| Kansas City, MO | 02/15/12 - 02/15/12 | ( register ) |
| San Diego, CA | 02/15/12 - 02/15/12 | ( register ) |
| Los Angeles, CA | 02/15/12 - 02/15/12 | ( register ) |
| Denver, CO | 02/15/12 - 02/15/12 | ( register ) |
| Richmond, VA | 02/15/12 - 02/15/12 | ( register ) |
| Baltimore, MD | 02/15/12 - 02/15/12 | ( register ) |
