Power Query for Business

£195.00

What Will You Learn?

  • How Power Query can be used to solve seemingly complicated data problems in the easiest possible way
  • How queries you design can be shared with others in your organization

Category:

DESCRIPTION

The Power Query for Business course is designed to help you understand how Power Query can be used for self-service data extraction and manipulation. This hands-on session starts with the basics of Power Query and takes you all the way through the possibilities when you write M queries from scratch.

INSTRUCTOR

DEVIN KNIGHT

Director of Training
Devin Knight is our Training Lead overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books: “Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services”, “Knight’s Microsoft Business Intelligence 24-Hour Trainer” and “SharePoint 2010 Business Intelligence 24-Hour Trainer”. He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server User Group in Jacksonville, Florida (JSSUG).

 

WHAT TO KNOW BEFORE THE CLASS

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.


Duration: 3:50:17
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.
Power Query - What you need to get started
Module 01 - Class Introduction
20:50
Module 02 - Introduction to Power Query
15:02
Module 03 - Importing Data with Power Query
11:19
Module 04 - Using Power Query to Transform Data
22:43
Module 05 - Combining Data with Power Query
40:21
Module 06 - M Query Basics
01:03:39
Module 07 - Parameterizing M Queries
46:31
Module 08 - Sharing Queries with Power BI
09:52
Class Survey

SYSTEM REQUIREMENTS