This episode is actually a recap of a talk I gave at a meetup. After reflecting a bit about the subject matter, I wanted to discuss some other topics that are more important than writing VBA scripts or doing stuff in Excel. At the meetup,

PivotTables have been on my mind lately (you'll see why in a couple weeks). An issue you may face with PivotTables is how to change the source data for a PivotTable you've meticulously set up. You have some new data being added to your source data,

When you think of sports and data, you may think about all the data collect on player performance and game stats. There's another world of sports data that is usually overlooked: the fans. In this episode, I speak with Caiti Donovan,

Transforming Netlify's data pipeline one SQL statement at a time. Lauren Adabie started her career analyzing data and answering questions about the data at Zynga. As a data analyst at Netlify, she's doing more than just exploratory analysis.

Numerous studies claim that data scientists spend too much time cleaning and preparing data (although this article claims it is a bullshit measure). I agree with some points in that article in that you should get your hands dirty with cleaning data to ...

This episode is all about data storytelling at a "traditional" enterprise company like LinkedIn and also at a major news publication. Janie Ho is a former global account analyst at LinkedIn in NYC where she facilitated data-driven presentations to clos...

Oz is one of the best creators of Excel content I know with his Excel on Fire YouTube channel. Unlike traditional "how-to" videos, his videos blend education with entertainment making the learning process feel like binging your favorite Netflix show.

It's a story we've all heard before. You're working a full-time job, and you have more fun doing your side hustle than your 9 to 5. This is what happened to John Michaloudis. He was a financial controller at General Electric but found his passion shari...

The NY Enterprise Tech meetup was one of my favorite events to attend in-person prior to the pandemic. While the meetup is now all virtual, the speakers they bring in continue to be top-notch--particularly in the data space.

Data warehouses have come a long way since the days of Oracle and Microstrategy. A data warehouse should be able to grow and expand with the business it supports. At Canva, the data amount of data coming into the data warehouse has exploded in the last...