Report for Aug 2019

Report Date: August 2019

Programme Commentary

Overall BI/MI Programme is AMBER.

DTI049 is AMBER until the sprint velocity is understood and a better overall estimate of cost to complete the HR datamart is known

- starting assumption is 6 dev sprints + 2 maintenance sprints and budget of 350 + ISG days effort

BI / MI Programme - Key Achievements in Last Period

DTI049 Sprint 1 started

BI / MI Programme - Top Issues

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.

Agreed Business Analyst resource from Core Systems not forthcoming.

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 Aug 2019

DTI BI Tools RAG at end of July 2019

Resources to the end of Aug 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.

This article was published on Oct 2, 2019