Dear Analyst

Technology Podcasts

A show made for analysts: data, data analysis, and software.

Episodes

Dear Analyst #134: How Stephen Follows used AI to decode the Oscars and film data to debunk the film industry

Dear Analyst #133: Find or check if a cell contains text from a list of values or partial matching text in a list (3 methods)

Dear Analyst #132: How the semantic layer translates your physical data into user-centric business data with Frances O’Rafferty

Dear Analyst #131: Key insights and best practices from writing SQL for 15+ years with Ergest Xheblati

Dear Analyst #130: What happens when we rely too much on Excel spreadsheets and shadow IT takes over?

Dear Analyst #129: How to scale self-serve analytics tools to thousands of users at Datadog with Jean-Mathieu Saponaro

Dear Analyst #128: What is citizen development and how to build solutions with spreadsheets?

Dear Analyst #127: Spreadsheets vs. Jira: Which one is better for your team?

Dear Analyst #126: How to data storytelling and create amazing data visualizations with Amanda Makulec

Dear Analyst #125: How to identify Taylor Swift’s most underrated songs using data with Andrew Firriolo

Dear Analyst #124: Navigating people, politics and analytics solutions at large companies with Alex Kolokolov

Dear Analyst #123: Telling data stories about rugby and the NBA with Ben Wylie

Dear Analyst #122: Designing an online version of Excel to help Uber China compete with DiDi on driver incentives with Matt Basta

Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and Francesca Gino

Dear Analyst #120: Marketing attribution, sensitivity models, and building data infrastructure from the ground up with Zach Wilner

Dear Analyst #119: Developing the holy “grail” model at Lyft, user journeys, and hidden analytics with Sean Taylor

Dear Analyst #118: Uncovering trends and insights behind Facebook News Feed, Reels, and Recommendations using data science with Akos Lada

Dear Analyst #117: New 2023 Google Sheets functions for data manipulation that already exist in Excel

Dear Analyst Episode #116: Will Microsoft’s AI Copilot for Excel replace the need for analysts?

Dear Analyst #115: How to count the number of colored cells or formatted cells in Google Sheets