Longitudinal data integration for a tracking system for health professionals
University of New Brunswick
Increase in the number of programs offered and awareness on the benefits of data collection and analysis have prompted universities across the globe to develop tracking systems that monitor the socio-economic impact of their graduates on the community. A data warehouse is required to store the data for analysis and reporting. In this thesis, an approach for building a longitudinal data warehouse is proposed for such tracking systems, in which data acquired from several sources is cleaned, integrated and structured for analytical reporting. The challenges encountered during the development of this tracking system are addressed with proposed solutions. A front-end application is also designed and developed that displays the queried data in the form of reports and charts.