Speaking Files in Microsoft Data Insight Summit 2017

Microsoft Data insight Summit 2017 has been held in Seattle from 12 to 13 Jun. It is the main conference for Microsoft Data Analysis with Power BI. All interesting and new topics in Power BI has been presented. Most of the speakers are from Microsoft product team or  experienced speakers in this fields. there are ...

Read More

Azure ML Part 9- Cross Validation: Machine Learning Prediction (6)

In the previous posts (from Part 1 to Part7), I have explained the whole process of doing machine learning inside the Azure ML, from import data, data cleaning, feature selection, training models, testing models, and evaluating. In the last post, I have explained one of the main ways of improving the algorithms performance name as “Tune ...

Read More

Azure ML Part 8- Tune Parameters: Machine Learning Prediction (5)

In the previous posts from Part 1 to 7, I have explained how to do machine learning with Azure ML. I have explained some of the main components in Azure ML that helps us to do data wrangling, train the model, feature selection and evaluating the result. The data cleaning such as SQL transformation, select ...

Read More

Azure ML Part 7: A Machine Learning Prediction scenario (4)

In the previous posts from Part 1 to 6, I have explained how to do machine learning process. The data cleaning such as SQL transformation, select specific columns, remove missing values,  Edit meta data, and normalize data.  Also, I have explained how to find relevant attributes  using Feature Selection Feature to identify which feature are more ...

Read More

Azure ML Part 6: A Machine Learning Prediction scenario (3)

In previous posts (Part 4 and Part 5), I have explained some of the main components of Azure ML via a prediction scenario. In post one the process of data cleaning (using SQL Transformation, Cleaning Missing Value, Select specific Columns, and Edit Meta Data)  has been explained. and in the second Post, I have explained how to apply ...

Read More

Azure ML Part 5: A Machine Learning Prediction scenario (2)

In the previous Post , I start to do prediction the cancer diagnosis using some laboratory data. I have explained some of the main components for doing the data cleaning such as “SQL Transformation”, “Edit Meta Data”, “Select Columns” and “Missing Values”. In this post I am going to show the rest of data cleaning ...

Read More

K-mean clustering In R, writing R codes inside Power BI: Part 6

In the previous post,I have explained the main concepts and process behind the K-mean clustering algorithm. Now I am going to use this algorithm for classifying my Fitbit data in power BI.   as I have explained in part 5, I gathered theses data from Fitbit application and I am going to cluster them using ...

Read More

Clustering Concepts , writing R codes inside Power BI: Part 5

Sometimes we just need to see the natural trend and behaviour of data without doing any predictions. we just want to check how our business data can be naturally grouped. According to the Wikipedia , Cluster analysis or clustering is the task of grouping a set of objects in such a way that objects in the same group (called a cluster) ...

Read More

Variable Width Column  Chart, writing R codes inside Power BI: Part 4

In the part 1, I have explained how to use R visualization inside Power BI. In the second part the process of visualization of five dimension in a single chart has been presented in Part 2, and finally in the part 3 the map visualization with embedded chart has been presented. In current post and next ones I ...

Read More