Report for Nov 2020

Report Date
November 2020

**Draft**

 

Programme Commentary

Overall the programme is AMBER

The BI Tools programme is AMBER ,  budget for 20/21 has been agreed with People & Money

 

 

Status and Forward Look at end of Oct 2020 ( BI Tools within wider BI/MI Programme)

** add update **

 

 

 

Resource Summary to end of Oct  2020

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

 

Discretionary

 

Milestones

Qlik Sense deploy to LIVE - 15-April - DONE

Qlikview CAHSS user and data migration - 22-April - DONE

Closure:         Oct 2020

RAG - GREEN

Report by Jamie Thin for Aug 2020

Achievements this period

Qlik Sense pilot with GASP completed

 

Next Steps

Complete remaining project deliverables and handover to BAU teams

Close project

 

Issues

Qlikview - licence lease and QMC access issues when users run the services from their work laptops when working remotely

CAHSS users can not sign off the new Qlik view deployment until they can successfully connect remotely when working from home

 

 

 

DTI 047 - BI Embed and Optimise

 

Discretionary

 

Milestones

 

End of Planning:         

28-Aug 2020 (Done)

 

RAG - AMBER

Report by Jamie Thin for Aug 2020
 

Achievements this period

 

  • Revised brief approved and End of Planning completed ,   the project will extend into 20/21
  • Agreed new minimum project brief to support launch of new HR Strategic reporting service in Dec 2020. 

Issues

 

  • 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

Next Steps

  • Dependency - Fine tune existing manual  approach for EDW access and authorisation through a small pilot with GASP ( via DTI034) 
  • Complete work to launch Service wrapper for the new EDW Datamarts 
  • 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 - AMBER ISSUE

Issue - waiting for Budget for 20/21 to be agreed. Budget is transferring from ISG to People & Money (USG)

 

Programme Status
RAG Status
Overall
AMBER
Has formal escalation taken place?
No
RAG Commentary
AMBER - DTI034 closure delayed by open issues - Qlikview on new VPN issues escalated to ITI