Huy Nguyen
Data Engineer turned Product; writes SQL for a living.
Business Intelligence AQL: A Better Output Query Language for Agentic Analytics
AI analytics needs a purpose-built output language. We compare SQL, metric DSLs, and measure-aware SQL, then explain why we designed AQL for composable, governed, verifiable analytical reasoning.
Feature Release Product Updates: Power BI Migration, New Explore Interface, Embed Events, and More
June 2026 product updates: Power BI Migration Skill, New Explore Interface, Embed Events, Oracle Connector, KPI Metric Styling, and Color Palettes as Code.
Feature Release Product Updates: Smart AI Follow-ups, Branded AI Chatbot, Dashboard Auto-Run, and More
May 2026 product updates: Smart AI Follow-ups, Branded AI Chatbot, Dashboard Auto-Run, Auto-Abbreviate Numbers, and local agentic AI development.
Feature Release Product Updates: AI Chat History, BYO LLM, Open Semantic Layer, Dynamic Content Block, SCIM, and More
April 2026 product updates: AI Chat History, Bring Your Own LLM, Open Semantic Layer API, Dynamic Content Block, SCIM provisioning, and SSO enforcement.
Feature Release Product Updates: Chat to Refine Charts, Dynamic Content Block, Mobile View, and More
March 2026 product updates: Chat to refine charts, cleaner field descriptions, mobile view configuration, email updates for embedded users, and Dynamic Content Block.
Feature Release Product Updates: Verify AI, Collaborate on Dashboards, Auto Mapping, Quick Filtering and More
January 2026 product updates: Verify AI Answers, AI in Embed, simultaneous dashboard editing, Auto Field Mapping, Quick Filtering, dashboard component reuse, and faster saving.
Feature Release Product Updates: Context Control, Embeddable AI, and More
December 2025 product updates: Context Control for AI, Embeddable AI, Default Dashboard Templates, Search by Description, Canvas Dashboards in Personal Workspace, and Calculation Builder improvements.
Business Intelligence Slice n' Dice: A Self-Service Story
Business Intelligence The Goldilocks Rule of Getting Data Driven
Business Intelligence The 4 Types of Data Scales
Numbers aren't all created equal; they fall into four distinct categories known as data scales. Understanding this, you'll learn how to handle each type correctly to make your data work for you.
Business Intelligence 4 levels of Analytics-as-Code
How did Analytics-as-Code evolve? We explain the history behind the movement, and present the 4 levels of analytics as code over the years.
Business Intelligence The Two Forms of Metrics: Interval vs Point
In actual business conversations, the metric's form is sometimes ignored and implicitly understood. Understanding this concept gives you much better clarity in dealing with metrics.
Business Intelligence The skills chasm of the data analyst career
Why are so few data analysts get good at business problem-solving?
Business Intelligence How Would An Ideal Semantic Layer Look Like?
Business Intelligence How to run a Data Clinic (aka Data Office Hours)
Data clinic is one of many ways you create value and drive your organization toward better data literacy. Here's how.
Business Intelligence The Misleading Data Analyst Job Title (and Career Ladder)
Investment analyst is an entry-level investment position. So is data analyst an entry-level data position, too?
Business Intelligence Business Metrics vs Customer Metrics
Business Intelligence The Silos between Data Analysts and Data Engineers
Business Intelligence The Silos of Data Organization: Data Analysts vs Business Users
Business Intelligence Analytics as Code
A short story about my history with programmatic configuration (or lack thereof) and how it's related to analytics.
Business Intelligence Fitting Into Your Company's Learning Cadence
How a data person might fit into your company's learning cadence, and what that means for company performance.
Business Intelligence Simple Data People Tricks
Simple data people tricks, a hierarchy of feature stores, and Shreyas Doshi on product metrics.
Business Intelligence How Amazon Uses Input Metrics
How Amazon uses input metrics, a data pipeline is a materialized view, and the case against self-service data and analytics.
Business Intelligence Snowflake and the Data Lakehouse
A quick look at what Snowflake's been up to re: the Data Lakehouse, an inside look at Amazon's data-driven decision making, and how Airbnb customized Superset to fit their needs.
Business Intelligence The Data Lakehouse is a Thing
The data lakehouse is a thing, Superset is also a thing, and how to make dashboards using a product thinking approach.
Inner Join Announcing The Analytics Setup Guidebook: The First Principles Approach to Data Analytics
We're releasing The Analytics Setup Guidebook, a first-principles approach to data analytics. Get it free today!
Startups Qualitative data-driven: How we boost team alignment and customer empathy by written communications
Holistics Power-ups Optimizing Embedded Analytics Dashboard Performance by Pre-transforming Data
Your embedded analytics dashboard in Holistics takes a long time to load, thus impacting your customers' experience. This post shows you how to optimize the performance of embedded dashboard by preaggregating the data.
dbdiagram 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 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 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.
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)
Lean Analytics Quick Guide: Calculate Cohort Retention Analysis with SQL
Lean Analytics Useful PostgreSQL Queries For Monitoring Purpose
Engineering Why and How We Migrated from AngularJS to VueJS
New at Holistics Introducing Annotations
Engineering Moving From Redshift to Presto - Data Engineering at Grab
Lean Analytics Quick Guide: Building Daily + Running Total Report With SQL
SQL Tips Splitting array/string into rows in Amazon Redshift or MySQL
Lean Analytics Quick Guide: Reusing Your SQLs with Query Templates
Engineering