GrowCFO Show

GrowCFO Show


#234 Power BI, Python & Copilot: What Finance Teams Need to Know with Dan Stockdale, GrowCFO Facilitator

May 20, 2025
#234 Power BI, Python & Copilot: What Finance Teams Need to Know with Dan Stockdale https://open.spotify.com/episode/4gs9QiDVheQ0U2ZnGm4QBU

In this insightful episode, host Kevin Appleby welcomes back Dan Stockdale, a GrowCFO facilitator and financial modeling specialist. Dan shares his journey from management accountant to financial modeling expert across diverse industries including media, advertising, defense, and retail. Currently working as a contractor for London Business School and creating online courses for finance professionals, Dan offers valuable insights on automation tools that are transforming finance departments.

The conversation explores how Power BI, Power Query, Power Pivot, Python, and Microsoft Copilot are revolutionizing financial analysis and reporting. Dan emphasizes that while learning these tools initially requires investment, the practical implementation in day-to-day finance operations delivers significant time savings and value creation. He highlights that as organizations collect increasingly larger volumes of data from diverse sources, finance professionals who can leverage these automation tools become indispensable to their businesses.

Key topics covered:
  • Dan explains how Power BI enables finance teams to automate month-end reporting and create dynamic visualizations that tell compelling financial stories
  • The conversation covers the growing importance of Python in Excel for predictive analytics and how it’s becoming more accessible to finance professionals
  • Dan discusses how Microsoft Copilot is changing financial modeling, though he cautions about the need for human oversight when using AI-generated code
  • The discussion explores how automation tools free finance professionals from routine tasks, allowing them to focus on delivering insights and strategic value
  • Dan shares his plans to continuously update his courses as Microsoft releases new AI and automation features, ensuring finance professionals stay current with technological advancements
https://www.youtube.com/watch?v=ote8IemqGfs Links Timestamps Find out more about GrowCFO

If you enjoyed this podcast, you can subscribe to the GrowCFO Show with your favorite podcast app. The GrowCFO show is listed in the Apple podcast directory, Spotify and many others. Why not subscribe there today? That way, you never miss an episode.

GrowCFO is a great place to extend your professional network. Join GrowCFO as a free member today and participate in our regular networking events and webinars. Premium members can also access our extensive training center and CFO Digital Toolkit. You can enroll in our flagship Future CFO or Finance Leader programs here.

You can find out more and join today at growcfo.net