Product Versions

This document aims to give an overview of all active product versions in Holistics.

👉 Check your current version

Main Versions

Currently there are three main Holistics versions:

• Version 2.0 (SQL Reporting): This version involves building reports directly by writing SQL. This version is no longer being actively developed.
• Version 3.0 (Modelling-based Reporting): The key differences in this version are our modeling-centric layer, self-service analytics, modelling/datasets-based reports.
• Version 4.0 (3.0 + Analytics-as-code): Our latest, actively developing version. Its key concepts include Analytics-as-code (with AMQL development, Holistics’s Modeling & Querying languages), Git Version Control, and dbt Integration. If you want to find out more about Holistics 4.0, please refer to this Holistics 3.0 vs. 4.0 Feature Comparison.

The following table summarize the key differences between the versions:

Concept	Description	Version 2.0	Version 3.0	Version 4.0
Data Modeling Layer	A real-time layer above the database that centralizes all data components and logics of an organization	❌	✅	✅
Data Importing	The process of transferring data from other source into SQL database	✅	❌	❌
Data Transformation	The process of centralizing and optimizing SQL logic by pre-transforming data	✅	✅	✅
Self-service Analytics	The process of analyzing and examining data sets to discover patterns, relationships, and other insights	❌	✅	✅
Reporting	The process of preparing and presenting reports, allowing users to share actionable insights and make informed decisions	Build reports by writing SQL queries	Build reports by drag-and-drop	Build reports by drag-and-drop
Analytics As-Code	The ability to do analytics work using Holistics's code language (AMQL)	❌	❌	✅
Git Version Control	Utilizes Git for code management, allowing users to track changes, create branches, and review code for quality and collaboration.	❌	❌	✅
dbt Integration	Connects dbt transformations with BI tools, improving metadata consistency and reporting accuracy	❌	❌	✅
User Roles	Learn more about User Roles in Holistics	Admin, Analyst, Viewer	Added: Explorer	Added: Explorer

Transitional Versions

In the past, Holistics developed two transitional versions to provide a stable release for 2.0 customers who were not yet ready to migrate to version 3.0.

• Version 2.5: A combination of 2.0 and 3.0 where you can both keep the old way to create reports from SQL and experience our Data Modeling Layer.
• Version 2.7: A more stable and upgraded version than Holistics 2.5, where 2.0 and 3.0 features are used and managed separately. Hence, it provides 2.0 customers a clearer migration path to 3.0 version.

Both of these transitional versions are no longer active and not stable long-term. If you are on one of these versions, to request an upgrade to Holistics 3.0, please fill in this form.

What's my Holistics version?

Learn how to check your Hollistics version.