K2's Introduction to Power Query - On Demand (2 hours)

K2's Introduction to Power Query - On Demand (2 hours)

  • $89.00

Course Description

Power Query is an Excel data extraction and transformation tool integrated in all versions of Excel 2016 and newer, and is available also as a free add-in for those using Excel 2013. Power Query allows users to combine data from multiple, disparate data sources, such as relational databases, OData feeds, web pages, Azure, SharePoint lists, Hadoop HDFS, and Excel, text, and XML files, etc. The Query Editor allows users to transform and cleanup data with the "M" query language using an intuitive query-by-example interface. The code created by the Editor can be fine tuned or modified to meet any need. Queries and data transformations can be saved, shared, and reused across an enterprise. Don't miss this opportunity to explore the power and time-saving functionality of Power Query.

Major Topics

  • Connecting to external data sources
  • Using the Query Editor to transform and cleanup data
  • Modifying and fine tuning query code
  • Saving queries for reuse by others in an organization

Learning Objectives

Upon completing this course, you should be able to:

  • Identify five common data sources that can accessed by Power Query
  • Describe the process of extracting data from an external data source
  • Use the Query Editor to transform and cleanup data
  • List three data transformations that can be accomplished with the Query Editor
  • Explain the process of saving queries for future use

Who Should Attend: Accountants and finance professionals who want to use Power Query to access, import, and transform external data for analysis and reporting

Course Level: Intermediate

CPE Credits: 2 Hours Information Technology  

Prerequisites: Good working knowledge of Excel

Advance Preparation: None

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.