Published 05/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 19 lectures (3h 29m) | Size: 1.54 GB
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
Homepage
https://www.udemy.com/course/mastering-in-power-query-from-basics-to-advanced/
H4S
DOWNLOAD FROM HOT4SHARE.COM
DOWNLOAD FROM HOT4SHARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM