Blog
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.
Generated by Gemini Banana As an Analytics Engineer working with e-commerce data, I see too many analysts aggressively GROUP BY their data to find insights, effectively throwing away valuable row-level context. Window...
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....
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...