Report for Dec 2019

Report Date
December 2019

Programme Commentary

Overall the programme is AMBER.

Automated solution for EDW access and authorisation is not urgent. Existing manual solution is robust enough for the short term. Don't want to invest in automation until future usage patterns  of EDW is 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 hooked up to HR datamart on EDW in DEV. Prep for deploy to LIVE started
  • DTI047 - EDW data access and authorisations options appraisal held and way forward agreed

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 options appraisal and secure funding to deliver recommended option



Status and Forward Look


RAG status as at end of Dec  2019



Resource Summary to end of Dec 2019


BI Tools actual spend to end of DEC 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:         Mar 2020

RAG - Amber

Report by Jamie Thin for Dec 2019


Achievements this period

Conf call with BME to better understand permissions model in Qlik MBME granted access to Qlik Management Console to Andrew McFarlane - so Andrew could continue the config work started by Anne Major MI Analyst (Kevin Harkin) did a show & tell of the steps to get Qliksense hooked up to the EDW and HR data with his named user Oracle account connection Discussed early pilot of Qliksense with GASP
  • Next Steps

  • Implement actions from review of optimum Qlik architecture  & configuration of new service for LIVE with Qlik and BME consutlants ( conf call on 29-Oct) 
  • Schedule Go Cab change control to promote Qliksense SSO using ADFS config to LIVE ( with ITI and other ISG teams)  
  • Complete remaining project deliverables and handover to BAU teams
  • Communicate delivery plan to user community via IS Service Management
  • Close project
  • Issues

  • Need to complete scenario testing of AD groups and how they will work with the Qliksense access and authorisation ( task in  TEST )
RAG Commentary
Amber Issue - Project team resources - Testing stalled after a key member of the team left the University. IS service Management have made resources available to cover gap . New milestones will be agreed with project sponsor during Jan 2020


DTI 047 - BI Embed and Optimise






Closure:         Mar 2020


RAG - Amber

Report by Jamie Thin for Dec 2019

Achievements this period

  • Consensus reached within project team for recommended option - to extend existing interim solution to add some scripting and automation , to allow the interim solution to scale up to bigger numbers of users
  • Resource booking made with IS Apps S/W dev team for developer to do some outline design work and price up the work


  • Need to bid for funding to automate interim solution ( rough estimate 50d small project requiring 20d effort from IS Dev services team, pending more detailed estimation from the developer)

Next Steps

  • Fine tune approach for access and authorisation through a small pilot with GASP
  • 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 embed new EDW / BI Tools service
  • Launch new service
  • Close project 

RAG Commentary

Amber Issue - need a steer on BI Tools strategy to align this project work with longer term strategy. Propose to fully support both Qliksense and Power BI. Need to agree business requirements to feed into estimate of development costs of the EDW Access and Authorisation solution.

Some requirements will be agreed through a pilot with GASP



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 conflict for both projects and dependency on agreeing the University wide BI Tools strategy