• News
|
• Training
|
• Careers
|
• Investors
|
• Contact Us

Select Region:
Global
France
Germany
Japan

Courses & Workshops

394 Mastering BI Query Admin (v8.x)

Duration: 2 days

This two-day hands-on course is designed for the BI Query administrator who wishes to create or update a managed query environment for end-users by employing the latest functionality of BI Query Admin. Participants will learn how to create an effective data model that keeps pace with their organization’s changing needs, ensure the integrity of the data model and to properly deploy the data model.

This session is geared to current and future BI Query administrators responsible for creating or customizing the graphical data models. It also covers BI Query Admin's interaction with BI Server for those locations where BI Query Admin has been installed with BI Server.

On completion of this course, participants should be able to:

• Create and deploy a graphical query environment (data model) for use with BI Query User and BI Query Update.
• Connect to a relational database.
• Create a data roadmap by selecting tables from a database’s catalog and creating join conditions.
• Simplify the data roadmap by merging data objects.
• Add value to a data model by adding design windows, ornaments, graphics and text.
• Control user access through object qualifiers and assigning permissions.
• Enhance the usability of a data model through data values lists, prompts and variables.
• Automate activities using buttons.
• Organize the data model and buttons to create a customized data access environment.
• Control various aspects of the user interface and data access using a system of data model and user and group preferences and permissions.
• Deploy and maintain a data model.

Audience:

Intermediate to Advanced Administrators

Prerequisites:

Participants must have:

• Previous experience with Microsoft Windows
• Completion of Courses 191 – Mastering BI Query User and 192 – Mastering BI Query Reports, or Course 193 – The Complete BI Query User and Reports or equivalent experience
• An understanding of basic relational database concepts and data access issues is recommended

Pricing

	Format		Currency		Price
	Per Student at Open Text Site:		€ - Benelux		1400
	Per Student at Open Text Site:		CDN		1590
	Per Student at Open Text Site:		GBP		1100
	Per Student at Open Text Site:		USD		1590

Taxes: All prices exclude VAT or other taxes where applicable (all currencies).

Extra expenses: Customer site course prices do not include instructor travel expenses, which are billed separately.

Reservations: Please provide a minimum of 3 weeks advance notice when arranging courses at customer sites.

Course & Workshop Calendar

Below is a listing of all the currently available dates and locations for this course and/or workshop from Open Text.

Selection & Registration Process

Before you can register for a course or workshop, you need to select which one you want to attend. To do this, simply click on the "Add to cart" link and it will be added to your shopping cart.

Note: After clicking on the "Add to cart" link, you will be taken to the main course and workshop selection page where all of the courses and workshops you have added to your shopping cart will appear at the top of the page.

Once you have selected all the courses and workshops you want to attend, simply select the "Check-out link and complete the registration form.

	Date		Course Type		Course Name		Language		Location		Price		Add
	Dec 03, 2009		On-site		BI Query Admin v8.x		English		Reading, UK - Open Text		1100		Add to Cart
	Mar 04, 2010		On-site		BI Query Admin v8.x		English		Reading, UK - Open Text		1100		Add to Cart