Introduction to Data Analytics and Power Query
Overview:
Dealing with data is an inevitable part of the role of a CPA and doing it efficiently and effectively can differentiate you from others in the field. Power Query, a data connectivity and data preparation technology, enables users to seamlessly access data stored in hundreds of data sources and manipulate it to fit their requirements.
This presentation focuses on data analytics with Power Query. Here we explore the basics of Power query and learn how to extract, transform and prepare data for analysis.
Objectives:
Topics of discussion will include:- Develop an in-depth understanding of Power Query as a BI tool
- Identify the potential benefits of applying Power Query to your workflow
- Discover and experiment with importing and transforming basic data into Excel using Power Query
- Apply data load capabilities of loading into Excel vs. Loading into a “data model”
Instructors:
Designed For:
CPAs or accounting professionals
Prerequisite:
Some familiarity with accounting
Additional Info:
Thank you for registering for the "Introduction to Data Analytics and Power Query" OnDemand course. You can begin immediately by going to the 24/7 Learning Library portal at https://ficpa.courselaunch.io and logging in with your current FICPA member login credentials.
Your course or courses should be immediately available after you login.
If you have any issues, please let us know by submitting a ticket through the Support link and we will assist you as quickly as possible.
Event Promotions