4
The Most Common Data Cleaning Operations
Now that you’ve built a strong knowledge of data quality and the importance of assessing and documenting your data cleaning process, it’s time to roll your sleeves up and get stuck into some data.
In this chapter, you will be learning how to deal with the most common data cleaning steps within Power BI, as listed next. For each of these example topics, you will find a step-by-step walk-through on how to carry out these transformations yourself.
We will cover the following specific topics:
- Removing duplicates
- Removing missing data
- Splitting columns
- Merging columns
- Replacing outliers
- Creating calculated columns versus measures
By the end of the chapter, you will have built a strong base of foundational ...
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.
