What you’ll learn:
What is Power Query?
Getting Data using Power Query
Authentication with a Data Source in Power Query
Power Query using SharePoint & OneDrive
How to create Dataflows using Power Query?
Analytical Vs Standard Dataflows
Troubleshooting Dataflows
Best Practices in Power Query
Query folding in Power Query
Fuzzy Matching in Power Query
Data Privacy FireWall in Power Query
Query Plan in Power Query
Parameters in Power Query
Import Data from a Database using Native Database Query
Optimizing Power Query when expanding columns
Requirements:
Basic Knowledge of Power BI
Good to have basic knowledge of SQL
Description:
This course will help you to mastering in Power Query from the basics to the advanced concepts.
If you’re looking to become a Microsoft Power Platform (Power BI, Power Apps, Power Automate, Power Virtual Agents, Dataflows or Datamarts) and MS Excel user, this course is the A-Z guide that you’re looking for. I’ll introduce the “Dataflows”, and Data transformations using Power Query from basics to the advanced level.
