Business Intelligence through CubeJS

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!

Business Intelligence – Download

1 Comment

  1. kahkashan

    Good Article

    Reply

Submit a Comment

Your email address will not be published.