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.
CELUS Data Hub
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.

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
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.

Data structure
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.

Examples
Data Hub lets institutions build dashboards tailored to their own needs. These are real dashboards made with CELUS Data Hub.
A dashboard for strategic reporting.
Why it matters: ideal for reporting to university leadership or funding bodies.
.avif)
Collection age analysis.
Why it matters: supports evidence-based collection development and renewal decisions.
Compare platforms and access types over time.
Why it matters: helps you optimize subscriptions and negotiate licenses.

Case study
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.
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:
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 data now flows into Power BI:
Coventry University
Customer story
“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.”


.jpg)

Customer story
“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.”
Good to know
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.
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.
Your usage data and tags sync with Data Hub every day. You can also start a manual sync at any time.
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.
Data Hub adds 20% to your annual CELUS price, which depends on the number of publisher platforms you manage. See the pricing table below.
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
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).
