From uncharted waters to a mapped horizon: Building a research intelligence app with Power BI and integrated open and institutional data

Simple item page
dc.contributor.authorGiesbrecht, Karina
dc.date.accessioned2026-06-16T21:32:35Z
dc.date.available2026-06-16T21:32:35Z
dc.date.issued2026-06-03
dc.descriptionPresented at the Bibliometrics and Research Impact Community (BRIC) 2026 Conference, June 2–4, 2026, in Edmonton, Alberta. Delivered as a 20-minute short presentation. Speaker notes are included in the slides.
dc.description.abstractWhat does it look like to chart a research data landscape when the map doesn't yet exist? This presentation traces the development of the Research Intelligence (RI) App at the University of Victoria (UVic), a Power BI platform that consolidates over 15 open and institutional data sources into a unified, accessible tool for evidence-informed decision-making. The RI App organizes UVic's research ecosystem across six domains: People, Grants, Expertise, Scholarly Works, Innovation, and Rankings. Six purpose-built dashboards — including a new International Connections dashboard that maps global co-authorship networks — serve over 100 users, from executive leadership and Deans to Faculty Grants Officers and librarians, supporting both exploratory analysis and repeatable queries. Data integration is handled through a Python-based ETL pipeline built on a Medallion architecture (Bronze, Silver, Gold), drawing on sources including internal systems (Grants, HR), open platforms (OpenAlex, ORCID, CAUBO), and global university rankings (THE, QS, ARWU, Maclean's). Built in alignment with DORA and the Leiden Manifesto, the platform is designed as a tool for insight and storytelling, not surveillance or ranking. Attendees will come away with practical strategies for building research intelligence capacity at their own institutions, including approaches to data integration, responsible metrics, stakeholder engagement, and fostering a collaborative data community.
dc.description.reviewstatusUnreviewed
dc.identifier.citationGiesbrecht, K. (2026, June 3). From uncharted waters to a mapped horizon: Building a research intelligence app with Power BI and integrated open and institutional data [Conference presentation]. Bibliometrics and Research Impact Community (BRIC) 2026 Conference, Edmonton, AB, Canada.
dc.identifier.urihttps://hdl.handle.net/1828/23989
dc.language.isoen
dc.rightsAttribution-NonCommercial-ShareAlike 4.0 Internationalen
dc.rights.urihttp://creativecommons.org/licenses/by-nc-sa/4.0/
dc.subjectresearch intelligence
dc.subjectPower BI
dc.subjectbibliometrics
dc.subjectdata integration
dc.subjectopen data
dc.subjectresearch dashboards
dc.subjectresponsible metrics
dc.subjectdata visualization
dc.subject.departmentOffice of the VP Research and Innovation
dc.titleFrom uncharted waters to a mapped horizon: Building a research intelligence app with Power BI and integrated open and institutional data
dc.typePresentation

Files

Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
giesbrecht_bric_presentation_2026.pdf
Size:
828.31 KB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.62 KB
Format:
Item-specific license agreed upon to submission
Description:
Download

Collections

Faculty and Staff Publications
 
University of Victoria Libraries

We acknowledge and respect the Lək̓ʷəŋən (Songhees and Esquimalt) Peoples on whose territory the university stands, and the Lək̓ʷəŋən and W̱SÁNEĆ Peoples whose historical relationships with the land continue to this day.