Chapter 3: Data Preparation
The most important input for Artificial Intelligence (AI) is the data you have. You must ensure that you have enough data and that it is of good quality. The first step we take after importing data into Power BI is exploring the data to make sure we understand what we are working with. The next step is to clean the data and prepare it for our AI applications.
In this chapter, we'll learn about the common problems we may have with our data and how to fix them. It is important to prepare the data properly in the Power Query Editor as this will help us in extracting the right insights from the data using AI. The common problems we will talk about in this chapter are as follows:
- Fixing the structure of your data
- Working with missing data
- Mitigating bias
- Handling outliers
