Advanced Data Transformation and Preparation with Power Query in Power BI

Video Training: Data Transformation and Preparation with Power Query in Power BI

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Length: 5 Hours and 20 Minutes

$259.95

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours money-back guarantee* T&C applies

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours money-back guarantee* T&C applies

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month per member
Or log in to access your purchased courses

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Modules

Introduction to Power Query and Get Data

This module brings you to the world of Power Query. First it starts with an introduction sample of connecting to web data sources, and applying some data preparation operations. Then it will continue with explaining other types of data sources such as Excel and SQL Server. You will learn about value structures and data types in Power Query. And also you will learn some specific data source types such as JSON. All scenarios will be explained through examples.

Lessons

Column and Row Transformations

There are a number of transformations that can be applied on columns and rows. Column transformations such as selecting columns, re-ordering, removing columns will be explained. for row transformations you will learn about filtering data and tricks about it, removing or keeping rows from start or end of the dataset. you will learn about removing error rows or duplicates as well through many examples.

Lessons

Specific Column Transformations

Every type of column, has a number of possible transformations. In this module, you will learn about transformations that you can apply on ANY types of columns; such as change type, fill down, up. Also specific transformations such as Text, Numeric, Date Time, and structured column transformations will be explained.

Lessons

M Scripting

M is the Power Query scripting language. Every transformation will be written in this language. You cannot be a Power Query expert without learning M. This section will give you a full understanding of M scripting language. You will learn about syntax structure of the language. You will also learn about some of the features that are not yet fully implemented in the graphical user interface, however it is available in M scripting. The module is full of sample codes and examples.

Lessons

Sample Power Query Use Cases

It's time now to go through some of the learning from this course through real-world use cases. This module goes through some real-world use case samples such as creating a full end to end date dimension and also looping through files in a directory and combining them together.

Lessons