How getting an advanced computer science degree can help build a credible skillset and make meaningful connections to get a job in tech

Photo by MD Duran on Unsplash

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.

{
"item_1": {
"cost": 100,
"name": "My Product",
"category": "My Category"
},
"item_2": {
"cost": 150,
"name": "My Other Product",
"category": "My Other Category"
}
}

This format can be difficult to work with in SQL. Let’s consider looking at the average cost for each item category. To extract the nested values, we need to know the actual key we’re indexing. …


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. …

Leigha Jarett

Cloud Developer Advocate @Google, Grad Student @NYU, stereotypical dog lover based in Brooklyn

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store