Holistics Blog

In our new Holistics release (v1.29), we finally unveiled a popularly requested feature: Geo Heatmaps! Our engineering team has been working hard on this behind the scenes for a while now, so we’re really excited to share this with you, as part of creating a great Holistics software user experience!

Combining the power of SQL with being able to answer...

As you progress in your business, it’s becoming more and more difficult to keep track of the small or big events that happened, things like:

• The first launch of iOS app
• A big release with an awesome feature
• Your business getting featured on the media
• Running a big marketing campaign
• …

That’s why today, we’re excited to share a new awesome feature: Annotations! Annotations help you keep track of what has happened on a timeline, or directly on your chart.

Watch a short demo video of the feature...

Recently one of our customers, Grab - the Uber’s competitor in SEA, unicorn startup - published a blog post on how they moved their data infrastructure from Amazon Redshift to Presto to cater for their scaling needs. We thought it’s pretty interesting and wanted to do a short summary of the post below.

• They were using Amazon Redshift but the data grew really big, and Redshift couldn’t handle
• Built a data lake, separate the storage layer from the data processing layer.
• Storage layer using...

At Holistics, we use Sidekiq, the de facto standard background processing framework for Ruby. By combining the reliability feature of Sidekiq Pro and our own retry logic, we can be assured that no back-end job gets lost or forgotten. Yet for a while, there were process management issues that we had not been able to solve effectively.

Gracefully restarting worker processes

In order to restart a Sidekiq worker, the recommended way is to send SIGTERM, which is the signal sent to a process to...

In our last release (v1.22), we’ve supported the ability for you to freeze your table header. This is of the many minor enhancements our engineers make under the hood to improve our overall software user experience!

What this means for you

This is especially helpful for data analysts and product teams who need to browse through massive volumes of...

In this article I will show you how to build daily user growth report with cumulative number (running total) using mostly SQL, and filter capabilities of Holistics platform.

Requirements: We want to build a report that:

• Show daily users and a cumulative user growth
• Ability to select a date range
• Ability to filter by some user’s conditions (gender, user type, etc)

First, The Dataset & A Simple Daily Count

Assume we work with this simple users table in PosgresSQL (fields like username...