Course
Data Transformation in Power BI
IntermediateSkill Level
Updated 12/2025Start Course for Free
Included withPremium or Teams
Power BIData Manipulation3 hr9 videos28 Exercises2,150 XP58,086Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Course
Training 2 or more people?
Try DataCamp for BusinessCourse Description
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.Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Choose the appropriate combination method—append, merge, and join type—based on dataset structure and relationship requirements.
- Identify the correct Power Query transformation for producing calculated or aggregated results.
- Identify the correct Power Query transformation needed to reshape or reorient a dataset.
- Recognize M-language syntax elements and distinguish whether M or DAX is used in a given modeling or transformation scenario.
Prerequisites
Data Preparation in Power BI1
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.
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.
3
Custom Columns
In this chapter, you’ll cover advanced features of Power Query, such as adding custom columns and custom conditionals.
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.
Data Transformation in Power BI
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance review
Included withPremium or Teams
Enroll NowJoin over 19 million learners and start Data Transformation in Power BI today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.