Tutorialspoint

Mastering in Power Query - From Basics to Advanced

Transform Data Using Power Query

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:

  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.

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
Show More

Curriculum

  • Introduction
    06:34
    Preview
  • Getting Data using Power Query
    08:19
    Preview
  • Authentication with a Data Source
    09:51
  • Power Query using SharePoint & OneDrive
    12:42
  • Transform Data Using Power Query - Part I
    21:22
  • Transform Data Using Power Query - Part II
    11:15
  • Analytics Vs Standard Dataflows
    13:19
  • Troubleshooting Dataflows
    12:34
  • Best Practices in Power Query
    10:02
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Mastering in Power Query - From Basics to Advanced
This Course Includes
  • 3 hours
  • 19 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515