Course
Data Transformation in Power BI
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.Loved by learners at thousands of companies
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 BIReshaping Data
Combining Data in Power Query
Custom Columns
Advanced Editor
Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
Is this course suitable for Power BI beginners?
The course assumes basic familiarity with Power BI. Chapter 1 starts with reshaping techniques like pivoting and unpivoting, so some prior experience loading data in Power Query is helpful.
What transformation techniques will I learn in this course?
You will learn how to pivot, unpivot, and transpose tables, merge and append queries using different join types, create custom columns, and write M language in the Advanced Editor.
What is M language, and will this course teach me how to use it?
M language is the scripting language behind Power Query transformations. Chapter 4 teaches you to read, write, and edit M code in the Advanced Editor, including variables and custom functions.
What types of joins are covered in this course?
Chapter 2 covers merging queries using left joins and right joins in Power Query, along with appending queries to combine data from multiple sources.
Who will benefit from this course?
Data analysts and BI professionals who already load data into Power BI and want to learn more efficient ways to reshape, combine, and transform it before building reports.
Join 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.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.