|
|
|
|
 Home > UQ Data Warehouse
|
What is a Data Warehouse?
A data warehouse is a repository of information specifically designed to make the extraction and analysis of data simple and efficient. Production systems, such as student information systems, are designed to provide for data input, transactional and operational processing. Data warehouses, by comparison, are designed to optimise the extraction of data. They are generally read-only and may be updated less frequently than operational systems. A data warehouse does not contain live data.
Further information on data warehousing is available from the Data Warehouse Information Center.
History of the UQ Data Warehouse
MIS began developing a data warehouse in 1995 as part of its management information strategy to enable users to access a wide range of data for management purposes simply and efficiently. An information sub-system based on student data as reported to the Commonwealth Government was used as the initial prototype.
During the initial development of this information sub-system, MIS began to evaluate ad hoc query and reporting tools as a means of providing a user-friendly interface to the Data Warehouse. Business Objects was chosen for its ease of use by non-technical users.
The UQ Data Warehouse Today
The business intelligence (BI) environment at UQ which is underpinned by the Data Warehouse has grown considerably and is under constant development. The UQ data warehouse holds a large amount of information that has been sub-divided into a number of Data Collections:
- Student (census date snapshots, historical and current data)
- Staff (census date snapshots, historical and current data)
- Finance (General Ledger, Transactions, Allocations and Tuition Fee Allocations)
- Research (Grants and Publications)
- Space (Allocation of physical space combined with staff and student load)
- National Data (Graduate Destination Surveys, Aggregated Student and Staff data for Australian Higher Educational Institutions)
Reporting Using the Data Warehouse
Currently, UQ staff, subject to security restrictions, can use BusinessObjects and/or the Reportal to gain access to the data warehouse. BusinessObjects allows UQ staff to prepare their own reports or modify existing reports using data from the data warehouse and the Reportal allows UQ staff to view existing BusinessObjects reports in a web-based format. Follow the link below to find out more about access to the data warehouse and BusinessObjects.
>> Access to Data Warehouse and BusinessObjects.
|
|
|
|