Dear Analyst

Dear Analyst


Latest Episodes

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)
December 02, 2024

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
September 10, 2024

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 wa

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

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 yo

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

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

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

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 peopl

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 t

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

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

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

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 mul

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

We sometimes forget that a large organization is composed of groups and divisions. Within these groups, there are teams and individuals looking to advance their careers. Sometimes at the expense of ot

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

When you think of data journalism, you might think of The New York Times' nifty data visualizations and the Times' embrace of data literacy for all their journalists. Outside of The New York Times, I