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