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
The DataUse web site is a part of AACC
and was created and is regularly updated by CRESST
in partnership with WestEd,
and supported by the U.S. Dept. of Education.
