Report for December 2017

DTI005 ETL Tool Implementation  

 Planned to start Apr-18

Project Manager's Commentary  

DTI004 - ETL Tool Procurement

Discretionary

Milestones

15-Dec-2017  ITT Issued

28-Mar-2018 Project Delivery

13-Apr-2018 Project Close    

RAG

GREEN

Report by Nick Graham for December 2017 

Achievements in Last Period

• Business case for expenditure approved by CIO.
• Procurement strategy finalised, reviewed and agreed.
• ITT finalised, reviewed agreed and published.  
• Completion of project re-estimated, rescheduled and approved:  variation to budget (21 days) and governance milestones.

Issues

• None.    

Next Steps

• Bidder conference (optional). 
• Receipt of tenders. 
• Evaluation and selection.  

The project is reporting GREEN.

DTI006 - EDW Implementation 

Discretionary

Milestones

15-FEB-18    Org Hierarchy ASOR

9-MAR-18   Infrastructure Build Complete

16-MAR-18

Deployment

02-APR-18    Project Close

RAG

AMBER

Report by Chris Lawford for December 2017

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. Progress is being made, but much slower than anticipated. It continues to be difficult to estimate a DEV build completion date, as much of the work relates to new architecture and configuration. We are closely monitoring progress against a triaged and prioritised list of tasks. The EDW build is at the technical leading edge, and the experience gained will prove useful for other non-DTI work.  
• BI/MI service organization tasks underway.   
• Org / Hierarchy build complete. Session held with Talend technical pre-sales consultant to review design.  End-to-end demonstration held.
• Technical guidelines documentation in progress.

Issues

• 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, until either a) the DEV build is complete, or b) the project delivery dates are adjusted.

DTI019 - BI/MI Analysis Toolkit 

Discretionary

Milestones

RAG

GREEN

Report by Sue Woodger for December 2017

Achievements

• Version 3 of BI/MI toolkit received 8 December but comments made
• Version 4 of toolkit received 22 December

Issues

•   We were awaiting a third revised toolkit from the consultants and this arrived on 8 December as expected. However, while all reviewers felt that this was a vast improvement on the 2^nd draft we still didn’t have the confidence that a business analyst could pick this document up and carry out analysis in the BI/MI field. We therefore fed our comments back to consultants (Link to Feedback document ) and a new version (004) was sent to us on 22 December.
• However most people were on Christmas leave then so was picked up week beginning 8 January.  The changes we requested have mostly been made but the document still doesn’t flow properly or explain the main techniques properly. The decision has been made between programme manager and project manager to accept this as the final version and the project manager will create a new version of the toolkit with input from other project managers and business analysts. This is to be agreed with the project sponsor on Friday 12 January.

Next Steps

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

Project is GREEN again as we have agreed a plan going forward

DTI022 - EDW Business Engagement  

Discretionary

Milestones

15-SEP-17              Planning Complete

24-JAN-18             Project Delivery

31-JAN-18             Project Close

RAG

GREEN

Report by Geoff  Cropley for December 2017

Achievements in Last Period

A change request was raised in December to reflect a timing challenge which meant that  - Migration Strategy paper would take longer than planned.  Expected delivery date is now 24th January 2018.  In addition, The deliverable Requirements Gathering Process within the Business Engagement Planning millstone is delayed and is now expected to complete on 18th January.

There were no impacts to budget or resources as there is sufficient remaining funding to accommodate the change.

These two project deliverables are progressing and are on track.

The communications strategy and plan is up and running with a lunchtime seminar scheduled for the end of January 2018. Governance, strategy and plans have been produced and formal acceptance is planned during January 2018. 

Issues

None to report

Next Steps

Sign off deliverables for Communications, Governance and Business Engagement.

Prepare Migration Strategy Options paper and complete the Requirements Gathering process and documentation.

Handover deliverables.