arrow_back
Power Query Material
Material
Introduction to Power Query
Getting Started With Basics Of Functions
Introduction to Basic Functions in Power Query
Loading Data in Power Query
Learning Basic Text Functions
Trim Text Functions
Split Text in Multiple Columns
Split Text with Delimiter
Adding Prefix & Suffix
Date Functions
Date Functions Weekdays
Calculate Age
Date Functions Start & End of Particular Date
Number Function
Text Functions
Date Functions
Number Functions
Assignment 2
Conditional Column & Column From Examples
Introduction to Conditional Column & Column From Example
Conditional Column on Numbers
Conditional Column on Text
Conditional Column on Dates
Comparing Columns with Conditional Column
Flash Fill with Column From Examples
Column From Examples - Split Text
Column From Examples - Merge Text
Column From Examples - Date
Column From Examples Extract Text
Conditional Column & Column From Examples
Assignment 3
Appending & Combing Files
Introduction to Appending or Combining Files
Combine Tables in One Table
Combine Multiple Table with Functions
Consolidate Multiple CSV Files
Combine Multiple Excel Files From Folder
Combine Multiple Data Sources
Append Queries
Assignment 4
Powerful Cleaning Features In Power Query
Introduction to Cleaning Data in Power Query
Fill Down Unmerged Cells
Promote & Demote Header
Removing Blank Rows
Data Types in Power Query
Dealing with Error Values
Transposing Data Set
Replacing Null Values
Group By in Power Query
Data Cleaning Part1
Data Cleaning Part2
Assignment 5
Replacing VLOOKUP With Merge Queries
Introduction to Replacing VLOOKUP
What is VLOOKUP in Excel
Merge Queries
Merge Two Tables
Merge Two Different Table From Two Different Excel Files
Merge Two Different Data Sources
Merge Queries with Multiple Matching Columns
Find Out Common Records From Two Tables
Merge Queries with No Common Columns
Fuzzy Match in Power Query
Challenge - Find Out Only Working Days
Solutions - Finding Working Days
Replacing VLOOKUP
Assignment 6
Working With Rows & Columns In Power Query
Introduction to Working With Rows & Columns
Remove Blank Records
Remove Duplicates Values
Remove Top or Bottom Rows
Keep Top or Bottom Rows
Remove Columns
Rename, Delete, Duplicate & Move Columns
Working with Rows & Columns
Assignment 7
Working With Filters & Parameters
Introduction to Working With Filters & Parameters
Filtering Textual Data
Filtering Date Data
Filtering Numerical Data
Sorting Data
Creating a Parameter
Connect Parameter With Dataset
Case Study - Filter Data Using Excel Cell Value
Working with Filters & Parameters
Assignment 8
Custom Function Feature To Clean & Combine Files
Introduction to Custom Function to Clean & Combine Files
Clean & Combine Multiple CSV Files
Clean & Combine Multiple Excel Files
Custom Function Features
Assignment 9
Getting Data From Different Sources
Get Data From Google Sheets
Get Data From XML Files
Get Data From MS Access
Get Data From JSON
Get Data From Website
Get Data From PDF, WEB & CSV
Object in Power Query
Introduction of Objects in Power Query
List in Power Query
Records in Power Query
Case Study - Creating Dynamic Calendars in PQ
Case Study - Extract Relevant Information
Case Studies
Introduction to Case Study in Power Query
Clean Bank Statement Available In PDF
Create Fiscal Year Calendar in Power Query
Matching Records in Two Tables
Pick Up The Latest File From The Folder
Technoedge Case Study
Cleaning Bank Financial Data
Changing Stacked Address Table
Split Data In Rows & Columns
Clean Data & Get Discounts
Cleaning Payroll Data
Get File Names From a folder
Data Cleaning-Unpivot Columns Ex-1
Data Cleaning-Unpivot Columns Ex-2
Excel Power Query to Power BI Power Query
Excel Power Query To Power BI Power Query
Power Query Project
Capstone Project
Project Template
Project 1
Project 2
Project 3
Project 4
Project 5