Report Date
December 2019
Achievements this period
Sprint 6 completed - Access layer basic star schema / connection to BI Tools
EDW prep for automated deployments to Foundation Layer - Git / Bamboo Synch between DEV, TEST and LIVE has been done for Foundation layer
Planning for Sprint 7 and Alpha release done
Issues
Budget will need to be increased - 280+ days has been spent from initial allocation of 300 days and this is for the load of historic legacy data before the new core HR data is loaded
Next Steps
Full backlog to be collected for the HR datamart
Complete Sprint 7
Alpha release to LIVE
Plan Beta release
Start analysis for loading the new HR data from the new Core system
Project Status
RAG Status
Time
RED
Cost
RED
Scope
AMBER
Overall
RED
RAG Commentary
*RED Issue* - Time - can't deliver full HR datamart for legacy and new HR data by June 2020. Project requires more time and budget. Resource conflict with Finance Datamart queued behind HR. If Finance work is more important than HR, then some HR work might need to be put on hold to focus on Finance. There are also resource conflicts across the business leads , HR SME's across the university who are also working on the ERP implementation at the same time , and the People and Money ERP implementation takes priority over the DTI Strategic reporting work.
*Business Impact* - First alpha release of the HR datamart with legacy data may not be available until Feb 2020 , Work hasn't yet started on the new People & Money HR data which will be consumed via APIs from the cloud ERP.
The Beat release joining up data from legacy data source and new data source may be not be ready for the June 2020 SEP People and Money HR Go-Live. Actual impact on business activities is unknown at this point in time. Some business planning activities may not have access to best longitudinal data to pick out trends - or this data may still be available, but might have to be cobbled together by MI analysts from multiple separate sources taking more effort and time.
*Action to get project back to AMBER or GREEN* - By end of Feb, the impact of the SEP core systems re-plan should be known. If some of the SEP core system delivery milestones move - then it is likely the project RAG can move to AMBER as there will be more time to complete work on the HR datamart. If the SEP People and Money HR go-Live stays as a hard deadline in June 2020 - then as a contingency, discussions have started with budget holders to request additional funding to scale up the BI team - so that work on the HR and Finance datamarts can be done in parallel. Note there is currently no DTI funding for the BI project team beyond July 2021. This funding cap will curtail the scope of datamart development work. Once the HR and FInance datamarts have been delivered, there will need to be funding for some BI resources in IS Apps beyond July 2021 to maintain the datamarts and EDW to ensure a sustainable transition to business-as-usual.
Change Status
Time
Significant
Cost
Significant
Scope
Moderate
Overall
Significant
Has formal escalation taken place?
Yes
Escalated to
Lynda Hutchison, Project Sponsor
Change Commentary
Reviewing velocity through build work and the outstanding work to complete for the Alpha and Beta releases to LIVE, the project is larger than initially estimated
Activity
Approved budget
300.0 days
Activity this month
30.0 days
Activity this year
245.0 days
Activity to date
326.0 days
Estimate to complete current year
100.0 days
Estimate to complete future years
50.0 days
This article was published on Jan 24, 2020
