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 |
|
|
|
|
|
Data Schema
DATA SCHEMA IS USED TO MODEL RAW DATA INTO MEANINGFUL BUSINESS DEFINITIONS AND PRE-AGGREGATE DATA FOR OPTIMAL RESULTS.
- SQL query
- Pre-Aggregations
- Joins
- Measures
- 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
- Fast Built of Charts, Data Block, Summary Blocks
- No Coding is required
- 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!
Good Article