It’s been a while since I worked on a machine learning project from exploratory phase to model development. I bumped into a real newbie error and decided to write it down for my future self, and for you of course. Here’s the code I wrote and I hoped to get…
Lately, I have been messing around with some machine learning training & monitoring tools. Since Comet.ml has been high on my wish list for a couple of months, it was an obvious choice to give it a spin. I really like Comet.ml so expect more blog posts in the future.…
In this blog post, I elaborate on two specific operations you’ll run into when using dates in BigQuery. Subtracting an interval from a data and calculating the difference between two dates. Subtracting a unit Subtracting a specific amount of days, weeks, months, quarters, or years from a date can be…
The future is server-side. The rise of ad blockers and other privacy extensions hasn’t made product analytics implementation easier. On the other hand, good ol’ Google Analytics has gained quite a lot of competition in recent years from vendors like Heap and Mixpanel. A friend of mine asked my opinion…
Fundamental to data modeling is that you need a fact table or a table with a unique key per row. That is no different in GoodData. In this blog post, I tackle a specific error that you might run into if your dataset doesn’t meet the necessary requirements. When I…
Here’s a blog on GoodData. They have a clever way of prepping and loading data from data warehouses. I was under the impression that reading rights would suffice for GoodData to access my BigQuery datasets, but clearly, that wasn’t the case. In GoodData’s Data Integration Console, I got this big…
Recently I decided to start streaming clickstream data (from this blog, indeed) into BigQuery using the insertAll method. It is a relatively cheap solution that requires almost no technical configuration. Until I bumped into an error. Let’s tackle it in this blog post. The error I encountered is: “google.api_core.exceptions.BadRequest: 400…
Pandas can be somewhat puzzling, sometimes. It has a ton load of functionalities, but that can make the syntax and methods obscure. Simply judging from the method name, the ‘join’ and ‘merge’ method could be the same thing. However, they aren’t. Here’s an error that I used to run into…
In this blog post we discover how you can replace empty fields in tables with a zero. As you will see below, this is very straightforward. You can see in this table that some values are empty, that is because there is no corresponding value if that metric for a…
Your first steps in setting up Cloud Build for deploying Google Cloud Functions but running into yet another error? You’re not alone. With this blog post, I hope to put you on your way again. Have you run into the following error? “Permission ‘cloudfunctions.functions.get’ denied on resource […]” Here’s what’s…