Episodes 10
Avg. Duration 39m
Activity Sporadic
Since Mar 2024
Latest Episode Mar 2025

Publishing Details

Schedule
Monthly
Format
Episodic
Hosting
www.thekeycuts.com

Contact & Outreach

About This Podcast

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

Podcasting 2.0 Features

episode medium podping

Explore Statistics

Recent Episodes

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

Mar 26, 2025 45m

Ever wondered if Hollywood’s magic is just smoke and mirrors, or if there’s actually some cold, hard data behind those blockbuster hits? I sat down with Stephen Follows, the film data analyst who’s…

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)

Dec 02, 2024 32m

There are times when a problem nags at you like a pebble in your shoe. Even when you’re not working on the problem itself, you’re thinking about the problem which make it even worse. Rarely do I come…

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

Sep 10, 2024 35m

When you think of your data warehouse, the “semantic layer” may not be the first thing that pops in your mind. Prior to reading Frances O’Rafferty‘s blog post on this topic, I didn’t even know this…

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

Aug 05, 2024 47m

If you could only learn one programming language for the rest of your career, what would be it be? You could Google the most popular programming languages and just pick the one of the top 3 and off…

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

Jun 24, 2024 45m

This is a replay of an episode from the Make Sense podcast with Lindsay Tabas. In the 1990s, large enterprises typically bought software in a tops-down approach. IT teams would get get Oracle…

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

Jun 18, 2024 31m

When you’re organization is small, a centralized data team can take care of all the internal data tooling, reporting, and requests for all departments. As the team grows from 100 to thousands of…

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

May 28, 2024

This is a replay of an episode from the Citizen Development Live podcast with Neil Miller. Citizen development is a relatively new term I learned about a year ago or so. To me, it’s using no-code…

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

May 13, 2024 36m

I wasn’t sure if this topic should be it’s own episode but it’s been on my mind ever since I came back from Atlassian Team ’24 (Atlassian’s annual conference). At the conference, I had the…

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

Apr 15, 2024 44m

With an undergraduate degree in zoology and a master’s in public health, you wouldn’t expect Amanda Makulec to lead a successful career in data analytics and data visualization. As we’ve seen with…

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

Mar 25, 2024 37m

Sometimes pop culture and data analysis meet and the result is something interesting, thought-provoking, and of course controversial. How can one use data to prove definitely which Taylor Swift songs…

Frequently Asked Questions

How many episodes does Dear Analyst have?

Dear Analyst has published 10 episodes since March 2024, covering topics in Education, How To.

Is Dear Analyst still active?

Dear Analyst is currently sporadic with new episodes monthly. Average episode length is 39m.

How do I contact Dear Analyst for sponsorship or guest appearances?

Sign up on Grep.FM to access contact details for Dear Analyst, including email and social media links.

Similar Podcasts