1

Introduction to Power BI Data Cleaning

Although not definitive, it’s generally accepted that when creating data visualizations, cleaning and preparing data can often account for as much as 50-80% of the overall time spent on a data visualization project. Power BI provides you with some great tools to carry this out and so we will dive deeper into what is available during this chapter.

In this chapter, we’re going to cover the following main topics:

  • Cleaning your data in Power BI
  • Understanding Power Query
  • Understanding Data Analysis Expressions (DAX)
  • Where do we begin with data?

After this chapter, you will understand with confidence which tools are available within Power BI to help prepare your data for analysis, how to navigate around Power ...

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.