Overview

The governance of the HR and Finance datamart projects DTI049 and DTI050 has moved to SEP People and Money programme as of 27-March 2020

BI/MI Programme will deliver datamarts for HR and Finance to enable Strategic reporting - these datamarts are in addition to the operational reporting provided by the Oracle Fusion People & Money system.

The DTI BI/MI budget for 19/20 and 20/21 is already committed to funding the dedicated BI team to build the HR and Finance datamarts within the UoE Enterprise Data Warehouse.

The BI team is also committed to completing the EST109 Estates Strategic reporting project - as this datamart will be the first to go live on the shared EDW infrastructure , and so is the pathfinder for the future HR and FInance datamarts

--

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

 

Governance

  • Report to  Service Excellence (SEP) Governance  groups and follow SEP PMO processes
  • Work as part of the SEP "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 the DTI BI/MI Programme Board which now reports to SEP People & Money Programme Board for DTI049 and DTI050
    • DTI BI/MI Programme board membership:
      • Jennifer Milne (Programme Owner and chair of DTI BI/MI Programme board) 
      • Lynda Hutchison ( UoE BI/MI Lead) 
      • Stephen Roy (DTI Portfolio Manager) 
      • Daniel Emerson (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. 

 

 

Contacts

Jamie Thin 0131-650-2108

jamie.thin@ed.ac.uk

Current Programme status

Report Date RAG
November 2020 AMBER
Code RAG RAG Date Manager Status Stage
DTI049 HR Datamart for Strategic Reporting RED November 2020 James Thin In Progress Build
DTI050 Finance Data Marts for Strategic Reporting AMBER October 2020 Ben Armstrong In Progress Plan