“I appreciate the fact that we were able to easily deviate from the book when possible to cover more interesting & advanced topics. [Instructor] is very knowledgeable and honest about BO XI capabilities. Thanks.”
John F, FedEx

“[Instructor] is very knowledgeable in this subject and is able to communicate information in an easy, understandable manner. I look forward to doing the advanced class…”
– Kimberley G, Rogers Wireless

“This instructor gets a 10 out of 10. He is brilliant and has the expertise and teaching methodology that makes this type of course fun and educational. Highly recommend for future courses!!! OUTSTANDING!!!!!!!!!!!”
Attendee, Burger King Corporation

Course Description

This course is designed to give report developers the advanced skills needed to take their Web Intelligence reporting skills to the next level. Users will learn techniques such as advanced queries, synchronizing data sources, advanced variables and functions, grouping data and much more.

Audience

This course is targeted for users who are already experienced with Web Intelligence report development and need to learn advanced reporting techniques to further enhance their reporting skills.

Objectives

After completing this course, students will be able to create advanced queries, use advanced calculation techniques such as context calculations, learn how to used advanced functions and variables, learn how to synchronize data from multiple data sources, learn how to group data and other techniques. Students are also taught how to combine their existing knowledge of Web Intelligence reporting skills with these advanced techniques.

Duration & Version

2 Days – 4.x

Prerequisites

The 2-day “Introduction to Web Intelligence” reporting course (or its equivalent), or equivalent hands-on experience with developing Web Intelligence reports.

Topics Covered

Numeric Functions
Character Functions
Date Functions Document Functions
Other Commonly Used Functions

Understanding Grouping in WEBI
Using IF () to Group Data
Advanced Conitional Formatting

Creating Multiple Queries
Synchronizing Data

What are Context Calculations
– ForEach, ForAll, IN, Where
Modifying Calculation Context

Creating Sub Queries
Combination Queries
Query on Query
Advanced Conditions and Filters
Query SQL

Hyperlinks to Other Documents
Element Linking
Creating and Using Shared Elements

Prefer Custom Training?

Schedule A Call