Dear Analyst
Latest Episodes
Dear Analyst #91: Growing Peloton’s product analytics team and growth funnel experimentation at Superhuman with Elena Dyachkova
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
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
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
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
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
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
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
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)
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
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