Report for Feb 2020

Report Date
February 2020

Programme Commentary

Overall the programme is RED

The DTI047 project may need to be suspended unless the End of Planning project brief can be agreed within next month. DTI047 set to RED until this issue is resolved - delays to End of Planning relates to resource conflicts within IS Apps and changing  priorities and emerging constraints when setting BI Tools strategic direction 

Automated solution for EDW access and authorisation is not urgent. Existing manual solution is robust enough for the short term. UoE are best advised not to invest in automation until future usage patterns  of EDW are 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 upgraded to latest release, and new round of system testing in TEST in progress
  • DTI047 - EDW data access and authorisations options appraisal completed and high-level S/W dev team design and rough cost estimate done

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 End of Planning
  • DTI047 - Complete DTI047 deliverables



Status and Forward Look at end of Feb 2020


BI Tools RAG status as at end of Feb 2020



Resource Summary to end of Feb 2020


BI Tools actual spend to end of Feb 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






Closure:         Mar 2020


Report by Jamie Thin for Feb 2020

** Add new text **

Achievements this period

Project team started testing access and authorisation to Qliksense based on AD group membership BME  applied the software updates to bring both Qliksense DEV / TEST / LIVE  to the latest version 
  • Next Steps

  • Complete Acceptance testing sign-off
  • Complete Deployment Checklist
  • Schedule Go Cab change control to promote Qliksense SSO using ADFS config to LIVE ( with ITI )
  • Complete remaining project deliverables and handover to BAU teams
  • Communicate delivery plan to user community via IS Service Management
  • Close project
  • Issues
  • Need to resolve issue with 'unqualified group names' being passed by the ADFS config from AD to Qliksense
RAG Commentary
AMBER issue - Technical issue with ADFS integration and 'unqualified AD group names' to be resolved before testing can be completed in TEST Business Impact - Delay to start of Qliksense pilot for GASP, legacy installations can still support local Qlikview service for GASP and CAHSS so not impact on existing Qlikview users Action to get to GREEN - fix any ADFS config issues which come out of UAT


DTI 047 - BI Embed and Optimise






Closure:         Mar 2020



Report by Jamie Thin for Feb 2020
** Add new text **

Achievements this period

  • EDW Access and authorisation options appraisal completed with outline design & costing of the IS Apps dev work to automate the existing manual provision of Oracle user accounts.


  • Project will be suspended if End of Planning not approved by Wed 26-Feb
  • 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
  • Need to bid for funding to automate interim manual solution ( rough estimate 50d small project requiring 20d effort from IS Dev services team)

Next Steps

  • Dependency - Fine tune existing manual  approach for EDW access and authorisation through a small pilot with GASP ( via DTI034) 
  • 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 launch new EDW Datamarts  as part of go-live of EST109 and DTI049
  • Launch new EDW service for MI Analysts using Power BI and Qlik BI Tools
  • Close project 


RAG Commentary - RED Issue - Resource conflict within project team , unfilled vacancies in IS Service Management team - End of Planning should be approved by 26-Feb 2020, or ISG PMO instruct that the project should be suspended. Business Impact - if project suspended and DTI047 deliverables are delayed, the launch of the HR datamart for HR Strategic reporting required for the People and Money programme will be delayed Action required - project stakeholders for DTI047, need to prioritise approving the End of Planning project brief w/c 24-Feb , over and above other competing activities. ISG SLT should prioritise approving PRAFs and enable vacancies to be filled quickly else there will be resource conflicts for project work




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?
Escalated to
DTI BI/MI board
RAG Commentary
Programme is RED as one project is RED