Power Query for Business (Online)

The Power Query virtual training is an intensive two day class that 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.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionnaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

All virtual training students are provided a previously recorded version of the class that are available for 7 days after the end of the class.

Outline

Day 1

1. Class Introduction

  • Self-Service BI Lifecycle
  • Understanding How Power Query Fits into Power BI

2. Introduction to Power Query

  • Power Query Overview
  • Why use Power Query?
  • Who Should Use Power Query?

3. Importing Data with Power Query

  • Importing Data from External Data Sources
  • Managing Data Refreshes

4. Using Power Query to Transform Data

  • Sorting and Filtering Data
  • Organizing Data for Reporting
  • Applying Transforms in the User Interface

5. Combining Data with Power Query

  • Merging Queries Together
  • Drill Down into a Related Table
  • Appending Query Results

Day 2

6. M Query Basics

  • Introduction to M
  • Understanding Query Folding
  • Commonly Used Functions
  • Creating a Date Table

7. Parameterizing M Queries

  • Creating Power Query Functions
  • Creating a Parameter User Interface

8. Sharing Queries with Power BI

  • Saving Queries to the Data Catalog
  • Consuming Shared Queries

Prerequisites

This class teaches you Power Query from the ground up so does not require any prior knowledge of the tool. It is not mandatory but students may benefit from having a basic understanding of Excel Formulas and Pivot Tables.

SystemRequirements

·¬†Excel 2010 or 2013

· Power Query Add-In (http://tinyurl.com/PowerQuerySept2014)

· Power BI Designer (https://powerbi.microsoft.com/downloads)

Some of our clients