Building data warehouse in Metropolia University of Applied Sciences

Abstract

Universities use many different data systems that store data in different databases. To get maximum benefit from this precious data it is necessary to build a data warehouse. In this building project data from different sources is integrated and processed to form that can be easily used in reporting and analyzing.
There are two different widespread data warehouse architectures: Inmon’s and Kimball’s. Metropolia started first with Inmon’s architecture. There were many problems and after many years we could not get much useful data to reporting. Later we changed to Kimball’s architecture and got good results with it.