Consolidating library data with PowerBI: a case study from UWTSD Library

Dalling, John and Davies, Emily and Toyne, Lisa (2025) Consolidating library data with PowerBI: a case study from UWTSD Library. In: 16th International Conference on Performance Measurement in Libraries, 3-4 Jun 2025, Liverpool, UK.

[img] Text
Consolidating_Library_Data_with_PowerBI_-_LibPMC_2025_Final_Paper.pdf
Available under License CC-BY Creative Commons Attribution.

Download (946kB)

Abstract

Over the past three years, the Library and Learning Resources team at the University of Wales Trinity Saint David (UWTSD) have worked on a project to consolidate data across the service using Microsoft PowerBI. The project was initiated to address inconsistencies in reporting and improve measurement of service impact. Before this work, our data collection was siloed and ad-hoc, relying heavily on our Alma Library Management System which primarily captures data on collection usage and does not represent our full range of services such as digital skills provision, open access compliance, and interactions with our specialist and front line staff. We aimed to create a consistent and comprehensive in-house reporting solution that would aid us in the performance measurement of a broader range of services beyond usage of our collections, using existing tools available to us at no additional cost. This presentation will outline our experience and progress in the first three years of the project.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: libraries, statistics, performance measurement, analytics, business intelligence, Power BI, Microsoft
Subjects: Q Science > QA Mathematics > QA76 Computer software
Z Bibliography. Library Science. Information Resources > Z665 Library Science. Information Science
Divisions: Library and Learning Resources
Related URLs:
Depositing User: John Dalling
Date Deposited: 26 Sep 2025 07:38
Last Modified: 26 Sep 2025 07:38
URI: https://repository.uwtsd.ac.uk/id/eprint/3920

Administrator Actions (login required)

Edit Item - Repository Staff Only Edit Item - Repository Staff Only