Development of the data warehouse and monitoring reports

Project has been launched

1. The university has a data warehouse with a scalable and bottom-up architecture, as automated as possible, and where data is collected following agreed definitions and methodologies.
2. The university has an interoperable network of data analytics.
3. Data analytics is used to manage various processes.
4. To ensure data quality, continuous improvements are made to different processes (moment of data generation) and information systems (IT development cycle).
5. Regular reports are based on data warehouse data and are automated.

Project benefits

The university’s management decisions are data-based, the university has effective quality monitoring, and the required information is operatively available for managers. The data are easier to access for the whole organization, which in turn helps to increase the number of people who do the analysis.

Results and deadlines
1. Application of DWH updated architecture (STG, ODS/ARCHIVE, Fact/Dimension, DMARTs)The end of 2024
1.1. Updating the Data Loading System (ETL)2023-2024
1.2. Implementation of the data monitoring systemStarting from 2024
2. To analyze the coverage, recording changes, and documenting the rules. 2023
3. Creating the Glossary (definitions, methods, changes). The end of 2023
4. Agreeing upon business data rules (ensuring data quality from original systems such as ÕIS, NAV, etc.). The end of 2023
4.1. Integrations with original systems updated as needed. 2023
4.2. Implementing a data quality monitoring and feedback routine with the original systems, linking it to changes in business processes and ordering IT developments that will recur in cycles. The end of 2023
5. To develop a way for the user to access the dataThe end of 2024
6. Development of the management desk - 2024 (Business side Project manager: undecided)2024
6.1. Identifying needs (employees, students)2023