The Data Warehouse: 2 Years Later... Lessons Learned

Abstract

A data warehouse is often the first client/server application that institutions attempt. Such was the case at Arizona State University. Two years ago, ASU initiated a project that brought together student, financial, and human resources data in a integrated data warehouse. In the presentation, we plan to share the lessons learned after two years of work. Some of those lessons include: learning new technologies, understanding the warehousing concepts, integrating the data, designing the warehouse, marketing the idea, finding resources, "officialness" of data, impact on Data Administration, defining data, making a production system, prioritizing information that goes in, costs, data delivery methods, training and security. We plan to share our success stories as well as what we would do differently if we could start over. There will be a discussion of how the ASU Data Warehouse fits in the University's information architecture, future plans and live demonstration showcasing the ease of use and power of this innovation information resource. Paper presented at CAUSE94, the full proceedings of which are available through this Library as PUB1094. This paper has been superceded by a _CAUSE/EFFECT_ magazine article, CEM9548.