logo
episode-header-image
Oct 14
1h 7m

#282: Using (and Creating!) Data to Unde...

Michael Helbling, Moe Kiss, Tim Wilson, Val Kroll, and Julie Hoyer
About this episode

Data does not just magically spring into existence. Someone, somewhere, has to decide what data gets created and the rules for its creation. We would claim that this often starts as a pretty simple exercise, and then, over time, that simplicity balloons to be pretty complex! What if, for instance, you decided to listen to every #1 song on the Billboard Hot 100 going back to its inception in 1958? You may start by just capturing the song name, the artist, and the week(s) it was the #1 song. But, before you know it, you may find that you’re adding in artist details…and songwriter details…and producer details…and genre details…and instrumentation details, and your dataset has 105 columns! But, oh, the questions that dataset could answer! And that’s exactly the dataset that our guest for this episode, Chris Dalla Riva, created. He uses it (with a range of supplemental datasets) for his pieces in his Substack, Can’t Get Much Higher, as well as the underlying raw material for his upcoming book, Uncharted Territory: What Numbers Tell Us about the Biggest Hit Songs and Ourselves. While the underlying material was music, the parallels to more staid business data were many when it comes to the underlying processes and challenges for doing that work!

This episode's Measurement Bite from show sponsor Recast is an explanation of the miracle of randomization when it comes to addressing unobserved confounders from Michael Kaminsky!

For complete show notes, including links to items mentioned in this episode and a transcript of the show, visit the show page.

Up next
Yesterday
#283: Good Things (Can) Come in Small Datasets with Joe Domaleski
Does size matter? When it comes to datasets, the conventional wisdom seems to be a resounding, "Yes!" But what about small datasets? Small- and mid-sized businesses and nonprofits, especially, often have limited web traffic, small email lists, CRM systems that can comfortably ope ... Show More
1h 12m
Sep 30
#281: Analytics: The View from the Corner Office with Anna Lee
From spreadsheets to strategy: what does data look like from the CEO’s chair? For this episode, we sat down with Anna Lee, CEO of Flybuys and former CFO/COO of THE ICONIC, to get her view on data-led leadership and what great looks like in data and analytics. Discover how Anna's ... Show More
1h 6m
Sep 16
#280: Dashboards Must Die! Long Live Dashboards! with Andy Cotgreave
If you didn’t have a visceral reaction to the title for this episode, then you are almost certainly not in our target audience. There are few more certain ways to get a room full of analytics folk fired up than to raise the topic of dashboards. Are they where data goes to die, or ... Show More
1h 6m
Recommended Episodes
Jun 2022
The Critical Role of Business Analysis in Becoming a Data-Driven Organization Research Recap
In this bonus episode, Scott and Susan talk with Dr. David Marco, President of EW Solutions and global authority in data governance.  We answer more questions from the Achieving More With Data: The Critical Role of Business Analysis in Becoming a Data-Driven Organization webinar ... Show More
52m 18s
Jul 8
Talking Heads – Artificial Intelligence - Everything, Everywhere, All at once
This year’s disruptive jolt from developer DeepSeek showed that the cost of training and using AI models can be trimmed significantly. Listen to our podcast with Portfolio Manager Derek Glynn as he tells Chief Market Strategist Daniel Morris that use cases are set to expand far b ... Show More
12m 8s
Oct 3
How to AI-Proof Your Career, Spot Market Hype, and Raise Critical Thinkers — ft. Greg Shove
In this special episode of Office Hours, Scott brings on Greg Shove, CEO of Section, to tackle your biggest AI questions. They break down whether markets are running on AI hype, how professionals can prove their AI chops, and how parents can raise critical thinkers in the age of ... Show More
25m 9s
Jun 2025
It's not just Big Tech: How AI is disrupting every industry
AI is the future and investors need to prepare accordingly. In this episode of Stocks in Translation, TECHnalysis Research president Bob O’Donnell joins Markets and Data Editor Jared Blikre and Yahoo Finance Senior Reporter Allie Canal to discuss the impact of AI on technology, t ... Show More
24m 45s
Jul 14
797: Building Hypotheses From Data Exhibits (Case Interview & Management Consulting classics)
Reading graphs is a perennial problem for many candidates. Yet, the problem is not the interpretation of the graphical data itself. Rather, it is knowing what to do with that data once you have interpreted it. This podcast introduces a simple 4-step process we introduced for a Ya ... Show More
13m 11s
Sep 2024
AI is more than GenAI
GenAI is often what people think of when someone mentions AI. However, AI is much more. In this episode, Daniel breaks down a history of developments in data science, machine learning, AI, and GenAI in this episode to give listeners a better mental model. Don’t miss this one if y ... Show More
40m 3s
Jan 2025
Understanding AGI Alignment Challenges and Solutions - with Eliezer Yudkowsky of the Machine Intelligence Research Institute
Today’s episode is a special addition to our AI Futures series, featuring a special sneak peek at an upcoming episode of our Trajectory podcast with guest Eliezer Yudkowsky, AI researcher, founder, and research fellow at the Machine Intelligence Research Institute. Eliezer joins ... Show More
43m 3s
Aug 2022
Is Gap Analysis Useful?
It's the age-old #businessanalysis question: Do I need to do a gap analysis for this project? Any time we make a change, we need to assess the current state, identify the future state, and analyze where there are gaps between those 2 states. In this episode, Scott and Susan defin ... Show More
41m 5s
Jun 2022
How to Become a Business Analysis Professional
Scott and Susan receive a lot of questions from listeners interested in getting into the business analysis profession. In this episode, we cover everything from transferrable skills to business analysis certifications to how you can learn and develop through IIBA Chapters. As alw ... Show More
33m 52s