Once a dataset has been shaped and structured (as covered in the previous two chapters), it probably still needs a good few modifications to make it ready for consumption. Many of these modifications are, at their heart, a selection of fairly simple yet necessary techniques that you apply to make the data cleaner and more standardized. I have chosen to group these approaches under the heading data cleansing.
10. Data Cleansing
Get Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data 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.