BI/MI Programme has delivered a new HR datamart to enable Strategic reporting - this datamart is in addition to the operational reporting provided by the People & Money system.

The governance of the HR and Finance datamart projects DTI049 and DTI050 moved from Digital Transformation to the People and Money programme as of 27-March 2020 and then back to ISG from 1-Aug 2021

--

The programme is now focused on the HR datamart.

The Finance datamart project (DTI050) has been closed , as there is over-lap with other work going on as part of the Historic Data Store  (HDS) programme and People & Money Finance transformation.

This programme bis built on previous DTI projects which built the in-house Enterprise Data Warehouse (EDW) platform and procured new BI tools.

Governance

• Report to - People & Money Governance groups and follow People & Money PMO processes
• Work alongside the "Virtual Programme for Coordination of Reporting & BI/MI Delivery" that is lead by Lynda Hutchison
• Direct governance and decision making on Scope, Quality, Budget and Timescales  is via Project sponsors and Programme Sponsors who report to People & Money Programme Board 
  • Previous DTI BI/MI Programme board membership ( as of 2021) - not now active in 2022 - new BAU governance structure will be put in place for 2022 onwards:
    • Jennifer Milne (Programme Owner and chair of DTI BI/MI Programme board) 
    • Lynda Hutchison ( UoE BI/MI Lead) 
    • Stephen Roy (DTI Portfolio Manager) 
    • Alison Townsley (ISG BI Lead)
    • Alex Carter (ISG EDW Service owner) 
    • Dave Berry ( ISG Enterprise Architect and DTI049 / DTI050 Senior supplier)
    • Jamie Thin ( DTI BI/MI Programme Manager)
• Responsibilities of the DTI BI/MI Programme board:
  • Initiate new projects as required
  • Identify key stakeholders from each business area for each of the HR, Finance, Payroll, Procurement and HR recruitment datamarts
  • Use the Gasp MI Analyst engagement model  for effective stakeholder management  and gathering of business requirements
  • Deliver a Communications Plan
  • Bid for new funding / Request new resources - as required 

K:\ISAPPS\dsg\Projects\DTI - BI MI Programme

Approach

• Agree Vision & Goals
• Understand why people need to use HR and Finance data and identify what data, how this is defined, seeking agreement on data definitions and how to join HR & Finance data together and dimensional modelling
• Develop the required HR, Finance, Payroll, Procurement and HR recruitment datamarts
• Define what data is to be brought in and how it is to be defined
• Develop a high-level plan and roadmap with timescales for implementation of strategic reporting and analytics for HR and Finance

Scope

• Dedicated team tasked to design, build and test the HR, Finance, Payroll, Procurement and HR recruitment datamarts
• Managed end-to-end integration testing with UoE centrally supported BI Tools - SAP BI Suite, Qliksense and MS Power BI
• Manage User engagement through a User group , and manage structured User Acceptance testing by the user community for each new datamart

Out of Scope

 Any other datamart development for other business areas including Student, Applicant and Research.

 Responsive BI Service Development.

SEP Core systems Historic Data Storage service.

Resourcing

IS Apps is resourcing the Programme with a dedicated BI team using fixed term appointments and/or backfilling seconded roles. 

Jamie Thin 0131-650-2108

jamie.thin@ed.ac.uk