Mastering in Power Query - From Basics to Advanced

Transform Data Using Power Query

Udemy
platform
English
language
Other
category
instructor
3
students
3.5 hours
content
May 2022
last update
$29.99
regular price

What you will 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

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: 


  1. Power Query Using SharePoint & OneDrive

  2. In this course, you'll learn

  3. What is Power Query?

  4. Getting data using Power Query

  5. Authentication with a Data Source

  6. Transform Data Using Power Query

  7. Analytics Vs Standard Dataflows

  8. Troubleshooting Dataflows

  9. Best Practices

  10. Query Folding in Power Query

  11. Power Query Basics

  12. Power Query Advanced

  13. Fuzzy Matching

  14. Data Privacy FireWall

  15. Query Plan

  16. Parameters in Power Query

  17. Import Data using Native Database Query

  18. 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.

Screenshots

Mastering in Power Query - From Basics to Advanced - Screenshot_01Mastering in Power Query - From Basics to Advanced - Screenshot_02Mastering in Power Query - From Basics to Advanced - Screenshot_03Mastering in Power Query - From Basics to Advanced - Screenshot_04

Content

Basics of Power Query

Introduction
Getting Data using Power Query
Authentication with a Data Source
Power Query using SharePoint & OneDrive
Transform Data Using Power Query - Part I
Transform Data Using Power Query - Part II
Analytics Vs Standard Dataflows
Troubleshooting Dataflows
Best Practices in Power Query
Power Query Basics - Let's Check you Knowledge

Power Query Advanced

Query Folding in Power Query
Fuzzy Matching in Power Query
Data Privacy FireWall
Query Plan
Parameters in Power Query
Error Handling
Import Data from a Database using Native Database Query
Create MS Power Platform Dataflows From Queries in MS Excel
Optimizing Power Query When Expanding Columns
Support & Troubleshooting in Power Query
Power Query Advanced Quiz - Let's see what you have learn so far
4709736
udemy ID
5/29/2022
course created date
6/22/2022
course indexed date
Bot
course submited by