Report for Feb 2019

Report Date

February 2019

Achievements in Last Period

• Project has been suspended since 13-July 2018
• The Business team have confirmed that they now have a viable alternative solution for reporting that has been built using Microsoft Power BI against the raw Worktribe BI Data extract to produce KPI reports and other useful reporting
• The Business lead and project sponsor don't want to invest any more effort in the BI Suite universe solution
• It is now proposed that the STU252 project is withdrawn
• Draft closure report has been written

Issues

• Open - Lessons learned to be documented in the closure report
• Unresolved - UAT testing failed - could not get the figures to match in the BI Suite KPI reports and the existing KPI reports
• Unresolved - UAT testing failed - could not replicate the user permissions model as implemented in the Worktribe application , in BI Suite.
  • Risk that BI suite users could get access to a wider set of data for other research projects that they were not entitled to see.
    • Workaround  of providing no org unit data restrictions to small group of super users / managers in the centre has been rejected by Business lead
    • Workaround explored with IS Service Management of applying row level permissions within BI Suite , but doesn't look like this would work for  IGMM and Roslin, nor would complex data structures with collaborative projects with multiple budgets for each Org unit

Next Steps 

• Lessons learned meeting scheduled on Wed 13th March  - with Damon Querry, Kelvin Clark, Dave Berry , Danny Emerson, Geir Granum, John Chan, Jamie Thin - to feed into future BI / MI and Enterprise Data Warehouse projects
• Complete final closure report and close project

Milestones

Closure Milestone - date updated