Project

Development of the data warehouse and monitoring reports

Owner
Manager
Responsible department
The main processes
Jira
RAK 27
Link with the Strategic Plan

The management of the university is inclusive and value-based. Management decisions at every level direct the development of the university towards high quality teaching, learning and research.

The university runs seamless and cost-efficient support services in order to support and better integrate high quality studies, research and innovation.

Deadline
31/12/2024
Status
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.

Regulations
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