Report for July 2019

Report Date: July 2019

Section One: Programme Commentary, RAG and Resources Update

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

2-day agile training delivered to BI/MI project team
DTI034 has started proof-of-concept ADFS config for Qliksense SSO (instead of EASE / samil)
Problem with EDW data access and authorisations addressed in meeting with key IS Apps stakeholders
- short-term workaround agreed to allow access for EST109 Estates Strategic reporting UAT , and for testing of DTI049 HR datamart
- next steps identified as part of fuller options appraisal
Handover of Programme Manager and Project Manager role for DTI BI/MI and BI Tools programmes from Geoff Cropely to Jamie Thin

Top Issues

Need to agree a long-term solution for EDW access and authorisations

Key Next Steps

Close DTI034 and DTI047
Sign-off project brief for DTI049

Status and Forward Look

DTI BI Tools RAG to end July 2019

Resource Summary to end of July 2019

DTI BI Tools actual spend to end July 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

31-Aug-2019 Project Closure

RAG - Amber

Qliksense SSO using ADFS proof of concept is in TEST - with UoE / BME to complete config and testing
Meeting held to discuss end-to-end solution for EDW access and authorisation from Qlik BI Tools to EDW ( will be taken forward as part of DTI049)

Report by Jamie Thin for July 2019

Achievements this period

Next Steps
Complete Qlikview Single Sign-on access using ADFS in TEST
Agree process to promote ADFS config to LIVE ( with ITI and other ISG teams)
Complete remaining project deliverables and handover to BAU teams
Close project
Issues
Change of Project Manager - Geoff Cropely has finished his contract and has handed over to Jamie Thin
Error with ADFS config in Qliksense TEST to be resolved by UoE / BME

DTI 047 - BI Embed and Optimise

Discretionary

Milestones

Closure: 31/08/2019

RAG - Amber


Report by Jamie Thin for July 2019

Achievements this period

Limited progress
Change of Project manager from Geoff Cropely to Jamie Thin, now Geoff has finished his contract
The project didn't close by 31-July, so it now expected to close early in 19-20
Meeting held with project team and key IS Apps stakeholder to discuss problems with EDW access and authorisation
- short term workaround agreed, longer term solution required for full roll of BI Tools and the HR and Finance data marts

Issues

Need to agree long-term solution for EDW access and authorisation

Next Steps

Get agreement to push the long-term solution for EDW access and authorisation into DTI049 , as this project will do the end-to-end testing of the BI Tool connection to the EDW for the new HR datamart
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

Attachment	Size
DTI BI Tools actual spend to end July 2019	24.18 KB
DTI BI Tools RAG to end July 2019	41.05 KB

This article was published on Aug 9, 2019

Report for July 2019