In this chapter, you'll learn how to become a data plastic surgeon by restructuring and reshaping data in Power BI. You'll also stitch together data in different ways from various sources to enrich your analytical capabilities.

Reshaping and aggregating  data

Which shape after transformation?

Reshaping and aggregating tables in Power Query

Unpivoting and transposing

Pivoting

Grouping and aggregating

Reshaping Data

In this chapter, you'll learn stitch together data in different ways from various sources to enrich your analytical capabilities.

Combining data in Power Query

What causes null values?

Merging and appending queries in Power Query

Appending queries

Merging queries: left join

Merging queries: right join

Transforming sales data for analysis

Combining Data in Power Query

In this chapter, you’ll cover advanced features of Power Query, such as adding custom columns and custom conditionals.

Custom columns in Power Query

Custom conditional columns

Custom columns demo

Stock ranking

Stock values

Grouped stock ranking

Custom Columns

In the final chapter, you’ll learn to read and write M language, which allows for a more efficient way to do data transformations in Power Query.

Introduction to Advanced Editor

Using the Advanced Editor

Options

M Language

DAX vs M Language

M Language and Advanced Editor demo

Calculate stock deviation

Rename steps and add comments

Variables and custom functions

Calculate Z scores

Congratulations!

Advanced Editor

Exercises and Datasets

Course Glossary

In this course, you’ll learn all about table transformations in Power BI. You’ll learn how to (un)pivot, transpose, and append tables. You’ll also get introduced to joins and discover when it makes sense to use them. Finally, you’ll gain power with custom columns, including how to use M language and the Advanced Editor, to help you be even more efficient in data preparation.

The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos.

The course glossary can be found on the right in the resources section.

To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

<h2>Apply Table Transformations</h2>
In this course, you’ll learn all about table transformations in Power BI. You’ll learn how to (un)pivot, transpose, and append tables. 
<br><br>
<h2>Work with Joins</h2>
You’ll also get introduced to joins and discover when it makes sense to use them. 
<br><br>
<h2>Utilize the Advanced Editor</h2>
Finally, you’ll gain power with custom columns, including how to use M language and the Advanced Editor, to help you be even more efficient in data preparation.


Data Preparation in Power BI

You’ll learn how to (un)pivot, transpose, append and join tables. Gain power with custom columns, M language, and the Advanced Editor.

Data Transformation in Power BI

Data Analyst in Power BI

Using the Advanced Editor

Data Transformation in Power BI

Praktische interactieve oefening