Hoppa till huvudinnehåll

Hem Business Intelligence

course

Data Transformation in Power BI

MellanliggandeFärdighetsnivå

Uppdaterad 2025-12

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

Börja Kursen Gratis

Power BIData Manipulation3 timmar9 videos28 exercises2,150 XP60,589Uttalande om prestation

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Älskad av elever på tusentals företag

Utbilda 2 eller fler personer?

Testa DataCamp for Business

Kursbeskrivning

Apply Table Transformations

In this course, you’ll learn all about table transformations in Power BI. You’ll learn how to (un)pivot, transpose, and append tables.

Work with Joins

You’ll also get introduced to joins and discover when it makes sense to use them.

Utilize the Advanced Editor

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.

Förkunskapskrav

Data Preparation in Power BI

1

Reshaping Data

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

Grouping and aggregating

2

Combining Data in Power Query

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

3

Custom Columns

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

4

Advanced Editor

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

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!

Data Transformation in Power BI

Kursen
är

Få ett prestationsutlåtande

Lägg till denna inloggningsuppgifter i din LinkedIn-profil, ditt CV eller ditt CV
Dela det på sociala medier och i ditt prestationssamtalRegistrera Dig Nu

Gå med över 19 miljoner elever och börja Data Transformation in Power BI idag!

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Utveckla dina datakunskaper med DataCamp för mobilen

Gör framsteg när du är på språng med våra mobila kurser och dagliga 5-minuters kodningsutmaningar.