©  Adam Aspin 2020
A. AspinPro Power BI Desktophttps://doi.org/10.1007/978-1-4842-5763-0_8

8. Data Transformation and Cleansing

Adam Aspin1 
(1)
Stoke-on-Trent, Staffordshire, UK
 

Once a dataset has been shaped and filtered (as covered in the previous chapter), 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 transformation and 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 of processes that finalize

Get Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User 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.