I write about data engineering, analytics, and lessons learned along the way.
A step-by-step walkthrough of how I built an end-to-end data pipeline from ingestion to visualization using PostgreSQL, dbt for transformation, and Apache Airflow for orchestration — all self-hosted on AWS EC2.
Read moreBoost your data wrangling efficiency with these underutilized pandas functions and patterns.
Read moreHow I transitioned from business analysis into data engineering and the skills that bridged the gap.
Read moreMastering ROW_NUMBER, LAG, LEAD, and partition-based analytics with real-world examples.
Read more