While Power BI did a good job of automatically identifying and categorizing our data, the data is not entirely in the format we will require for analysis. Therefore, we need to modify how the data gets loaded into the model. In other words, we need to transform the data. To do that, we will use a powerful sub-application: the Power Query Editor.