WebIntelligence 4.3 Comprehensive

PT26737
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; creating new documents, formatting reports, applying reporting functions, and conditional formatting; creating different block structures, using Turn Into, vertical, horizontal, forms and cross table reports, master/detail, complex conditions, charts, advanced cross tables, ranking, breaking, sorting, filtering, Input Controls and conditional formatting with cross tables; formulas, variables and functions, multiple data providers, advanced query filters, subqueries, cross tables and charts, combination queries, and advanced reporting techniques.
Prerequisites
Before taking this course, students should have basic Windows skills.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for WebIntelligence users who create their own documents.
Topics
  • WebIntelligence As A Tool
  • What Is WebIntelligence?
  • What Is A Universe?
  • What Are Objects/Query?
  • Working in BI Launchpad
  • Understand BIWorkspace
  • Adding /Removing Objects
  • Adding/Removing Filters
  • Using Query/Report View
  • Saving Documents to Favorites
  • Saving to Local File Formats
  • Using Copy and Paste
  • Inserting, Duplicating, Deleting, Renaming ::Reports
  • Inserting/Removing Columns
  • Adding New Rows and Columns
  • Sizing Rows and Columns
  • Fonts
  • Colors
  • Justification
  • Grouping
  • Ranking
  • Breaking - Multi-level, Value Based, Auto-totals
  • Outlining
  • Sorting
  • Filtering
  • Calculations
  • What are Rules?
  • Conditional Formatting
  • Applying Conditional Formatting to Report blocks
  • Active Data Tracking
  • Using Templates/Turn Into
  • Creating Vertical/Horizontal Blocks
  • Creating Forms/Cross table Blocks
  • Creating Master/Detail Reports
  • Inserting Multiple Sections
  • Adding Summary Cells to Sections
  • Creating and Formatting Charts
  • Chart Types
  • Create Prompts
  • Setting Default Values For Prompts
  • Creating Multiple Filters
  • Using Ands/Ors /Using Brackets
  • Review of Block types
  • Creating Cross tables
  • Displaying Row and Column Headers
  • Advanced Cross tables
  • Applying Breaking, Ranking, Folding
  • Applying Sorting
  • Applying Filters at Block, Section and Report Level
  • Creating Sectioned Reports
  • Applying Conditional Formatting to Applying ::Conditional Formatting to Crosstabs
  • Outlining in Cross TablesOutlining
  • Input Controls – Document, Cascading
  • Creating/Editing Formulas
  • Creating/Editing Variables
  • Converting Formulas to Variables
  • Utilize Functions in Calculations
  • Reference Cells
  • Context
  • Adding New Queries
  • Duplicating Queries
  • Deleting Queries
  • Merging Dimensions to Link Data Providers
  • Add To Merge
  • Reporting From Excel, Text Files Directly
  • Reporting From SQL Directly
  • Reporting from Webi documents
  • Creating Single Report Blocks From Multiple Data Providers
  • Object To Object Filters
  • Creating Subqueries (Any/All)
  • Query within Query
  • Union Queries
  • Intersect Queries
  • Minus Queries
  • Viewing and Editing SQL
  • Resetting and Saving Changes
  • Hiding Cells, Blocks and Sections
  • Linking Elements
  • Shared Elements

Related Scheduled Courses