Data Driven · September 16 · 54 min

Why Business Knowledge Beats Tool Complexity in the AI Era

Welcome back to Data Driven, the podcast where we dive deep into the evolving worlds of data science, business intelligence, and artificial intelligence. In this episode, host Frank La Vigne sits down with Rob Collie, CEO of P3 Adaptive and a former Microsoft engineer, to explore the remarkable journey from Excel’s foundational role in data-driven workplaces to the transformative power of Power BI—and now, to the unfolding impact of AI in business. Rob shares captivating stories from his time on the Excel and Power BI teams at Microsoft, offering insider perspectives on how these tools revolutionized the way organizations work with data. Together, Frank and Rob discuss the critical role of expert stewardship in products like Excel, the complexity hidden beneath familiar interfaces, and the challenges traditional BI faced before the rise of more accessible, user-centric solutions. The conversation then turns to the cutting edge, unpacking what generative AI and large language models mean for the future of data, and why business intelligence might just be the best starting point for companies aiming to embrace AI. Whether you’re a data engineer, AI enthusiast, or business leader, this episode is packed with insights on how mastering data remains the foundation for all technological progress. Join us as we look backward and forward at what it really means to be data driven. Links Rob on LinkedIn -https://www.linkedin.com/in/robcollie/ Fair Game: Customizing AI to Your Business Is Easier Than You Think -https://link.amazon/B0bgySLKy Get a free Audiobook on Us -https://www.audible.com/ep/creator?afsrc=1&source_code=PDTGBPD060314004R Time Stamps 00:00 Interview with Rob Collie 06:38 Managing Excel's core development team 08:28 Learning Excel's Complexity 12:15 Discovering Power BI at Microsoft 15:12 Understanding and using SSAS MDX formula 20:23 Making Power BI user-friendly 23:29 AI exceeding expectations for crafters 26:21 Founding and evolving P3 company 28:05 AI model advancements and business impact 32:34 LLM memory limitations 35:11 Integrating AI into consulting business 40:21 Challenges with training AI chatbots 41:24 Understanding AI without going deep 46:56 AI improves business intelligence 48:34 AI enhancing business intelligence 51:53 Why LLMs succeed where CPUs fail 54:29 Core skills in tech evolution

0:00-54:42

Play in

Transcript file

transcript

No transcript — this publisher did not publish one.

show notes

Rob shares captivating stories from his time on the Excel and Power BI teams at Microsoft, offering insider perspectives on how these tools revolutionized the way organizations work with data. Together, Frank and Rob discuss the critical role of expert stewardship in products like Excel, the complexity hidden beneath familiar interfaces, and the challenges traditional BI faced before the rise of more accessible, user-centric solutions.

The conversation then turns to the cutting edge, unpacking what generative AI and large language models mean for the future of data, and why business intelligence might just be the best starting point for companies aiming to embrace AI. Whether you’re a data engineer, AI enthusiast, or business leader, this episode is packed with insights on how mastering data remains the foundation for all technological progress. Join us as we look backward and forward at what it really means to be data driven.