Course Description
In this chapter you’ll learn advanced techniques for transforming data, such as using the Advanced Editor. In addition, you’ll learn how to create parameters to dynamically filter datasets, create columns from examples, as well as configure custom functions and conditional columns based on if, then, and else conditions. Finally, you’ll learn query dependencies, which will help in understanding sources and targets for datasets and queries.
What You'll Learn
- Use the Advanced Editor to apply advanced data transformation techniques
- Create parameters to dynamically filter datasets
- Build columns from examples and configure conditional columns based on if, then, and else conditions
- Configure custom functions in Power BI queries
- Trace query dependencies to understand sources and targets for datasets and queries
- Model data using advanced techniques including many-to-many and bidirectional relationships
Key Takeaways
- The chapter covers advanced techniques for transforming data, such as using the Advanced Editor.
- Parameters can be created to dynamically filter datasets in Power BI.
- Conditional columns are configured based on if, then, and else conditions.
- Query dependencies help in understanding the sources and targets for datasets and queries.
- The course covers advanced modeling topics including many-to-many and bidirectional relationships, row level security, and aggregations.
Frequently Asked Questions
What does this Power BI chapter cover?
It covers advanced techniques for transforming data using the Advanced Editor, creating parameters to dynamically filter datasets, creating columns from examples, configuring custom functions and conditional columns based on if, then, and else conditions, and understanding query dependencies for the sources and targets of datasets and queries.
What lessons are included in this course?
The lessons are Advanced Editor, Parameters, Column from Examples, Custom Functions, Conditional Column, and Query Dependencies.
What skills will I gain from this course?
The course develops skills in Advanced Analytics, Data Manipulation, Data Transformation, Microsoft Power BI Embedded, Power BI, and Query Designer.
What advanced modeling topics are addressed?
The learning objectives include modeling data using advanced techniques, many-to-many and bidirectional relationships, migrating an Excel data model and report to Power BI, advanced properties, row level security, and aggregations.
