Adding a dataflow for ML queries

Now that you’ve ingested, cleaned up, and transformed the data from the FAA Wildlife Strike database, you can build out your specialized queries for Power BI ML models. Before you get started, note that Power BI ML is a version of Azure AutoML that has been built into Power BI as a SaaS offering. Data science teams using advanced tools will often apply transformations to data, such as imputing missing values, normalizing numeric ranges, and weighting features within a model. The advanced transformations of features won’t be covered in this book since AutoML has featurization capabilities to optimize data for ML. The queries you will be creating could probably be improved upon with advanced featurization techniques, but for this project, we will keep things simple and let the AutoML featurization capabilities in Power BI ML handle some of the advanced feature transformations.

Adding the Predict Damage ML query to a dataflow

You will...