Holistics Docs - End-to-End Business Intelligence Platform

Holistics Documentation

Welcome to the Holistics Documentation page. You'll find comprehensive guides and documentation to help you start working with Holistics as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started

Product Versions

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

Our latest version is Holistics 3.0 which evolves around the Data Modeling Layer, emphasizing on maintainability, reusability, and scalability of an analytics tool. It not only gives data teams more control on their analytics stack but also enables self-service exploration for non-technical teams.

Why did Holistics decide to make a move to version 3.0?

Since we realized that creating reports directly from SQL can cause report sprawl scenario. Although they are seemingly quick and easy to generate, SQL-based reports are non-reusable and hard to manage, especially when your team has to deal with a huge amount of data. That's why we came up with version 3.0.

As we mentioned above, the core value of our latest version is Data Modeling Layer:

  • If you are a Data Analyst, our semantic layer can help you match your organization’s physical data with business logic, build reusable Data Models for future complex analyses and reports, or share them with the business teams to explore.
  • If you are a non-technical person with keen eyes for numbers, you might want to explore data yourself without relying too much on data analysts, but are still intimidated by SQL. In that case, our Datasets and Explore Data feature will be most useful for you.

How many versions are there in Holistics?

In brief, there are four different versions with different :

  • Version 2.0: This version requires you strong technical knowledge since all reports are built directly from scratch by using SQL.
  • 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.
  • Version 3.0

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

Item

Description

Version 2.0

Version 2.5

Version 2.7

Version 3.0

Data Modeling Layer

A real-time semantic layer above the database that centralizes all data components and logics of an organization

Not supported

Supported

Supported

Supported

Data Import / Transform

Managed via Data Manager

Managed via Data Manager and Data Modeling

  • Managed via Data Manager and Data Modeling
  • Able to convert a import/transform to a data model

Managed via Data Modeling

Data Exploration

Not supported

Supported

Supported

Supported

Metric Sheet

Metric Sheet 2.0

Metric Sheet 3.0 (coming soon): Supports filtering, email schedule,...

  • Metric Sheet 2.0
  • Metric Sheet 2.0
  • Metric Sheet 2.0
  • Metric Sheet 3.0
  • Metric Sheet 3.0

Report

SQL Report (Report 2.0): Reports created from pure SQL
Dataset Report (Report 3.0): Created by exploring dataset, easily performed by non-tech users.

SQL Report

  • SQL Report
  • Dataset Report
  • SQL Report
  • Dataset Report

Dataset Report

Dashboard

Dashboard 2.0: Compatible with SQL Reports.
Dashboard 3.0: Compatible with Dataset Reports.

Dashboard 2.0

Dashboard 2.0

Note: If a dashboard 2.0 stores a report 3.0, this report cannot be applied filter due to the version conflict

  • Dashboard 2.0
  • Dashboard 3.0

Dashboard 3.0

Filter

Filter 2.0: Created from SQL, used in dashboard 2.0
Filter 3.0: Created from datasets, used in dashboard 3.0

Filter 2.0

Filter 2.0

  • Filter 2.0
  • Filter 3.0

Filter 3.0

Standalone Report

Users can save their query or exploration result as an independent report

Supported

Supported

  • Only supported for SQL Reports
  • Dataset Reports have to be stored in a dashboard

All reports have to be stored in a dashboard

User Role

Learn more about User Roles in Holistics

  • Admin
  • Analyst
  • Viewer / Business User
  • Admin
  • Analyst
  • Explorer (Optional)
  • Viewer
  • Admin
  • Analyst
  • Explorer
  • Viewer
  • Admin
  • Analyst
  • Explorer
  • Viewer

How do I check my product version?

If you signed up after 18 February 2020, you mostly are on our latest version 3.0. However, to check it again, please click on Help button at the top right corner and you'll find your product version at the last row.

Holistics Product Version

My company is using Holistics version 2.0 / 2.5 / 2.7, how can we upgrade to Holistics 3.0?

If your team is using our old versions and would like to experience our latest product version, please contact us via email [email protected]

Updated 26 days ago


Product Versions


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.