Report for Nov 2019

Report Date

November 2019

Programme Commentary

Overall BI/MI Programme is RED.

DTI049 - HR Strategic Reporting - has completed five x 3-week agile sprints and Sprint 6 is now in progress 

DTI049 will require additional budget , as it hasn't yet completed the load of the legacy HR data , and still has to load the new HR data from Core systems (AMBER)

DTI050 - Finance Strategic reporting -   planning stalled while focusing on HR Strategic Reporting (RED)

Both DTI049 and DTI050 have been set to Higher priority on the IS Applications overall priority scale ( up from 'Normal' to 'Higher') . This is a 3 step priority scale from Normal to Higher to Highest.

BI / MI Programme - Key Achievements in Last Period

• DTI049 Sprint 5 completed - Access layer prototype in DEV
• DTI049 Sprint 6 planning done and new sprint started

BI / MI Programme - Top Issues

• Some of the BI team resources had to be assigned to the EST109 Estates Strategic Reporting project - to get that project over the line for start of UAT Phase 2
• 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 Enterprise Architecture (EA) input this year to cover increased data sourcing analysis but EA team has limited spare capacity.

BI / MI Programme - Key Next Steps

• Agree programme brief with stakeholders.
• Estimate size of each separate datamart project -  HR datamart , Finance and Payroll datamarts and eRecruitment datamart - to feed into overall sprint planning - how many sprints per project
• Confirm resourcing commitment with IS Production Management ( estimated 0.2 FTE) - who and when and governance for agreeing changes as project goes through the different stages of built & Test
• Agree scope limitations and expectations with SEP Core Systems programme / REF / Historical data store
• Programme Risk Review and consolidate related EDW/BI Tools risks.
• Agree  comms plan with Lynda Hutchison and Programme stakeholders 

--

RAG Forward Look to end of Nov 2019

Resources to the end of Nov  2019

Section Two: Projects Not Started 

Section Three: Projects in Progress

Section Four: Closed or Withdrawn Projects

Attachment	Size
BIMI Actual spend to end of Nov 19	19.67 KB
BIMI RAG to end of Nov 19	39.86 KB