Build your ultimate AI agent
Course 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
Curriculum
Course outline
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.
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
