Whoops! We are now 10 days into 2021 – time flies, indeed! Similarly to everyone else, 2020 was the strangest year of my life. Therefore, with 2020 finally gone, I want to look back and take stock of everything lost, and the surprising things gained. Disappointments and detours Did anyone’s 2020 turn out the way
Pandas for Productivity Vlog Ep.8: 4 Key SQL Concepts For Business People
Why this topic? SQL isn’t only for data engineers and analysts. In a world where businesses need to be nimble and respond quickly to changes, everyone needs to be up-to-date with key metrics. Therefore, as business managers, we still need a working knowledge of how to manipulate SQL queries for quick insights. What it covers:
Vlogging Diary wk 9: My polygamous relationship with editing software (Part 1 of Potentially Many)
When I first started thinking about creating a sewing vlog two years ago, I assumed that I’d buy Premiere Pro. After all, at the time, that was everyone’s natural choice for video editing. However, I found a pleasant surprise! Instead of having just one (expensive) option, many options exist! Not only that, some of them
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
Vlogging Diary wk 6: Back to ground zero…
Whatever goes up, must come down… or so it seems… I was on cloud nine after successfully completing H Can Hack episode 1, and then landed on a day of entire standstill with Pandas for Productivity. Doing away with my Youtube intro Perhaps the most drastic decision of the fortnight was to scrap all intros
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