bright idea

Goals


- Create simple WebI documents using BI Launch Pad

- Implement the query editor to feed its documents with the relevant data of your choice

- Enhance and format your business data with graphs

- 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

View documents
Manage documents (rename, delete, file)
Schedule execution and delivery of documents
Change portal preferences
Create my InfoView (my home page)
Improved search

Know the elements available in a universe
Presentation of the query editor
Presentation of the data formatting interface
Modify an existing document / add data and display them
Managing the reports of a document
Create simple vertical, horizontal tables
Create forms
Create cross tables
Create charts

Create your query filters (express or advanced)
Use the different operators (« Equal to », « In list », « Corresponds to the model » …)
Query filter with prompt (dynamic choice of the values ​​of the criterion)
Query with prompt: purge data and automatic refresh, configuration of the operation of the prompt
Combine query filters: AND operator, OR operator, combine AND and OR operators
Concept of contexts
Properties of a query

Create sections
Create table breaks, table
formatting Cell
formatting Report formatting
Create fixed filters
Create dynamic filters by input controls
Create ranking
Apply conditional formatting

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

Create variables
Create a simple calculation
Transform calculations into a variable

Duration

4 days

Price

£ 1887

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS989-F

Create simple graphs – practice
Turn a table into a graph – practice
Properties of graphs – practice
Stock market chart – practice
Bubble chart – practice
Keyword cloud chart – practice

Formatting cells (reminder)
Pre-programmed cells – Practice
Complete the data with your calculations, create variables
Create a simple calculation and transform it into a variable – practice
Use the functions
The functions and the writing rules
Functions – practice

Reminder on query filters
Combining query filters
Managing priorities between query filters
Using complex operators
Going beyond the limits of complex operators
Combining queries (Minus)
Combining queries (Intersection)
Combining queries (Union)
Usefulness of sub- queries
Create a subquery (InList, ALL)

Add a new request to a document
Automatic
synchronization Manual synchronization
Multi requests in a document: automatic synchronization or not
Delete synchronization
Practice: multi request document and synchronization

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 « #VALEURMULTI » error
Calculation context and context d ‘display
Use the « ForAll »
operator Use the « ForEach » operator

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date