The scope of this project is to deliver a strategic reporting solution for the following:

• Space Management. Covers the definitions and relationships between buildings, floors and rooms.
• Maintenance Management. Covers the activities of the hard services organisation when executing the on-going planned and reactive maintenance of the University’s 550 buildings. This covers approximately 60,000 reactive maintenance tasks and 30,000 compliance tasks per annum. The initial key reporting requirements centre on workload, performance & productivity, cost, and maintenance trend analysis.

The solution in question will include:

• A set of agreed, certified reports.
• The provision of an ad-hoc query capability to a limited number of suitably trained users, giving them the ability to extract data and generate their own custom analysis and reports.

The solution will utilise existing BI/MI services (SAP BI Suite), but based on a new capability; the Enterprise Data Warehouse (EDW).

The creation of the space and maintenance management subject-areas will not only serve the requirements of this project, but also act as a guiding light for all future Estates Management Information, Business Intelligence and strategic reporting projects.

-----------------------------------------------------------------------------------------------------------------

(Project Manager Comments) 

This project is a continuation of EST093 Estates Strategic Reporting. As the scope of the project is considerably clearer than it was back in April 2016, it has been decided to create a new project EST109 to cover the remaining activities.

The EST093 project brief was originally created in May 2016. The planning phase was completed and two pieces of business analysis were completed and signed-off. In December 2016 the project was put on hold for a number of reasons (resource constraints, changing business drivers, emerging EDW programme). As a different landscape emerged, the project was re-booted in June 2017.

Based upon the current situation, the brief and associated artefacts have undergone a major revision. This document supercedes all previous versions of the brief.

To refer back to the original brief, use the following link –

https://www.projects.ed.ac.uk/project/est093