Any views expressed within media held on this service are those of the contributors, should not be taken as approved or endorsed by the University, and do not necessarily reflect the views of the University in respect of any particular issue.

Enterprise Architecture

Enterprise Architecture

Discussion and news from the Enterprise Architecture (EA) service

Data Mart for HR Strategic Reporting

Our data warehouse team are winding up work on the HR Strategic Reporting data mart, which we have developed in support of the University’s programme to replace our ancient HR and Finance processes and systems.

The first release of the data mart was a year ago and contained the strategic data from the old HR system.  At the time, this was little noticed, because analysts could continue to use the old data mart.

In January, the second release included a subset of the data from the University’s new “People & Money” system.  The final release, in May, added funding data, along with mappings from the old data schemas to the new ones, so that analysts could provide trend reports regardless of the underlying change in data sources.

The final release coincided with switching off the old data mart and so we started to get more feedback from the analysts.  Our post-live support work has focussed on these user-led requirements, and we are poised to reach a stable state.

We have also worked with colleagues in Service Management and HR to put processes in place to manage support calls and access requests.   The core audience for the data mart is a core group of MI analysts who are preparing reports that they will share across the University.

Members of University staff can see more information about the HR Strategic Reporting Data Mart via the Core Data Hub SharePoint site:

Leave a reply


Report this page

To report inappropriate content on this page, please use the form below. Upon receiving your report, we will be in touch as per the Take Down Policy of the service.

Please note that personal data collected through this form is used and stored for the purposes of processing this report and communication with you.

If you are unable to report a concern about content via this form please contact the Service Owner.

Please enter an email address you wish to be contacted on. Please describe the unacceptable content in sufficient detail to allow us to locate it, and why you consider it to be unacceptable.
By submitting this report, you accept that it is accurate and that fraudulent or nuisance complaints may result in action by the University.