The Enterprise BI Team based in PACS was established in early 2024 to develop and release new reports and data solutions.
The following profiles highlight examples of work delivered by members of the Enterprise BI Team:
Andy Crowley Collins, Business Intelligence Developer
Worked closely with the Finance team to unblock and progress the integration of source data from financial systems into the on premises data warehouse. This included collaboration with subject matter experts to develop reporting logic layers that streamline access to data and support a wide range of users with differing needs.
Supported the development of several Power BI reporting solutions, including significant contributions to the Budgeting and Forecasting Tool and Principal Investigator reporting. The latter makes use of the new data warehouse architecture and brings together data from multiple professional service areas, enabling cross cutting, multi discipline reporting.
Collaborated extensively with the Planning and Council Secretariat (PACS) team to deliver reporting that supports strategic level project oversight and committee membership analysis. In addition, worked with the Assurance team to develop strategic management insights derived from training completion data and survey outcomes.
Christopher Goodland, Business Intelligence Developer
Worked predominantly on cross domain dataset development, with a significant focus on identifying and addressing data quality and referential integrity issues when integrating data from multiple source systems via the data warehouse. This work culminated in the development of a prototype Principal Investigator report, which brings together data spanning Research Services, Finance, People and Student systems, with linkage to the central organisational structure to enable coherent, cross domain analysis.
Worked closely with the Student Data Modelling and Analytics team (SDMA) to support their data provision service through the development of reports in response to user requests. Contributed to planning activities for the transition from the current reporting platform to Fabric and provided analytical support during the early stages of the eVision report migration project.
David Johnson, Business Intelligence Developer
Worked predominantly within HR Analytics to design and deliver both strategic and operational reporting solutions. This includes the development of a proof of concept health and safety dashboard to support the University in managing institutional risk. The dashboard provides six key metrics to the Safety Executive Group and highlights incident data at institutional, divisional and departmental levels, supporting improved oversight and risk management.
Developed a dashboard for the Grading Services team to support continuity of the recruitment process and provide management level insight into service provision. In addition, created a Power BI report that improves the efficiency of an internal HR Analytics process, enabling more timely and consistent delivery of recruitment data to departments.
Milda Mackela, Business Intelligence Developer
Designed and delivered a number of key dashboards to support strategic decision-making across the University. This includes the Professional Services report, which enables detailed analysis of trends in staffing levels and costs by function and organisational structure, helping stakeholders better understand workforce composition, resource allocation, and cost drivers. The report is being used by senior stakeholders to inform planning and improve visibility of workforce data across divisions.
Developed the Value for Money (VfM) report to support the Planning and Resource Allocation Committee (PRAC) in assessing operational efficiency and effectiveness. This report provides insight into how resources are utilised to maximise benefit and support the University’s academic mission, in line with its Value for Money strategy. It brings together complex datasets enabling more informed discussions and evidence-based decision-making.