sublimd Analytics meets Cube.js

sublimd Analytics meets Cube.js

In the beginning of 2019, we received the first request for our new module sublimd Analytics from a client. At that time, we had established an open source business intelligence server solution in our product. We were struggling a lot with preconfiguring our analytics dashboards and ship it ready-to-use to our (non-technical) customers. Acting from necessity, we were looking for an easier solution to cover our needs: having full control over the customer configuration (tracked in a version-control system).

Cube.js Diagram

By chance, Cube.js attracted our attention on an independent comparison website. It felt almost too good to be true: Cube.js fits our technology stack including Node.js, MySQL and Redis. Which means a much simpler deployment than before. Beyond that, the framework gives developers the freedom to implement the frontend with their custom look and feel. After creating a small prototype, our goal of a seamless integration in our software suite appeared realistic again.

Cube.js Controls

During the integration, we were really pleased how mature Cube.js already was. Even more impressive was that it had been open-sourced only for two to three months. As our organization was de facto the first developer team who was working with the framework, we got an overwhelming premium support by the Cube.js team (Kudos to Pavel and Artyom). In return, we have sent back a lot of feedback and occasionally contributed to the project with commits to GitHub. It is our effort among other things to provide TypeScript definitions.

Our first version of the product still had the usual teething troubles. So we improved it and a few weeks ago, the brand new version was successfully rolled out to our first sublimd Analytics customer. The customer is happy, the software works like a charm and reveals unprecedented information of processes in the hospital.

sublimd Analytics

What’s next? Our analytics module does not yet tap the full potential. We have thousands of health data points to pre-process and visualize in appealing charts. Cube.js is our framework of choice with building blocks including a caching and pre-aggregation layer to allow us to build a high-performance analytics tool for healthcare. This is another success story of open source software where a distributed team of engineers from all over the world solves a real-world problem.

We are sublimd from Switzerland, an award-winning medical software platform to radically reduce paperwork in hospitals, enhance treatment quality and revolutionize clinical research.