Report for Nov 2019

Report Date
November 2019

Programme Commentary

Overall the programme is AMBER.

Problem with long-term solution for  EDW access and authorisations is unresolved

  • short-term workaround agreed to allow access for EST109 Estates Strategic reporting UAT , and for testing of DTI049 HR datamart

Open issues with DTI034 and DTI047 have prevented these projects from being closed by planned closure date of 31-July 2019.

Key Achievements in Last Period

  • DTI034-  Conf call with Qlik & BME to agree LIVE architecture and configuration
  • DTI047 - Prep and business requirements gathering for EDW data access and authorisations options appraisal workshop

Top Issues

  • Need to agree a long-term solution for EDW access and authorisations, and any budget implication
  • Need to deploy new Qlik services to LIVE

Key Next Steps

  • DTI034 - Deploy new Qlik services to LIVE
  • DTI047 - Complete options appraisal and secure funding to deliver recommended option



Status and Forward Look


Bi Tools  RAG status as at end of Oct 2019



Resource Summary to end of Oct 2019


BI Tools actual spend to end of Oct 2019





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






Closure:         Jan 2020

RAG - Amber

Report by Jamie Thin for Oct 2019


Achievements this period

Reviewed optimum Qlik architecture  & configuration of new service for LIVE with Qlik and BME consutlants ( conf call on 29-Oct) 


  • Next Steps

  • Complete remaining project deliverables and handover to BAU teams
  • Communicate delivery plan to user community via IS Service Management
  • Close project
  • Need to schedule Go Cab change control to promote Qliksense SSO using ADFS config to LIVE ( with ITI and other ISG teams)  
  • 1d extra BME consultancy required to complete Qliksense SSO deployment to LIVE ( PM to raise PO) 
  • Limited availability of project team has delayed some planned tasks
  • Need to complete more scenario testing of AD groups and how they will work with the Qliksense access and authorisation ( task in  TEST )



DTI 047 - BI Embed and Optimise






Closure:         Jan 2020


RAG - Amber

Report by Jamie Thin for Oct 2019

Achievements this period

  • Prep for Access and Authorisation Workshop done
  • Workshop scheduled for 7-Nov
  • Conf call with Qlik supplier (on 29-Oct,  as part of DTI034) helped answer some questions in relation to how the Qlik BI Tools can be configured for access and authorisation 


  • Need to agree long-term solution and new processes for  granting EDW access and authorisation 

Next Steps

  • Collect business requirements, and complete options appraisal for EDW access and authorisation technical solution
  • Agree how any extra unplanned work will be funded
  • Complete work to embed new EDW / BI Tools service
  • Close project 





Section Four: Closed or Withdrawn Projects

Project Info Project Manager's Commentary

DTI046 - BI Framework


Geoff Cropley - closed


Programme Status
RAG Status
Has formal escalation taken place?
RAG Commentary
Resource conflicts for both projects and dependencies on agreeing the University wide BI Tools strategy