Lean Analytics
Business Intelligence
Quick Guide: Calculate Cohort Retention Analysis with SQL
Cohort Retention Analysis is a powerful thing that most business owners need to look at. In this post, I'm going …
Lean Analytics
Engineering
Business Intelligence
Useful PostgreSQL Queries For Monitoring Purpose
Below are some useful Postgres queries for both troubleshooting, monitoring and analytics purpose. Note: if you're looking for a simple …
Engineering
Inner Join
Why and How We Migrated from AngularJS to VueJS
As I'm writing this, we've just removed the last line of AngularJS code from our application codebase, ending …
New at Holistics
Using Holistics
Introducing Annotations
As you progress in your business, it's becoming more and more difficult to keep track of the small or big …
Engineering
Data at Work
Business Intelligence
Moving From Redshift to Presto - Data Engineering at Grab
Recently one of our customers, Grab - the Uber's competitor in SEA, unicorn startup - published a blog post on …
Lean Analytics
Using Holistics
Quick Guide: 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, …
SQL Tips
Splitting array/string into rows in Amazon Redshift or MySQL
We've worked with a lot of customers who writes SQL on a regular basis. And from time to time they …
Lean Analytics
Holistics Power-ups
Using Holistics
Quick Guide: Reusing Your SQLs with Query Templates
As engineers we refactor and abstract our code regularly, this is part of process to improve our code quality and scale up …
Engineering
Lean Analytics
Business Intelligence
Why You Should Use Postgres Over MySQL For Analytics Purpose
Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, …