Podcast Summary: “Beyond the Numbers: Lance Rubin’s Insights on AI, Power BI, and the Future of Financial Modeling”
In this episode, Paul Barnhurst interviews Lance Rubin, a highly experienced financial modeler.
Lance, who has worked with firms like PwC & KPMG, Investec Bank, and National Australia Bank, shares his insights on leveraging AI and Power BI in financial modeling. The discussion covers his two decades of experience in the field, including his role as CFO of a FinTech startup, Banjo, and his work in automation consultancy.
Lance Rubin also discusses how finance professionals can use AI and Power BI to enhance their financial modeling skills. Drawing from his two decades of experience with firms like PwC and KPMG, he provides insights on leveraging technology and overcoming common challenges.
Lance also highlights his contributions as a certified trainer for the FMI, authoring a study guide on financial modeling, and his judging role at the Financial Modeling Innovation Awards. He also presented at Power BI Global Summit in 2022.

Key concepts and quotes from the episode include:
- The HACK Framework: This is a system for combining technical skills (Hygiene, Automation) with soft skills (Capability, Knowledge).
- The distinction between data modeling and financial modeling: The podcast highlights that while they may sound similar, they are fundamentally different.
- The importance of people: Rubin emphasizes that people are the most crucial component of financial transformation, alongside process and technology.