Data Warehousing: An Opportunity for Collaboration between Administrative Computing and Academic Departments Abstract (2003)
BibTeX
@MISC{Abel03datawarehousing:,
author = {Robert Van Abel and William Wehrs},
title = {Data Warehousing: An Opportunity for Collaboration between Administrative Computing and Academic Departments Abstract},
year = {2003}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
The campus administrative computing unit and an academic department at the University of Wisconsin -- La Crosse (UWL) are engaged in a collaborative effort to develop a campus data warehouse. A data warehouse is a store of data created to support decisionmaking. It is separate from the operational systems of an organization, and holds time variant operational and other data that have been integrated by subject area. Data warehousing is the process of developing, maintaining, and employing a data warehouse. A bottom up approach to data warehouse development is being taken. A pilot data mart is being developed for use by the campus institutional research unit. This data mart will be focused on student enrollment as a single subject area. This data mart will be used not only by campus decision makers, but also by students engaged in coursework. Both uses will employ the same data mart, but sensitive data will not be available for instructional use. There are a number of courses in the undergraduate and graduate curriculum where a data warehouse may be employed in instruction. These include courses requiring technical prerequisites focusing on the data warehousing process, as well as courses in the business curriculum focused on the use of a data warehouse in support of decision making. The development of this data warehouse as a collaborative effort is based on a community of interest between administrative and academic units. The collaboration produces benefits for both parties. On the academic side one of the benefits is professional data server administration. A number of challenges must be faced in order to successfully complete the development process. These challenges relate to technical and budgetary issues in development, and to difficulties associated with dual ad...
Keyphrases
data warehouse data warehousing academic department abstract data mart administrative computing collaborative effort professional data server administration academic side pilot data mart student enrollment instructional use wisconsin la crosse decision making technical prerequisite business curriculum subject area operational system data warehousing process campus data warehouse dual ad sensitive data single subject area development process campus decision maker campus institutional research unit academic unit data warehouse development academic department budgetary issue graduate curriculum
