© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. AspinPro Data Mashup for Power BIhttps://doi.org/10.1007/978-1-4842-8578-7_10

10. Data Cleansing

Adam Aspin1  
(1)
STAFFORD, UK
 

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.

The sort of things that you may be looking to do before finally loading source data into the data model normally cover a range ...

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.