The DTI047 project may need to be suspended unless the End of Planning project brief can be agreed within next month. DTI047 set to RED until this issue is resolved - delays to End of Planning relates to resource conflicts within IS Apps and changing priorities and emerging constraints when setting BI Tools strategic direction
Automated solution for EDW access and authorisation is not urgent. Existing manual solution is robust enough for the short term. UoE are best advised not to invest in automation until future usage patterns of EDW are better understood
Both DTI034 and DTI047 need additional funding to continue into 19/20 - this will come from the DTI BI/MI Programme and has been agreed with the DTI Portfolio Manager, Stephen Roy
Key Achievements in Last Period
DTI034 - Qliksense upgraded to latest release, and new round of system testing in TEST in progress
DTI047 - EDW data access and authorisations options appraisal completed and high-level S/W dev team design and rough cost estimate done
Top Issues
Need to agree a long-term solution for EDW access and authorisations considering both the Qlik and Power BI user communities, and any budget implication
Need to deploy new Qlik services to LIVE
Key Next Steps
DTI034 - Deploy new Qlik services to LIVE
DTI047 - Complete End of Planning
DTI047 - Complete DTI047 deliverables
Status and Forward Look at end of March 2020
Resource Summary to end of March 2020
Section Two: Projects Not Started
Project Info
Project Manager's Commentary
Section Three: Projects in Progress
Project Info
Project Manager's Commentary
DTI034 - Qlik Implementation
Discretionary
Milestones
Qlik Sense deploy to LIVE - 15-April
Qlikview CAHSS user and data migration - 22-April
Closure: Mar 2020
RAG - GREEN
Report by Jamie Thin for Mar 2020
Achievements this period
Qlki Sense passed UAT testing incl Qlik Sense ADFS integration with AD group permissions Qlik Sense deploy to LIVE scheduled for 15-April 2020 Project team adjusted to working from home
Next Steps
Complete Qlik Sense deploy to Live
Run Qlik Sense Pilot for GASP
Launch new Qlik Sense service
Supplier BME to complete Qlikview software updates
Supplier BME to move users and data from GASP local server to new Qlikview service
Complete Qlikview UAT and deploy to LIVE
Launch new Qlikview service
Complete remaining project deliverables and handover to BAU teams
Close project
Issues
Qlikview milestones has been moved back to allow project team to focus on Qlik Sense go-live first ( Milestone changes approved by Project Sponsor)
RAG Commentary
Action has been taken to get project from AMBER to GREEN - ADFS config issues have been fixed and passed testing
DTI 047 - BI Embed and Optimise
Discretionary
Milestones
End of Planning:
May 2020
RAG - RED
none
option to formally suspend project is being considered - effectively work on the project is already suspended while other more urgent work is prioritised
Early discussions of University-wide Reporting TOM (Target Operating Model) have started to run in parallel to development of the People & Money TOM
Report by Jamie Thin for Mar 2020
Achievements this period
Next Steps
Issues
Dependency on approved outcomes of UoE wide Reporting TOM - suspend project until these are known
Project should be suspended as End of Planning was not complete by Wed 26-Feb
More time to complete planning now People & Money milestones have moved, and HR datamart will go-live later
Need the EDW access and authorisation business requirements to become more stable before any work starts on implementing the recommendations from the Options Appraisal
Additional business requirements need to be collected for support of both Qliksense and Power BI
Need to understand how the security model will be managed for the Finance datamart - it is expected that the BI team may need to deliver multiple different datamarts for different user groups
Need to bid for funding to automate interim manual solution ( rough estimate 50d small project requiring 20d effort from IS Dev services team)
Next Steps
Dependency - Fine tune existing manual approach for EDW access and authorisation through a small pilot with GASP ( via DTI034)
Agree how any extra unplanned work will be funded - either as part of new phase of DTI047 , or to be delivered by a new project
Complete work to launch Service wrapper for the new EDW Datamarts as part of go-live of EST109 and DTI049
Launch full EDW service wrapper to provision service requests from BI Developers and MI Analysts from across the Schools, Colleges , Support Groups and other business units
Close project
RAG Commentary - RED ISSUE- Resource conflict in IS Service Management team and BI team ,
IMPACT End of Planning not completed, ACTION - Suspend project until resources are available to continue with the Project and outcome of UoE wide Reporting TOM is known, and deliver in line with DTI049 HR datamart go-live for Dec 2020
