King, S., & Jackl, A. (2006). Optimal reference guide: What's behind your data warehouse? Part II. Austin, TX: ESP Solutions Group. Retrieved June 14, 2007 from http://www.espsolutionsgroup.com/resources.php
In this paper, the second in a series from ESP Solutions Group on data warehousing and longitudinal data systems, King and Jackl focus on the design, structure, and configuration of a data warehouse. The authors discuss the different design considerations for a data warehouse versus a reporting data store, both of which are also distinguished in Part I. King and Jackl also provide two detailed examples to illustrate the process of creating a data warehouse. In the first example, they highlight the steps for developing a district-wide student attendance data system while in the second example they describe how to create a state longitudinal system to track student performance data on state administered tests. Overall, the authors maintain that creating a data warehouse is a complicated, time intensive process so they recommend that education agencies and districts build warehouses that meet their current needs and can grow as needs change over time.
Data Systems, Infrastructure