Dear Analyst

Dear Analyst


Latest Episodes

Dear Analyst #101: How to invest in modern data startups with David Yakobovitch
July 25, 2022

Outside of Excel, you've seen and heard multiple data platforms on this newsletter and podcast. Everything from commercial data platforms to open-source platforms driven by communities. In this episod

Dear Analyst #100: Hitting a hunned! A look back at the top 5 episodes of Dear Analyst
July 11, 2022

Holy cannoli. Somehow we've hit 100 hundred episodes of the Dear Analyst podcast. This podcast started off as an experiment because I was lazy and got tired of writing. I figured speaking about Excel

Dear Analyst #99: Hyperscaling at Uber Eats and using VBA to automate M&A models with Ryan Cunningham
July 05, 2022

MLOps, neuromorphic computing, next-generation enterprises. These are concepts you generally don't hear about in the field of data analytics. This episode shows that you can parlay a career in data an

Dear Analyst #98: How a career in graphic design helps you with data storytelling and visualizations with Wacarra Yeomans
June 21, 2022

When you're working in a marketing or advertising agency, you'll work with clients across various industries. The data you analyze will also vary client to client, giving you exposure to various datas

Dear Analyst #97: Becoming a data Swiss army knife for marketing, operations, and customer support data problems with Sarah Krasnik
June 13, 2022

As a flex player on a data team, you might play the role of a data scientist, data analyst, or data engineer. Sarah Krasnik is one of those people who has held all these roles. In this conversation, S

Dear Analyst #96: Treating data as code and the new frontier for DBAs with Sean Scott
June 06, 2022

What did the developer say to the DBA? It doesn't matter, the answer is "no." I've never worked with a database administrator (DBA) before but know they play an important part in the data lifecycle at

Dear Analyst #95: Nobody ever got fired for choosing Google Sheets
May 23, 2022

The motivation for this post/episode is a selfish one (scroll to the very bottom or skip to the end of the podcast to see why). As I thought about the framing of this post during my normal "thinking"

Dear Analyst #94: Helen Mary Barrameda on having a “portfolio career” prior to being a data analyst, winning the NASA Space Apps challenge, and wfh tips
May 16, 2022

A common theme I've noticed from talking with many data analysts and data engineers is that they didn't come from a "data" background. Helen Mary Barrameda someone who exemplifies this theme. She is b

Dear Analyst #93: How to bring data literacy to schools and teaching Python with Sean Tibor and Kelly Schuster-Paredes
May 09, 2022

This episode is quite different from other episodes for a few reasons. One, it's the first time I've had two guests on the show at the same time. Second, it's the first time I've had educators on the

Dear Analyst #92: Generating insights from vehicle telemetry data and crafting a data strategy with Victor Rodrigues
April 25, 2022

Data can come from different places, and one area I don't hear about too often is from vehicles. Victor Rodrigues is from Brazil and transitioned into a career in data six years ago. Before that, he w