Power Query and M Introduction

£395.00£9,750.00

Power Query is a robust data connection and transformation tool which is built into Power BI and which allows you to connect to data from a wide variety of sources and then transform that data into exactly the right shape and format for your reporting needs. In this one-day Introduction to Power Query and M, delegates will learn to use the Power Query interface to perform a wide variety of useful transformations on data, making it ready for use in the data model.

Clear
SKU: GCOM-PQMPU-101 Category:

Description

Power Query is a robust data connection and transformation tool which is built into Power BI and which allows you to connect to data from a wide variety of sources and then transform that data into exactly the right shape and format for your reporting needs. In this one-day Introduction to Power Query and M, delegates will learn to use the Power Query interface to perform a wide variety of useful transformations on data, making it ready for use in the data model.

Course Outline

Power Query Essentials

Power Query Overview
Transforming and Loading Data
Queries vs Tables
Working with Applied Steps
Adding Metadata to Steps

Data Sources

Connecting to Files
Connecting to Folders
Connecting to Web Data
Connecting to Databases
Modifying Data Sources
Data Source Credentials
Using PBIDS Files

Manipulating Columns

Navigating Columns
Selecting and Removing Columns
Column Data Types
Data Type Conversion
Splitting Columns
Combining Columns
Extracting Characters

Manipulating Rows

Filtering Text Columns
Filtering Numeric Columns
Filtering Date Columns
Removing Rows
Removing Duplicates
Removing Errors
Replacing Values and Errors
Using Fill Down

Reshaping Data

Transpose
Unpivot Columns
Pivot
Split by Rows

Combine queries

Append Queries
Merge Queries
Join Kind
Left Outer
Inner
Left Anti
Right Outer
Full Outer
Fuzzy Matching

Additional information

Date

3 Mar 2022(Tutor-led, Online), 9 May 2022(Tutor-led, Online), 11 Jul 2022(Tutor-led, Online), 26 Sep 2022(Tutor-led, Online), 21 Nov 2022(Tutor-led, Online), Private Training for up to 10 Users, Private Training for up to 20 Users, Private Training for up to 30 Users, Private Training for up to 40 Users, Private Training for up to 50 Users, Private Training for up to 60 Users, Private Training for up to 70 Users, Private Training for up to 80 Users, Private Training for up to 90 Users, Private Training for up to 100 Users