Published 05/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 19 lectures (3h 29m) | Size: 1.54 GB

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

Basic Knowledge of Power BI
Good to have basic knowledge of SQL

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.

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

HomePage:

https://anonymz.com/https://www.udemy.com/course/mastering-in-power-query-from-basics-to-advanced/