Introduction to Data Analytics with Excel Power Query
Excel workbooks will be made available for all participants to use at their leisure and further explore the topics discussed.
In the accounting profession, dealing with data is life. Doing it efficiently and effectively are skill differentiators. Power Query, part of Microsoft Power BI suite, is an indispensable for extracting, transforming and loading data (the “ETL” of the commonly referred to ETLR). In this session, we will explore the basics of the Power Query add-in - extracting, transforming and preparing data for analysis.
|1. Introduction to Data Analytics with Excel Power Query||-|
Field of Study: Information Technology
Recommended CPE Credit Hours: 1.0
Course Level: Advanced
Prerequisites: Comfortable with Excel navigation and data related topics – LOOKUP, Pivot Tables, Data Tables, etc. would be helpful, but not required.
Advanced Preparation: None
Designed For: Any business professional responsible for managing and working with data.
Course Producer: Business Learning Institute
Instructor Biography: Donald R. Tomoff, CPA, MBA
Publication Year: 2018
Expiration Date: Course content is reviewed annually and revised with necessary changes or else the course is removed.