Course Overview

Power Query Fundamentals

Course Content

Expand All

Welcome to Power Query Fundamentals 1 Lesson

Expand

Module Content

0% Complete 0/1 Steps

Getting Started

Introduction 5 Lessons | 1 Quiz

Expand

Module Content

0% Complete 0/5 Steps

What is Power Query?

Versions of Power Query

Power Query UI Walk Through

When to Use Power Query

Our Suggested Learning Path

Module Quiz – Introduction

Importing Basic Data 4 Lessons | 1 Quiz

Expand

Module Content

0% Complete 0/4 Steps

Connecting to Delimited Flat Files

Connecting to Data in Excel Workbooks

Connecting to Data in the Current Excel Workbook

Connecting to Non-Delimited Flat Files

Module Quiz – Importing Basic Data

Query Settings 6 Lessons | 1 Quiz

Expand

Module Content

0% Complete 0/6 Steps

The Get Data User Experience

Data Profiling and Data Quality

Configuring Query Load Destinations

Query Error Auditing

The Importance of Defining Data Types

Module Quiz – Query Settings