Holistics

Holistics A self-service BI platform that enables data democratization for your entire organization.

Tired of exporting multiple database queries of business records into spreadsheets and emailing them repeatedly to different stakeholders? Holistics provides a simple, secure and effective way to access business records from your analytics database. It works without the need to store your data, and does not require any software training to use. Holistics extends the capabilities of SQL, enabling d

ata analysts to easily embed report filters for non-technical users to filter the operational business data across multiple dimensions in the form of date range, drop-downs or text fields. The platform also helps automate system jobs along their data delivery activities, freeing up the effort involved in developing and maintaining custom system scripts. Key Features:

- Data Publishing: Reports are created purely with SQL queries, and published on a cloud portal for users to view and interact with reports
- Data Management: A web interface allows your data teams to load data from various sources into your own data warehouse.
- Scheduled Transformations: Holistics helps you manage and perform your scheduled transformations within your database. Key Benefits:

- Maintain data ownership: We work without the need for our customers to load or transport data into our software.
- Easy to use: SQL is all that's required for your developers and data teams to publish reports on Holistics for business users.
- Prompt turn-around: Speed up the time it takes for your developers and data teams to deliver reports for your users.

Getting ghosted is one of the most universal dating experiences๐Ÿ’”, but when youโ€™re in a data team, you might run into ano...
18/03/2022

Getting ghosted is one of the most universal dating experiences๐Ÿ’”, but when youโ€™re in a data team, you might run into another type of ghosting.

Here are the six ways we think people โ€œghost" your (feel free to comment if you have other ones in mind):

11/03/2022

No data tool can ever help you achieve data literacy in your company.

The truth is: business intelligence problems are socio-technical problems, and you usually have to fix some combination of people (read: culture) and process and tool, all at the same time.

Self-service in the space is hard enough to define. Benn Stancil has a whole piece where he argues 'self-service is a feeling' โ€” which we largely agree with โ€” and Stancil says that self-service depends on how the org feels about self-serving data from their tools.

However, can we get more specific than โ€œSS is a feelingโ€?

To do so, weโ€™d need to invert the question, define โ€œself-serviceโ€ by what itโ€™s not, and look into the โ€œfailed stateโ€ of self-service.

You are a small company. You realize you need a data team, so you hire your first and you use Google Data Studio or Tableau or something. Your analyst churns out reports for management, and all is well for a few months. But eventually, your analyst can't keep up with all the requests she's getting, so you hire another. And another. And another. And then your company grows up, creates departments that report to different leaders, and each department hires their own analysts, and now you have an army of analysts in various parts of the company all writing queries or tuning Excel spreadsheets, just trying to keep up with the business requests your company throws at them.

These analysts are mostly English-to-SQL translators or Excel jockeys.

They're all relatively junior. Some are senior, sure. But there's not much career progression for them overall. And many of them are suitably displeased with their jobs, and a reliable percentage of them churns out (read: quits your company) every six months or so. You keep hiring new analysts to keep up with business demand and grit your teeth at the management challenge of constantly churning employees.

This is the failed state. And self-service, when seen through the lens of our inverted definition, is how far away you are from that failed state.

In an ideal world, self-service is a state where the business is sufficiently data-driven, but the data org does not look like an army of English-to-SQL translators. Youโ€™d just need a smaller group of data folks that can service a much larger number of data consumers.

In other words, self-service business intelligence is most usefully described as a business outcome โ€” a place that you get to through a combination of tools and processes and org structure.

And the way you get to it is by asking yourself, each step of the way: "does this move bring us closer or further away from the failed state?"

In such a scenario, the best thing a tool can do is to not get in your way. The best thing a tool can do is to give you handles when you want to evolve your org away from the failed state. And that's what we have to do at Holistics.

February passed by really fast but has been life-changing for some people around the world, so in the midst of it all, w...
09/03/2022

February passed by really fast but has been life-changing for some
people around the world, so in the midst of it all, we hope that you're safe and sound.
At Holistics, this is what we have been up to this month in terms of product features and updates:
๐Ÿ“‚ Export reports to the same files
๐Ÿ—‚๏ธ Export multiple widgets into the same Google Sheets file
๐ŸŒˆNew KPI Metric style and color palettes
๐ŸŒŽAuto-Migration Process to EU/US Data Center

๐Ÿ› ๏ธ WIP - External git integration (GitHub/GitLab)

Coming Soon:
- Query Parameters for Dynamic Dimensions, Measures, and more.
- Dashboard as-code and Data Source as-code.
- Model Field Revamp.
- AML 2.0
- Custom Charts.

For more information, please check and discuss in our community post here: https://buff.ly/3hTSrct

๐Ÿ’กHolistics' Monday Product Update:New Timezone Settings for   Did you know that you can now feasibly change the timezone...
28/02/2022

๐Ÿ’กHolistics' Monday Product Update:

New Timezone Settings for

Did you know that you can now feasibly change the timezone where your data is processed and displayed? For example, if your business operates in Singapore,
you can have every calculation handled in UTC+08:00.

More on: https://docs.holistics.io/docs/datetimes/timezones

๐Ÿ’ซWednesday's Blog Selection:Previously, we've explored the silos between Data Analysts and Business Users. This week, we...
23/02/2022

๐Ÿ’ซWednesday's Blog Selection:

Previously, we've explored the silos between Data Analysts and Business Users. This week, we dig in deeper to talk about the relationship between Data Analysts and Data Engineers.

โžก https://lnkd.in/gFXEGryX

Our team wants to send to you our best wishes for the year 2022. Our world has changed, but it won't stop us from embrac...
12/01/2022

Our team wants to send to you our best wishes for the year 2022. Our world has changed, but it won't stop us from embracing those changes and improving Holistics every day.

Let's take a quick look at some exciting features plus updates we've been working on in the last month.
๐Ÿ‘ช Community revamp
๐Ÿƒ Running Total
๐Ÿ”’ Updates on Analystโ€™s permission
โ†ฉ๏ธ Git integration

Coming soon in the upcoming month:
- Permission on Private Workspace
- Timezone Settings (MySQL and MSSQL)

For more information, please check and discuss in our community post here:
https://community.holistics.io/t/holistics-december-2021-product-updates/648

28/12/2021

๐Ÿƒโ€โ™‚๏ธ ๐ˆ๐ง๐ญ๐ซ๐จ๐๐ฎ๐œ๐ข๐ง๐ : ๐‘๐ฎ๐ง๐ง๐ข๐ง๐  ๐“๐จ๐ญ๐š๐ฅ

While 2021 is running to an end, Holistics is all about...Running Total!

Running Total is a very common calculation method that shows how a metric changes over time e.g. how the number of goods sold accumulates over months.

In this version, we support 4 types of Running Total: Sum, Average, Min and Max.

We have been trying to become a global brand ever since the first day. Last month, we were one step closer. We've releas...
10/12/2021

We have been trying to become a global brand ever since the first day. Last month, we were one step closer. We've released features that cater to the customers thousands of miles away from us.

๐Ÿ—ฝ New data centers: We have two new data centers in Frankfurt (EU) and San Francisco (US).

๐Ÿ•‘ New Timezone Settings (beta): This feature will help you change the timezone where your data is processed and displayed.

Coming soon (together with Santa) in the upcoming months:
- Analytics As Code
- dbt integration
- Git integration
- Period-over-Period Comparison for Table and Pivot Table.
- Multiple sort
- Running Total (Sum, Avg, Min, Max)
For more information, drop a visit to our release note at: https://releases.holistics.io/

For the last month, we've been working on exciting features that give business folks more options to interact with dashb...
29/10/2021

For the last month, we've been working on exciting features that give business folks more options to interact with dashboards and make them more beautiful

๐Ÿ“… ๐ƒ๐š๐ญ๐ž ๐ƒ๐ซ๐ข๐ฅ๐ฅ (beta) is now available for embedded dashboards and shareable links. Also, there are a lot of cool functions we have added to help you discover more insights by changing the time granularity.
๐ŸŒˆ ๐“๐ž๐ฑ๐ญ ๐œ๐จ๐ฅ๐จ๐ซ in charts will be auto-adjusted to your chart colour so that you can see the numbers easier and clearer.
โณ ๐๐ž๐ฐ ๐“๐ข๐ฆ๐ž๐ณ๐จ๐ง๐ž ๐’๐ž๐ญ๐ญ๐ข๐ง๐  (beta) allows you to feasibly change the timezone that your data is processed and displayed.

What are waiting for you in the upcoming months?
โ–ช๏ธ๐€๐ง๐š๐ฅ๐ฒ๐ญ๐ข๐œ๐ฌ ๐€๐ฌ ๐‚๐จ๐๐ž
โ–ช๏ธ๐๐›๐ญ ๐ˆ๐ง๐ญ๐ž๐ ๐ซ๐š๐ญ๐ข๐จ๐ง
โ–ช๏ธ๐†๐ข๐ญ ๐ˆ๐ง๐ญ๐ž๐ ๐ซ๐š๐ญ๐ข๐จ๐ง
โ–ช๏ธ๐๐ž๐ซ๐ข๐จ๐-๐จ๐ฏ๐ž๐ซ-๐๐ž๐ซ๐ข๐จ๐ ๐‚๐จ๐ฆ๐ฉ๐š๐ซ๐ข๐ฌ๐จ๐ง ๐Ÿ๐จ๐ซ ๐“๐š๐›๐ฅ๐ž ๐š๐ง๐ ๐๐ข๐ฏ๐จ๐ญ ๐“๐š๐›๐ฅ๐ž.
โ–ช๏ธ๐Œ๐ฎ๐ฅ๐ญ๐ข๐ฉ๐ฅ๐ž ๐’๐จ๐ซ๐ญ
โ–ช๏ธ๐‚๐ฎ๐ฆ๐ฎ๐ฅ๐š๐ญ๐ข๐ฏ๐ž ๐’๐ฎ๐ฆ

For more information, drop a visit to our October release note https://lnkd.in/gbDA3R9f

The fourth quarter of 2021 is fast approaching and promising several wonderful opportunities. And today is a long-awaite...
08/10/2021

The fourth quarter of 2021 is fast approaching and promising several wonderful opportunities. And today is a long-awaited occasion for all of us, as we wrapped up September with a slew of exciting new features! ๐ŸŽ‰

Let's see what we've got for you:
๐Ÿ”น Beta versions of Data Alert, Multiple Sort and Date Drill on the dashboard!
๐Ÿ”น Official release of New Pivot Totals!
And many other product updates are waiting for you to explore here: https://releases.holistics.io/8evhnv6/2021-september-updates

29/09/2021

Wake me up when Ship-tember ends! ๐Ÿ›ณ๏ธ

No, we're not singing Green Day's song here. We're coming again with our shipping-spree this month, we'd like to introduce to you: DATA ALERT โš ๏ธ

โš ๏ธ allows you to receive automatic notifications when the data meets certain conditions, so you can make timely and strategic decisions for your business.

Say, Billie, a wants to be notified when the number of daily users in his App passes 1000 without manually checking the number in the dashboard every minute or hour. With this feature, Billie now can easily set the Alert Frequency to be Daily at 8:00 AM, Holistics will start checking the data at 8:00 AM every day to see if it is over 1000 or not ๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ป

To start creating an alert, select Data Alert from the menu icon of the report > click Create New Alert.

For more information about this amazing feature, visit our Data Alert documentation, https://docs.holistics.io/docs/delivery/data-alert

Address

71 Ayer Rajah Crescent
Singapore
139951

Alerts

Be the first to know and let us send you an email when Holistics posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share