Power Up Power Query - Skillwave Training

Course Overview

Power Up Power Query

Course Content

Expand All

Unwinding Data 7 Lessons

Expand

Module Content

0% Complete 0/7 Steps

Pivoting Stacked Data

Pivoting Stacked Data Revisited

Unpivoting Subcategorized Data

Pivoting Vertical Pairs

Pivoting Horizontal Pairs

Numbering Grouped Rows

A Hacker’s Approach to Numbering Grouped Rows

Custom Functions 3 Lessons

Expand

Module Content

0% Complete 0/3 Steps

Manual Creation of Custom Functions

Debugging Custom Functions

UI Assisted Parameters and Functions

Advanced Cleaning 5 Lessons

Expand

Module Content

0% Complete 0/5 Steps

Advanced Table Append

Managing Changes to Columns

List of Values to Filter Columns

Convert UTC to Local DateTimes

Switching Time Zones

Optimization 3 Lessons

Expand

Module Content

0% Complete 0/3 Steps

Optimizing Power Query Settings

Leveraging Buffer Functions

Reducing Development Lag