Report for June 2020

Report Date
June 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





Qlik Sense deploy to LIVE - 15-April - DONE

Qlikview CAHSS user and data migration - 22-April - DONE

Closure:         June 2020


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


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






End of Planning:         

May 2020



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. 


  • 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


Programme Status
RAG Status
Has formal escalation taken place?