Report for October 2017

DTI005 ETL Tool Implementation  

 Planned to start Jan-18

Project Manager's Commentary  

DTI004 - ETL Tool Procurement

Discretionary

Milestones

11-Aug-2017  ITT Issued

18-Dec-2017 Project Delivery

08-Jan-2018 Project Close    

RAG

AMBER

Report by Nick Graham for October 2017 (submitted by Chris Lawford)

Achievements in Last Period

• Business case approved by stakeholders and submitted to CIO - revision of costs and commercial strategy requested. 
• ITT drafting reviewed and undergoing revision in light of feedback from new Procurement manager.      
• Further discussion of software component options and costs with possible supplier. 
• Business case drafted and in review. 
• Completion of project re-planned, agreed by stakeholders and programme board, awaiting authorisation by WIS.  

Issues

• Revision of business case and ITT is leading to delay in issue of ITT. 
• Loss of procurement support is leading to delays in the finalisation of key procurement artefacts; specification, questions sets, procurement strategy.  Has been escalated to the assistant director of procurement.    
• Project completion timescales can only be firmly identified once revised business case is resubmitted and approved.  (Currently assumed to be 27/11/17).

Next Steps

• Resubmit business case. 
• Complete ITT content.
• Re-plan project completion on basis of approval of the above.

The project is reporting AMBER.

DTI006 - EDW Implementation 

Discretionary

Milestones

20-DEC-17          Org Hierarchy ASOR

24-JAN-18           Infrastructure Build Complete

31-JAN-18           Deployment

27-FEB-18           Project Close

RAG

GREEN

Report by Chris Lawford for October 2017

Achievements in Last Period

• Security Policy agreed with CISO.
• Technical architecture design complete; to be reviewed by CISO. .
• DEV build in progress. Network changes required, due to bespoke nature of build.
• Initial meetings held with Apps Dev regarding the MI/BI organisation of the future. Follow-up session planned.
• Org / Hierarchy build in progress.
• Project re-planned and approved, based upon the use of a non-standard Oracle platform.

Issues

• None

Next Steps

• Complete DEV build.
• Complete Org / Hierarchy development.

The project is currently reporting GREEN.

DTI019 - BI/MI Analysis Toolkit 

Discretionary

Milestones

RAG

GREEN

Report by Sue Woodger for October 2017

Achievements in Last Period

• None this month

Issues

• A second draft of the toolkit was expected by 6 October. Unfortunately the consultant was unable to deliver and new dates were agreed. Delivery was to be 10 November with an interim review on 31 October and closure moved to 11 December.
• However on 30 October the consultant confirmed that the delivery of work in progress at 31 October was not achievable.   Consultant is going to concentrate on the Estates work first and then the toolkit.  He will deliver the toolkit in full by 10 November allowing review and amendment with signoff expected by 24 November. Closure date has not been affected.
• We are expecting that the 1st draft of this work is as close to the final version as possible.  
• Programme manager has escalated with consultancy MD.

Next Steps

• BI/MI consultant to provide draft of toolkit by 10 November
• Review meetings are already set up and will take place on 17 and 24 November
• Meeting also set up on 24 November to discuss how to deliver the templates into service and where they will reside

Project is Green as new dates have been agreed following delay to deliverables

RAG Commentary: n/a  

DTI022 - EDW Business Engagement  

Discretionary

Milestones

15-SEP-17              Planning Complete

22-DEC-17             Project Delivery

14-JAN-17             Project Close

RAG

GREEN

Report by Geoff  Cropley for October 2017

Achievements in Last Period

• Project brief and end of planning completed successfully at WIS on 20th October.
• Project deliverables are progressing and are on track for delivery by the required date.
• EDW Wiki has been established and draft communications collateral, strategy and plans have been produced.
• Draft Governance and Business Engagement process have been produced and will be submitted for approval during November.

Issues

• None to report

Next Steps

• Agree publication of Communications, Governance and Business Engagement processes
• Engage with Estates as an early adopter of the EDW and run through processes 

The project is reporting GREEN.  Last month status was AMBER