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