Data Transformation in Power BI

Offered byDataCamp

Data Transformation in Power BI
at
DataCamp
Overview

Gain power with custom columns, M language, and the Advanced Editor

Duration	3 hours
Total fee	Free
Mode of learning	Online
Schedule type	Self paced
Official Website	Explore Free Course
Credential	Certificate

Data Transformation in Power BI
at
DataCamp
Highlights

Learn from 9 Videos and 28 Exercises

Data Transformation in Power BI
at
DataCamp
Course details

Skills you will learn

Sales

More about this course

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

Data Transformation in Power BI
at
DataCamp
Curriculum

Reshaping Data

Reshaping & aggregating data

Which shape after transformation?

Reshaping & aggregating tables in Power Query

Unpivoting & transposing

Pivoting

Grouping & aggregating

Combining Data in Power Query

Combining data in Power Query

What causes null values?

Merging & appending queries in Power Query

Appending queries

Merging queries: left join

Merging queries: right join

Transforming sales data for analysis

Custom Columns

Custom columns in Power Query

Custom conditional columns

Custom columns demo

Stock ranking

Stock values

Grouped stock ranking

Advanced Editor

Introduction to Advanced Editor

Using the Advanced Editor

DAX vs M Language

M Language & Advanced Editor demo

Calculate stock deviation

Rename steps & add comments

Variables and custom functions

Calculate Z scores

Congratulations!

Data Transformation in Power BI
at
DataCamp
Faculty details

Maarten Van den Broeck

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. He is also a certified Power BI and Tableau data analyst. After his career as a PhD researcher at KU Leuven, he wished that he had discovered DataCamp sooner.

Khaled Choucri

Khaled is a Power BI certified Strategic Analyst at Trilogy. He has a strong focus on data engineering and financial analytics. Khaled is passionate about studying human behavior and financial decision-making, particularly using machine learning and AI.