Report for Oct 2019
- Report Date
- October 2019
Programme Commentary
Overall BI/MI Programme is AMBER.
DTI049 - HR Strategic Reporting - has completed four x 3-week agile sprints and Sprint 5 is now in progress
DTI050 - Finance Strategic reporting - has been started - planning stalled while focusing on HR Strategic Reporting
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 4 completed - ETL job created to pull funding into HR datamart foundation layer
- BI/MI - programme risk review started with risk workshop
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 Oct 2019
Resources to the end of Oct 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 HR Strategic ReportingCategory: Discretionary Milestones
RAG StatusAMBER |
Report by Jamie Thin for Oct 2019
Achievements this period
Issues
Next Steps
|
||||||||||||||||||||||||
DTI050 Finance Strategic ReportingCategory: Discretionary Milestones
RAG StatusAMBER |
Report by Jamie Thin for Oct 2019
Achievements this period
Issues
Next Steps
|
Section Four: Closed or Withdrawn Projects
| Project Info | Project Managers Commentary |
|
Project Code / Project Name Category: Compliance / Discretionary |
**Add** Report by PM This project was closed on .... Please see the Completion Report for further information. |
|
|
| Attachment | Size |
|---|---|
 BI/MI actual spend to end of Oct 2019 | 19.84 KB |
| BI MI RAG status as at end of Oct 2019 | 35.73 KB |
