Hi 👋 Today I want to jump on a simple trick in Looker in order to avoid some basic breaking changes on your instance. The problem You have some nightmares because you’re scared about schema evolution in your data warehouse? You’re scared because you hope business users will not find something broken…

Hi 👋 Still on the same vibes as my last article (here), I just wanted to share a great tips about how to save a lot of time regarding your data tests 🥸. You may already know great_expectations a kick ass service to handle your data quality. As a reminder…

Hi all 👋 Hope you’re all doing well! Today I want to discuss about one topic really important to me because I’m working on it since around 2 years. As you all already know, the ‘’modern data stack’’ is becoming one of the buzzwords in the past months. …

Hi all, Hope you’re doing well. Today and want to discuss about BigQuery ML and how you can leverage Machine Learning with ‘’only’’ SQL knowledges. Context You all already know BigQuery, but since a couple a years you can call Machine Learning models only with SQL queries. …

Hi everyone! Hope you’re all doing great. Today we will use BigQuery to retrieve GPS points of crimes in Chicago. Then we will visualize those crimes in Data Studio. Context As a reminder you can use BQ to analyse public datasets, in the greatest way to level up your skills on…

Hi everyone 👋 First of all, happy new year. Hope everything is fine for you and your family. Well, today I want to discuss about what is the best service to pick in order to build your data lake. So first of all, let’s deep dive in some general concepts. What is a Data Lake? …

As usual, I hope you are all doing well! Today I want to discuss a tricky part of any new technical project, especially when you are dealing with a ‘’shift lines’’ project. Let’s start with the context. Context As you all know, the Cloud is now part of our daily journey…

Hi all 👋, As always, I hope you’re all doing great 😊 Today I want to discuss a critical topic and how to avoid (big) mistakes (and confusion). I’ve been working for a couple of months on a Business Intelligence project and I’ve made (a lot) of mistakes because I…

Hello world! Hope you’re all doing great! When you’re dealing with ETL / ELT you alway have to work at connections and how you will have access on your data sources (and to be honest, it’s not really the most interesting part). Fivetran can help us (a lot) with pre-built…