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.LinksRob on LinkedIn -https://www.linkedin.com/in/robcollie/Fair Game: Customizing AI to Your Business Is Easier Than You Think -https://link.amazon/B0bgySLKyGet a free Audiobook on Us -https://www.audible.com/ep/creator?afsrc=1&source_code=PDTGBPD060314004R Time Stamps00:00 Interview with Rob Collie06:38 Managing Excel's core development team08:28 Learning Excel's Complexity12:15 Discovering Power BI at Microsoft15:12 Understanding and using SSAS MDX formula20:23 Making Power BI user-friendly23:29 AI exceeding expectations for crafters26:21 Founding and evolving P3 company28:05 AI model advancements and business impact32:34 LLM memory limitations35:11 Integrating AI into consulting business40:21 Challenges with training AI chatbots41:24 Understanding AI without going deep46:56 AI improves business intelligence48:34 AI enhancing business intelligence51:53 Why LLMs succeed where CPUs fail54:29 Core skills in tech evolution