->

Mastering in Power Query - From Basics to Advanced

Mastering in Power Query - From Basics to Advanced

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

 

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 BeginnersMicrosoft Power Platform DevelopersMicrosoft Excel UsersData AnalystsData ScientistsBI DevelopersAnyone who wants to perform Data Analytics using Microsoft Power Platform

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

 

Mastering in Power Query - From Basics to Advanced


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.




rss