Data Warehouse-Based Analytical System in Private Higher Education Institution

Data Warehouse-Based Analytical System in Private Higher Education Institution

연구 분야: Databases

학회: 2023 46th MIPRO ICT and Electronics Convention (MIPRO)

Data warehouses have been present in the business environment for several decades, providing businesses with deeper insight into their business data through which they gain competitive advantage and decision-making support. However, the integrated characteristics of data warehouses can be a key factor in improving process automatization through the integration of various heterogeneous sources, speeding up certain processes, and providing process integration in the organization without impacting the existing infrastructure. In this paper, an analytical system based on a data warehouse is presented which integrates data sources in a high education institution, such as internal operational applications and structured and semi-structured files, and incorporates new data sources such as websites and their interfaces. By introducing the integration of the data sources, processes that share the same data scattered across multiple tiles or need multiple manual entries can use a single source of truth, while also having the possibility of automatic integration of open-access data. In the paper, the necessary processes are identified, and their respective data marts are proposed, while also providing proof-of-concept for several chosen processes.