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