/blog

Blog

Practical essays on reliable data systems.

Data Cleaning: The Dirty Work That Actually Matters
Feb 19, 20268 min read
Data Cleaning: The Dirty Work That Actually Matters

A practical checklist of common data cleaning pitfalls and actionable practices to keep pipelines and reports trustworthy.

Data CleaningData EngineeringData Quality
Why Most Students Learn Data the Wrong Way
Jan 2, 20264 min read
Why Most Students Learn Data the Wrong Way

A guide to thriving in data analytics, navigate complex real-world problems with confidence, and develop a skill set grounded in fundamentals that outlast fleeting trends and ever-changing tools.

Data AnalyticsSQLData ExplorationPractical Learning
Building a Modern ELT Pipeline with Snowflake, dbt, and Airflow
Jan 31, 20266 min read
Building a Modern ELT Pipeline with Snowflake, dbt, and Airflow

A practical guide to building modern ELT pipelines using Snowflake, dbt, and Airflow — patterns, orchestration, and operational considerations.

ELTSnowflakedbtAirflowData EngineeringPipeline Architecture
End-to-End Data Engineering Project: Analyzing 2023 Uber Trips on Google Cloud Platform
Sep 30, 20254 min read
End-to-End Data Engineering Project: Analyzing 2023 Uber Trips on Google Cloud Platform

An end-to-end walkthrough building a scalable data pipeline for 2023 NYC Yellow Taxi trip records using GCP, Mage.ai, BigQuery and Looker Studio.

Data EngineeringGCPBigQueryMageETL