This weekend is my long awaited commencement ceremony – MET Boston University class of 2021 – my class! Masters of Science in Computer Information System with a concentration in Data Analytics. What?! It’s awesome. Yes, allow me to boast at least for the weekend. Want to attend? Not a problem. The first prerecorded ceremony for […]
A few moments ago I posted the article below on LinkedIn. It is my first time creating an article on LinkedIn, rather than posting writings from here. While I am not a fan of creating articles in platforms I don’t control, I am curious on the effects. The complete article can be found here: How […]
I get tired of wasting time searching for this in old files… I typically use BigQuery, but when it is handy, it is handy.
This is just a memo. It is mid-March and I think it is worth writing a few words of what is happening: a pandemic. Something I have not experienced before. In some places also a pandemonium. What information do I have at this moment? The virus originated in a “wet market” in Wuhan. The type […]
I keep recreating queries from client to client, case to case. Let’s see if I can just use this blog as a future resource. SELECT from UNNEST Very useful for when you just want a particular value from the nested values. The below is from BigQuery, Google Analytics App + Web (app) exports. SELECT device.operating_system […]
I had come across something like this developer’s cheat sheet a while back and forgotten about it. Today I received an email from Google pointing to it and though I’d better save it for future reference. Also, I wonder how well this is going to age 🙂 The image is from https://medium.com/google-cloud/every-google-cloud-product-described-in-4-words-or-less-4d3f37f4567b by @gregsramblings