Report for January 2018

Report Date
January 2018

Report compiled by Chris Lawford (Programme Manager) for Alex carter (Programme Owner)

Section One: Programme Commentary, RAG and Resources Update

Programme Commentary

Key Achievements in Last Period

  • EDW DEV environment build still in progress. Target now 09/02.
  • ETL Procurement:  ITT responses received and under review.
  • Draft development guidelines created and under review.  
  • Communication strategy & plan, governance strategy & plan, migration plan delivered.
  • BIMI Service RACI – first draft created and under review.
  • Mid-year review conducted and proposal for 18/19 created.
  • Sustainability plan created and under review.    

Top 3 issues

  • Delays in EDW build process.
  • Limit the knock-on effects of any delays in ETL procurement.
  • Funding approval for Oracle Advanced Security, in order conform with EDW security policy.       

Key Next Steps

  • Closely monitor DEV build progress.

The programme continues to report AMBER - due to the underlying project statuses. 

Status and Forward Look

For security reasons, images aren't duplicated during cloning. Please re-add or replace the image as required.

Resource Summary

Section Two: Projects Not Started

Project Info Project Manager's Commentary

DTI005 ETL Tool Implementation  

 Planned to start Apr-18  
DTI021 EDW Embed & Optimise    

 Planned to start Apr-18


Section Three: Projects in Progress

Project Info

Project Manager's Commentary  

DTI004 - ETL Tool Procurement






15-Dec-2017  ITT Issued

28-Mar-2018 Project Delivery

13-Apr-2018 Project Close    



Report by Nick Graham for January 2018 

Achievements in Last Period

  • ITT responses received. 
  • Bidders' conference completed.
  • Response evaluation begun. 


  • None.    

Next Steps

  • Bidder tool demonstrations.
  • Completion of evaluation.
  • Selection of tool.


The project is reporting GREEN.



DTI006 - EDW Implementation 





12-MAR-18    Org Hierarchy ASOR

13-APR-18   Infrastructure Build Complete



07-MAY-18    Project Close



Report by Chris Lawford for January 2018

Achievements in Last Period

  • DEV build still in progress. Was planned to finish 22/12, but there are still a number of complexities to be addressed. Triaged list of tasks available. Estimated completion date of 09/02.    A significant number of items have been deferred. These will be need to be addressed as part of the “Embed & Optimise” project. The EDW build is at the technical leading edge, and the experience gained will prove useful for other non-DTI work.  
  • BI/MI service organisation tasks in progress. Draft RACI available.    
  • Technical guidelines documentation complete.  
  • Milestone dates have been adjusted to account for the late delivery of DEV environment.  


  • Slow progress on DEV infrastructure build (see above).

Next Steps

  • Complete DEV build.
  • Commence TEST build.
  • Continue BI/MI service organisation analysis.

The project is currently reporting AMBER, due to the late delivery of Dev infrastructure.


DTI019 - BI/MI Analysis Toolkit 




16-Feb-2018 Redrafting of toolkit as UoE toolkit (new)
09-Mar-2018 Approval by Operational Guidance Committee
13-Mar-2018 Delivery of BI/MI Analysis Toolkit into overarching BI/MI Projects toolkit
20-Mar-2018 Delivery Review
23-Mar-2018 Close



Report by Sue Woodger for January 2018


  • Version 4 of Simpsons toolkit (received 22 December) approved as our version 1.0 12 January 18
  • Revised scope approved by WIS 26 January 18
    • Scope is changed as Consultant was to complete the toolkit but we are signing off their version as v1.0 of the toolkit and we will provide an updated v2.0 of the toolkit
  • Revised milestones approved by WIS 26 January 18
  • Revised budget approved by WIS 26 January 18
    • Redrafting of toolkit into a UoE toolkit plus review and signoff 16-Feb-2018 (new)
    • Approval by Operational Guidance Committee 9-Mar-2018 (new)
    • Delivery into overarching BI/MI Projects toolkit 16-Mar-2018 (was 1-Dec-2017)
    • Delivery Review 16-Mar-2018 (was 8-Dec-2017)
    • Close 23-Mar-2018 (was 11-Dec-2017)
  • Current budget was exhausted and currently sat at 38 days against the approved 36 days. Project sponsor and programme manager have approved a revision of 45 days to complete the update to v1.0 to produce v2.0 and to review and approve v2.0.
    • Was 36 days: Now 45 days


  • none this month

Next Steps

  • Revise milestones and closure date through WIS
  • Create UoE version of toolkit, review and sign it off

Project is green as new dates have been approved

DTI022 - EDW Business Engagement  





15-SEP-17              Planning Complete

24-JAN-18             Project Delivery

31-JAN-18             Project Close



Report by Geoff  Cropley for January 2018

Achievements in Last Period

As part of the communications schedule a lunchtime seminar was held focusing on the need for EDW governance and project pipeline planning.

All project deliverables have been completed and handover to the business owner is underway.   Project closure is expected to complete 20th February.


None to report

Next Steps

Sign off all deliverables for Communications, Governance and Business Engagement.

Handover outcomes to business owner.


Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

COM029 Proof of concept project has now been closed. 



Image icon capture-resource-summary.png29.81 KB