Time series anomaly detection with BigQuery ML and DataformFor the time series data, let’s see how you can check for anomalies without actually looking into the data.Feb 24, 2023Feb 24, 2023
BigQuery, Airbyte, Intercom, and another story of Google Cloud Platform cost optimizationIt is always a good practice to check the costs if you are trying a new tool connected to BigQuery. Here is a case of how you can do that.Nov 18, 2022Nov 18, 2022
Building data pipelines in Google BigQuery with DataformI’ve been using Google BigQuery since its’ public release and I like where it has been going through all these years. The team behind the…Oct 10, 20221Oct 10, 20221
How to Use Self-made Service Account Key with Expiration Date on Google Cloud PlatformYou should rotate your local credentials from time to time for security reasons. This is how you can do that with GCP service account keys.Nov 23, 2021Nov 23, 2021
Improving product decision confidence with Kano modelThere are a lot of different ways to raise the level of confidence of the product decisions. Kano model could be one of the tools to do…Nov 17, 2021Nov 17, 2021
I Thought I Would Never Use Math AgainAre you sure that math is not for you? Let’s take a look at the power of math using the simple formula from SaaS world.Aug 23, 2021Aug 23, 2021
Constructing SQL Queries Using Google BigQuery ScriptingComplex SQL queries are hard to construct and maintain. Using BigQuery scripting you can automate this process.Mar 15, 2021Mar 15, 2021
How to Grant an Access for R googlesheets4 package Using Google Cloud Platform Service AccountI use googlesheets4 package to communicate with Google Sheets and it works frictionless on my local machine. But not in cloud instance.Jan 29, 2020Jan 29, 2020
How To Stop Wasting Money on Google BigQuery in Google Data StudioOne of my responsibilities as a product manager is tracking the influence of product on key metrics like revenue or MRR. I also prefer to…Apr 17, 20181Apr 17, 20181