Dear Analyst

Dear Analyst


Latest Episodes

Dear Analyst #91: Growing Peloton’s product analytics team and growth funnel experimentation at Superhuman with Elena Dyachkova
April 18, 2022

I first heard Elena speak on another podcast and was shocked to hear an analyst talk about one of the biggest companies to emerge during the pandemic: Peloton. Someone from the inside, as it were, is

Dear Analyst #90: Biostatistics, public health, and the #1 strategy to land a job in data with Tyler Vu
April 11, 2022

You go to a family gathering and everyone is fawning over you cousin who has a cushy stats job at Harvard. Knowing your cousin, you think to yourself: if my cousin can do it, so can I. Next thing you

Dear Analyst #89: Leading high performing data teams and deciphering the data stack with David Jayatillake
April 04, 2022

Most episodes I have the privilege of speaking with analysts who are in the trenches using tools and doing analyses. In this episode, we look at the role of data from a manager/director of data's pers

Dear Analyst #88: How to learn data science and machine learning from scratch with Santiago Viquez
March 21, 2022

Companies are generating more big data these days, so dumping the data into a CSV for analysis just doesn't cut it anymore. Sure you could use Power Query or Power BI, but more analysts are turning to

Dear Analyst #87: What we can learn about Enron’s downfall from their internal spreadsheet errors
March 14, 2022

Everyone is probably familiar with the 600,000 emails released by Enron after their scandal right at the turn of the century. A lot of different analyses was done on those emails, but there's one inte

Dear Analyst #86: One Important Excel Feature to Know to Do Your Best Data Analysis
February 28, 2022

Nothing like a click-baity headline to get your spreadsheet emotion all riled up amirite? Earlier in my data analysis career, I thought knowing advanced Excel formulas and writing macros made you a go

Dear Analyst #85: Preksha Kaparwan talks about her journey as a chef To CMO of a data analytics company
January 18, 2022

You might think not having a data background means it'll be tougher for you to get a career in data. For Preksha Kaparwan, co-founder and CMO at Alphaa AI, the journey into data was anything but tradi

Dear Analyst #80: Applying the rules of Squid Game to real-life games like negotiating a job offer
November 01, 2021

I finished watching Squid Game a few weeks ago and still have all these swirling thoughts about the series. Through a few basic survival games, the show brings to light wealth inequality, capitalism,

Dear Analyst #79: How to finally AutoFit column widths in Excel for the Mac (and PC)
October 11, 2021

When you're creating some dashboard or report, one of the most common formatting operations you'll find yourself doing is expanding the column width to fit the text or numbers in a cell. You might als

Dear Analyst #78: 3 mental models from the show Billions
October 04, 2021

Following up from episode #77 about mental models, I wanted to take things one step further and tie mental models to one of my favorite shows. If you came here hoping for the latest Excel trick or key