Q&A How Do I Prepare for A Data Analyst Interview? Preparing for a data analyst interview can be intimidating. Learn a few tips to help you prepare your interview better.
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
