Data and Reporting Services: BrioQuery Guide
Overview
BrioQuery is the report generator used at MIT by most Data Warehouse users to report on information from the warehouse. BrioQuery is made up of five different sections:
- query - where the query is built
- results - where results are displayed after processing
- pivot - which can present data in a spreadsheet style format
- chart - which permits you to view data in line, bar, pie, and other types of graphical charts
- report - a formatted report with more flexible layout options than the Pivot.
All sections except the Query section can be printed or exported for use with other applications.
BrioQuery resides on your desktop. It works with Oracle, which is the application that communicates with the warehouse server. Oracle provides a secure network connection and encryption to protect your data.
Data Warehouse users may wish to refer to our glossary to get definitions for new or unfamiliar terms.
Resources
- Install BrioQuery - Installation instructions.
- Using BrioQuery 6 via Citrix on Mac OS X machines - Mac OS X users should install Citrix, a PC emulator enabling you to run PC versions of MIT's enterprise applications that do not have native OS X versions.
- Customize BrioQuery - Once BrioQuery is installed, you can customize it to meet your needs.
- Request Access to the Data Warehouse - Before using BrioQuery, be sure you have access.
- Change Your Warehouse Password - Use secure Web certificates to change your password.
- Learn How to Use BrioQuery - Attend an IS&T training course.
- How to Create a Basic Query - Step by step instructions to get you going.
- Creating Advanced Queries - Information for advanced users.
- Getting Results - What to do when things go wrong.
- Downloading and Processing BrioQuery Reports
- Tips on Using BrioQuery - A collection of advice from the Data Warehouse Team.
- Common Error Messages - Problems and solutions.
