Data and Business Intelligence Hub

Data and Business Intelligence Hub

Welcome to the Data and Business Intelligence Hub. Here you can find information about University data, access the University’s Power BI Dashboard Portal, find information about the University’s BI journey, sign up for training in Power BI, and access a variety of external data sources. The University has adopted Microsoft Power BI as business intelligence software to enhance business intelligence capability and is implementing a Data and BI Programme of work with the aim to provide staff with a wealth of data in all key areas to inform our activities.

Power BI Dashboard Portal

The Power BI Dashboard Portal offers all staff access to a number of official University of Aberdeen dashboards that have been approved for release by the Data & BI Co-ordination Group.

Power BI Dashboard Design and Development

Have an idea for a dashboard for sharing with others?

Then contact the Data & BI Hub at databihub@abdn.ac.uk and and we would be happy to discuss this further with you. We also have a Dashboard Request Form that you can complete and submit to the Data & BI Hub for consideration.

University of Aberdeen Power BI Template

This is the official University of Aberdeen Power BI Template for use in creating your own dashboard reports.  This is presented in an official University of Aberdeen Power BI theme with colours derived from the corporate palette. 

If you cannot access this page please contact the Data & BI Coordination Group to arrange access.

Dashboard Review Procedure

Dashboards published to the Data & Business Intelligence portal should be reviewed periodically according to the following procedure: 2024 05 22 Dashboard Review Procedure - FINAL.pdf

Power BI Training

Power BI Training

The Data & BI Hub offers training to support the use of Microsoft Power BI at the University of Aberdeen.  

Our training includes the following:

  • Introduction to the Data Environment.  This training must be completed before a user is permitted access build Power BI Dashboards in the data warehouse environment. This course provides an introduction to the Data Environment at the University of Aberdeen, including the Power BI system and associated data sources, and the Data & BI Hub.
  • Using Power BI Dashboards. This training is takes you through an example dashboard which aims to familiarise users with the common features they will find in a Power BI report.  This training is in video format and can be accessed here.
  • Dashboard In A Day.  This training is aimed at users who want to use Microsoft Power BI to transform data and create reports and dashboards from this data.  This training would normally be delivered in two half-day sessions.
  • Power BI Hints & Tips. 10 helpful pointers to read before you use Power BI to ensure you only use personal data appropriately and also signposting on where to get further advice. You can view the tips here.

For information on how to book training, please contact the Data & BI Coordination Group.

About the Data and BI Coordination Group

Purpose

The Data & BI Co-ordination Group is a permanent virtual team overseeing the Data & BI Hub owned by the Directorate of Planning and Governance with membership from across the University.  The central purpose of the Data & BI Co-ordination Group at the University of Aberdeen is to create and foster a data culture by undertaking the following:

  • Delivering the Data Platform as per the Roadmap agreed by the Data & Business Intelligence Project Board
  • Supporting and maintaining the Data Platform
  • Advocating for the Data Platform
  • Implementing and maintaining Data Governance

Organisation

The Data & BI Co-ordination Group currently consists of membership from Planning, DDIS, Library Services, Student Records, HR, Research & Innovation and Finance. This membership will expand as future phases of the Data & Business Intelligence Project moves into new subject areas.

The Data & BI Hub is managed by the Data & BI Co-ordination Group.

Functions

  • Data & Analytics Programme Management
  • Data & Analytics Vendor Management
  • Data & Analytics Standards
  • Governance: Data, Process, Programme
  • Subject Area Delivery in the Data & Business Intelligence Project
  • Minor Enhancements
  • Solution Support & Maintenance
  • Data Analysis, Insights & Innovation
  • Training & Tutoring

Deliverables

  • Data Integration (ETL)
  • Data Warehouse
  • Reports & Dashboards

Contact

The Data & BI Co-ordination Group can be contacted via email at databihub@abdn.ac.uk.

Internal Data

The Directorate of Planning & Governance produces a range of reports on our performance in various student and graduate surveys (e.g. National Student Survey, Postgraduate Taught Experience Survey, Graduate Outcomes).  To access these reports please use the link below:

The University holds a wide range of management information internally, including data on students , research performance and staff. There are several existing reporting tools to enable staff to access this information. If you require access to internal data, please visit the Management Information Systems section of StaffNet in the first instance, and contact planning@abdn.ac.uk if you would like further assistance.

External Data

The University regularly submits data as part of statutory returns to the Scottish Funding Council and to the Higher Education Statistics Agency (HESA). Subsets of HESA data are available to staff at the University through the online Heidi Plus portal, and this is especially helpful to enable benchmarking against other institutions within the UK. Requests for access to HESA data should be submitted in the first instance to planning@abdn.ac.uk.

League Tables

For further information on university league tables and our performance please click here.

External Higher Education (HE) Data Reports

Below you can access various HE data reports prepared by external parties which may be of interest.

David Kernohan at Wonkhe publishes regular articles relating to technology and data in higher education which you can access here: David Kernohan | Wonkhe

Other recent analyses of note include: