Accessing and Cleaning Data with Power Query and Power BI

Accessing and Cleaning Data with Power Query and Power BI
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.

NOTE: Course login details are normally sent to registrants within one week from date of registration.


While there are a wide range of ways to analyze data, one must first retrieve, scrub, and organize data effectively before any of those techniques can be used.  This session will help users understand and utilize end user data retrieval tools like Microsoft Power Query as well as content packs for Microsoft Power BI to connect, retrieve, reorganize, and create scripts to automatically reformat data of all kinds from a wide variety of sources.  Attend this session and learn to use these powerful tools to solve and automate your data extraction and transformation processes.


  • Learn about Power Query and begin using it to automate your data importing and formatting to make your work more productive
  • See how content packs largely automate the retrieval of information from a wide range of applications
  • Review powerful techniques for rearranging your data quickly in Microsoft Excel

Upon completion of this course, participants should be able to perform the following tasks:

  • Define the major components included in Microsoft Power Query and Power BI Content Packs
  • Explain how Power Query fits into the Microsoft self-service Business Intelligence ecosystem (Power Query, Power Map, Power Pivot, Power View, and Power BI)
  • List the types of data sources which can be accessed using Power Query, Power Pivot, and Power BI Content Packs
  • Describe how Power Query transformations can be used to reformat, combine, and rearrange data retrieved from a wide range of sources
  • Explain how Power BI and the Excel Data Model provide ways to use this data to create effective reports

Fundamental knowledge of computer operations and Microsoft Excel
Program Level: Intermediate 
Advance Preparation: None 

Business professionals who are seeking to query data from external data sources into Excel and Power BI for analytical purposes. This program focuses on Excel for Windows.

CPD: 2 Hours

4/1/2022 - 3/31/2023 11:59 PM