Skip to content
Sabaqاردو

Advanced Data Analysis with Power Query, Power Pivot and Power BI (ExcelIsFun)

By excelisfun

Course audio
Course audio: English
Level
Advanced
Length
15 lessons

What you'll be able to do

  • Import, clean and combine data with Power Query
  • Choose the right merge or join for a task
  • Read and write basic M code

About this course

ExcelIsFun's MSPTDA class (Microsoft Power Tools for Data Analysis) is a full advanced business intelligence course taught by Mike Girvin. It opens with a dashboard overview and BI terms, then goes deep into Power Query: importing and transforming data, combining multiple files, Excel.CurrentWorkbook, merge, append and unpivot, the six join types, Group By and an introduction to M code, plus fixes for common errors. Later parts move to Power Pivot, DAX and Power BI. It suits analysts who are already comfortable with Excel formulas and PivotTables. Practise each lesson with the downloadable files.

Before you start: Solid Excel formulas and PivotTables

Syllabus

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

  1. 1Free Advanced Data Analysis & BI Course at YouTube (MSPTDA)
  2. 2Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.
  3. 3MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class
  4. 4MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop
  5. 5MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set
  6. 6Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662
  7. 7MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook
  8. 8MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations
  9. 9MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples
  10. 10MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)
  11. 11MSPTDA 08.5: Power Query Group By Unique List or Consecutive Occurrences
  12. 12MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More
  13. 13Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)
  14. 14MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column
  15. 15Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546

What to take next

Related courses

Videos by excelisfun, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request