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:
- Power Query Using SharePoint & OneDrive
- In this course, you'll learn
- What is Power Query?
- Getting data using Power Query
- Authentication with a Data Source
- Transform Data Using Power Query
- Analytics Vs Standard Dataflows
- Troubleshooting Dataflows
- Best Practices
- Query Folding in Power Query
- Power Query Basics
- Power Query Advanced
- Fuzzy Matching
- Data Privacy Firewall
- Query Plan
- Parameters in Power Query
- Import Data using Native Database Query
- 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
Goals
- 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
Prerequisites
- Basic Knowledge of Power BI
- Good to have basic knowledge of SQL
