Report for March 2020

Report Date
March 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 March 2020


BI Tools RAG status as at end of Feb 2020



Resource Summary to end of March 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





Qlik Sense deploy to LIVE - 15-April 

Qlikview CAHSS user and data migration - 22-April

Closure:         Mar 2020


Report by Jamie Thin for Mar 2020

Achievements this period

Qlki Sense passed UAT testing incl Qlik Sense ADFS integration with AD group permissions  Qlik Sense deploy to LIVE scheduled for 15-April 2020 Project team adjusted to working from home
  • Next Steps

  • Complete Qlik Sense deploy to Live
  • Run Qlik Sense Pilot for GASP
  • Launch new Qlik Sense service
  • Supplier BME to complete Qlikview software updates
  • Supplier BME to move users and data from GASP local server to new Qlikview service
  • Complete Qlikview UAT and deploy to LIVE
  • Launch new Qlikview service
  • Complete remaining project deliverables and handover to BAU teams
  • Close project
  • Issues

  • Qlikview milestones has been moved back to allow project team to focus on Qlik Sense go-live first ( Milestone changes approved by Project Sponsor)
RAG Commentary
 Action has been taken to get project from AMBER  to GREEN -  ADFS config issues have been fixed and passed testing


DTI 047 - BI Embed and Optimise






End of Planning:         

May 2020



  • none
  • option to formally suspend project is being considered - effectively work on the project is already suspended while other more urgent work is prioritised
  • Early discussions of University-wide Reporting TOM (Target Operating Model) have started to run in parallel to development of the People & Money TOM
Report by Jamie Thin for Mar 2020

Achievements this period

  • Next Steps



  • Dependency on approved outcomes of UoE wide Reporting TOM - suspend project until these are known
  • Project should be suspended as End of Planning was not complete  by Wed 26-Feb
  • More time to complete planning now People & Money milestones have moved, and HR datamart will go-live later
  • 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 Service wrapper for the new EDW Datamarts  as part of go-live of EST109 and DTI049
  • 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 - RED ISSUE- Resource conflict in IS Service Management team and BI team ,

IMPACT End of Planning not completed, ACTION - Suspend project until resources are available to continue with the Project and outcome of UoE wide Reporting TOM is known, and deliver in line with DTI049 HR datamart go-live for Dec 2020




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
Programme RED as DTI047 is RED