Business Intelligence: Power Query for Excel

Course Introduction

Course Community

Get started

What is Power Query and what are its applications in Excel.

Phases in Power Query

Why Power Query?

Supported Excel versions for Power Query

Common data sources supported within Power Query.

Import data from table or range

Connecting to data from Excel Workbook

Connecting to Data From CSV or Text file

Connect to Data from Databases: MS Access

Connect to data from Database: SQL Server

Import data from PDF

Import data from web

Importing Data from folder

Introduction to the Power Query editor

Identify column headers

Power Query Data types

Filter columns

Sorting columns

Rearrange columns

Filling missing values

Splitting columns

Split data with delimiter

Remove Rows

Keep rows

Transpose columns

Load destinations

Load destinations Demo

Append queries

Append queries with different column names

Append multiple Excel files

Merging queries

Introduction to Join kinds

Join kinds sample Dataset

Left Outer Join

Right outer join

Full outer

Inner Join

Left Anti Join

Right anti join

Join Kinds demo

Grouping data with GROUP BY

Pivot rows

Pivot rows 2

Unpivot columns

Adding columns Introduction

Adding Condtional columns

Adding Columns from Examples

Adding Columns from numbers

Adding Columns from Dates

Adding custom columns

Custom column: IF Statement

Introduction to data profiling

Data profiling demo

Copying queries

Duplicte vs reference

Introduction to errors in Power Query

Data Source error

Column not found

Cell level errors

Handling errors with If otherwise

Project 1

Project 2

Course conclusion

Do not copy and paste financial results into Excel. Learn how to use Power Query to import and transform the financial statements.