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

Discretionary

Milestones

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)

Issues

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

Discretionary

Milestones

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

Issues

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 Discretionary	Geoff Cropley - closed

Project Info

Project Manager's Commentary

DTI046 - BI Framework

Discretionary

Geoff Cropley - closed

Programme Status

RAG Status

Overall: AMBER

Has formal escalation taken place?: No

RAG Commentary: Resource conflicts for both projects and dependencies on agreeing the University wide BI Tools strategy

This article was published on Jan 15, 2020

Programme Commentary

Status and Forward Look

Resource Summary to end of Oct 2019

Section Two: Projects Not Started

Section Three: Projects in Progress

Section Four: Closed or Withdrawn Projects

Programme Info

Documentation