CELUS Data Hub

Extend CELUS with advanced analytics

Data Hub puts your CELUS usage data into a dedicated analytical database, so you can work with it in Power BI, Tableau, Metabase, Apache Superset or any SQL client. It is an add-on for active CELUS subscriptions.

  • Combine usage with financial data
  • Create executive dashboards
  • Integrate data into institutional BI tools (MS Power BI, Metabase, Tableau, APACHE Superset,...)
  • Run custom SQL queries
  • Automate internal reporting pipelines
CELUS mascot presenting Data Hub analytics

Daily

Automatic sync, plus manual sync on demand

ClickHouse

Dedicated analytical database for your data

SQL + BI

Power BI, Tableau, Metabase, Superset

+20%

Add-on to your annual CELUS price

How it works

What is CELUS Data Hub?

Your bridge between usage statistics and your other data. Data Hub exports your CELUS usage data into a dedicated analytical database (ClickHouse) running on CELUS infrastructure.

The database is separate from your main CELUS account and comes with secure credentials for BI tools and SQL clients. All usage data and tags sync with Data Hub every day, and you can start a manual sync at any time.

For exploring and testing, a simple web interface lets you browse the database structure and run queries on your data.

Diagram: CELUS usage data flows into a ClickHouse database that connects to BI tools such as Power BI, Tableau and Metabase

Data structure

How is the data structured?

Each report in your CELUS instance gets its own table. If you harvest TR, DR and PR reports, you get three tables: TR, DR and PR.

COUNTER 5.1 reports have their own tables. To make the switch from R5 to R5.1 easier, there are also merged tables for TR, DR, PR and IR_M1, combined month by month. R5.1 data are used first, with R5 as the fallback when R5.1 data are not available.

Non-COUNTER reports are exported too, each as a separate table.

Tags are exported into the title_tags and platform_tags tables. Join them with the report tables to see usage by tag.

CELUS Data Hub web interface showing the database tables

Examples

What libraries are building with Data Hub

Data Hub lets institutions build dashboards tailored to their own needs. These are real dashboards made with CELUS Data Hub.

Executive usage overview

A dashboard for strategic reporting.

  • Total usage overview
  • Time-based filtering
  • KPI tiles for quick reporting
  • Platform-level filtering

Why it matters: ideal for reporting to university leadership or funding bodies.

Dashboard of usage by year of publication built with CELUS Data Hub

Usage by year of publication

Collection age analysis.

  • Usage by year of publication
  • Access type segmentation
  • Title tag filtering (e.g. Computer Science)
  • Identification of backfile value

Why it matters: supports evidence-based collection development and renewal decisions.

Platform and access model comparison

Compare platforms and access types over time.

  • Compare platforms (EBSCO, JSTOR, ProQuest…)
  • Analyze Controlled vs Open vs OA_Gold
  • Filter by year / quarter
  • Identify trends across time

Why it matters: helps you optimize subscriptions and negotiate licenses.

Case study

How Coventry University uses CELUS Data Hub

At Coventry University, COUNTER data are used almost every day: to measure collection usage, evaluate renewals, consider new purchases and assess how library services shape the student experience.

The problem

Working with COUNTER tabular reports in Power BI took a lot of manual effort. Even with report aggregators like JUSP, collecting and preparing datasets at scale was slow and inefficient.

Importing hundreds of tabular reports meant:

  • Heavy manual preprocessing
  • Complex transformations before analysis
  • Limited agility when new data arrived
Download the full case study
download

The transformation

Data Hub changed that completely. For Coventry, being able to query the ClickHouse database and pull data for all platforms in a single transaction was transformational.

“A few SQL queries will sort and pull the data needed.”

The result

The data now flows into Power BI:

  • Ready to be queried
  • With minimal transformation required
  • Easily refreshable as new data become available
  • Embedded directly into strategic planning workflows

Coventry University

What they built with Data Hub

Executive overview dashboard

  • Cross-filterable by platform
  • Comprehensive eResources usage overview

Longitudinal journal usage analysis

  • Usage trends over time
  • Filterable by access type and platform
  • Includes COUNTER 5.1 datasets

Year of Publication (YOP) analysis

  • Identifies which platforms generate usage
  • Evaluates legacy collections
  • Supports subscription review decisions

Title-level and subject-level analysis

  • Journal usage by title
  • Scopus subject area breakdown
  • Insight into long-tail usage across collections

Customer story

How John Carroll University uses CELUS Data Hub

“The CELUS Data Hub feature enables us to easily manipulate our data using tools with which we are already familiar. Connecting Tableau directly to our CELUS data allows the creation of visualizations that communicate the value of our collections to our stakeholders, while saving the time we used to spend downloading data, reorganizing it in Excel, then working with it in Tableau. CELUS has always provided invaluable tools for evaluation of our usage data to aid in internal decision-making, but the Data Hub connection facilitates broader sharing of insights and trends. Plus, the team at CELUS is always ready to help resolve issues and provide support, so setting up the connection was straightforward and quick.”
Lauren K. Marshall, Collections Analyst, Cataloging & Metadata Department, John Carroll University
John Carroll University Tableau dashboard of top business journals usage
John Carroll University Tableau dashboard of nursing collection usage
Macquarie University Power BI usage overview dashboard
Macquarie University Power BI platform evaluation dashboard

Customer story

How Macquarie University uses CELUS Data Hub

“The CELUS–Power BI integration has enabled the institute to develop user‑friendly dashboards that give staff quick, clear insights into platform usage. By connecting the CELUS Data Hub with cost data, we can easily identify platforms that may require closer monitoring or follow‑up evaluation. Previously, both these tasks relied on multiple Excel worksheets and manual data downloads; the new workflow significantly streamlines the process and saves time for the team.”
Emma Clift, Team Leader (Collection Planning & Assessment), Resources & Discovery, Macquarie University

Good to know

Frequently asked questions

What is CELUS Data Hub?

CELUS Data Hub is an add-on that exports your CELUS usage data into a dedicated ClickHouse analytical database. You get secure credentials to connect BI tools and SQL clients.

Which tools can I connect to Data Hub?

Data Hub works with BI tools such as Microsoft Power BI, Tableau, Metabase and Apache Superset, and with SQL clients. A simple web interface is also included for exploring the data and testing queries.

How often is the data updated?

Your usage data and tags sync with Data Hub every day. You can also start a manual sync at any time.

How is the data organized?

Each report has its own table, for example TR, DR and PR. COUNTER 5.1 reports have their own tables, plus merged R5/R5.1 tables for TR, DR, PR and IR_M1. Non-COUNTER reports and tags are exported as separate tables.

How much does Data Hub cost?

Data Hub adds 20% to your annual CELUS price, which depends on the number of publisher platforms you manage. See the pricing table below.

Who can use Data Hub?

Data Hub is available as an add-on to active CELUS subscriptions. To request access, email ask@celus.net.

Still have a question about Data Hub? Ask us

Pricing

Transparent, affordable pricing that also supports CELUS development and maintenance. Your annual price depends on the number of publisher platforms you manage (COUNTER and non-COUNTER).

Publisher platforms
CELUS
EUR / year
CELUS + Data Hub
+20%
Optional add-on for advanced analytics. Not required to use CELUS. Learn more
1 – 25
€2,000
€2,400
26 – 50
€2,500
€3,000
51 – 75
€3,000
€3,600
76 – 100
€3,500
€4,200
101 – 150
€4,000
€4,800
151 – 200
€5,000
€6,000
Publisher platforms
CELUS
USD / year
CELUS + Data Hub
+20%
Optional add-on for advanced analytics. Not required to use CELUS. Learn more
1 – 25
$2,300
$2,760
26 – 50
$2,900
$3,480
51 – 75
$3,500
$4,200
76 – 100
$4,100
$4,920
101 – 150
$4,700
$5,640
151 – 200
$5,800
$6,960

Explore CELUS with a 42-day free, non-binding trial. No credit card needed.

start free trial
arrow_forward