9
Advanced Data Cleaning Techniques
So far in this book, we have covered several techniques that range from basic to intermediary. Now, we are ready to progress to the next stage of this book, where we will explore more advanced techniques for cleaning, preparing, and enhancing data for analysis within Power BI and its toolkit.
In this chapter, you will learn about the following:
- Using Power Query Editor from within Dataflow Gen1 – fuzzy matching and fill down
- Using R and Python scripts
- Using ML to clean data
By the end of this chapter, you will have learned how to build complex functions within Power Query. In addition to this, you will also learn how to begin bringing other advanced languages such as R or Python into your data model.
The ...
Get Data Cleaning with Power BI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
