Data at Work
Business Intelligence
Data Lake vs Data Warehouse vs Data Mart
The term "Data Lake", "Data Warehouse" and "Data Mart" are often times used interchangbly. But what …
Engineering
Inner Join
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
Lean Analytics
Data at Work
Business Intelligence
ETL vs ELT: How ELT is changing the BI landscape
In any organization’s analytics stack, the most intensive step usually lies is data preparation: combining, cleaning, and creating data sets that …
Lean Analytics
Business Intelligence
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 …
Lean Analytics
Business Intelligence
4 Ways to Improve Dashboard Performance
A common problem that data analysts and report users face is slow dashboards, making users wait for charts and reports to load. …
Lean Analytics
Business Intelligence
Knowing Your Key Metrics
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.
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
Startups
Inner Join
When Engineering drives Growth: Why we release everyday
The benefits of how an engineering-driven culture drives the growth of Holistics, a data analytics company