Skip to main content

Key Concepts

Data Source​

A data source is a connection to your SQL database. This is the first thing you need to set up in Holistics.

Data Modeling​

The core of Holistics, an abstract/semantic layer where mapping between business logic and underlying data table sits. Data Teams will spend most of their time in this layer.

Data Model​

An abstract concept that sits on top of a database table, where different business logic are added in the modeling layer. Part of the modeling layer. There are 3 types of data models: Table, Transform and Import.

Relationship​

The linking between data models. Similar to joins/foreign-key relationship in database.

Dimension and Measure​

Each data model contains fields (similar to the data table and their respective columns). There are 3 types of fields:

  • Base Dimension: the "original" fields in your source data.
  • Custom Dimension: created by using non-aggregate functions to transform one or multiple dimensions.
  • Custom Measure: A field that returns the result of a Metric, created by using aggregate functions (SUM, COUNT, etc)

Data Exploration​

This concept provides a user-friendly interface for exploring and visualizing data through drag-and-drop interface or SQL Editors, enabling faster insights and analysis.

Dataset​

A selected collection of data models and their relationships. Dataset is needed to explore data, and creating charts/dashboards.

Business Calculation​

Business Calculation is one type of the custom fields in Holistics computed on the result-set from your exploration activities, but it doesn't touch the original data warehouse and modeling layer.

Dashboard​

A collection of charts put together. Dashboard can be shared to business users.

Widget​

In Holistics, there are two types of widgets: Report widget and Text widget.

  • A report widget or a chart is a dynamic visualization of data, is created by exploring a dataset.
  • Text widgets are used to provide additional instructions, context, warnings... directly in your dashboard

Dashboard Filter​

A component to add to dashboard to let viewers control/restrict the data being displayed based on certain conditions.

Let us know what you think about this document :)