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.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

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.

This course includes:

4+ hours hours of training
Access on mobile and browser
Certificate of Completion

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.

This course includes:

4+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Power Query for Business - What you need to get started

Module 01 - Class Introduction 15 min.

Module 02 - Introduction to Power Query 25 min.

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:

4+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Industry Expert

Learn More

This course includes:

4+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

Please download the following file, which includes all material covered during class and labs that you can work on after class. These labs backup the concepts discussed during the workshop. Unzip these files to your root directory in a Power Query folder. (Ex: C:\Power Query) [Click to download](https://pragmaticworksonline.sharepoint.com/:u:/s/FileShare/EQOvaJ5h5rBHqJXfD7hpSDoBP8Z_2AGt6lAYB4-Z67HAtA?e=9zWctq&Download=1) **VERY IMPORTANT** You may have either Excel 2010 or Excel 2013 installed for this class but all in class examples will be done using Excel 2013. We strongly recommend downloading the 64 bit version of Office if possible. In addition to Excel please also download and install the following free Microsoft Excel Add-in: - [Power Query Add-In](http://tinyurl.com/PowerQuerySept2014)

This course includes:

4+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

4+ hours hours of training
Access on mobile and browser
Certificate of Completion