How getting an advanced computer science degree can help build a credible skillset and make meaningful connections to get a job in tech
Four years ago I was a PhD student in Computational Biology. I was proficient in Python and had taken courses in all the Computer Science fundamentals. But when I decided to drop out and pursue a career in tech, I was surprised by the stream of rejections for entry level positions. I had qualified to be getting my doctorate after all!
After months of applying, I wound up getting a position in data science. Despite securing a…
Sometimes your data lands in BigQuery as a nested JSON string. One example might be an a column that has one key for each item — with details about the item nested as shown below.
"name": "My Product",
"category": "My Category"
"name": "My Other Product",
"category": "My Other Category"
Performing period-over-period analyses with SQL always seems to feel complicated. If you’re anything like me, each time you need to do some “Period-to-Date” comparisons you wind up searching Google for examples of queries you can leverage. Hopefully this post will make your searching a bit more fruitful!
Here, I’ll break down how we can use BigQuery to perform a simple analysis where we want to look at Week to Date (WTD), Month to Date (MTD), Quarter to Date (QTD) or Year to Date (YTD) aggregations and compare them to the prior period (i.e. …
Cloud Developer Advocate @Google, Grad Student @NYU, stereotypical dog lover based in Brooklyn