Introducing a Data Blending API (Support) in Cube.js

Introducing a Data Blending API (Support) in Cube.js

If you’re not familiar with Cube.js yet, please have a look at this guide. It will show you how to set up the database, start a Cube.js server, and get information about data schemes and analytical cubes.

Sometimes in our daily data visualization, we need to merge several similar data sources so that we can manipulate everything as one solid bunch of data.

For example, we may have an omnichannel shop where online and offline sales are stored in two tables. Or, we may have similar data sources that have only a single common dimension: time. How can we calculate summary metrics for a period? Joining by time is the wrong way because we can’t apply granularity to get the summary data correctly.

Furthermore, how can we find seasonal patterns from summarized metrics? And how can we get and process data synchronously to track correlations between channels?

Well, the new data blending functionality in version 0.20.0 of Cube.js takes care of all these cases.

If you’re not familiar with Cube.js yet, please have a look at this [guide_](https://cube.dev/blog/cubejs-open-source-dashboard-framework-ultimate-guide?utm_source=medium&utm_medium=post&utm_campaign=data-blending). It will show you how to set up the database, start a Cube.js server, and get information about data schemes and analytical cubes._

Please, keep in mind that we used here another dataset:

$ curl http://cube.dev/downloads/ecom2-dump.sql > ecom2-dump.sql
$ createdb ecom
$ psql --dbname ecom -f ecom2-dump.sql

Now let’s dive into the metrics for an example shop and visualize sales by channel and as a summary.

Here is the full source and live demo of the example.

I used React to implement this example, but querying in Cube.js works the same way as in Angular, Vue, and vanilla JS.

dashboard open-source web-development tutorial javascript

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

An Open-Source Book About the Open Source World

Open source today is a word that often include a lot of things, such as open knowledge (Wikimedia projects), open hardware (Arduino, Raspberry Pi), open formats (ODT/ODS/ODP) and so on.

Dashboard Development Services | Custom Dashboard Design and Development

Custom Dashboard Development Services- Mobiweb offers all type of Dashboard Software Design and Development Solutions and Data Visualization services to global clients.

Dashboard Development Services | Custom Dashboard Design and Development

Custom Dashboard Development Services- Mobiweb offers all type of Dashboard Software Design and Development Solutions and Data Visualization services to global clients.

Infographic: Open Source Web Application Development in Enterprises

The open-source software allows anyone to use. This infographic highlights various benefits of open source web application development for large enterprises

Infographic: Open Source Web Application Development in Enterprises

The open-source software allows anyone to use. This infographic highlights various benefits of open source web application development for large enterprises