Instructor
Marc Hamilton
Instructor
Marc Hamilton is a strategy-oriented finance executive with proven successes in change management. Mr. Hamilton has over 30 years of extensive practical experiences with data analytics, process design and technology implementation. His roles have provided broad exposure to functional, operational and management challenges facing organizations in the era of systems intelligence.
As a technologist CPA, Mr. Hamilton frequently speaks from his experiences on big data, data science, artificial intelligence and the developing Blockchain infrastructure. He also frequently presents AICPA cybersecurity content.
Mr. Hamilton holds a Masters in Tax Accounting from the University of Alabama and practiced with both Deloitte & KPMG before moving into a business and industry roles including VP of Taxation, Treasurer and Chief Financial Officer. He currently serves as CFO at Three Notch Group, Inc.
The traditional manual cycle of exporting, cleaning, and formatting reports is a significant drain on professional productivity. This session demonstrates how to transform this process by integrating Excel's Power Query with the analytical power of ChatGPT. We will explore the "Extract, Transform, Load" (ETL) lifecycle, showing how to create repeatable, one-click reporting workflows that handle messy data with ease. Participants will learn advanced techniques for using AI to write complex M code and DAX formulas, automate variance analysis narratives, and bridge the gap between disparate data sources. Attendees will leave with a practical framework for building "self-healing" reports that scale with their firm's needs, turning hours of manual labor into seconds of automated processing.
Modernizing data workflows through AI-integrated automation.