Overview

 

Our vision is to "Deliver the strategic data that enables evidence-based decision making across the University"

A study commissioned externally identified many challenges facing the BI/MI community across the University.  These were recognised in the BI/MI Strategy in 2014.  The BI/MI programme has addressed many of the “soft” issues identified in this report, such as the lack of a coherent BI/MI community.  This proposal will address the more technical issues.

The study identified the following issues that are relevant to the current proposal:

  • Data inconsistencies due to multiple silos of information.
  • Existing reporting solutions do not integrate data from multiple areas
  • Central systems are perceived as not fit for internal stakeholder purposes
  • Inconsistent or unclear data definitions

All of these will be resolved by the creation and population of an Enterprise Data Warehouse (EDW) facility and service. The 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.

The Enterprise Data Warehouse service will:

  • provide a platform to store University data translated into University terminology for management information and business intelligence purposes
  • manage a service for the extraction and translation of data from source systems ensuring that data is consistent with the source system
  • provide high quality, performant, access to the data in the EDW for consumption by BI tools
  • curate data definitions and purpose for each of the EDW elements
  • advise and respond to changes required to support strategic decision making and University reporting needs
  • reduce the coupling with source systems and BI tools, thus simplifying the migration from one vendor to another

See attachments for key programme artefacts.  

 

 

Code RAG RAG Date Manager Status Stage
DTI005 ETL Implementation AMBER July 2019 Andrew Stewart Closed Close
DTI006 EDW Implementation BLUE August 2018 Lee-Ann Simpson Closed Close
DTI019 BI/MI Analysis Toolkit BLUE August 2018 Sue Woodger Closed Close
DTI021 EDW - Embed & Optimise May 2019 Anne Mathison Closed Close
DTI022 EDW Business Engagement BLUE April 2018 Geoff Cropley Closed Close
DTI004 ETL Tool Procurement (extract-transform-load) BLUE July 2018 Chris Lawford Closed Procure