The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

Data Warehouse

Penn State's Data Warehouse provides information on students, employees, classroom facilities, applicants, and financial transactions. It allows access to institutional data for analytical and reporting purposes. The data is non-modifiable and provides a snapshot of time-fixed data.

Service News

Free IBISFIN Data Training

A free IBISFIN Data Training workshop is scheduled for December 22, 2009, from 9:00 a.m. until 11:00 a.m. in 404 Old Main

Read More »

DW Password Utility Changes

New features have been added to the data warehouse password change utility, which is now called the Account Status and Password Change Utility.

Read More »

Student DB--Changes Ethnicity Data

Changes to how International students ethnicity is displayed

Read More »

Access 2007 Advanced Training

There are still seats available for the Data Warehouse: Advanced Queries Using MS Access 2007 training on December 2, 2009 (1 p.m. - 5 p.m.) and December 3, 2009 (8:30 a.m. - 12 p.m.)

Read More »

News Archive »

General Information

Hours of Availability

Data Warehouse is available 7 days per week, 24 hours per day

Note: On occasion, server and/or database maintenance activities might interrupt this schedule.

System Requirements

The Data Warehouse is compatible with the Windows and Macintosh platforms that have ODBC connectivity. More information can be found in the Connecting page in the Help and Support section below.

Obtaining Access

New Data Warehouse users are required to take a Web-based mandatory training course. See the Access to Mandatory Training Course page for more information.

  1. If you do not already have an AIS Account, request one through your Access and Security Representative (ASR).
  2. Access to the Data Warehouse provides a user within the University access to significant amounts of institutional data, some of which is confidential. Please read User Responsibilities for a complete overview.
  3. Your ASR or manager should select the appropriate database from the list below and submit a request to the assigned Data Steward. For additional information on each database see Penn State's Data Warehouse Database Documentation.

Help & Support

Training

Related Information

Content Questions: AIS Support | Support Questions: AIS Support