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 key aim of this chapter is to provide an introduction to techniques that you can leverage as you clean, prepare, and enhance your data for analysis, as well as to introduce you to working with dataflows from the...
