PQB: Power Query Basics From A to Z - Full Course, 5 hours, 17 topics, 25+ Examples

0:00 Intro
-------------------------------------------------------------------------
3:27 PQB01: Introduction "Get & Transform" Automate Data Transformation
To download excel workbook:
-------------------------------------------------------------------------
17:04 PQB02: Extract data from current workbook, and create dynamic unique list
To download excel workbook:
-------------------------------------------------------------------------
29:47 PQB03:Extract from excel workbook & consolidate multiple worksheets in 1 pivot table
Excel file:
Data file:
-------------------------------------------------------------------------
42:28 PQB04:Extract data from a folder contains “CSV files” automatically update new data
Excel file:
CSV files:
-------------------------------------------------------------------------
58:41 PQB05: Extract data from Access Database and load to excel data model
Excel file:
Access database:
-------------------------------------------------------------------------
1:19:35 PQB05.5: Power Query in Power BI. from access database to an interactive dashboard
Access database:
Power BI file:
-------------------------------------------------------------------------
1:46:45 PQB06: Connect to the web with power Query
Excel file:
-------------------------------------------------------------------------
1:58:05 PQB07: Split Column to Rows - Automate & Organize Chaotic Input Data
Excel file:
-------------------------------------------------------------------------
2:12:05 PQB08: Append data from 3 different Tables
Excel file:
-------------------------------------------------------------------------
2:26:07 PQB09: Merge Queries: V-lookup in Power Query
CSV:
Excel:
----------------------------------------------------------------------
2:40:28 PQB10: Merge Queries: Compare between 2 tables
Excel file:
----------------------------------------------------------------------
2:58:00 PQB11: Merge Queries: Left Outer - Solve duplicate issues
Excel file:
---------------------------------------------------------------------
3:10:10 PQB12: Merge Queries: Replace Sum-if
Excel file:
---------------------------------------------------------------------
3:20:01 PQB13: Merge Queries: 2D search using Formulas (V-lookup + Match) & Power Query
Excel file:
---------------------------------------------------------------------
3:40:44 PQB14: Excel.CurrentWorkbook() to extract data & “Group by” to Summarize data
Start file:
End file:
Additional data:
---------------------------------------------------------------------
4:06:20 PQB15: Dynamic Filter with PQ, criteria input from excel & customized refresh button
Working files:
---------------------------------------------------------------------
4:30:49 PQB16: Manage Queries: Duplicate, Reference or Append
Working files:
---------------------------------------------------------------------
To subscribe:

[Vikaskumar-qvuc]

I'm watching this is in 2024. what a series it is. trust this person and finish this series, you all going to learn a lot from this. also practice along with the chapter. thnkyou

[PURVESHPRAJAPATI-tmds]

Today I was able to complete the course.
It is the very well manner teaching of each and every step of Power Query Example.

[arnoldschwartz]

This course is a much appreciated educational experience related to PQ - It's well organized, has clear and understandable language, great back-up resources ... a real gem for learning some more advanced PQ skills.

[sszzVipeRzzss]

You deserve a medal for this .. awesome I could not stop watching for 4hours straight

[klarawijs]

Thank you so much for this amazing and useful course, I am so grateful that you shared this with us. Cheers from Romania! <3

[terrencepasanting]

This is just the most comprehensive power query tutorial exactly I need.

[hishamoo]

ما شاء الله شغل جميل جدا ومنظم بشكل احترافي ويمكن لاي شخص ان يتعلم حتى لو كان مبتدا لسلاسة الشرح بارك الله في رزقك وعملك

[BenDieselBasicAutomotive]

Thank you very much for the very comprehensive.... yet simplified explanation!... I now have a solid foundation to study Power Query....

[NikVilluri]

Honestly, all your hard work and dedication shows. Thank you so much 🙌🏼

[deeliyanage-demj]

Thank you lot of sir, lot of things learning from your videos. From Sri lanka

[Gastonag]

Thank you so much for this tutorial, I’m trying to switch professions from BA to data analyst and Power Query - Power Pivot are a good starting point. Great Job!

[MobinulHaq]

I think that this is one of the best Power Query courses on YouTube. It's amazing, so detailed. Thank you so much!

[shrikantbadge]

I just wanted to take a moment to express my sincere gratitude for your exceptional Power Query tutorials. Your teaching style is incredibly effective, and your dedication to providing clear, practical explanations is truly commendable.

Thanks to your videos, I've gained a much deeper understanding of Power Query, and I feel more confident using it in my projects. Your real-world examples and step-by-step guidance have been invaluable.

I genuinely appreciate the time and effort you invest in creating these tutorials. Your passion for Power Query shines through, and it's inspiring for all of us eager learners.

Looking forward to more fantastic content from your channel. Keep up the fantastic work!

Warm regards

[TheJdelgomes]

Absolute amazing Power Query Course. Thank You very much.

[ousmanesidibe]

did start power query for long, but this is the best video i've seen so far

[vanillasoda]

Wow thank you so much sir you are truly a godsend, im still at PQB04 and this is already very useful and interesting, definitely gonna learn all of it!

[InsightfulJourney]

I just discovered this course and channel! Amazing gem! Well presented with knowledge power! Subscribing!! Thank you very much, Sir!🙏

[hskalsi]

Simply it’s awesome. Standing clearly out from many stuff on this subject available in YT. I spend months to understand the PQ without success, but this one is working. Great.
Thanks.

[jawadahmadehssan]

Can't thank you enough for the great service you do. Thanks alot.

[simohnkanyiri]

Heartfelt gratitude goes to the tutor for this amazing power query video....its very comprehensive detailed and easy to learn. Thank a lot.