ORSYS formation
CONTACT - +33 (0)1 49 07 73 73
CONTACT - 📞 +33 (0)1 49 07 73 73    drapeau francais   drapeau anglais
Consult our trainings :

Business Objects XI, Desktop Intelligence L1 Training

Hands-on course
Duration : 2 days
Ref : BDI
Price  2019 : Contact us
  • Program
  • Participants / Prerequisite
  • Intra/Tailored
Program

This course is intended for Webintelligence BO XI users. It will give them the opportunity to understand the concepts and enable them to master the query, reporting and analysis functionalities.

Hands-on work

Learners will practice all topics covered, create queries and reports on actual examples.
PROGRAM

Introduction to Desktop Intelligence

  • Desktop intelligence description.
  • Data analysis and presentation.
  • Information sharing and security management.

Connectivity to the data with Desktop intelligence

  • Connection to data sources.
  • Creating a query in an existing document.
  • Modifying a data provider.
  • Document repository : importing and exporting.

Using the universes to create queries

  • Universe definition.
  • Creating and executing a simple query on a universe.
  • Query panel.
  • Applying conditions.

Data analysis

  • Use of the rotation mode.
  • Master/detail reports.
  • Pivot tables and 3D diagrams.
  • Visualising and deleting data.
  • Data blocks management (delete, rename, redefinition).

Data Filtering and sorting

  • Filtering the displayed data.
  • Inserting, managing filters and creating complex filters.
  • Controlling the order, sorting and multiple sorting of data.
  • Using the ranking to view maximal and minimal values.
  • Conflicts between ranking, filters and sorting.
  • Hiding data columns and rows.
  • Creating, activating and disabling alerters.

Modifying Queries using the universe

  • User objects (creation, modification, delete).
  • Applying complex conditions on queries.
  • Sub queries and calculations.
  • Using an existing query in a condition.
  • Managing the condition groups.
  • Use of AND/OR operators.
  • Creating combined queries.

Calculations

  • Adding simple calculations in reports.
  • Count functions.
  • Calculate with Dimension and Detail objects.

Formulas, Local Variables and functions

  • Creating formulas and using the formulas editor.
  • Creating a local variable.
  • Using the calculation functions.
Participants / Prerequisite

» Participants

End-user in charge of the enterprise reporting and all people involved in the business decision support processes of the company.

» Prerequisite

Knowledge of desktop tools such as Excel. Knowledge of decison support environments would be an added-value.
Intra/Tailored

Contact Informations

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).
You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr
By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Submit your request

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.
However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.
The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day
linkedin orsys
twitter orsys
it! orsys
instagram orsys
pinterest orsys
facebook orsys
youtube orsys