Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Mastering in Power Query - From Basics to Advanced

person icon BI Consulting Pro

4.3

Mastering in Power Query - From Basics to Advanced

Learn Dataflows and transformations using Power Query from basics to the advanced level

updated on icon Updated on Jun, 2025

language icon Language - English

person icon BI Consulting Pro

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -19

Duration -3 hours

Lifetime Access

4.3

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course will help you to master 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 DataMart's) 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:

  • Power Query Using SharePoint & OneDrive.
  • 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.
  • Anyone who wants to perform Data Analytics using Microsoft Power Platform.

Not only this, I'll provide you with source materials as well as Quiz to check your knowledge.

Goals

  • 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 a Native Database Query.
  • Optimizing Power Query when expanding columns.

Prerequisites

  • Basic Knowledge of Power BI.
  • Good to have basic knowledge of SQL.
Mastering in Power Query - From Basics to Advanced

Curriculum

Check out the detailed breakdown of what’s inside the course

Basics of Power Query

9 Lectures
  • play icon Introduction 06:34 06:34
  • play icon Getting Data using Power Query 08:19 08:19
  • play icon Authentication with a Data Source 09:51 09:51
  • play icon Power Query using SharePoint & OneDrive 12:42 12:42
  • play icon Transform Data Using Power Query - Part I 21:22 21:22
  • play icon Transform Data Using Power Query - Part II 11:15 11:15
  • play icon Analytics Vs Standard Dataflows 13:19 13:19
  • play icon Troubleshooting Dataflows 12:34 12:34
  • play icon Best Practices in Power Query 10:02 10:02

Power Query Advanced

10 Lectures
Tutorialspoint

Instructor Details

BI Consulting Pro

BI Consulting Pro

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515