Business Intelligence: Power Query for Excel
in Data Analytics with Microsoft ExcelAbout this course
Comments (0)
Course Introduction
Course Community
Get started
Download the practice file and follow along with the videos.
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
.png){kind=small}
.png){kind=small}
.png)