Mastering in Power Query - From Basics to Advanced
Transform Data Using Power Query
Updated on Dec, 2023
Language - English
Lectures -19
Duration -3 hours
30-days Money-Back Guarantee
Get your team access to 8,500+ 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 will you learn in this course:
- 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
What are the prerequisites for this course?
- 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
Insights | Analytics | VisualizationBI Consulting Pro is an educational channel, created to help data lovers around the globe. We help to analyze, and visualize the data using MS Power Platform, and MS Azure. Here, we help people to learn about data visualization, data extraction, and storytelling using data. As someone said" A picture is worth a thousand words", so data visualization is an important part of any business. If you are looking to learn Data Visualization using Power BI then subscribe to our channel and connect with us.
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
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