The scope of this project is to implement (‘install and productionise’) the ETL tool selected by project DTI004 (ETL Tool Procurement), integrated with the three EDW environments (Development, Test and Live).
The tool will be used to create and maintain robust live technical processes to extract data from operational systems, to validate and transform the data and then load information into EDW (Enterprise Data Warehouse). The tool will provide facilities for monitoring these processes and correcting problems that arise.
This is part of the EDW programme, under the Digital Transformation portfolio.
The creation of EDW will provide the data and information needed by decision makers across the University, giving a consistent view of data across multiple sources, adhering to consistent data definitions. This is in line with the University’s BI/MI Strategy, our reference architecture and the growing requirement for evidence-based planning and decision making.
Current project status
|Report Date||RAG||Budget||Effort Completed||Effort to complete|
|July 2019||AMBER||135.0 days||145.0 days||2.2|