Thoughts & learnings

Blog

I write about data engineering, analytics, and lessons learned along the way.

Data Engineering Aug 2023

Building a Full Data Pipeline with dbt and Airflow on AWS

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.

🐍

Python Jul 2023

5 Pandas Tricks Every Data Analyst Should Know

Boost your data wrangling efficiency with these underutilized pandas functions and patterns.

📊

Analytics Jun 2023

From Business Analyst to Data Engineer: My Journey

How I transitioned from business analysis into data engineering and the skills that bridged the gap.

🗄️

SQL May 2023

Window Functions in SQL: A Practical Guide

Mastering ROW_NUMBER, LAG, LEAD, and partition-based analytics with real-world examples.