Using Power Query, ChatGPT and Excel to Automate Reporting
Overview
*** Save 15% on this event when you use the code SAVE15 at checkout ***
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.
Highlights
Topics of discussion will include:
- Modernizing data workflows through AI-integrated automation.
Prerequisites
None
Designed For
Objectives
Preparation
None
Notice
Leader(s):
Leader Bios
Marc Hamilton, Chief Financial Officer, CDG
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.
Non-Member Price $245.00
Member Price $199.00