← Back to portfolio

Practical Data Engineering

Weekly Guides

How modern data tools work together to build reliable, scalable data platforms.

ETL vs ELT: Same Pipeline, Two Patterns

Week 2 · 9 min read

ETL vs ELT: Same Pipeline, Two Patterns

A technical comparison of ETL with Spark and ELT with dbt: code for both, how Airflow orchestrates each, cost and PII trade-offs, and how Microsoft Fabric supports both.

AirflowdbtSnowflakeFabric
From CSV to Dashboard: How a Complete Data Pipeline Works

Week 1 · 8 min read

From CSV to Dashboard: How a Complete Data Pipeline Works

A technical walkthrough of every layer between a raw CSV and a Power BI dashboard, with real code for ingestion, Airflow, Spark, the warehouse and refresh.

AirflowSparkFabricPower BI