The BI Tools programme has moved from RED to AMBER , now that a way forward has been agreed for DTI047. This still requires the resource gap in the IS Service Management team to be filled before the new end-to-end BI Tools services can be fully launched.
DTI047 will need additional funding to continue into 20/21 - this will come from the DTI BI/MI Programme and has been agreed with the DTI Portfolio Manager, Stephen Roy
Status and Forward Look at end of May 2020 ( BI Tools within wider BI/MI Programme)
** add update **
Resource Summary to end of May 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 - DONE
Qlikview CAHSS user and data migration - 22-April - DONE
Closure: June 2020
RAG - GREEN
Report by Jamie Thin for May 2020
Achievements this period
Qlik Sense pilot with GASP in progress with support of the project team Qlikview EASE SSO deployment completed for DEV, TEST & LIVE
Next Steps
Complete Qlik Sense Pilot for GASP Test the remote-qlik terminal services server as solution for CAHSS issues Launch new Qlik Sense service Launch new Qlikview service Complete remaining project deliverables and handover to BAU teams Close project
CAHSS users can not sign off the new Qlik view deployment until they can successfully connect remotely when working from home
Issues
Qlikview - licence lease and QMC access issues when users run the services from their work laptops when working remotely
DTI 047 - BI Embed and Optimise
Discretionary
Milestones
End of Planning:
May 2020
RAG - AMBER
Report by Jamie Thin for May 2020
Achievements this period
After escalation from ISG WIS - A way forward has been agreed with Stefan Kaempf, Dave Berry, Susan Cooke, Stephen Roy and Daniel Emerson.
Revised brief approved and new budget agreed to extend the project into 20/21 Agreed new minimum project brief to support launch of new HR Strategic reporting service in Dec 2020.
Issues
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
Next Steps
Dependency - Fine tune existing manual approach for EDW access and authorisation through a small pilot with GASP ( via DTI034)
Complete work to launch Service wrapper for the new EDW Datamarts
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 - AMBER ISSUE
Issue - End of Planning delayed , gap in resources in ISG Service Management, Business Impact - no major impact until Dec 2020 by which time the minimum EDW service wrapper must be available for the new HR Datamart, Action - new minimum scope to be agreed to deliver service wrapper for HR delivery in Dec 2020, and fit future milestones to resource availability in ISG Service Management
BI Tools actual spend to end of May 2020