Holistics is business intelligence (BI) software with an analytics operations focus, making it easy for data teams to maintain.
Non-technical users can explore data and build their own dashboards without the need to know SQL.
Holistics provides a data modeling layer that is easy for any data teams to adopt (native SQL), and cuts down repetitive mundane work traditionally required to maintain a self-service BI platform.
Learn more about Holistics data modeling layer.
Here is a step-by-step of how setting up Holistics looks like:
Yes. You’ll need a SQL database for Holistics to connect with, since Holistics doesn’t collect or store the data for you.
If you don’t have a SQL database, you can consider getting one: How to set up a free BigQuery or PostgreSQL for data warehousing.
We designed Holistics to be SQL-based because of the following:
Learn more about our biases.
Yes, you can. The way to do it is:
For more details, check this guide.
Maybe. If you value interactive, rich visualizations for storytelling, Tableau is more suitable for you. Our focus is on analytics operations that makes it easy for data teams to maintain dashboards with minimal repetitive mundane work across the data preparation process.
Holistics falls into a different category compared to these products. Holistics is a BI tool that allows you to analyze your existing business data you already collected. Holistics needs to connect to your existing SQL databases.
Mixpanel, Amplitude, and Heap are “product analytics tools” where they allow you to track and analyze product-related behavioral data and analyze them based on pre-built report templates.
Learn more: Holistics vs Product Analytics Tools
You can see our past and upcoming product releases in our Release Notes.
Yes we do. Read more here:
Alternatively, you can contact us here to discuss how that can be done.
We don’t at the moment. If you are looking for Python workflow automation, you can try Airflow.
However, within our customers’ setup, data scientists usually use Holistics API to extract data to feed into their machine learning models.
While Holistics primarily focuses on the modeling and self-service BI layer, we do support ELT for some simple and common sources like:
Check out our Import Model for more information.
Holistics is not meant or designed to replace other ETL/ELT tools. So if you have many other sources of data, we recommend you use a dedicated ETL/ELT tools. StitchData, Fivetran, Meltano (open-source) are the common options you can look at.
We don’t support it currently.
All of our servers are hosted with reputable data center providers:
Holistics does not store any of your data. Holistics connect to your existing SQL database and farm queries to the database and only capture the resultset. The raw data sits in your own data warehouse, and you retain the full ownership of your data.
Holistics stores 2 things:
Learn more in our Data Security docs.
On top of the not storing customer data above, we also apply other security measures like: encrypted connections between Holistics servers and your database servers. We also conduct penetration testing on our applications on a regular basis.
You can read more about our measures for security in our Data Security docs.
Yes. Read more about our GDPR Statement
We also have a standard Data Privacy Agreement provided upon request, please contact us for more information.
Holistics is a fully cloud-based solution. This means you don’t have to spend time to set up and maintain your cloud infrastructure.
Currently, we do not offer on-premise solution.
Yes we do. You can check out our book, The Analytics Setup Guidebook, to get a practical, high-level understanding of a modern analytics system. This will save you the hassle of re-building your data analytics stack in future as we shared the best practices through our experience.
While we’re based in Singapore, the majority of our customers are in US and Europe. And despite the timezone difference, Customer Support has been among our most praised qualities from our customers.
“It’s very easy to use…. the responsive rate for support is very helpful.” - Ethan, Data Analyst at Piktochart
Our pricing is based on usage. Check out our pricing page for more information.