This month has seen slow ans steady progress on several fronts.  We don’t have a big shiny reveal to boast about, just incremental work. Much of my attention has been on staffing changes, as the funding for the data warehouse team is shifting from fixed-term to open-ended contracts.  This means that some members of staff […]

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

I’m currently experimenting with various types of modelling diagrams, with a goal of finding which work best for us.  But what do I mean by “best”, and who do I mean by “us”? The original profession of architects, i.e. the people who design buildings, have been creating 3-D models for centuries.   Minu shows some examples […]

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