Azure Logic APPS–A simplest way to Automate your Business Process

As you may aware Microsoft Azure provides you a bunch of services, feature and Azure Logic Apps is one of the best Service which Microsoft provides to automate, orchestrate tasks, business process etc.

Logic Apps is the simplest visual designer solution to solve your simple to advance problem without writing a complex logic.

Indiandotnet_Microsoft_Logic_App

I know you might be thinking where we can use this. So my answer is everywhere in your business where you might need some kind of automation. Let’s understand the need with a few examples here.

Example:- Suppose, you are a business owner and most of the customer contact you via email. So, whenever a mail comes with subject invoice or new order you read those email carefully and depending upon the the subject you either send then to Account department  or Production team moreover if the email is coming from new client then you add his basic details in your system and once the production team update status of work complete and notify you. You again send the completion confirmation to end client.

Now, all these processes which we have gone through are in the different system and most of them required human interaction, for example, identifying the new client and firstly make their entry in the system.

So, this whole process can be automated using Azure Logic Apps.  So, in the above problem, Azure Logic Apps firstly read your email and identify the specific subject’s email. Once those identify check the email address in your client repository whether that exists or not if not exists then will add in the client repository.

In the next step, Logic Apps send detail to the production team or Account system. Also, keep eye on the database of the production team and when they trigger order complete send an email or SMS to end client.

And believe me, all this complex logic you can achieve in Logic Apps without writing complex code but using designer object provided in Azure logic Apps.

One more thing which I have faced personally if you worked  in supply chain system especially E-Pedigree, EPCIS & EDI then you might need to work on complex XML, AS2 format files for which you have to write complex code but with the help of Logic Apps this can be few steps job  and without writing any complex code.

Few more example like

1. Connect with Facebook and find the negative post and remove from your wall.

2. Fetch Tweets and  either retweet or find the sentiment

3.  Fetch newly added detail from SQL Server/ CRM/ Sales Force and send a welcome SMS or Email.

There are tones of the example where Logic Apps workflow makes your life easy.

Let’s understand the main component of Logic Apps which is a Connector.

These connectors will help you to connect with various API, protocols, integration account and enterprise account connector.

Now, to proceed further let me tell you there is more than 200 connector (predefine components) available to help you in achieving your goal.

connector

Every connector   has two main parts which are Action & Trigger

By the name, it is clear that Action is the action item needs to be taken and Trigger will help us to define when to take the action.

Now,  Lot’s of theory here let’s understand this by a step by step simple example. The problem statement is whenever an Email comes to our Office 365 account we will create a file in Dropbox and the file will content the email body. Isn’t it cool?

Prerequisites:- The first and most important prerequisites here is that you should have Microsoft Azure portal Account.

Step 1: Login to Microsoft Azure Portal  https://portal.azure.com/  using your credentials

Step 2: Once the login is done the next step is to click on All services and find integration option when you click on that option you will get Logic Apps option as shown in below figure.

Logic_Apps_1

Step 3: When you click on the Logic Apps option you will get the following screen. Here if you have not created any Logic Apps earlier then the grid will show blank. So just click on Create Logic Apps option or Add button

Indiandotnet_Logic_Apps_2

Step 3:-  You will get the following screen after using Add new Logic Apps option. Where you need to provide your application name and select the subscription, and use the existing resource group or create new. At last, need to select the location where to deploy the app. Once you are done with this just Click on Create button in the bottom of the screen.

Indiandotnet_Logic_App_3

Step 4: – Now, it will take a few minutes to complete and you will get following notification that application is deployed.

Indiandotnet_Logic_Apps_4

Step 5: Now open this application by going back to Logic Apps Resource Grid or Pin the Application on Dashboard by clicking Pin To Dashboard option and open from Dashboard.

Indiandotnet_Logic_App_5

Step 6:  Now when you click on open you will following screen. Where you can choose any predefined template which fulfils your business needs. But in this example, we are taking option Add new Logic App and proceed further

Indiandotnet_Logic_Apps_5

Step 7: You will get the following screen after clicking New Logic Apps option.

Indiandotnet_Logic_Apps_6

Step 8:  Now when you click on Connector you will find there is various connector available which you can choose. In this example we are taking Office 365 outLook email connector

Indiandotnet_Logic_Apps_7

Step 9: When you click on OutLook option you will get a new screen where you will find the different trigger on which you want to take action. To make this example simple we are choosing the option when a new Email Arrives

Indiandotnet_Logic_Apps_8

So, it means whenever a new Email comes to the outlook we will do something. Now when you click on When A new Email Arrives it will ask you Outlook credential

Indiandotnet_Logic_Apps_9

Step 10:  Give proper credentials and allow the Logic Apps to access Office 365 email.

Indiandotnet_Logic_Apps_10

Step 11:-  Once you allow Access then you will get the following screen where you need to define the different option value. For example how frequently mail need to be check etc

Indiandotnet_Logic_Apps_11

Step 12:- Now, what we need to do here, whenever a new mail found we will create a file in Dropbox. So just add Create a file in dropbox connector for next step.

Indiandotnet_Logic_App_Drop_Box_Finding

Step 13: As obvious, you have to provide drop box access to Logic Apps to further action. So, just press the allow button.

Indiandotnet_Logic_App_Drop_Box_Access

Step 14:-  Once you authorized in the next step you have to configure the dropbox like where should we save file folder path in the current example we are saving the file in root folder.

Next what is the file name so, we are creating email subject as the file name. and to view it properly we will append the extension HTML in the filename.

Next property is file content, so we are going to save email body (email content) in the file.

Indiandotnet_Logic_Apps_Dropbox_Setting

You can configure the properties as per your ease.

Indiandotnet_Logic_Apps_DropBox_Settings

Step 15: Just save the Logic Apps and  hit the run button to test it further

Indiandotnet_Logic_App_Hit_Run_Button1

Step 16: To make sure it is working properly, we are going to send an email from my personal Gmail to my office 365 account

Indiandotnet_Logic_Apps_Email

Step 17: Now, once we send this email to my office 365 account. The logic app should create a new file in my dropbox. As you can see in below figure it showing WOW Azure Logic App.html as expected.

Indiandotnet_Logic_Apps_Dropbox_View

Step 18: Now, we will try to open it and check the content of the file and WOW, it is working as per our expectation.

Indiandotnet_Logic_Apps_File_Conent

So, we have created our first simple Azure Logic App without writing a single line but handled a complex logic.

In my next few post, we will see more inside of Azure Logic Apps.

I hope you may like this post.

Happy learning.

What is collection & How to manage a collection in PowerApps ?

In the last article we learned about the different controls which exist in PowerApps although there are some more controls which we will discuss going forward before jumping into remaining controls let’s discuss here the most important part Collection.

What is collection?

A collection is used to store data that can be used in your app or we can say a collection is a group of items that are similar. For example, Student data collection where the collection will store student first name, last name and other information about the student.

To see it practically let’s open PowerApps editor and add a new screen and OnStart function create a collection.

Now to create a collection in PowerApps we have  “Collection” function in PowerApp and syntax is as follows 

Collect(Collectionname, items)

So, Student collection can be defined as follow.

Collect(StudentCollection,      {Name:”Rajat”,LastName:”Jaiswal”},   {Name:”Sandeep”,LastName:”Jain”})

OnStartCollectionNew

So, we have created our first collection. To view this in action add any control you want here we are using Gallery control.

AddGalControl

Once you added this control you will find the data properties and we can see our created collection which is “StudentCollection

StudentCollection

Here we can assign  the title and subtitle  properties of the gallery with the property Name  & LastName of our newly StudentCollection.. Just Save the application at this point and reload the app again.

You will find the following screen.

DataWithGallary

We can check our newly created collection by file option as shown below

StudentCollection_001

In this way, we can create a collection. Now, the next question is how to ADD/EDIT/Remove in the collection. So, let’s understand this now.

Add Collection

Just drag-drop textboxes, labels, and a button to add the data to the collection as shown below.  On Add, button onSelect write  below function

addCollection

Now, when you run and click on Add button. You can see the Record appears in your gallery as shown in below figure.

Collection Add

Remove Collection

Now, In the next step, we will delete the record from the collection.

The syntax of this is very simple

Remove (CollectionName,item)

Now, to achieve this add a delete icon in the gallery as shown in below figure.

DeleteCollection

On select of delete icon, we can write  Remove(StudentCollection, This.Item)

Here This.Item is selected item of the gallery to which we need to delete from the collection.

Now,  What if we want to delete the entire collection? then in such case, we have

Clear Collection

The syntax is very simple Clear(CollectionName)

So in our case, we have to write Clear(StudentCollection)

Now, to Edit a particular item in a collection the first this is select the item in the text box which we want to edit and to achieve this we bind the textbox by Gallery’s selected item as shown in below figure.

Selectcollection

Once you have done with this  then on Update button we can write Patch collection function as shown below

PatchSection

So the syntax is very simple

Patch(StudentCollection,Gallery1.SelectedItem, {Name:TextInput4.Text,LastName:TextInput5.Text})

so in this way, we can update the specific item (As shown above we updated only selected item from Gallery).

So, In this session, we understood Collection, add an item in the collection, Remove function to remove a specific item from the collection, Clear Collection to delete entire items from the collection and none other than Patch function to edit the collection.

RJ

Learn How To Start PowerApps Controls

Congratulations, in the last post you have successfully created your first PowerApp.

In this post, we will try to understand different controls available in PowerApps.  Before jumping directly into PowerApps one quick tip wants to share with you that PowerApps is very much inspired by Excel. So, whenever you stuck to any problem which you want to solve than just give a try how you could solve that particular problem in Excel. You will find most of the functions similar to Excel.

Just remember that  screen & its controls have global scope in PowerApps.

PowerApps support various controls which we will discuss shortly but before that would like to share that every control has properties and these properties has 2 types Input properties and output properties. We can update the input properties but not output properties.

with this let’s start controls:

You can use control by clicking  on control’s icon of Insert menu

ControlMenu

Label :- Label is simple a ready only control to show text value. We can change the properties like font, color, position, size etc.. from properties window.

You can write a custom function for any input properties or assign direct value.

Properties

TextBox : When we need input from the user then in such cases we can use Textbox control. For example, asking the name of the person.

Just to make you aware Text property is  Output property of textbox so you can’t assign value. while Default is in the input property to show any value in the textbox.

TextboxDefault_properties

Button: Button control is used to perform any action by clicking on it. You can write custom action using the OnSelect trigger.

Action

HtmlText :  When we have to deal with Html Data then in such cases we can use HTML textbox.

Html_Text_Input

Pen Input: This is one of the interesting control. When you need pen input from Apps like a signature or something that then you can use this control

PenInput

Date Picker : When you want date value then in such case we can use Date Picker control. We have provision to change DateTime format & time Zone from Local to UTC.

DatePicker_Control

DropDown:- Whenever we have multiple options from which we need to select the value then we can use DropDown control. DropDown control has Items properties to bind the dropDown options. If a user selected any Dropdown option then we can get by Selected property of dropdown.

DropDown_Item_Collection

Combobox:- Combobox most likely a DropDown and also provide multi selection option.

Combobox

Rating :- If we want a rating for a specific reason then we can use Rating control.

StartRating

Timer:  By the name, it is clear that it is a timer which starts counting. You can invoke an event on OntimerStart, OnTimerEnd etc..

timer_Control

Toggle: Toggle is just True/False option. So, whenever you want true/false option we can use it.

Toggle_Control

Radio Button:  Radio button is again normal control which you might have used earlier. You have a list of option and you need  to select a specific option then we can use a radio button.

RadioButton

Slider: When we required a predefined range and want a user to select from that particular range then slider is one of the option.

Slider

Apart  from this there some other controls like Form Control , Grid, Attachment etc.. which we will describe soon in our coming post as they need individual attention.

Till then enjoy reading.

The A – Z Guide Of Create the first powerApps

In this last post, we discussed the PowerApps templates. Now, in this post finally, we are going to create our first PowerApp isn’t it exciting?

So, as mentioned earlier login with the authorized credentials and after login you will find following dashboard screen. Here, we need to select a Blank Template as shown below. Here, we have a choice to opt mobile or desktop web. We can choose as per your ease or requirement and then press make this App button.

Dashboard_Blank_app

After clicking the make this app button we get following screen which is basically our playground for App creation or actual editor where we can manage our pages, add new pages, add controls  etc..

Editor_Area

As this is our first app, we are going to make it very simple and create an addition of 2 numbers screen (Although, it seems simple but bit tricky as well.)

For which we will click 3 label controls ,3 textboxes & 1 button and arrange them properly as shown in below figure. Here we can change the control’s default text. color, etc by property pane.

Rough_Screen_of_Sum

Once this part is done, in the next step we need to show the sum of First Number, Second number’s value in 3rd text box when user clicks the Sum button.

One more point which we need to take care is format property of the textbox.

formatPropertytoText

Now, to achieve this we are going to write a function on button click as shown in the below snap.

image

Here, we need to write the code in function’s tab as shown below in screen. if you see here we are using a SUM inbuilt function and using UpdateContext (an internal function) for assigning the addition value of the textboxes to a variable called myAdd.

Sum_Function

Now, once we are done with the above function, in the next step we are going to assign the myAdd variable (who holds the addition of text1 & text2) to our result text box. To achieve this select the textbox in which we need to show summation value & click on the Property window’s function tab.

Here, we have to assign the myAdd variable  as a data’s default value (shown in below figure)

assigning_Default_Value

Once we done with above steps, next item would be to run this App and do a quick testing. To run this App click on run button (Top right corner of the editor) as shown in below figure.

run

We will get the below screen to test our sum logic.

Test_result

That’s great we created and tested our first PowerApps. Now, in next step Save this application. After clicking File menu a new screen (as we are saving this first time)  will appear where we need to provide App name , description of app and icon. After providing this details click on the Save menu .

save_App

So, congratulations we have created our first simple PowerApps and saved successfully.

Save_App_done

We will see later how to publish it which is also very easy step.

In next article we will see more stuff of PowerApps till then enjoy.

RJ

It’s All About (The) PowerApps Tempates

In the last post, we discussed what is PowerApps and an initial point where we can register our self and start working.

We can use either web studio or desktop studio for creating the PowerApps. I generally, prefer web version.

In this article, we will see different inbuilt templates Apps which give us confidence that what the PowerApps can do.

Click on https://powerapps.microsoft.com/en-us/  and log in with your authorized credentials

signin_with_Microsoft_account 

so, After login, we will find below dashboard screen.

Dashboard_Screen

There are several inbuilt PowerApps templates available along with blank Templates. Let’s start few of them to understand the capabilities of PowerApps.

Service Desk:- 

This is simply ticketing system where we can see How many tickets are open? How many are closed? and How many are in progress ? along with ticket details. so, in the organization ticketing system required the can be a good App.

Service_Desk_Template

Assets Tracker:

This template app Keep tracks of the tools and equipment your teams need to do their jobs.

Assests_Tracker

Leave Request :

This template will help the organization’s employee to raise a leave request and manager will approve it.

Leave_Request_Power_Apps 

There are many more other templates available which you can use as an instant recipe.

As it is Microsoft tool so you can easily access Office 365, planner etc. but on the top of it, you can use Camera & Location feature as well.

Accessibility_of_camera_And_Location

Now, in next article, we will see how to start with a new blank App.

step by step powerApps Made Simple – Even Your Kids Can Do It

f you are not family with this awesome thing then surely you might be curious to know what is PowerApps ?, How it works? Where can utilize it? and there are many more questions.

To resolve all these queries we are starting a Zero to Hero series in PowerApps. You will find a series of the blog going forward and we will do deep dive in PowerApps.

What is PowerApps?

You will find a lot of different definition for PowerApps but for me, it is a tool which gives you the power to create your business application which can run on web/mobile/tab with a little writing or without writing code.

PowerApps tool is super easy to use and with the help of this tool, you can create the various business app in which you can use any data source like SQL Server, Excel,  twitter, facebook etc.

Although, PowerApps is basically created for Non-developers but still as a developer you can use it.

In nutshell, we can say it Platform As A Service model. PowerApps has various controls & templates which we can utilize to create our business App.

We can create PowerApps by 2 ways either we can download PowerApps app in Window 10 from Microsoft Store as shown in the figure below.

image

Or just use following URL http://powerapps.microsoft.com

image

Once you downloaded or open the PowerApps first or foremost important is to login into the tool using Microsoft /OutLook/office365 account.

Once you  done with sign up process. you have to provide your valid username & Password to access it further.

In next blog, we will see how to create our first simple Power app.

Keep learning

How easy to create Your first chat bot using Azure Bot Services in 10 steps

Friends,

BOT is one of Buzz word now days. Everyone is taking about BOT Services.  I thought to explore it and came here with my understanding and 10 easy steps to create your first chat Bot using Azure Bot Services.

So, let’s start by understanding What is CHAT BOT? Just think Chat BOT/BOT an intelligent program which interacts with human or users. or we can say it is a simulator which simulates conversation with human users.

As mentioned that it is an intelligent program which use Machine learning to understand the pattern and respond accordingly. In Nutshell, we can say an Artificial Intelligent program which trend using Machine learning to mimic human chat.

Microsoft, Facebook, and other companies came up their own chat Bot framework.

Here in this example, we are talking about Microsoft Azure Bot Service which is super easy. You can create chat Bot and deploy & inject with different sources like Skype, your own site, slack, Facebook etc. Although, in this post, we are going to create chat bot only. Integration with other sources like Facebook, Slack is not part of this post. We will see in upcoming posts.

There is only one major prerequisite for creating your chatbot which is Azure portal account.

Now, let’s create your first Chat bot using Azure Bot Service.

Step 1:-  You will get Bot Service option which is currently in preview mode through the following option

App Services  —> Intelligence + analytics  —->  Bot Service (Preview)

Indiandotnet_AzureBot

Once you click the Bot Service you will get following option where you have to define the basic information like App Name & Location where you want the server.

1 

Step 2:-  Once you created it you will get the following screen where you need to create AppId which is a prerequisite to authenticate your bot with bot framework.

2

when you click “Create Microsoft App ID and password” button you will get the following screen. Where you  need to create password and paste in the below screen once you have done with copy /paste of password, you have to click “Finish and go back to Bot Framework” button

3

Step 3:-  You will below screen where your need to select your code languages like C#  or Node.Js.   As I like C# so I have selected C# from the below screen.

4

Just, below this language option, you have some other options as well as shown in below screen which is basically a template of your bot. You can select any template which make sense or fulfill your objective. In this example I have selected Language understanding template.

5

Step 4:- Now, when you continue with above option. The next interesting objective is to teach your Bot through LUIS where LUIS stands for Language Understanding Intelligence service.  Here, LUIS  helps to teach BOT.  You can directly login to https://www.luis.ai  and work for AppID which we created earlier in the steps.

6

7

 

Step 5 : Once you logged in LUIS you will get the following screen which a dashboard from where you can manage your Chatbot application’s model.

10

The next step is to teach your Model.

Step 7 : If you are not aware of LUIS currently just understand it is a teacher which teach your bot for the intents. Suppose you said “Hello” then your intention is greeting and so in this way we can teach our model. I will share a separate post for LUIS soon.

11

Step 8:- You can train your Model by option “Train “ in left bottom. Once your training is done and you think it is working fine then you can deploy or publish it. You can test it query parameter as shown below in the screen.

12

Step 9: Once you are done with LUIS you came back to your Azure Bot service application here you can manage the C# code and modify it further for the different intent which you set in LUIS. for example, In above screen, you will find three intents which are none, Location & Greetings. Similar way you can create multiple intents to make your chatbot robust. Here if you see the code in Azure itself and you don’t need to worry for different settings for publishing and make the code up and running.

9

Step 10:- As we added different Intents in our chat model so we need to update our C# code as well. To add any intent you need to modify “BasicLuisDialog.csx” as highlighted in yellow below.

13

if you see above image you will find we have added the our two intents which are Greetings, Locations and wrote our custom logic.

We can test right away by entering the different statement in chat in right chat panel.

Once you satisfied with your work just publish it. I hope this might be enough content for hands on your first Azure Chat Bot Service. I know you might face some challenges in LUIS but trust me it is super easy just try it your end and in any case, I am going to write another post for LUIS.

Please, share your inputs what you think about this post and Azure Bot Service.

What your face says let’s find out using Microsoft Emotion service

We always hear your face say everything. Your emotions on your face says everything. Microsoft’s did a great job to identify these expressions,these emotions  with Microsoft Cognitive Service.

Microsoft Cognitive service is an umbrella which has various APIs to help us intelligently.

Emotion API is one of them to determine the the expression or emotion in a image.

With the help of this Emotion service we can easily identify the emotion like happy, sad, fear,surprise etc.  The best part of this API is that it detect all the faces in an image and provides the emotion collection object. Another good thing about this API is it is easy to use you just need to pass the image and rest other thing is handle by API itself.

Now, I am very sure you are curious to know more and want to implement it at your end.  I am trying to share basic steps how you can use this in your project. just wanted to share that I am using MVC C# in my example .

In my example, I tried to upload  an image and passing that image to API and according to API result showing the result. so Let’s begin with step by step

Step1 :- First & for most important step is register for this API and grab your subscription key.  To get this  you have to register on https://www.microsoft.com/cognitive-services/

Once you registered you can get the subscription key from my account. As you notice in the snap below in free trial we have 30,000 transaction per month & 20 per minutes API calling facility.

Indiandotnet_Congintive_Service_Key

Once you got the key the next step is implement it in your project.

Step 2:- You can implement this via API URL or Nuget package manager in visual studio.  Just to update you that Microsoft’s Oxford team is working on this so the namespace name is Project oxford.

Indiandotnet_Nuget_Package_Oxford

In my project , I successfully installed nuget package manager

Indiandotnet_Installed_Through_nuget_Package_Manager

Step 3:- Once the Emotion package installed in your project simply create the object of Service API and call.

Pass the image steam or required parameters as per the documentation. As you can see in below image, I have created a new object of EmotionServiceClient & passing subscription parameter to avail it.

Once my object is Created, I am calling RecognizeAsync method in and passing the uploaded file stream.  This Recognize Asynch  method.

The best part is it return Emotion’s array by determining the number of faces. but in current, code I am just interested in determining the emotion of single face. So, I did code accordingly.

Indiandotnet_Calling_emotion_API

Step 4:-  To capture all the emotion’s score I have created a EmotionScore class as you can see below.

Indiandotnet_Different_Emotion_Capture

Step 5:- Once Everything setup just run the page and upload image.when you upload the image you will get emotion collection to play. See below snap in which I tried the same.

Indiandotnet_Sprised_Aayush

I tried with several expression (Thanks to my little champ“Aayush” to help me out with his cute expressions).

Indiandotnet_Different_Expression

As mentioned above you can use API URL as well to call it.

I hope you may like this new face expression API. For more information you can visit following sites

https://www.microsoft.com/cognitive-services/

https://www.microsoft.com/cognitive-services/en-us/emotion-api

Different samples https://www.microsoft.com/cognitive-services/en-us/SDK-Sample

Please, feel free to share your inputs.

Happy coding !!

RJ

The Step by Step Azure Machine Learning is good Idea Part–3

In the previous post , we discussed about different algorithm types which help us in Machine Learning. Now, In this post, we will see how to work with Azure Machine learning studio.

So, let’s start with Step by Step how to use Microsoft Azure Machine learning.

Step1 :- You have to login into Microsoft Azure portal with your credential if you have not created yet then below is the link by which you can create your Azure account.

Step1
Step 2:- Click on Portal option of Machine learning as shown below. Here you have to click on “Create AN ML WORKSPACE” when you click on this option you will find the below the screen. You need to add workplace name and select the server location.

Step2
Once you done with above steps, you will find the below screen

Step3

Step 4:- You can open Azure ML studio by clicking Open Studio icon or you can click directly login into https://studio.azureml.net 

Once you successfully logged in you will get the following screen.

Step4

In this screen, you will see different options like existing experiments created by you, samples by Microsoft etc.

Step 5:- You can check existing samples as well which are on different data analysis algorithms.

step5

Step 6:-  But, let’s not go with existing sample as we will try to create something from scratch.  For that when you click on new Experiment then you get the following screen.

There is 3 main part of the studio screen. In Left panel, you will find different data sources , filters, transformation,models,Options. You just need to drag-drop on the central panel which will be our working area where as the right side panel will show the properties.

Blank_Experiment_Template

for our test, we can use  already uploaded dataset or upload new dataset on which we want to create the model. In this example, we are using Adult Census income which is already available in dataset repository of Azure Studio.

Although, we can download same data from http://archive.ics.uci.edu/ml/datasets/Census+Income as well  and upload to Azure Studio back. If we open the link you will find different attributes like  age, sex, marital status, race country  etc.

Before going further, let’s understand  what we are going to do?

So, we are going to  predict the income and determine/predict  whether the income is more than $50,000  or not. The training model  is based on the known inputs like age,education, job type, marital status, race and  number of hours worked per week.

Just drag drop the data source (dataset) on the central panel.

Choose_Data_Source

You can visualize the data by right click on the central circle of each control. You can check data anytime in any step.

DataVisualizationtion

Step 7:- Now, this dataset  might content some missing data values and for better result or prediction we will clean these data. To achieve this we need to drag-drop the Missing data control and provide dataset inputs. Here from the property panel you can set any value and replace it with the missing data value.

In this example, we will set the value to 0 (as shown in the figure). Now the output of this missing value is a proper dataset on which we can do the analysis.

Indiandotnet_CleanMissing_Data

step 8: Once we have proper dataset then our first goal is to split the data using split control . Here splitting data divide our dataset into 2 part

Indiandotnet_Split_Data_ML

1) Training data :- With the help of this data we will train the Machine

2) Validation data :- This data is used to check the accuracy of prediction which we will apply.

We can set the ratio of these two parts by the properties.

Step 9:- Here  we need to apply the algorithm. Assuming the prediction result set we are going to use Two-class classification model. If you see in the left panel there are many classifications. For this example Two-class Boosted decision tree.

Indiandotnet_two_class_Boosted_Decision

Step 10: Now, we have data with us on this data, we have to apply the algorithm and teach the model how to evaluate. for this, we will drag drop the “Train Model” control from left panel to our designer panel .

Indiandotnet_Train_Model

Here we need to configure “Train Model” . For this just provide the output of Split data (Training data output) to the Train model and also output of two class Boosted decision control’s output to train model. Once you set both the control then your screen will look like as below

Indiandotnet_TrainModel_1

Step 10:- Now once we have provided the input data to Train Model next thing is to  provide the name of the column which we have to predict. for this click on Train Model. Check the right panel and select the column which you need to predict  by clicking Launch column selector.

Indiandotnet_Select_Column

Step 11:- So far we are good, we have created the trained model now it’s time to score the model and cross-check the accuracy of the algorithm which we have applied. To evaluate the model we will drag drop a Score Model from the left panel and connect with Train model and the other validation data output of split data. Once you are done with this just press save button and run the model. if everything works well then there would be a right checkbox appear on control.

Indiandotnet_Score_Model

Step 12:- Once everything with green checkbox check as shown in the figure .

Indiandotnet_Saved_Score_Model

We will check data visualization by right clicking on score model.

Indiandotnet_Score_Model_Visualization

You will find 2 additional columns which are Scored Label & Score probabilities. These two columns provide scored value and probability percentage

Indiandotnet_Score_Card_Visualization2

Although, we can have different methods as well to achieve the same task and we can evaluate the result of these different methods by one more control which is Evaluate Module.  We have to drag-drop this module from left panel to designer and provide the Score model’s  output to the evaluate module.

Although, we have  only one training model with two class method but we can create another train model as well as compare them by providing output of the model to Evaluate module.

Indiandotnet_Evaluate_Model

It provides a set of curves and metrics which we need to understand and choose the best train model if we are evaluating two train model.

Indiandotnet_Graph

Till now we have created a model. here are not going to save the model as a trained model and publish it we try to expose this model using a web service.

Indiandotnet_Web_Service_Input

Step 13- Add output of web service dragging and dropping the web service output control and configure as shown below figure.

Indiandotnet_Web_Service_Input_Output_ML

Step  14:- In the next step, we will publish the web service with the below button of the designer when you click on publish web service you will get the following screen after completion of the step.

Indiandotnet_Default_Api_Deployed

Here just click on Test operation and you are good to go with Azure Machine learning experience.

I hope you will try yourself. Please , keep sharing your inputs.

Enjoy

RJ

The Step by Step Azure Machine Learning is good Idea Part–2

In the last post, we have discussed Machine learning. Now in this post, we will discuss some more detail about algorithms and trust me this is one of the most important objects which a Machine learning engineer should know.

These objects are nothing but the algorithms. As a data scientist or Machine learning engineer, the first and most important thing are we should know

what is the data ?

What the result is ?

what analysis do you need to apply to get the desired result or prediction?

I know this is pretty much clear but let me explain with an example. Suppose, we have students data with high school ‘s internal assignments and we need to predict if the student can be pass in the final exam or not.

Now let me give you a brief overview of some of the algorithm  types which we may require in Azure Machine Learning. Although, there are much more types ,subtypes available but will not go in deep. So, let’s start

1) Two- Class  Algorithm Type:-

We will apply this algorithm type when the prediction result in either Yes/No or true/false or 1/0. for example, a student can be pass or not.

http://www.dreamstime.com/-image9248825

2) Classification Algorithm Type:-

This is another algorithm type which help us to predict  answer like which Kabaddi team or cricket you will cheer or which political team you will vote.

 

3) Linear Regression  Algorithm Type:-

This is one of the common prediction methods which everyone applies Smile sometimes. for example, in office, you can predict an engineer’s salary range depending upon last few engineer’s salary, prediction of property selling amount range Like this plot might be from 20 lac- 25 lac depending on last few years property price.

 

Indiandotnet_Predict

4) Anomaly detection  Algorithm Type:-

By the name, it is clear we need to find anomalies. for example, you have to determine from a group of  white cows and black cow you need to find out odd color cow means black color cow.

 

Indiandotnet_Anomoaly

 

I hope the all the above algorithm types is clear. In next post, we actually do the step by step Microsoft Azure Learning so don’t worry about that.

Please, provide your inputs