Mastering in Power Query - From Basics to Advanced
Mastering in Power Query - From Basics to Advanced
Duration: 3h 29m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.5 GB
Genre: eLearning | Language: English
Duration: 3h 29m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.5 GB
Genre: eLearning | Language: English
Transform Data Using Power Query
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.
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
More Info