Part 3 – Advanced Data Cleaning and Optimizations

This part navigates through advanced techniques for shaping and optimizing data within Power BI. You will dive into custom function creation in Power Query, mastering planning, parameters, and function creation. Later, you will explore M query optimization to gain insights into query optimization for peak performance, before concluding with an understanding of data modeling and relationship management to ensure that data models set the stage for success.

This part has the following chapters:

• Chapter 9, Advanced Data Cleaning Techniques
• Chapter 10, Creating Custom Functions in Power Query
• Chapter 11, M Query Optimization
• Chapter 12, Data Modeling and Managing Relationships