Nov 23, 2021How to Use Self-made Service Account Key with Expiration Date on Google Cloud PlatformOne of the best practices for storing service account keys is to rotate them on a regular basis. You can do that manually but it would be much better to have a kind of mechanism that doesn’t let you miss the date of key renewal. I will use some gcloud…Google Cloud Platform3 min read
Nov 17, 2021Improving product decision confidence with Kano modelAs a product person you are usually trying to find a balance between time to market and amount of value delivered to your users. In other words, if something produces a lot of value and you don’t have to spend ages before you release it — you are good to…R7 min read
Aug 23, 2021I Thought I Would Never Use Math AgainIt was yet another online meeting where we discussed design patterns with my colleagues. Somewhere during the conversation I used the knowledge about disjunctive normal form in boolean logic as an argument to throw away some unnecessary UX elements. This saved us tens of hours on design validation and development…Mwc Reentry5 min read
Mar 15, 2021Constructing SQL Queries Using Google BigQuery ScriptingLet’s start with a simple question: for each tool in my product what fraction of daily active users per day visits the tool? Maybe not so simple so let me add some assumptions to simplify the solution. Daily active user is the one who visits at least one tool per…Sql7 min read
Jan 29, 2020How to Grant an Access for R googlesheets4 package Using Google Cloud Platform Service AccountOne of my weekly tasks brought me to Google Cloud Platform instance to deploy a tiny R script as a cron job. This script makes some data transformations and writes the results to Google Sheets. …R2 min read
Apr 17, 2018How 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 share this data with my team for us to be on the same line while we are developing new features or improving something that already…Bigquery7 min read
