Business Intelligence through CubeJS

Business Intelligence through CubeJS

Published By

Umar
ERP
Oct 3, 2021

We at Halsimplify use CubeJs for Analytics. In this article, we will introduce it so you can consider using it in your applications

Business intelligence (BI) combines business analytics, data mining, data visualization, data tools and infrastructure, and best practices to help organizations to make more data-driven decisions.

Some key players,

  • Tableau
  • Microsoft Power BI
  • CUBE

Why do we need Business Intelligence

BI helps users draw conclusions from data analysis. Data scientists dig into the specifics of data, using advanced statistics and predictive analytics to discover patterns and forecast future patterns.

How Do We Analyse Data?
1 2 3 4 5
BEGIN SET WITH THE RIGHT QUESTION SET CLEAR MEASUREMENT PRIORITIES COLLECT DATA ANALYZE DATA INTERPRET RESULTS
Questions should be measurable, clear what to Measure
In What Dimensions
Collect Data from the database Compare with the Question Solution for the question

Data Schema

DATA SCHEMA IS USED TO MODEL RAW DATA INTO MEANINGFUL BUSINESS DEFINITIONS AND PRE-AGGREGATE DATA FOR OPTIMAL RESULTS.

  1. SQL query
  2. Pre-Aggregations
  3. Joins
  4. Measures
  5. Dimensions

SQL query
  1. Raw SQL Query
  2. Join tables with UNION, HAVING, FULL OUTER

Pre-Aggregations

Pre-aggregations are materialised query results persisted as tables. Cube.js has the ability to analyse queries against a defined set of pre-aggregation rules in order to choose the optimal one that will be used to create a pre-aggregation table.

Joins

The joins parameter declares a block to define relationships between cubes. It allows users to access and compare fields from two or more cubes at the same time.

Measures

The measures parameter contains a set of measures and each measure is an aggregation over a certain column in your database table.

Dimensions

The dimensions property contains a set of dimensions. You can think about a dimension as an attribute related to a measure, e.g. the measure user count can have dimensions like country, age, occupation, etc.

Benefits of CUBE
  1. Fast Built of Charts, Data Block, Summary Blocks
  2. No Coding is required
  3. Fast loading of Dashboards with BI

Should you have any questions/suggestions, please feel free to comment below. I will do my best to get back. Looking forward to hearing from you!