Camille Lebrun ·
Photo by Viktor Talashuk on Unsplash In french we say “Dans les vieux pots on fait les meilleures soupes” Why medallion architecture is a cloud-native rebrand of ODS and Data Warehousing —...
cloud-computing data-engineering
Blog
Data Engineering Blog: Modern Data Stack Insights & Best Practices
I publish battle-tested tips on building reliable analytics platforms: from dbt modeling patterns and BigQuery SQL recipes to workflow orchestration with Kestra or Airflow. Everything you read here is sourced from real consulting engagements and side projects.
Author: Camille Lebrun — Data Consultant & Analytics Engineer.
Camille Lebrun ·
Photo by R Mo on Unsplash Every week, an analytics engineer somewhere ships a dashboard showing an Average Order Value of $150. Their CEO makes decisions based on it. Their median order...
window-functions data-analysis sql
Camille Lebrun ·
Photo by Joshua Golde on Unsplash A dashboard showed positions 1, 2, 3, 4, 5, 6, 6, 8, 9, 10. Product #7 was missing. Not a pipeline issue — two products had...
data-analysis sql bigquery
Camille Lebrun ·
BigQuery provides robust support for Pivot and Unpivot operations, allowing you to transform rows into columns and vice versa. These operations are essential for reshaping datasets for reporting, visualization, or downstream analysis....
analytics bigquery sql
Camille Lebrun ·
Overview In today’s data-driven world, effective data transformation is essential for ensuring that your data is not only accurate but also consistent and ready for insightful analysis. Whether you’re developing dashboards, creating...
data-engineering data dbt etl