Holistics

Holistics at a Glance

Holistics is a modern business intelligence platform built around a code-based semantic layer called AML (Analytics Modelling Language). Data teams define metrics, dimensions, and relationships once in version-controlled text files, then business users self-serve dashboards and ad-hoc explorations against that shared model. Holistics ships SQL pushdown to the warehouse, two-way Git sync, and dbt support on every plan.

Founded in 2015 by Vincent Woon, Thanh Dinh, and Huy Nguyen, Holistics is headquartered at 14 Robinson Rd, Singapore 048545 with offices in Ho Chi Minh City, Jakarta, and Dallas. The platform serves 350+ customers across 20+ countries including Privy, TestGorilla, Zuora, 9GAG, Navan, DNSFilter, Deutsche Welle, and Feeld.

How Much Does Holistics Cost

Holistics publishes three self-serve tiers and two contact-sales tiers on its pricing page. Annual billing is the listed rate; monthly billing carries a premium. A free trial is available via the request-trial page.

Extra users beyond the included 10 are $12.50/month on annual billing. For a quick reference point: Looker enterprise quotes typically land between $30,000 and $60,000 per year, which puts Holistics Standard at roughly 65-80% less for teams that need a semantic layer with similar discipline. Buyers comparing against open-source options should also weigh Metabase for free-tier dashboarding before settling on a paid BI stack.

Hidden Costs and Contract Gotchas

Holistics list pricing is straightforward, but a few items still creep into the year-one total:

• Warehouse compute. Holistics queries run on your Snowflake, BigQuery, or Redshift cluster, so heavy dashboards drive warehouse spend that is invoiced by AWS or Google, not Holistics.
• AS-IS modeling time. The AML semantic-layer language is powerful but new to most analysts. Budget 40 to 80 hours of analyst time to port a legacy SQL-based reporting setup.
• Embedded analytics add-ons. Multi-tenant embedded usage is priced separately from the internal-BI tier; pull a quote before you commit.
• Annual prepay discount. Monthly billing carries roughly a 15% premium versus annual prepay; pick the cadence deliberately.

Holistics Product Suite

The platform's identity is its code-first semantic layer. AML files define datasets, measures, and joins, then any chart or dashboard pulls from that single source of truth. A few things stand out in day-to-day use:

• AML semantic-as-code: models live in plain text, reviewed in pull requests like any other code.
• Two-way Git sync: Entry uses a Holistics-hosted repo; Standard and above connect your own GitHub, GitLab, or Bitbucket.
• AQL for complex metrics: a functional query language for window functions, cohorts, and period-over-period math without writing raw SQL.
• dbt integration on every plan: import dbt models directly into the semantic layer.
• Self-service explorations: business users drag-and-drop against governed datasets without touching SQL.
• Scheduled email and Slack reports: dashboard snapshots delivered on cron.
• Data-as-code workflows: branch, review, merge, and deploy semantic changes.

If you have already invested in dbt and want a BI front-end that respects that work, Holistics is one of the few tools where the semantic layer is the product rather than an afterthought. Teams shopping Looker Studio for free reporting alongside a paid governance layer often run Holistics on top of their warehouse.

Holistics Integrations

Holistics connects natively to cloud warehouses and most major relational databases. Supported sources include Snowflake, BigQuery, Redshift, Athena, Databricks, Postgres, MySQL, SQL Server, MariaDB, EnterpriseDB, ClickHouse, Presto, RDS, Aurora, CSV upload, and Google Sheets.

One honest gap: Oracle, Qubole, and Druid are not on the supported list. Shops running Oracle as their primary warehouse will need a different tool or a pipeline that lands data in a supported destination first. IBM Cognos Analytics and MicroStrategy remain the usual picks for Oracle-heavy enterprises.

For destinations and embedding, Holistics offers email, Slack, scheduled SFTP, REST API, and an embedded analytics SDK on the higher tiers.

Holistics Alternatives

Holistics sits in a specific corner of the BI market: code-first semantic modeling at mid-market pricing. The closest comparison on philosophy is Looker with its LookML language, but Looker's Google-tier pricing puts it out of reach for many teams. On the other end, drag-and-drop tools like Tableau, Microsoft Power BI, and Domo have richer visualization libraries but no real semantic-as-code story.

For teams already using Sigma Computing or Sisense, the trade is usually spreadsheet familiarity versus engineering rigor. Holistics asks more of your data team upfront and rewards them with cleaner downstream chaos. Zoho Analytics and Amazon QuickSight compete on price; QlikView and Tellius compete on associative or AI-driven exploration.

Lighter-weight open-source options like Redash can cover specific use cases for less, but they do not give you a versioned semantic layer.

What Real Buyers Report

Holistics scores 5/5 on recent G2 reviews with users calling it an "Outstanding, Good Value BI Tool with Powerful Dashboards and Great Support." On Capterra it averages 4.6/5 across 89 reviews; a Director of Operations in Health and Wellness highlighted that it is "Easy to setup, support for MongoDB, SQL based dashboarding, and granular access permission."

Vendor-published case studies cover a spread of industries: Pencil and Datacubed Health on clinical and creative analytics, Lepaya and StrongMind on edtech, SensorFlow and Flo Energy on energy data, Optimal Workshop on UX research, ShopBack and RedDoorz on e-commerce and travel, LINE GAMES on gaming, GroupM on adtech, 99.co on real estate, and Mainspring Energy on industrial monitoring. Public customer logos include Privy, TestGorilla, Raft, Zuora, Pinelab, Deutsche Welle, Tul.io, Joom, ZOE, Loadsure, Navan, Fave, DNSFilter, Spenmo, SideChef, 9GAG, Feeld, and Finimize.

Security and Compliance

Holistics maintains SOC 2 Type II certification, audited by Prescient Assurance and continuously monitored via Vanta. The platform is GDPR-compliant. ISO 27001 is not currently vendor-confirmed, so buyers needing that specific attestation should check directly with sales.

The Security Compliance Suite plan ($2,000/month) adds the controls most procurement teams ask for: role-based access control, SAML/SSO, SCIM user provisioning, and IP allowlisting. Audit logs and granular permissioning are available on lower tiers as well, just without the SSO and SCIM pieces.

Implementation Plan: Rolling Out Holistics

Onboarding starts with connecting a data source and importing or writing your first AML model. Teams already on dbt can point Holistics at their existing project and inherit the model graph. Most small analytics teams reach a working set of dashboards within two to four weeks; larger organizations typically run a 60 to 90 day rollout that includes training internal stewards on AML and AQL.

Support is offered by email and in-app chat on all plans. Higher tiers add a dedicated customer success contact. The Holistics community forum and documentation site cover most modeling patterns and AQL recipes, and the team publishes regular product changelog notes.

Pros and Cons of Holistics

A few honest gaps worth pricing into your decision:

• No native mobile app. Holistics is web-only. Dashboards render in a mobile browser, but there is no iOS or Android client. Field teams that need offline dashboards should look at Microsoft Power BI or Tableau Mobile.
• Oracle, Qubole, and Druid are not supported. Oracle shops will need an ETL step into Snowflake, BigQuery, Postgres, or another supported destination.
• English-only interface. The product UI and documentation are English. Multi-region rollouts in non-English markets will need to factor that in.
• Code-first learning curve. AML is approachable but it is still code. Teams without a dedicated analytics engineer or technically inclined analyst will spend longer ramping than they would on a drag-and-drop tool.
• No published brand YouTube channel linked from the homepage. Product walkthroughs live on the docs site and inside sales demos rather than a public video library.

Who Should Use Holistics

Holistics fits best when three conditions line up: your team takes data modeling seriously, you want a single governed semantic layer, and your budget is mid-market rather than enterprise. Specific buyer profiles where it wins:

• Series B to Series D SaaS companies running Snowflake or BigQuery with a small analytics engineering function.
• dbt shops that want a BI front-end built around their existing models.
• Teams that tried Looker and got priced out, or teams on Metabase that have outgrown ad-hoc SQL.
• Embedded analytics use cases where the vendor wants to ship dashboards inside their own customer-facing app.

Teams that are happiest elsewhere: business users who want zero-code drag-and-drop with no engineer involvement, Oracle-warehouse shops, and organizations that need a mature native mobile experience. Browse the full business intelligence category for alternatives if Holistics is not a fit.

Frequently Asked Questions

Is Holistics open source?
No. Holistics is a commercial cloud product. Source-available alternatives include Metabase and Redash.

Does Holistics work without a data warehouse?
It can connect to operational databases like Postgres, MySQL, and SQL Server, but performance and modeling discipline are best with a dedicated warehouse such as Snowflake, BigQuery, Redshift, or Databricks.

Can I bring my own Git repository?
Yes, on Standard and above. The Entry plan uses a Holistics-hosted repo for AML files.

What is AQL?
AQL is the Analytics Query Language Holistics uses for complex measures, window functions, cohorts, and period-over-period calculations on top of the AML semantic model.

Does Holistics offer a free plan?
There is no perpetual free tier. A free trial is available via the request-trial page on the vendor site.

Bottom Line

Holistics is one of the cleanest semantic-layer-as-code BI products on the market, and at $800 to $2,000 per month it sits well below Looker on price while preserving the same modeling philosophy. Teams with a data engineer or analytics engineer on staff, a modern warehouse, and a preference for version-controlled metrics will get more out of it than buyers looking for instant drag-and-drop dashboards. Verify Oracle support and mobile requirements before signing, and run a paid pilot against your actual dbt project to confirm the AML workflow matches how your team already works.