Pandas for Productivity Vlog Ep. 7: The necessity of making SQL queries scalable

Why this topic? Back in 2016, the size of my performance marketing portfolio tripled overnight. I was working 16-hour days with at least 2 hours per day spent updating Excel spreadsheets. However, this was all needless! What it covers: I give tips on how to automate daily repetitive SQL data pulls, to help you save

Pandas for Productivity Vlog Ep 6: Overcoming my mental block with Google BigQuery

Why this topic? The first time I encountered Google BigQuery in 2016, I was thrown off by some of its unique syntax. Previously, I had used mainly Hive and Teradata. Therefore, I’d like to share the most unfamiliar aspects to help those of you making this transition too. What it covers: I walk through the

Pandas for Productivity Vlog Ep 5: Moving averages in Pandas

Why this topic? This topic doesn’t have much documentation, yet is potentially very useful. Calculating moving averages in Excel is time-consuming. Furthermore, when you use a window function in SQL you must structure the query carefully. Why not do it in Pandas instead? What it covers: First, I demonstrate how to use .rolling() to get

A self-indulgent look back at my first vlogging month

Since, well, forever actually, I’ve had the itch to do just one self-indulgent, aesthetic vlog. Specifically, the ones where you use handwriting fonts and other aesthetic overlays and backgrounds. Although I’ve made a mental commitment to only do content that benefits others, I think this self-indulgent vlog can qualify. After all, it debunks the notion

Pandas for Productivity Vlog Ep 4: How to identify and fix missing data

Why this topic? This is a lead-in to next week’s episode, where I will talk about calculating moving averages in Pandas. Subsequently, I will show how nulls in the data set will affect how you want to structure your code. Therefore, I need to get everyone on the same page in understanding how nulls work.

Video editing software: Oct 2020 Summary

This is a quick attempt to document my learnings from shopping for video editing software. Below, I will summarize the options for different user types. Through this summary, you can compare the costs, features and resource needs of different software packages. Bare-bones beginner ($0-$50 outlay) Mostly, you aim to produce quick videos for social media