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

Project Info

Project
ETL Implementation
Code
DTI005
Programme
Digital Transformation - Enterprise Data Warehouse
Management Office
ISG PMO
Project Manager
Andrew Stewart
Project Sponsor
Bill Lee
Current Stage
Close
Status
Closed
Project Classification
Grow
Start Date
02-Apr-2018
Planning Date
26-Oct-2018
Delivery Date
17-May-2019
Close Date
26-Jul-2019
Programme Priority
1
Overall Priority
Higher
Category
Discretionary

Project Dashboard

Project journal

Change dashboard

Nothing to report.