A complete guide for maximizing the potential of BigQuery window functions to manipulate and transform data. — BigQuery is a fully managed data warehouse that uses Google’s infrastructure that allows fast processing of SQL queries. It is especially useful for analyzing, exploring, and visualizing large amounts of data. This article simplifies and helps to visualize the concepts of windows in Google Cloud for non-developers, as they can…

Analyzing and comparing 7 ways of deduplicating rows in a BigQuery table. — TL;DR: Use the QUALIFY clause and go to the conclusion. In this short article, we will dive into some of the different ways to deduplicate rows in a BigQuery table. Summary Introduction Replicability Method 1: Deleting rows in-place Method 2: Selecting distinct Method 3: Grouping by all keys Technical or functional deduplication? Method 4: Grouping by primary…

Learn PSO algorithm as a bedtime story with GIFs and python code — Introduction Particle swarm optimization (PSO) has been successfully applied in many research and application areas. For my part, I really enjoyed the application of this algorithm in the article by G. Sermpinis [1] on foreign exchange rate forecasting. It is demonstrated that PSO can have better results in a…

A visual and mathematical explanation of the 2D convolution layer and its arguments — Introduction Deep Learning’s libraries and platforms such as Tensorflow, Keras, Pytorch, Caffe or Theano help us in our daily lives so that every day new applications make us think “Wow!”. We all have our favorite framework, but what they all have in common is that they make things easy for us…

Stay informed with GCP Release Notes at your schedule and your preferred product with this simple deployment — In the fast-moving tech world, it’s crucial to know about the latest stuff. If you’re into Google Cloud Platform (GCP), getting info about updates and fixes is super important. Here’s where Scheduled GCP Release Notes comes in — a free tool that sends you just the updates you care about…

You are not a writer and you are confused about how to start writing an article that is meaningful to you? My method should help you to write your first awesome article. — I love my work, but most of all, I love when I am able to share it. I suppose you are just like me. But each time I start an article, I have no idea where to start, I am afraid of not being legitimate to talk about a subject…

In this tutorial you are going to deploy a simple Cloud Function triggered by a Cloud Storage event with Terraform — Cloud Functions are scalable “pay-as-you-go” Functions as a Service (FaaS) from Google Cloud Platform (GCP) to run your code with zero server management. Cloud Functions can be written in Node.js, Python, Go, Java, .NET, Ruby, and PHP programming languages. For the sake of readability, this tutorial will contain a Cloud…

Visualization, description and python GitHub of benchmark optimization functions. — Motivations If you only are here for eye pleasure you can go to the Benchmark part. 😜 I was looking for a benchmark of test functions to challenge a single objective optimization. I found two great websites with MATLAB and R implementations you can find on the sources. Yet I wanted…

Smooth python codes to augment your image datasets by yourself. — Whether we are enjoying Keras or Pytorch we have access to wonderful libraries to efficiently enhance our images. But what about those special cases where: Our dataset does not have a trivial structure (3 input images and 1–2 segmented outputs as an example). We want total freedom and transparency in…