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 Query, and then what to consider when getting started with preparing your data for analysis.
