The Value of Excel, Utilizing Generative AI, and Personal Hobbies

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst.

In today’s episode, Paul engages in an insightful roundtable discussion with Michael Dion on how FP&A goes beyond numbers and reports, focusing on collaboration and leveraging cutting-edge technology like generative AI to drive business success.

Michael, a seasoned finance professional and senior manager at a Fortune 100 company, is passionate about storytelling and presentations, transforming traditional financial reviews into engaging, story-based approaches. As a finance leader with extensive experience in media and entertainment, his innovative use of generative AI and dedication to continuous learning set him apart as a visionary in the FP&A field.

Key takeaways from this week's episode include:

Here is a concise summary of the key points from the discussion:

• Great FP&A emphasizes collaboration across departments, enabling informed decision-making rather than merely generating reports and numbers. This approach fosters a more integrated and strategic business environment.

• Future FP&A professionals need to be technically proficient with tools like Python and generative AI. These technologies are crucial for handling and processing large data sets efficiently, enhancing overall effectiveness.

• Implementing automation and AI can streamline FP&A processes, increasing efficiency and productivity. This allows FP&A professionals to focus on more strategic tasks, driving greater impact within their organizations.

• Moving from traditional, number-heavy presentations to story-based approaches that incorporate insights from various departments can make financial reviews more engaging and actionable, leading to better business outcomes.

• Strong relationships with business partners are essential for FP&A professionals. These relationships enable them to provide valuable support and drive strategic decisions, ultimately benefiting the entire organization.

• Continuous learning and adapting to new technologies are critical for FP&A professionals to stay relevant. Embracing technological advancements ensures they can meet the evolving demands of the industry.

• Proactively providing useful insights and well-prepared reports can make life easier for business partners and managers. This approach fosters better collaboration, enhances strategic decision-making, and supports career growth for FP&A professionals.

Quotes:

Here are a few relevant quotes from the episode 

• "We need to almost be pseudo IT professionals just like how you had to learn and transition into Excel 20 years ago”-Michael Dion

• “AI is going to make us in some ways more technical, not less.”-Michael Dion

• “I'm all about efficiency, and I've been using the generative AI to teach myself Python by learning its functionality by reviewing libraries of code.”-Michael Dion

• “My goal going in was to just engage people and make them, dare I say, excited about finance.” -Michael Dion

This discussion with Michael Dion focuses on the evolving role of financial planning and analysis (FP&A) in modern organizations. Key topics include the importance of collaboration, the integration of advanced technologies, and practical strategies for FP&A professionals to enhance their effectiveness and impact.

Exciting Announcement

I am excited to share my two new digital FP&A Courses with you FP&A Business Partnering, and Modern Excel. They just launched and I am excited to offer a 20% discount to my listeners using code PODCAST.

Link to courses: 

FP&A Business Partnering (thinkific.com)

Modern Microsoft Excel (thinkific.com)

Follow Michael:

LinkedIn - https://www.linkedin.com/in/dionmichaelc/

Website - https://www.f9finance.com/

Follow Paul:

Website - https://www.thefpandaguy.com 

LinkedIn - https://www.linkedin.com/in/thefpandaguy

For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

In today's episode:

[01:20] - Introduction

[02:00] - Guest Introduction

[03:05] - Integrating Consumer Insights

[04:44] - Preparing for Technological Changes

[05:30] - How technology enhances the abilities of FP&A professionals

[11:30] - Media Industry Passion

[15:30] - Amortization of Film Costs

[18:00] - Response to F9 Finance

[24:00] - Transforming Business Reviews

[28:34] - Advice for Story-Based Reporting

[38:00] - Career Advice

[39:00] - Rapid Fire Session

[41:07] - Use of Generative AI

[45:00] - Business Partnership

[46:14] - Contact Information of the Guest

[47:00] - Conclusion