dbdiagram How to Visualize Your Rails ERD Diagram Automatically Learn how to use this simple free tool dbdiagram.io to visualize your Rails ERD diagram, made by Holistics
Data at Work 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.
Data at Work 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 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 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
Lean 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
Lean Analytics 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
Lean Analytics 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 tool to run queries & visualize PostgreSQL results, check out Holistics.io Get
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,
