fb

How Holistics works

91% of our customers say they are able to deliver business answers within a day of adopting Holistics. Scroll down to learn how.

Free 14 day trial. No credit card required.

Mechanism

Holistics is designed to help your business users to access data themselves without bothering Data Team.

Data teams use Holistics to define business metrics, datasets and reports for business users. Business users can consume the predefined reports, or build their own reports with simple, visual report builders.

If you believe Data Team’s job should not be about answering adhoc report requests for Business, then Holistics might be a good fit for you!

Self-service BI platform

Before vs After Holistics

Before Holistics After Holistics

Data Team is a bottleneck

Data Team is overwhelmed with ad-hoc queries from business users.

Every slight change to the report format, Business Users cannot change themselves and have to ask Data Team for help.

Self-service Data Access for Business Users

Business Users perform adhoc data exploration without writing SQL or bothering Data Team. Data Team just needs to maintain central business logic layer.

With reduced adhoc data requests for Data Team, they can focus on more complex data analyses.

Repeated Logic Definitions

Multiple different SQL definitions of the same business logic across entire system.

When some field changes, you need to go through all the reports and manually change them one by one.

Business Logic is defined in one place

When some business logic changes, Data Team only needs to update once, and the change will be reflected across all related reports AUTOMATICALLY.

Inconsistent numbers

Different reports might give different values for the same metric.

Business Users confused and stop trusting the data, keep coming back to Data Team to verify.

Reporting that can be trusted

Since metric is defined once, all reports should give the same value for the same metric.

Data Teams Define Business Metrics

Data Teams can define business logic once in Holistics using SQL.

Curate these data & metrics into predefined datasets to share with non-technical users.

Define metrics in Data Model

Define metrics in Data Model

Map relationship

Map relationship

Curate datasets

Curate datasets

Non-technical users build reports by themselves

Non-technical users can explore datasets to build reports and dashboards, without writing SQL queries.

They can then share these reports with other people in their team.

Non-technical users build reports by themselves

Access & Interact with Data on Dashboards

Users can deep-dive into an existing dashboards with high degree of interactivity. Filtering, drilling down data or compare data between different time periods.

Data Filtering

Data Filtering

Drill-through

Drill-through

Cross Filtering

Cross Filtering

Time-period Comparison

Time-period Comparison

More awesome features

User Access Control

Tightly control how data is shared at report, row and column levels.

Smart Timezone handling

Intelligently understand database's timezone and adjust for users' timezone.

Built-in time-period comparison

Compare metrics with equivalent time periods in the past to get meaningful context.

Data Alerts

Get notified when data changes automatically with advanced conditions.

Works well with modern data warehouses

Works directly with modern SQL databases and does not need to store your data.

Best-in-class Support

Our team goes our of our way to provide supports for our customers.

citra

If you want to see the easiest way to see the data from your company, use Holistics because it’s an incredible platform.

Novia Citra Valinca

Supported Databases

Holistics works seamlessly with the following databases

PostgreSQL
MySQL
Amazon Redshift
SQL Server
Google BigQuery
Snowflake
Presto
Amazon Athena
Qubole
Clickhouse

Frequently Asked Questions

We support most SQL and analytics databases, like MySQL, PostgreSQL, SQL Server, BigQuery, Redshift and more ...

We also support other data sources like MongoDB, CSV, Excel, Google Analytics, and Google Sheets. You may read the full list here.

If you use something that's not on the list, feel free to contact us and we'll be happy to work on an integration.
We recommend you to create one, as it's relatively inexpensive today if you use a major cloud provider. See this video guide on how to setup a free BigQuery cluster in 5 minutes.

Or if you have a SQL database running and don't have lots of load, you can connect Holistics directly to your SQL database.
Tableau is great at visualizing charts, but requires you to prepare and transform the data beforehand. That's where Holistics come in.

You use Holistics to model and transform data to feed into Tableau for visualization.
Book a call with us! We'll walk you through a demo of the software and then activate a trial for you.

We do this to make sure you get the most value out of the software, by giving you a demo of the functionalities that most fit with your use cases.
The answer is yes! Holistics is designed to work well with other BI or ETL tools.