Report for June 2017

Report Date
June 2017

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

Section One: Programme Commentary, RAG and Resources Update

Programme Commentary

DTI004 - ETL Tool procurement. The Market research phase is nearing completion, with one supplier engagement due to complete early in July. The next key stage is to determine the procurement strategy we wish to adopt, and plan the next stages around this. DTI006 - ETL Implementation. Some delays in reaching end of planning , due to lack of availability of project manager. DTI019 - BI/MI Analysis Toolkit. We are looking to engage with an external consultancy for this work. Selection is ongoing and we hope to have made a decisions early July.      

Planning is in progress for 2017/2018 and we are looking to capitalise certain items around the creation of EDW as an asset.  The bid for DT tranche 2 money for MI/BI tool procurement has been approved, and a decision will need to be made whether to incorporate this within the scope of the EDW programme.  

RAG Status and Forward Look


Resource Summary



Section Two: Projects Not Started

Project Info Project Manager's Commentary

DTI005 ETL Tool Implementation  

 Planned to start Dec-17  
DTI021 EDW Embed & Optimise    

 Planned to start Jan-18

DTI022 EDW Business Engagement    Planned to start Jun-17


Section Three: Projects in Progress

Project Info

Project Manager's Commentary  

DTI004 - ETL Tool Procurement 



11-Aug-2017  ITT Issued

08-Nov-2017 Project Delivery

23-Nov-2017 Project Close    



Report by Nick Graham for June 2017

Achievements in Last Period

  • Pre-market engagement activities continued.
  • Four tools evaluated in outline.
  • Three demos, three reference sites, two informal Q&As completed. 
  • Indicative pricing structures for three tools received from vendors / partners.
  • Procurement strategy work continues.


  • None

Next Steps

  • Complete final reference site and informal Q&A.
  • Confirm procurement strategy - and plan to implement it.  
  • Complete Market engagement phase. 
  • Begin procurement phase.

The project is reporting GREEN.  

DTI006 - EDW Implementation 



09-Jun-2017 Planning Complete 



Report by Chris Lawford for June 2017

Achievements in Last Period

  • Project in planning phase


  • The project has missed the end of planning deadline. The milestone date will be re-worked and presented for WIS approval 07/07.
  • There has been the commitment of dev tech resource to the project. We now expect resource to come on board from 10th July.

Next Steps

  • Complete Planning phase

The project is reporting AMBER. 


DTI019 - BI/MI Analysis Toolkit 




BI/MI Analysis Toolkit created and reviewed


Delivery of BI/MI Analysis Toolkit into overarching BI/MI Projects toolkit


Delivery Review





Report by Sue Woodger for June 2017

Achievements in Last Period

  • Project Brief completed 26 June
  • Invitations to quote for BI/MI Analysis sent out and interviews are under way


  • Project Brief rejected at WIS as no signoff from EDW governance and PM still chasing

Next Steps

  • BI/MI Analyst to start work on toolkit

The project is reporting GREEN.


Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

COM029 Proof of concept project has now been closed. 



Image icon capture201707071.png25.24 KB
Image icon capture201707072.png29.07 KB


Not available.