Report for September 2017

Report Date
September 2017

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 Security Policy complete
  • Technical Architecture Design complete
  • ETL Tool procurement strategy decided (Open mini-tender)

Top 3 issues

  • 17/18 Programme budget not approved. ETL ITT cannot be issued.
  • Approval of governance for budget changes for ETL tool procurement.
  • Re-plan of EDW build, following agreement on technical architecture.

Key Next Steps

  • Return of AMBER projects to GREEN, via governance approvals.   
  • EDW DEV build.
  • Issue of ETL ITT
  • End of planning stage for EDW Business engagement, beginning of execution phase.
  • Delivery of BI/MI Analysis Toolkit.


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


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 September 2017

Achievements in Last Period

  • Procurement strategy of '1 year plus review' engagement agreed and approved by programme board.  
  • ITT drafting and review in progress.    
  • Business case drafted and in review. 
  • Completion of project re-planned, agreed by stakeholders and programme board, awaiting authorisation by WIS.  


  • Market engagement, procurement strategy & ITT production have over-run, leading to overspend.  Re-costed and re-scheduled plan for completion approved by stakeholders was submitted to WIS for authorisation 29th Sept and then overwritten.  Re-submitted to WIS for 6th Oct.  Approval will return project to GREEN.   
  • Business Case supporting ITT has not yet been approved.

Next Steps

  • Confirm ITT and issue. 
  • Receive responses. 
  • Begin evaluation.


The project is reporting AMBER.

Issues - Market engagement, procurement strategy & ITT production have over-run, leading to overspend. Re-costed and re-scheduled plan for completion approved by stakeholders was submitted to WIS for authorisation 29th Sept and then overwritten.  Re-submitted to WIS for 6th Oct.  Approval will return project to GREEN.    No further SMT action required.  


DTI006 - EDW Implementation 



21-JUL-17            Planning Complete

29-SEP-17            Design Phase Complete

24-NOV-17          Org Hierarchy ASOR

06-DEC-17           Infrastructure Build Complete

08-DEC-17           Deployment

12-JAN-18           Project Close



Report by Chris Lawford for September 2017

Achievements in Last Period

  • Security Policy broadly agreed. The remaining open issue is the need for encryption-at-rest for confidential data (see below).
  • Technical architecture design complete, and in final stages of approval. We will use Oracle as the DB platform. We will create a bespoke, separate VMware Oracle based platform. We do not require any additional Oracle license options for the initial build.
  • Org / Hierarchy application design complete. We will build Org /hierarchy using Talend Open source ETL.
  • SSIS Dev build complete. This is our back-up ETL tooling option.


  • The decision on the need for encryption-at-rest has been deferred current security policy; we will not have confidential data in the initial build. This issue is enterprise wide, and will be taken forward outwith the programme (Dave Berry).
  • The project was planned with an assumption EDW would be built using a standard Oracle platform. This is not the case, and additional time and effort will be required. The project will be re-planned to accommodate.

Next Steps

  • Commence DEV build
  • Start Org/ Hierarchy development.
  • Start Development Organisation discussions.

The project is currently reporting AMBER, until such time as the project has been re-planned and approved.


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 September 2017

Achievements in Last Period

  • Consultant provided a walkthrough of ideas for the toolkit. He will provide access to his initial slides for Project Services input and will update the toolkit based on programme manager and project manager input. A second draft of the toolkit is expected by 6 October.


  • Have to keep reminding consultant to send highlight reports


Next Steps

  • BI/MI Analyst to provide second draft of toolkit by 6 October


RAG Commentary: n/a  

DTI022 - EDW Business Engagement  



15-SEP-17              Planning Complete 22-DEC-17             Project Delivery 14-JAN-17             Project Close



Report by Geoff  Cropley for September 2017


September 2017

Achievements in Last Period

Initial kick-off session held confirming approach objectives and deliverables.  Further refinement of activities is continuing will be agreed at the next workshop to be held on 3rd October.

Project planning  is expected to complete with Asta and project brief  submitted by 13th October 2017.


  • It has taken longer than expected to reach end of planning. The plan will have to be reviewed and adjusted to account for the delay.

Next Steps

  • Continue planning and estimating
  • Agree Project Brief, risks issues and dependencies

The project is reporting AMBER, until planning is complete.


Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

COM029 Proof of concept project has now been closed. 



Image icon capture1.png28.29 KB
Image icon capture2.png35.85 KB