NEED HELP? TALK TO AN EXPERT (904) 638-5743

Power Query for Business

WHAT YOU'LL 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
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course 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.

 

Click here for a downloadable PDF

 

Outline

 

Module 01 | Class Introduction
20m 50s total

 

Module 01A | Class Introduction
20m 50s

 

Module 02 | Introduction to Power Query
15m 02s total

 

Module 02A | Introduction to Power Query
15m 02s

 

Module 03 | Importing Data with Power Query
11m 19s total

 

Module 03A | Importing Data with Power Query
11m 19s

 

Module 04 | Using Power Query to Transform Data
22m 43s total

 

Module 04A | Using Power Query to Transform Data
22m 43s

 

Module 05 | Combining Data with Power Query
40m 20s total

 

Module 05A | Combining Data with Power Query
40m 20s

 

Module 06 | M Query Basics
63m 39s total

 

Module 06A | M Query Basics
63m 39s

 

Module 07 | Parameterizing M Queries
46m 31s total

 

Module 07A | Parameterizing M Queries
46m 31s

 

Module 08 | Sharing Queries with Power BI
09m 52s total

 

Module 8A | Sharing Queries with Power BI
09m 52s

Instructor

DEVIN KNIGHT

President

Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works Training. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, Florida Devin is a contributing member to several local user groups.

 

System Requirements

What to Know Before 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.

REVIEWS

Great Class. Job well done.

Adnan C.

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required