This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.


Power Query- Clean and Transform Your Client's Data Logo aicpa

  Free |   AICPA |   02 Jun 2017 |   Specialized Knowledge and Applications |   AICPA Store

CPA's need to develop skills in data analytics as the world continues to see an increase in the use of data to gain insight, develop strategies and assist in decision support.

To prepare for the need to increase the use of data analytics skills the AICPA is updating the Analytical Procedures Guide to include the use of audit data analytics and has established a research initiative with Rutgers Business School focusing on integrating analytics into the audit process.

Learning Objectives

After attending this webcast, attendees will be able to:

  • Utilize the ETL Tool "Power Query" which will extract, transform and load raw data into data that can be used in data analytics
  • Load various sources of data into Power Query
  • Use the main components of the Power Query interface to clean up client data
  • Load data and refresh data
  • Understand queries, types of queries and have a basic understanding of the M Language

Important Information on Your CPE Credit


Free with CPE for IMTA section members and CITP credential holders:

When you log into this website with your AICPA member account, the section discount will be automatically applied during checkout. Section discounts cannot be combined with any other offer. Should you have any questions or encounter any issues, please contact the AICPA Service Center at 888-777-7077 or

Topics covered:
  • Management accounting: Technical: Management reporting & analysis: Financial analysis, Foundational
  • Assurance: Technical: Audit: Data analytics, Foundational
  • IT management & assurance: Technical: Information management: Data management & analytics, Foundational