#300: Are Semantic Layers Really Necessary?
About this episode
Jacob Matson discusses the limitations of semantic layers in data analysis and the importance of nuanced business questions.
If you've ever poured months into building a semantic layer only to watch it become shelfware the moment the business pivoted, Jacob Matson has some thoughts. And a metaphor. Your data is a jungle—and a semantic layer is a highway. Great if you need to get somewhere fast and reliably (monthly active users: highway, please). But the interesting business questions? The slicing, the dicing, the nuanced dimensions that actually differentiate your company from its competitors? There's no highway for that. There never will be. Jacob, a developer advocate at MotherDuck with deep roots in accounting and ERP systems, joined Michael, Moe, and Julie to talk through what comes after the semantic layer—or at least alongside it. The conversation covered why the most important parts of any business are precisely the parts that resist being modeled in someone else's framework, why AI is actually pretty good at writing SQL but not so great at remembering what it figured out yesterday, and whether the real job to be done here is less about modeling and more about search. Oh, and the uncomfortable truth that at episode 300, we still don't have a great answer for metric drift. But we've got some…
Sponsors
Stape, Prism from Ask-Y
More episodes of The Analytics Power Hour
- #302: It Was a Dark and Stormy Insight...
- #301: It Turns Out Analysts Are Natural AI Crafters
- #299: AI Can (Help) Build the Dashboard. It Can't Build the Buy-In.
- #298: Listener Questions Answered Live from Marketing Analytics Summit!
- #297: Durable Wisdom in an Age of AI Slop
Explore listener stats, chart rankings, contacts and more on the The Analytics Power Hour podcast page.