From Tables to Decisions: What Building This Project Taught Me About Analytics Engineering
Closing reflections on the mindset shift from moving data to designing trusted, decision-ready data products.
Avas#blog
From Entity360 to Executive Dashboards: Building a Neighborhood Summary Mart
Reusing Listing360 to build a simple, trusted executive-level Neighborhood Summary mart.
Building Listing360: Reusing Design Patterns to Scale Analytics Engineering
How reusing the Host360 architecture pattern made building Listing360 fast, consistent, and business-driven.
Building Host360: Implementing Our First Business Data Product
The author assembles the first complete business data product, Host360, by combining the host dimension with reusable intermediate metrics, and explores why the final layer of a data pipeline should be the simplest one.
Designing Your First Data Product: Why Analytics Engineering Starts Before SQL
The author steps back from implementation to explain how a data product like Host360 should be designed before any SQL is written, covering grain, consumers, metrics, and a lightweight design document.
Do You Always Need Fact Tables? Rethinking Dimensional Modeling in Modern Analytics Engineering
The author challenges the assumption that every analytics project needs standalone fact tables, exploring why the Airbnb project relies on dimensions and intermediate models instead, and how architecture should serve business needs rather than a textbook template.
Why Intermediate Models Are the Most Underrated Layer in dbt Projects
The author explains how intermediate models solve the hidden problem of duplicated business logic, using host-level metrics from the Airbnb dataset to show why this layer is essential for reusability, correctness, and readability.
Why Staging Models Are More Than SQL: The Hidden Power of dbt Tests and Data Contracts
The author explores how dbt staging models go beyond simple transformation logic, using YAML-based tests and data contracts to enforce data integrity across the Airbnb analytics project.
Ingesting Raw Data into Snowflake: Why the Raw Layer Should Stay Raw
Why the raw layer in a modern data warehouse should stay untouched, and how separating ingestion from transformation makes an analytics platform easier to maintain.
Designing the Architecture Before Writing Any SQL
The author outlines the critical importance of designing end-to-end data systems before implementing code, mapping out the architecture of their Airbnb project.
From Raw Data to Business Data Products (Part 1 Introduction)
The author reflects on a key mindset shift in analytics engineering: a data warehouse is only the foundation of data strategy, not the final destination.
Longest Consecutive Sequence — From Brute Force to Insight
A learning-focused walkthrough of the Longest Consecutive Sequence problem, showing how algorithmic optimizations reduce time complexity.
Harnessing Schema-Based UI for Seamless Interactions
Discover the power of schema-based UI for creating dynamic forms. Explore best practices, tutorials, and tools for designing intuitive and accessible form interfaces. Learn how to implement schema-based UI to streamline data collection and enhance user experiences.
Accessible Web Empowering Inclusive Online Experiences
Explore expert insights and practical tips on web accessibility. From WCAG compliance to inclusive design principles, we cover it all. Join us in making the web a more accessible and equitable space for everyone.
Unveiling Hidden Gems Lesser-Known Facts About TypeScript
Explore lesser-known aspects and hidden features of TypeScript in this insightful blog. From advanced type inference to powerful compiler options, uncover valuable tips and tricks to level up your TypeScript skills and enhance your development workflow.
Mastering GitHub Commits Tips for Efficient Editing and Version Control
Unlock the full potential of GitHub commits with expert tips and techniques for efficient editing and version control. Dive into tutorials, best practices, and tools to enhance your commit workflow and maintain a clean and organized repository history.
Boosting Website Performance with CSS Optimization
Explore expert guides and tools for streamlining your stylesheets and boosting website performance. From minification to code splitting, learn the latest CSS optimization strategies for lightning-fast browsing experiences.
Unlocking Storybook Features Exploring Essential Components and Add-Ons
Delve into the world of Storybook and uncover its powerful features for building and testing UI components. Discover tutorials, tips, and insights on leveraging Storybook's essential components and add-ons to streamline your development workflow and create exceptional user interfaces.
Unlocking Linux CLI Mastery Essential Tips and Tricks
Discover indispensable Linux command line interface (CLI) tips and tricks to enhance your productivity and efficiency. Explore tutorials, hacks, and best practices for navigating the CLI like a pro and unleashing the full potential of your Linux system.