As mentioned in Part 1, AI Builder is a game changer in Power Apps and Microsoft flow.

In this post, I am going to show how you able to access the AI Builder for classification. 

to see how to set up your environment check the Part 1.

Get Data

to get data, you need to click on the Data–> Entities in the right panel

then, click on the Get Data option from the top menu.

in the menu, I am choosing the Text/CSV as I already load my dataset into Blob storage.

Next, just put the link to the blob storage and click the Next, if you access via a place that needs authentication then you need to set it up here, in this scenario, I do not access a private channel.

Now, you will access the data flow editor to clean and transform your data if needed ( remove columns, combine tables…), then put a name for the data and click on the Next.

In this part, you need to adjust and map your entity, if you already have the entity, in the Load setting, you need to choose the  first option ( load to the existing entity)

otherwise the second one.

then you should provide the Primary Name Field for the Titanic dataset, I choose the Name column as the passenger name. also, you may get an error regarding the change the data type to the text and you need to click on the delete rows that no longer in the query ( if you change something in the previous step), then simply click on the Next to load the data.

After loading the data, you need to refresh it, I choose to refresh it manually for the first time and click on the Creat.

Now you need to wait for data be loaded as an entity

NOTE! if you choose a binary classification, your column to predict should be in True and False format.

next, the data should be loaded and you should see a load status change to complete. otherwise, you need to back and check the data.

Now, you should see the data you loaded as a new entity in the Entity List.

AI Builder

Now we have data, need to create the model.

if you create the environment correctly, you should see the AI Builder in the left menu, click on the AI Builder and Build option.

Now the main page for the election of the AI model will be shown, For this scenario, we are going to choose the Binary Classification for prediction.

again be sure the column you are going to predict be in TRUE/FALSE format.

put a proper name for your model and click on the Create

Now the main process of creating the model will start.

The first step is to select which dataset need to select for training the model and what column you are going to predict.

Then, you need to choose which column of the dataset you need to be selected for training. In this example, I choose all of them which is not at all best practice but we will see how to back and change it.

Click on the next bottom and then, review what you have, if needed back and change the columns and if you happy click on the Train.

so you will see below message till the model trained

finally, you need to see the message like :

now I saw the below message, as you can see you able to check the overall accuracy, there is a training report and you able to create a New  Version of this with different data, moreover in the left pannel we are not anymore in the Build section but in the Models one.

Click on the View detail in the previous page, to see the influence report.

This report shows which column has more impact on the survival of people from the Titanic ship. Also, make sure to choose the one that has made sense from a business perspective,

Name of people does not impact, also Fair and PCLASS is the same thing.

I select the Age and Pclass only. If you click on the training report, my dataset has less than 1000 rows so the report does not show here as you can see in the below picture.

At this time, to create a new training model, you need to click on New Version

This returns you to the main training page.

Now you able to select the column you want from the list.

and click on the Next to train it again.

after all experiment, now you able to publish your model to be used in a Model-driven application.

In next post I will explain how to show the results

Leila Etaati

Trainer, Consultant, Mentor

Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.