When to Use Power Query

Preview

Overview

This lesson covers 5 different use cases (scenarios) where it is useful to use Power Query.  These are by no means the only use cases, but however, they will give you a good sense of the breadth of the power of this tool.

Key Content

Topic Time Stamp
Introduction 00:00
Power BI Desktop 00:25
Shape your Data 02:15
Cleanse your Data 10:54
Eliminate Repetitive Processes 13:13
Auditing Information 15:46

Course Material

The sample files can be downloaded from the link below.  You can use the sample files to practice the skills covered in the lesson.

When to Use Power Query Lesson Files

Back to: Power Query for Excel and Power BI > Introduction to Power Query