Summary
In this chapter, you created queries coming from the FAA Wildlife Strike data, which will be used as the basis for both Power BI datasets and ML training datasets. Throughout the chapter, you removed unnecessary columns, cleaned up the column names, and formatted the queries so that they can be used as tables of data.
In the next chapter, you will explore the data in these queries and create a semantic model in a Power BI dataset, which relates all of the data together for the purpose of creating a Power BI report – this will kickstart analytics on the FAA Wildlife Strike data.