Archive / Podcast

RSS feed for this section
0-vlookup-multiple-conditions

How to do a VLOOKUP with multiple conditions or criteria (3 methods)

Once you learn the VLOOKUP formula, your world opens up in terms of being able to analyze and manipulate data. There are hundreds if not thousands of tutorials on how to use the VLOOKUP formula since it’s such a powerful formula for finding the data you need in a long list. Comparable formulas include the […]

0-austin-dowd

Dear Analyst #104: Creating a single source of truth by cleaning marketing analytics data with Austin Dowd

I’m always fascinated by how different people on the podcast find their way into data, and this episode is no exception. Austin Dowd has always enjoyed photography. He was associated with the American Marketing Association and was always curious in the metrics for his photos. After pestering the analytics person in the AMA in terms […]

12-copy-paste-pivot-table-slicer

Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers)

I used to create a monthly 30-slide report and each slide had a different table or chart that I copied and pasted from Excel. As a naive analyst, I literally filtered my list of data using regular dropdown filters on each column to get the numbers I needed. I would filter, sum or average the […]

0-mel-restori

Dear Analyst #102: Building a culture of experimentation on a data analytics team with Mel Restori, former Director of Analytics at Trove

Experimentation is a valuable activity in a variety of functions. A product team should be constantly experimenting with features to see which variant leads to the most engagement, sales, or some target metric. But what about on a data analytics team? Mel Restori is the former Director of Analytics & Analytics Engineering at Trove, a […]

0-David-Yakobovitch

Dear Analyst #101: How to invest in modern data startups with David Yakobovitch

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 episode, you’ll hear the other side of the data platform ecosystem. David Yakobovitch is a general partner at DataPower Ventures, a venture capital firm that invests in […]

0-100-episodes-dear-analyst

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

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 and data analytics would be easier than coming up with prose. Ironically, I’m still writing because all the show notes for […]

0-ryan-cunningham

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

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 analysis into any field you want. That’s exactly what Ryan Cunningham did to become a Senior Associate Builder at AI Fund. Ryan studied finance and […]

0-Wacarra-Yeomans

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

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 datasets and the business logic that drives these datasets. Wacarra Yeomans started her career as a graphic designer in the agency world. She always […]

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

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, Sarah gets into the weeds of what most data analysts do: helping business partners make better decisions […]

0-sean-scott

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

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 a company. Sean Scott stumbled into the DBA world and has been in this field for 25+ years. He […]