Report for Feb 2020

Project Manager's Commentary

DTI034 - Qlik Implementation

Discretionary

Milestones

Closure:         Mar 2020

RAG - AMBER

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

Discretionary

Milestones

Closure:         Mar 2020

RAG - RED

 

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.

Issues

• 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

DTI046 - BI Framework

Discretionary

Geoff Cropley - closed