Product Versions
This document aims to give an overview of all active product versions in Holistics.
How many versions are there in Holistics?
In brief, there are three main versions.
Main 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.
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 |
|---|---|---|---|---|
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 | 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.
What's my current version?
Learn how to check your current version.