
“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