Data Warehouse: Getting Started and Getting Help

Software Requirements

Windows

• BrioQuery
• Oracle Client Core: If you have an old version of Oracle on your system, use the Oracle uninstaller before installing the newest version.
• MIT CA and Personal Certificates

Mac

There is no desktop version of BrioQuery for Mac, but you still have two options for using it to access the Warehouse:

• Virtual Machine: Install VMWare Fusion and then install Windows, the Oracle 9i Client, and BrioQuery. Then follow the Windows instructions to download and run canned warehouse reports.
• Citrix: Use BrioQuery 6.x via Citrix.

Data Access Requirements

• An MIT Kerberos account
• A Data Warehouse password: You must set this online.

If you have an MIT Kerberos account, you automatically have access to all public data in the Data Warehouse. Request authorization to access non-public data. You will be granted the same reporting access in the Warehouse that you have in other Roles Database applications like SAP, HR, MITSIS, and EH&S.

For more information on using BrioQuery to access information in the Data Warehouse, see the BrioQuery Guide.

Downloading Standard Reports

Many standard reports have been prepared and made available to help you access the Data Warehouse. Reports are organized by business area and can be found on the main Data Warehouse at MIT page. The reports are pre-formatted templates that have been created using BrioQuery and do not contain data.

Each template contains at least one fully-formatted report that can be viewed, modified, and printed. You don't have to learn BrioQuery features and commands to construct reports on your own: Launch BrioQuery and use the Process command. You will be prompted for the additional information needed to generate your data.

For more information, see Instructions for Downloading and Processing BrioQuery Reports.

Training and Support

• General help using the Data Warehouse: warehouse@mit.edu
• Questions about access to the Data Warehouse: warehouse-admin@mit.edu

Training

Hands-on training classes are offered by IS&T. Sign up via Atlas using the Self-Service tab.

One-on-One Consultations

In cases where your questions might not be answered in the course of a user group meeting, or where special attention is needed, the Data Warehouse staff is also available for one-on-one consultations. Contact us to make arrangements.

Reporting User Group

User Group sessions will be hosted in a hybrid format. We will meet twice a month and alternate between in-person and virtual sessions.

2023 Schedule

Changes and cancellations to the user group schedule will be posted to this page. If you have questions, you can contact us at reporting-help@mit.edu.