Mastering in Power Query - From Basics to Advanced
Transform Data Using Power Query
Lectures -19
Duration -3 hours
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 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 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 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
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 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 Mastering in Power Query - From Basics to Advanced](https://d3mxt5v3yxgcsr.cloudfront.net/courses/9575/course_9575_image.jpg)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![BI Consulting Pro](https://www.tutorialspoint.com/assets/profiles/484679/profile/200_1176414-1657256002.png)
BI Consulting Pro
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)