Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Mastering OpenText BI Query - User & Reports

( Duration: 3 Days )

The Mastering OpenText BI Query User & Reports training course provides with a comprehensive understanding of the capabilities of BI Query User and Reports. Highlights include formulating simple and complex ad hoc queries, creating and using buttons, creating and formatting reports, and exporting results to other applications. You will also learn how to use BI Query Reports to present data as a columnar table, chart or crosstab presentation, to create calculations and exceptions, as well as customize and improve the effectiveness of reports by incorporating text and graphics.

Familiarity with Microsoft Windows

This Mastering OpenText BI Query User & Reports workshop is ideal for Beginner to intermediate Users.

COURSE AGENDA

1

Describe the components of BI Query (BI Query User, BI Query Reports, and BI Query Admin) and how they interact

2

Describe the elements of the BI Query data model and use them to formulate queries

3

Summarize and Group data

4

Work with query results and export query results to other applications

5

Create and edit super queries

6

Extract information from several tables in a relational database and restrict the information to specific criteria

7

Save and load queries and associate queries with buttons

8

Automate tasks

9

Create professional reports from query results with reformatted titles and column headings, and subtotals using Standard Reports

10

Describe the ability of BI Query Reports to effectively present data from queries as tabular, chart, crosstab, or hypercube presentations

11

Use Wizards to create columnar table, chart, or crosstab presentations from query results

12

Create and deploy a graphical query environment (data model) for use with BI Query User and BI Web Client

13

Create interactive reports to make re-qualifying reports easier for end-users

14

Derive additional information from the database by using calculations and DBMS functions

15

Generate exception reports

16

Present query results effectively as charts

17

Use the Chart Editor to customize reports

18

Create, save and apply styles and background templates

19

Save, refresh, and distribute reports using scheduling and publishing features

20

Schedule recurring and once-only queries to run in off-peak time

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X