The Analytic Mind

The Evolution of Power BI: From Excel Whizzes to AI-Powered Analytics with Wyn Hopkins

The Analytic Mind

Show Notes

Join Power BI experts Sam McKay and Wyn Hopkins as they discuss the evolution of Power BI, from its early days to its current AI-powered capabilities, and explore how it has transformed data analytics and reporting.

In this episode, Sam and Win Hopkins, Power BI veterans from Access Analytic, delve into their experiences with Power BI, its growth as a tool, and its impact on organizations' efficiency and productivity. They explore real-life success stories, the power of automation, and the revolutionary potential of AI in data analytics. Don't miss this insightful conversation about the past, present, and future of Power BI.

Wyn Hopkins is the Director at Access Analytic, where he provides amazing Excel and Power BI solutions to leading companies in Perth. With extensive expertise as an Excel MVP, Microsoft Certified Excel Expert, and Power BI Developer, Wyn is a highly sought-after trainer and speaker. He brings years of experience working with Chevron and a deep understanding of business intelligence software to help organizations optimize their analysis, reporting, and process improvement. With a track record of delivering solutions that exceed expectations, Wyn is at the forefront of empowering businesses with modern data analytics tools.

In this episode, you will learn the following:

The transformative impact of AI on productivity and learning, and how it is revolutionizing various fields.

The significance of Power BI as a distribution mechanism for insights and the role of cloud-based tools in data analysis and collaboration.

The transformative impact of AI in simplifying tasks and enabling quick learning of new tools.

Throughout the episode, our guest, Wyn Hopkins, shares insights, experiences, and perspectives on these topics, providing valuable knowledge and perspectives for listeners interested in AI, Power Query, Power BI, Excel, and content creation.

For full show notes, and the links mentioned visit: ⁠⁠⁠https://www.enterprisedna.co/podcast⁠⁠⁠

Be our guest, register here: ⁠⁠⁠https://www.enterprisedna.co/be-our-podcast-guest/⁠⁠⁠

Connect with Wyn Hopkins:

LinkedIn: ⁠⁠https://www.linkedin.com/in/wynhopkins/

Website: ⁠https://www.accessanalytic.com.au/

Website: https://pbi.guide/book

YouTube: https://www.youtube.com/@AccessAnalytic

Podcast: https://www.youtube.com/@PowerQuery

Connect with Sam McKay

Website: ⁠⁠⁠⁠https://www.enterprisedna.co/⁠⁠LinkedIn:⁠⁠ https://www.linkedin.com/in/sammckayenterprisedna/⁠⁠⁠⁠

Loved this episode? Leave us a review and rating here: ⁠⁠https://podcasts.apple.com/us/podcast/the-analytic-mind/id154106699

More from The Analytic Mind

Dec 29, 2025

AI conversations are stuck on agents, but the real shift is happening somewhere else. In this episode, we break down Agentic Software vs Agents and explain why the future isn’t about building hundreds of fragile AI agents, but about creating purpose-built, agentic software systems that actually do work. We explore how AI is evolving into an operating system, why workflow optimization matters more than raw model intelligence, and how layering models intelligently is replacing the obsession with “the best model.” We also discuss the rise of niche, domain-focused AI systems, why stickiness beats benchmarks, and how individuals and small teams can now build software that replaces entire roles, services, and workflows. This conversation is for builders, consultants, operators, and anyone trying to understand where real leverage in AI is emerging, beyond hype, tools, and demos. If you’re thinking about the future of work, software, and AI-enabled businesses, this episode will reframe how you look at all of it.

Dec 24, 2025

We’re entering a new phase of work, creativity, and experiences, and it’s moving much faster than most people realize.In this episode, we explore why experience-based events are selling out globally, how technology is amplifying demand, and what this shift tells us about the future of work. From endurance races to immersive sports broadcasts, data and real-time analytics are changing how experiences are created and shared.The conversation then moves into a deeper transformation: how AI is fundamentally reshaping knowledge work. We discuss why traditional tools like Excel and PowerPoint are rapidly losing relevance, how AI-generated analysis and presentations change productivity economics, and why full-code, AI-driven workflows are becoming the new standard.Finally, we break down what this means for data analysts, developers, and knowledge workers. Jobs aren’t disappearing, but roles are changing fast. The future belongs to those who can frame problems, guide AI systems, and build reusable workflows instead of manual outputs.If you work with data, analytics, or technology, this episode offers a clear look at what’s coming next and how to adapt before the shift becomes unavoidable.

Dec 8, 2025

AI tools are getting faster, cheaper, and more capable, and also more fragile and overloaded. In this conversation, we talk honestly about what it’s like to build and work on top of Gemini, Opus, Claude, Cursor, and custom skills while everything around us accelerates. We cover: Depending on the AI tools that keep timing out or routing unpredictably

Nov 27, 2025

AI hasn’t slowed down. It’s quietly hit another turning point. In this episode, we talk about how Google, OpenAI, and Microsoft are no longer just racing on models. They’re reshaping business models, workflows, and the tools we use every day. Gemini 3 is raising the bar, Microsoft is finally moving like an AI-first company, and OpenAI is facing serious pressure instead of cruising on first-mover advantage. But the real story is what this means for how work gets done: skills instead of brittle tools, agents instead of manual tasks, code generation instead of boilerplate, and voice as a serious interface for real products. If you’re a data professional, developer, or business owner, this conversation is about where the leverage is shifting and how to position yourself for what’s coming next. In this episode, we cover: Why Gemini 3 changes the Google vs OpenAI vs Microsoft dynamic

Nov 19, 2025

Most people still focus on model comparisons, but the real shift is happening in the systems built around them. This conversation breaks down why systems, workflows, and skills now matter more than the model you choose, and how fast “good enough” models paired with the right structure can outperform raw power. We explore the rise of voice-first development, real-time agent workflows, Claude skills, dynamic context loading, and how modular tools are becoming a new kind of micro-software. You’ll also hear why domain expertise is still a major advantage, how content libraries can turn into personalized learning systems, and why small teams are now capable of outbuilding giants by combining smart systems with modern tools. Perfect for data professionals, builders, and business owners looking for real leverage in this new era of work.

See all episodes →