Report for July 2019

Report Date
July 2019

 

Programme Commentary

Overall BI/MI Programme is AMBER.

DTI049 is AMBER due to  emerging issues around the design options to connect BI Tools to the Enterprise Data Warehouse (EDW)

Geoff Cropely has now finished his contract and has handed over the BI/MI Programme Manager role to Jamie Thin. Jamie Thin is now also PM for DTI049.

 

BI / MI Programme - Key Achievements in Last Period

  • BI/MI team attended 2-day agile training course
  • Agile scrum methodology adopted for DTI049 for HR Datamart delivery

 

BI / MI Programme - Top Issues

  • Service management resourcing model unresolved
  • Difficulties agreeing BI/MI scope boundaries with SEP Core Systems, due to their need of a 'Historic Data Store' (HDS) and expectations this would have been delivered by the EDW programme.

...this may utilise the data warehouse, although other options should be investigated and the requirements are not yet understood. Advice from Enterprise Architecture has led to invalid assumptions that this will met through the DT funded BI Team, whereas it will need its own management and resourcing. Had previously agreed this with Core Systems but now needing to clarify that position again.

  • Agreed Business Analyst resource from Core Systems not forthcoming.

...expected a dedicated resource to proactively cover reporting requirements but BAs have had delays in recruitment (expected July) and SEP process is to submit individual work package requests. Current expectation is to not receive much help for the analysis of strategic reporting requirements or data sourcing from existing systems, mitigated as much as possible by an increase in GaSP MI Analyst time seconded to the programme until the end of this year at least. Ideally need to increase Wilbert's time this year to cover increased data sourcing analysis but he has no spare capacity.

 

BI / MI Programme - Key Next Steps

  • Agree programme brief with stakeholders.
  • Estimate size of the HR datamart , Finance datamart and eRecruitment datamart - to find into overall sprint planning - how many sprints per project
  • Initiate Discovery/Analysis project for  Finance strategic reporting requirements and data sourcing
  • Confirm resourcing commitment with Service Management.
  • Agree scope limitations and expectations with SEP Core Systems programme
  • Programme Risk Review and consolidate related EDW/BI Tools risks.
  • Arrange comms plan with Shaun and BI Team.

--

RAG Forward Look to end of July 2019

 

DTI BI Tools RAG at end of July 2019

 

 

Resources to the end of July 2019

 

BI/MI Programme - actual spend to end of July 2019

 

 

 

Section Two: Projects Not Started 

 

Project Info Programme Manager's Commentary

Project Code / Project Name

Category: Compliance / Discretionary

New projects in the DTI plan for 19/20

 

 

Section Three: Projects in Progress

 

Project Info Project Managers Commentary

DTI049 BI Reports Discovery

Category: Discretionary

Milestones

 

Stage Milestone Due Date
Build    

 

RAG Status

AMBER

 

Report by Jamie Thin for July 2019

 

Achievements this period

  • Design and Build of the HR datamart has started
  • Project team attended 2 days agile training 
  • Project team are starting working to a scrum agile methodology
  • Initial backlog has been added to Jira 
  • Project Manager handover completed from Geoff Cropely to Jamie Thin

Issues

  • Long term solution for managing connections to EDW from BI tools to be resolved
  • Potential resource conflict with EST109 - Estates Strategic reporting - depending what new work arises out of the Estates UAT
  • Dependency on EST109 is preventing changes to EDW Access layer from being promoted to TEST
  • Waiting confirmation that the eRecruitment datamart has been formally brought into scope of the BI/MI programme

Next Steps

  • End of Planning to be completed
  • Full backlog to be collected for the HR datamart
  • Decision on whether the HR , eRecruitment and FInance datamarts should be separate projects within the BI/MI programme , or separate work packages in the DTI049 project

  

 

Section Four: Closed or Withdrawn Projects

 

Project Info Project Managers Commentary

Project Code / Project Name

Category: Compliance / Discretionary

Report by PM

This project was closed on ....

Please see the Completion Report for further information.

 

 

 

 

Resource Summary