Product Versions

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

👉 Check your current version

Main Versions

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. This version is no longer being actively developed.
• 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), Holistics AI, Git Version Control, and dbt Integration.

Both version 2.0 and 3.0 are currently in maintenance mode (no new feature development). If you're on these 2 versions, consider migrating to the latest version.

To differentiate these three main versions in details, please take a glance at the following table:

Concept	Description	Version 2.0	Version 3.0	Version 4.0
Development Status		🟠 Maintain	🟠 Maintain	✅ Active
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	✅	✅	✅ (from CSV, Google Sheets)
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 & natural language querying (AI)
Holistics AI	AI capabilities that support analytics workflows, including natural language querying for report creation.	❌	❌	✅
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 (Holistics 2.5 and 2.7)

In the past, Holistics developed the 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 our transitional versions are no longer active and not stable long-term. If you're on one of these plans, to request an upgrade to Holistics 3.0, please fill in this form.