ANALYTICAL REPORTING AND DATA MART ARCHITECTURE FOR PUBLIC ORGANIZATIONS

摘要

A data management architecture for a public institution such as a university is able to extract, transform, and load fact data from disparate data sources and store the information in appropriate data marts. The fact data is correlated with corresponding dimension data, and is correlated with various metrics of a data model, the metrics defined to be useful to the institution. A reporting tool provides user-selectable objects for each metric whereby a user simply selects an object and adds the object to a report in order to automatically generate reports using data from multiple data systems without any manual calculations or reporting by the user. The metrics and data marts can include information for such needs as grants management, financial aid management, admissions, and recruiting. The data marts also can store data over time to provide historical information that may not otherwise be available from the data sources.