This month, we’ve been putting support procedures in place for the HR strategic reporting data mart, and addressing data questions from its first users. We’re making sure that all queries are tracked and raised by calls in Unidesk, the University’s incident tracking system.  This makes it easier to route calls to the right people to […]

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 […]

One of the challenges we faced in designing our HR data mart was how to map the data from the old HR and Payroll system into the new data model used by the People & Money system. As an example of the problem, consider the data about which posts are funded from which sources – […]

This is a third post in what is becoming a series about our work on the data warehouse.  We have just handed a new release of our HR data mart to a small group of BI analysts, who will test it before we deploy the live version.  This release is significant because for the first […]

With increasing numbers of data analysts across the University using Power BI, the HR Datamart project decided to make strategic HR data available in Power BI workspaces.  We have achieved this, but it turned out to be significantly more work than we expected. Power BI is a data visualisation tool that lets analysts present information […]

Earlier this month, we had a stimulating conversation with colleagues from another Scottish university, in which we compared our approaches to structuring our core data.  We share the goal of making our core data as valuable as possible, in a world where data analytics is of increasing importance.   Much data analysis now manipulates data […]