View media kit
Product
Overview
Embedded analytics
Empower your customers with advanced analytics
How Holistics works
How the product works and its benefits
Self-service BI
Let anyone build reports with zero coding
Holistics AI
Explore data using natural language
Analytics as-code
Write code to define your BI logic & check them into version control
Data modeling
Build a central repository of all your business logic
dbt integration
Connect dbt transformation layer with Holistics BI layer
Data delivery
Push reports directly to your stakeholders
Reusable analytics
Build reusable analytics components
Canvas dashboard
Empower your data storytelling with unparalleled flexibility
Dynamic data sources
Dynamically select data source by user and environment
All features
Explore all powerful features in Holistics
Data Sources
See All
Amazon Redshift
Google BigQuery
Snowflake
PostgreSQL
MySQL
Microsoft SQL Server
Databricks SQL
Pricing
Docs
Blog
Customers
Customer Stories
Customers & case studies
Learn how our customers built reliable BI systems with Holistics
Support
White-glove support to help you succeed with Holistics
Resources
Learn
See All
Worldview
Our worldview on business intelligence
Demo sandbox
Try Holistics in your browser with sample data.
Documentation
Learn how to get started with Holistics.
Support
White-glove support to help you succeed with Holistics
Release notes
What just got shipped!
Product roadmap
What's shipping next?
Engage
Community
Ask questions, request new features or mingle with other Holistics users
Blog
Inner Join - our blog on Business Intelligence for practitioners.
Newsletter
Our weekly newsletter to 30K+ data professionals worldwide.
Contact us
Have questions? Contact our team.
Partners
Holistics consulting partner network.
Referral program
Earn commission by referring prospects to Holistics
Books
The analytics setup guidebook
Build scalable analytics & BI stacks in the modern cloud era
Slice & dice: A self-service analytics comic
What self-service analytics is, and why it is important.
Log in
Book a demo
Product
Overview
Embedded analytics
How Holistics works
Self-service BI
Holistics AI
Analytics as-code
Data modeling
dbt integration
Data delivery
Reusable analytics
Canvas dashboard
Dynamic data sources
All features
Data Sources
Amazon Redshift
Google BigQuery
Snowflake
PostgreSQL
MySQL
Microsoft SQL Server
Databricks SQL
Pricing
Docs
Blog
Customers
Customer Stories
Customers & case studies
Support
Resources
Learn
Worldview
Demo sandbox
Documentation
Support
Release notes
Product roadmap
Engage
Community
Blog
Newsletter
Contact us
Partners
Referral program
Books
The analytics setup guidebook
Slice & dice: A self-service analytics comic
Holistics Report
Create reports with dynamic SQL queries
Accept user inputs as parameters into your report SQL query
Reports
Holistics reports allows your users to access any data-sets they need without raising a new data request. Each report is made up of a dynamic query that can provide thousands of data-sets permutations for your users to access the data they need. A Holistics report can either be viewed on its own, or be included as a sub-report in a dashboard. You can also schedule reports to be emailed to you automatically on a daily, weekly or monthly basis. You can also set up specific alert thresholds to notify you of changes in your data.
Filters
to customize
any
data-sets you need
Add various fields to your report to make it easy for you to filter the data you need. Any inputs they into your SQL queries either as parameters or syntax to generate dynamic real-time operational reports. This lets you provide thousands of data-set permutations for your users to access.
Date Fields
Easily set default date values to load (3 weeks ago, last monday, yesterday) upon.
Text Fields
Flexibility to filter your records by fuzzy search or regular expressions.
Dropdown Fields
Populate drop-down filters dynamically from your database table, a custom SQL query, or keying in them in directly.
List Fields
Enter in thousands of records to filter your data. Saves time from selecting multiple selection of records.