[[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner

This FULL course in Power Query, In this video will cover how to write Power query in power bi development. We go through Creating a data transformations, handling data, query folding , data preview and many more concepts.
#PowerBI #PowerBIDesktop #PowerBITutorials

▬▬▬▬▬▬▬▬ Power BI - POWER QUERY- Tutorials - FULL COURSE ▬▬▬▬▬▬▬▬
1) 03:44 - Introduction
Power Query VS Power Pivot VS Power View
2) 12:37 - Excel Transformation
Remove Headers, Rows
Fill gaps, Unpivot
Data Types
3) 25:02 - Common Transformation
Split, derive a Column , remove Column
4) 37:32 - SQL Equivalent Transformation
Append Union / Union All
Merge Left/ Right/ Inner Join
Group By
5) 59:12 - Business Scenarios
Sort by month, Derive Age, Stored in Enter data,
Reading Multiple Excels, Split the delimited value into rows,
6) 01:41:58 - Data Preview Options
7) 01:49:04 - Handling nulls or blanks
8) 01:57:53 - Query Folding in Power BI
9) 02:09:17 - Power Query Tips & Tricks
Column From Examples
Reference vs Duplicate in Power Query
Query Dependency
Change Connection source / Source Type


Source Files:
1) Excel Transformation :
https://docs.google.com/spreadsheets/...

2) Append:

https://drive.google.com/file/d/1nCsH...
https://drive.google.com/file/d/1ZCA5...

3) Merge
https://drive.google.com/file/d/1fu1w...

4) Excel Automation / Reading Multiple Excel Files
https://drive.google.com/file/d/1wvFR...
https://drive.google.com/file/d/1qPMF...
https://drive.google.com/file/d/1qPMF...
https://drive.google.com/file/d/1qPMF...
https://drive.google.com/file/d/1qPMF...
https://drive.google.com/file/d/1qPMF...


✉ Business Queries / Analytics Consulting ✉ : [email protected]

💬 For Learners Post queries and Interact 💬
Telegram Channel - http://t.me/analyticswithnags
Linkedin Page -   / analyticswithnags  



Complete Playlists

Power BI Tutorials - Complete Playlist 📚📖    • How to do Power BI Installation - Pow...  
Power BI Desktop Tips and Tricks 📚📖    • How to Remove Top N rows in Power BI ...  
Power BI DAX - Complete Playlist 📚📖    • What is DAX in Power BI DAX Tutorial ...  
Power BI Services Playlist 📚📖    • Introduction to Power BI Service (1/30)  
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖    • Loan disbursement Analysis in Power B...  

Data Warehouse Tutorials 📚📖    • Introduction | Data Warehouse Tutoria...  
SQL Full Course | SQL Tutorial For Beginners 📚📖    • Learn SQL Complete | Course Introduct...  
SSAS Tutorials - SQL Server Analysis Services 📚📖    • Introduction to SQL Server Analysis S...  
SSIS Tutorials - SQL Server Integration Services 📚📖    • Introduction to SQL Server Integratio...  

Power BI Interview Topics 📚📖    • What to Expect in Power BI Interview ...  
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖    • What to Expect in MSBI (SSIS,SSAS,SSR...  

Excel for Data Analysis 📚📖    • Analytics with Nags YouTube Channel O...  
Power BI + R 📚📖    • Analytics with Nags YouTube Channel O...  
Azure for Analytics - Complete Tutorials 📚📖    • Analytics with Nags YouTube Channel O...  

Catch with Nags 📚📖    • Catch Up With Nags - Intro - Week 19 ...  
Nags Checklist 📚📖    • 5 Things to Consider when starting Po...  
Visuals with Nags 📚📖    • Visuals With Nags - Intro