dbdiagram
Using Holistics
How to Visualize Your Rails ERD Diagram Instantly
Learn how to use this simple free tool dbdiagram.io to visualize your Rails ERD diagram, made by Holistics
Data at Work
Business Intelligence
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.
Lean Analytics
Using Holistics
SQL Tips
How We Built Our MRR Dashboard (Using Pipedrive & Holistics)
Want to customize and automate MRR reporting, to suit your company's specific data needs? Luckily, Holistics integrates with Pipedrive, here's our guide!
Data at Work
Startups
Business Intelligence
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 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
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
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 …