Mastering in Power Query - From Basics to Advanced
Learn Dataflows and transformations using Power Query from basics to the advanced level
Office Productivity,Microsoft,Excel
Lectures -19
Duration -3 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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.

Curriculum
Check out the detailed breakdown of what’s inside the course
Basics of Power Query
9 Lectures
-
Introduction 06:34 06:34
-
Getting Data using Power Query 08:19 08:19
-
Authentication with a Data Source 09:51 09:51
-
Power Query using SharePoint & OneDrive 12:42 12:42
-
Transform Data Using Power Query - Part I 21:22 21:22
-
Transform Data Using Power Query - Part II 11:15 11:15
-
Analytics Vs Standard Dataflows 13:19 13:19
-
Troubleshooting Dataflows 12:34 12:34
-
Best Practices in Power Query 10:02 10:02
Power Query Advanced
10 Lectures

Instructor Details

BI Consulting Pro
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now