Report for May 2020

Report Date
May 2020

 

Programme Commentary

Overall the programme is AMBER

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 **

BI Tools RAG to 29-April

 

 

 

Resource Summary to end of May  2020

BI Tools actual spend 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

 

 

 

Section Four: Closed or Withdrawn Projects

Project Info Project Manager's Commentary

DTI046 - BI Framework

Discretionary

Geoff Cropley - closed

 

 
   
Programme Status
RAG Status
Overall
AMBER
Has formal escalation taken place?
Yes
Escalated to
Dave Berry and Susan Cooke for IS Service Management team resources
RAG Commentary
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.