The reporting needs of Multnomah University require the ability to do point-in-time reporting. To meet this need a student data warehouse has been developed which is populated hourly by an integration package. The data warehouse is then used by SQL Server Analysis Services which in turn provides the data for reports. This presentation will examine why a data warehouse might be needed at your institution, and the functionality it can provide. We will also look at what needs to be considered when designing a data warehouse, and how to populate the data warehouse. Brief consideration will also be given to how a data warehouse can be incorporated into Analysis Services.