O'Reilly logo

Pro Power BI Desktop by Adam Aspin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Adam Aspin 2016

Adam Aspin, Pro Power BI Desktop, 10.1007/978-1-4842-1805-1_4

4. Data Cleansing

Adam Aspin

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

Once a dataset has been shaped and filtered, 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 can include the following:

  • Change the data type for a column—by telling Power BI Desktop that the column contains numbers, for example

  • Replace ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required