Abstract
Data warehousing is one of the important approaches for data integration and data preprocessing. The objective of this project is to develop a web-based interactive courseware to help beginning data warehouse designers to reinforce the key concepts of data warehousing using a case study approach. The case study is to build a bottom up data warehouse for a university student enrollment prediction data mining system. This data warehouse is able to generate summary reports as input data files for a data mining system to predict future student enrollment. The data source include: (1) the enrollment data from California State University at Sacramento, and (2) the related public data of California. In the courseware, we build the data warehouse systematically using a set of four demonstrations covering the following data warehousing topics: fundamentals, design principle, building an enterprise data warehouse using an incremental approach and aggregation. Every demonstration has the capability of data reporting for the end users upon their requests. We integrate the courseware with an introductory data warehousing and data mining class. This class of 20 students evaluated the effectiveness of this tool. Addition of feedback link to the courseware website for the end users is one of the results obtained from this evaluation.