Holistics Blog

A Blog About Business Intelligence, Data Engineering, and Holistics product updates

Introducing Annotations

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...

Moving From Redshift to Presto

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.

Grab Data Architecture

  • 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...

Sidekiq Process Manager

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...

Freezing Report Table Header For A Better Experience!

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...

Building Daily + Running Total Report With SQL

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.

Animated raw

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...

SQL is The New Excel

There was a time when being a power Excel user gave you an edge in your resume – it implied that you can perform your tasks more efficiently than your peers. Excel remains one of the most commonly used tool for analyzing data today and can be applied in various scenarios such as financial modeling, data analytics, or even invoicing. However, it is running into a wall of limitations as the nature and use of data become more complex

Excel remains a powerful tool for data analysis today. But...

Page 1 of 2

Holistics Data Reporting provides a web interface for your existing SQL database to build and access reports

Holistics Data Preparation helps provide you an effortless approach to set up your reporting database.