King’s College London – Research Reporting Modernisation

King’s College London – Research Reporting Modernisation
Client

King’s College London (KCL) – A leading research-intensive UK university managing millions of pounds of research funding annually across complex pre- and post-award processes.

The Challenge

KCL relied on Worktribe as its core research management system, but lacked a reliable way to extract, model, and aggregate data for analytics. Stakeholders needed unified insight into pre-award and post-award finance, research lifecycle stages, and institutional funding trends.

The situation before Behan's involvement:

• No existing BI architecture for Worktribe

• Complex relational structures with limited documentation

• No performant way to build Power BI dashboards

• Research, finance, and IT teams had divergent needs

• Stakeholders believed the project was ‘not possible’

Image
The Solution

Behan designed and delivered a complete end-to-end analytics pipeline using Microsoft SSIS, automated extractions from Worktribe, a structured modelling layer, and high-performance reporting marts optimised for Power BI.

  • Built a robust SSIS solution to extract Worktribe data daily
  • Normalised complex Worktribe relationships
  • Embedded audit, error handling, and validation
  • Delivered a reusable, future-proof extraction design

Stakeholder feedback

Wow, you made that look easy — and it’s so well structured, we can build on this now.


Key Outcomes
  • Transformed an ‘impossible’ requirement into a production-ready BI solution
  • Millions of pounds in research data made visible and analysable
  • Accelerated Power BI dashboard development
  • Daily incremental updates from Worktribe
  • Reliable, clean, auditable data models
  • Strengthened collaboration across research, finance, and IT
  • Worktribe vendor recognised the technical excellence of the solution

Strategic Value

This project demonstrated Behan's ability to:

  • Deliver Microsoft SSIS-based enterprise ETL
  • Understand and model complex HE research finance data
  • Integrate and normalise Worktribe structures for BI
  • Build maintainable, future-proof data marts
  • Work effectively across teams at a major Russell Group university
  • Deliver where others believed it wasn’t possible

Behan enabled KCL to unlock research insight, improve governance, and establish a foundation for long-term analytics success.

Start your project today

Every project starts with a plan.

Let's talk.
Book a meeting

Ready to talk?

Whether you have a specific project in mind, need ongoing support, or just want to discuss your Oracle challenges, we'd love to hear from you.

Call us on 0800 246 1675 or
Book a Meeting

General enquiries: info@behan.co.uk

New projects: projects@behan.co.uk

Careers: careers@behan.co.uk

Behan Services

Start Your Project