Dear Analyst

Hosted by KeyCuts

Technology News EducationExplicit

Website RSS feed

Episodes

Latest episode

Mar 2025

Language

EN-US

About the show

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

Listen to episodes

10 recent

March 26, 2025Episode 13445 min

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

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 basically Indiana Jones, but instead of chasing ancient artifacts, he’s digging up the buried truths of the movie industry. We’re talking about […] The post Dear Analyst #134: How Stephen Follows used AI to decode the Oscars and film data to debunk the film industry appeared first on .

December 2, 2024Episode 13332 min

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)

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 across a Google Sheets/Excel task I cannot solve with formulas, but this one evaded my extensive knowledge […] The post 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) appeared first on .

September 10, 2024Episode 13235 min

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

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 was a concept that mattered in the data stack. To be honest, the concept is still a bit confusing […] The post Dear Analyst #132: How the semantic layer translates your physical data into user-centric business data with Frances O’Rafferty appeared first on .

August 5, 2024Episode 13147 min

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

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 you go (FYI they are Python, C++, and C). Or, you could pick measly #10 and build […] The post Dear Analyst #131: Key insights and best practices from writing SQL for 15+ years with Ergest Xheblati appeared first on .

June 24, 2024Episode 13045 min

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

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 software or Microsoft Office and get their entire organization to use the software. Since these tools are the default IT “blessed” tools, people start […] The post Dear Analyst #130: What happens when we rely too much on Excel spreadsheets and shadow IT takes over? appeared first on .

June 18, 2024Episode 12131 min

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

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 people, a centralized data team simply cannot handle the number of requests and doesn’t have the domain knowledge of all the departments. […] The post Dear Analyst #129: How to scale self-serve analytics tools to thousands of users at Datadog with Jean-Mathieu Saponaro appeared first on .

May 28, 2024Episode 115

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

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 tools at scale within a large enterprise. It’s a term that covers the population of people who are not […] The post Dear Analyst #128: What is citizen development and how to build solutions with spreadsheets? appeared first on .

May 13, 2024Episode 12736 min

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

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 opportunity to meet with a few people who are just as interested in spreadsheets as I am. We talked specifically […] The post Dear Analyst #127: Spreadsheets vs. Jira: Which one is better for your team? appeared first on .

April 15, 2024Episode 12544 min

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

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 multiple guests on the podcast, the path to a career in data analytics is windy and unexpected. It was the intersection of public […] The post Dear Analyst #126: How to data storytelling and create amazing data visualizations with Amanda Makulec appeared first on .

March 25, 2024Episode 12537 min

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

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 are the most underrated? Isn’t this a question for your heart to answer? Andrew Firriolo sought to answer this question over the last few months […] The post Dear Analyst #125: How to identify Taylor Swift’s most underrated songs using data with Andrew Firriolo appeared first on .

Is this your show?

Claim this listing to keep it up to date, reach guests who want to pitch you, and manage bookings with Guestify.

Claim this listing

More Technology podcasts

Modern Cyber with Jeremy Snyder

Jeremy Snyder

TechnologyBusiness

AI Pulse - Daily AI News Podcast

Richey Malhotra

Technology

Drive Electric Alabama

TechnologyInterviews guests

Builders by Proxify

Proxify