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.
The term "Data Lake", "Data Warehouse" and "Data Mart" are often times used interchangbly. But what …
Why and how we built a multi-tenant job queue system for our B2B SaaS Application with PostgreSQL and Ruby
In any organization’s analytics stack, the most intensive step usually lies is data preparation: combining, cleaning, and creating data sets that …
As business owners, understanding your customers’ behaviour is among the key things that will help you grow your business. If you’re …
A common problem that data analysts and report users face is slow dashboards, making users wait for charts and reports to load. …
In his early days of investing, Warren Buffett drove to the airport at Omaha to pick up David Strassler, a New York based businessman whose family bought and fixed distressed companies.
Cohort Retention Analysis is a powerful thing that most business owners need to look at. In this post, I'm going …
Below are some useful Postgres queries for both troubleshooting, monitoring and analytics purpose. Note: if you're looking for a simple …