<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Power Query for Business

Explore the potential of Power Query with our hands-on course. Starting from basics to crafting M queries, learn how Power Query simplifies seemingly complex data extraction and manipulation tasks.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

The Power Query course is designed to help you understand how Power Query can be used for self-service data extraction and manipulation. This is a hands on class that will start with the basics of Power Query, but take you all the way through what is possible when you write your own M queries from scratch. The goal is to show you how Power Query can be used to solve what would seem to be complicated data problems in the easiest possible way. You will also learn how queries you design can be shared with others in your organization.

Course Outline ( Free Preview)

Power Query for Business - What you need to get started

Module 01 - Class Introduction

Module 02 - Introduction to Power Query

Module 03 - Importing Data with Power Query 23 min.

Module 04A - Using Power Query to Transform Data (Appending Queries) 6 min.

Module 04B - Using Power Query to Transform Data (Merging Queries) 24 min.

Module 04C - Using Power Query to Transform Data (From Folder) 6 min.

Module 05A - M Query Basics (Overview) 34 min.

Module 05B - M Query Basics (Creating a Date Table) 22 min.

Module 06 - Parameterizing M Queries 26 min.

Module 07 - Advanced Query Functionality 14 min.

Module 08 - Dataflows 11 min.

This course includes:

  • 3+ hours of training
  • 12 Modules
  • * Access on mobile and browser
  • Certificate of Completion