Course Outline

What Is Power Query?

Why Power Query Over Traditional Methods?

Power Query Experiences

Extract the Data in Power BI

Extract the Data in Excel

Environment

Data From Web

Combine From Folder

Close & Load

New Query Section

Data Source Settings

Automation in Power Query in Power BI

Automation in Power Query in Excel

Query Section

Manage Columns

Reduce Rows

Split Column

Group By

Data Types

Fixing Header

Find & Replace

Combine Files

Merge Queries – Single Column

Merge Queries – Multiple Columns

Append Queries

Transpose & Reverse Rows

Fill Up & Down

Pivot Unpivot

Move Columns

Format Cell Values Using Various Functions

Extract the Data

Parse the Data

Number Columns Transformations

Date & Time Columns Transformations

Column From Examples

Custom Column

Conditional Column

Index Column & Duplicate Column

Quick Go Through

Duplicate & Reference Queries

Intro Exercise

Expense_Actual vs Allowance