bright idea

Goals


- Discover Webintelligence XI

- Use data

- Generate graphs

- Create reports

- Go further with functions

- Merge dimensions

- Create complex queries

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

Connect to Infoview
Navigation
The homepage
Set InfoView and WebIntelligence
View / edit a document WebIntelligence
Save a public document in my files
Export a document to Excel or PDF
Configure  » My Infoview « 
Use with the Infoview

Create a new WebI document
Know the elements available in a universe
The java query editor
Description of the training universe
Create a query and run it
To the report! Manipulate data
Duplicate a report (manage document reports)
Transform a vertical table into a crosstab
Transform a vertical table into a graphic
Print a document
Save a document
Create a personal folder
Organize your documents

Handling blocks
The report editor
Create several blocks
Insert an object in an existing table
Modify the structure of a crosstab
Display the structure
Delete a column
Delete a table

Create a chart
Turn a table into a chart
Change the structure of a chart
Format a chart
Change properties

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

The challenges of the multi-query
Create a new document
Add a second query
Introduction to the insertion
mode Choose the insertion mode of the new block
Name the queries and rerun them
Manage the queries
Presentation of merging dimensions

Create a new document with several blocks
Insert a break
Insert a simple calculation
Insert a sort
Insert a custom sort
Insert / Remove an express filter
Apply a global filter
Manage the report filters
Insert a section
Perform a calculation in a section
Insert a new block in a section
Modify the master
Insert alerters
Manage alerters
Insert a classification

Format tables
Modify the « general » and « display » properties of a table
Modify the « appearance » properties of a table
Modify the « page » and « position » properties of a table
Modify the « break » and « sorts » of a table
Format cells
Modify the « general » and « display » properties of a cell
Modify the « appearance » properties of a cell
Modify the number format of a cell
Modify the « break » properties « of a cell
Modify the » page « propertiesof a cell
Format sections
Modify the properties of a section

Insert a column in a table to place a calculation
Presentation of the formula editor
Create a formula
Transform a formula into a variable
Use functions (examples)
Manage variables

Define the scope of analysis
Explore in a table
Explore in a chart
Freeze an exploration level
Modify the scope of analysis
Insert exploration filters

Duration

4 days

Price

£ 1887

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS879-F

Reminders on formulas and variables
Create a formula
Transform a formula into a variable
Manage variables
User response function on a multi-query document
Replace function
Use of logical test Si
function
Use the if function to create groupings
Cumulative sum
function Date functions

Reminder on multi-query documents
Automatic synchronization
Display in a table of data coming from separate sources
Usefulness of synchronization
Case of objects that cannot be merged, problem solving

Reminder on query filters
Combine query filters
Manage priorities between query filters
Use complex operators (« at a time »)
Use complex operators (« except »)
Go beyond the limits of complex operators
Combine queries (« minus « )
Combine queries ( » intersection « )
Combine queries ( » union « )
Usefulness of subqueries
Create an » all « subquery
Create an » any « subquery

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #MULTIVALUE » error
Use the « ForAll operator « 
Use the » ForEach « operator

Sessions

Contact us for more informations about session date