Holistics Blog Holistics Blog
  • Blog Home
  • General
  • Analytics
  • SQL
  • Product Updates
  • Engineering
Subscribe
Huy Nguyen

Huy Nguyen

Original creator and cofounder of Holistics, a data platform for tech companies. Holistics’ customers are tech startups like Grab, Traveloka, ShopBack, 99co, Tech In Asia and alike.

Singapore & Vietnam •
13 posts •
Analytics

How To Interview A Data Analyst Candidate

How do you usually interview a data analyst candidates? In this article, I'll share some of the guidelines and areas you can focus on when interviewing a data analyst candidate. These serve as pointers to aid with your interview.

Huy Nguyen Huy Nguyen

Data Lake vs Data Warehouse vs Data Mart

The term "Data Lake", "Data Warehouse" and "Data Mart" are often times used interchangbly. But what are exactly the differences between these things? This post attempts to

Huy Nguyen Huy Nguyen
Engineering

How We Built A Job Queue System with PostgreSQL & Ruby For Our B2B SaaS Application

Why and how we built a multi-tenant job queue system for our B2B SaaS Application with PostgreSQL and Ruby

Huy Nguyen Huy Nguyen
Analytics

Understanding Your Average Customer Value Over Time (CVO)

As business owners, understanding your customers’ behaviour is among the key things that will help you grow your business. If you’re in ecommerce, retail, or F&B business, one question that

Huy Nguyen Huy Nguyen
SQL

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 to give you a step-by-step walk-through on how to build such an analysis

Huy Nguyen Huy Nguyen
SQL

Useful PostgreSQL Queries For Monitoring Purpose

Below are some useful Postgres queries for both troubleshooting and analytics purpose. Get Running Queries (And Lock statuses) in PostgreSQL The below display currently running queries, and a granted column indicate whether the

Huy Nguyen Huy Nguyen
Engineering

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 a 4-month non-intrusive effort to migrate our application from AngularJS to VueJS. In this post,

Huy Nguyen Huy Nguyen
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

Huy Nguyen Huy Nguyen
General

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 how they moved their data infrastructure from Amazon Redshift to Presto to cater

Huy Nguyen Huy Nguyen
SQL

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, and filter capabilities of Holistics platform. Requirements: We want to build

Huy Nguyen Huy Nguyen
SQL

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 come to us with SQL question - that we thought would be interesting

Huy Nguyen Huy Nguyen
SQL

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 our codebase. In my previous job, we refactor our code religiously

Huy Nguyen Huy Nguyen
Engineering

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, and the same fair amount who uses MySQL. And from our

Huy Nguyen Huy Nguyen
Holistics Blog © 2018
Latest Posts Facebook Twitter Ghost
Holistics Blog

Subscribe to Holistics Blog

Stay up to date! Get all the latest & greatest posts delivered straight to your inbox