Mastering in Power Query - From Basics to Advanced

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 DataMart's) 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.

In this course, you'll learn the followings:

1. Power Query Using SharePoint & OneDrive
2. In this course, you'll learn
3. What is Power Query?
4. Getting data using Power Query
5. Authentication with a Data Source
6. Transform Data Using Power Query
7. Analytics Vs Standard Dataflows
8. Troubleshooting Dataflows
9. Best Practices
10. Query Folding in Power Query
11. Power Query Basics
12. Power Query Advanced
13. Fuzzy Matching
14. Data Privacy Firewall
15. Query Plan
16. Parameters in Power Query
17. Import Data using Native Database Query
18. Optimizing Power Query When Expanding Columns

Who this course is for:

• Power BI Developers
• Microsoft Power Platform Developers
• Data Analysts
• Data Scientists
• BI Developers
• Excel users who want to learn advanced data modeling & business intelligence tools
• Students looking for a comprehensive, engaging, and highly interactive approach to Excel training
• Anyone looking to become an Excel POWER USER and supercharge their analytics skillset
• Students looking to pursue a career in data analysis or business intelligence

Not only this, I'll provide you source materials as well as Quiz to check your knowledge.

Who this course is for:

• Power BI Beginners
• Microsoft Power Platform Developers
• Microsoft Excel Users
• Data Analysts
• Data Scientists
• BI Developers
• Anyone who wants to perform Data Analytics using Microsoft Power Platform