Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.

Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In this episode, Paul Barnhurst delves into the intricate world of data integration, especially within financial modeling and FP&A. The discussion revolves around the practical challenges and solutions for accessing and automating data flows, a topic crucial for finance professionals who often grapple with multiple data sources and complex modeling tasks. The episode offers insights into the evolving landscape of data management tools and how they can streamline processes for businesses.

Adam Rakich, a seasoned expert in the world of FP&A tools and data integration, joins the show. With a diverse background spanning social media marketing software, FP&A consultancy, and leadership roles at companies like Workday and OneStream, Adam now focuses on making data integration more accessible through his work at Data Blend. His deep understanding of the challenges accountants and financial modelers face with data management makes him a valuable resource for listeners looking to optimize their processes.

Key takeaways from this week's episode include:

• The common pitfalls and solutions in financial modeling and data integration.
• When and why businesses should transition from spreadsheets to specialized planning tools.
• Practical strategies for automating data workflows, even when dealing with outdated or diverse systems.
• The importance of understanding APIs, SQL, and other technical aspects of data integration.
• How to build a business case for investing in data integration solutions.

Follow Adam:

• LinkedIn - https://www.linkedin.com/in/rakich/
• Click the link below to claim your free book (For a limited time only): The Business User’s Guide to Data Integration
• https://www.amazon.com/Business-Users-Guide-Data-Integration-ebook/dp/B0CMBMDCJ2/
• https://www.amazon.co.uk/dp/B0CMBMDCJ2/

Follow Paul: 

• Website - https://www.thefpandaguy.com   
• LinkedIn - https://www.linkedin.com/in/thefpandaguy  
• YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner  

• LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  
• Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. 

In today’s episode:

[01:30] - Introduction and worst financial model experiences

[07:18] - Adam shares his career path from economist to data integration expert

[09:38] - Transitioning from spreadsheets to planning tools

[16:56] - The challenges of data integration

[26:01] - Hybrid approaches to data automation

[28:55] - Tools and strategies for freelancers and small businesses

[37:46] - Adam talks about his book and the key takeaways for readers.

[44:32] - Rapid fire questions on financial modeling tools and techniques.

[52:47] - Final thoughts and contact information