Information Technology manages a data warehouse for the University community.  Our current environment leverages the data from the University’s administrative systems and delivers Information in reports using Microstrategy and the Oracle Business Intelligence Enterprise Edition (OBIEE). The Data Warehouse is a set of databases that can be used to prepare reports from data for which the user has authorized access.  The key feature of data warehouses is that the tools to prepare reports are very user-friendly (web-based, using point-and-click technology).  The warehouse includes data from major University systems - financial, student, human resources, and space management.  The data warehouse solution is composed of two parts: the data repository component and the reporting and analysis tool set.  The benefits of this combined solution are:

· Easy to use - A data warehouse provides a common data model regardless of the data’s source. This makes it easier to report and analyze information than it would be if multiple data models were used to retrieve information.  Additionally, prior to loading data into the data warehouse, inconsistencies are identified and resolved. This greatly simplifies reporting and analysis.

·Tools provided are easy to understand and use, with no intensive training being necessary.

·Format of data - Data is understandable, both on a stand-alone basis, and in its relationship to other data. Information in the data warehouse is under the control of data warehouse users so that, even if the source system data is purged over time, the information in the warehouse can be stored safely for extended periods of time.

·Availability of product - The tool is available most of the day, at least normal working hours, plus evening time.   Because they are separate from operational systems, data warehouses provide retrieval of data without slowing down operational systems.

·Security - Administration is able to restrict data available to each user for their needs and responsibilities.

OBIEE will eventually replace the Microstrategy reporting tool; Student Admission, Current Student Reporting and Course and Enrollment data are already transitioned to OBIEE. Future development will include Human Resources, Financial and other data.   For additional information, please contact