Edition 2 of Free Book: Power BI from Rookie to Rock Star

As promised, here is the second edition (March 2017) of Power BI book; from Rookie to Rock Star as PDF. We are still working on other methods of sharing this book (Kindle, paperback…). In this new version March’s posts are added which are; M or DAX? Content Packs, Shape Map, and IF or Filter in Read more about Edition 2 of Free Book: Power BI from Rookie to Rock Star[…]

Azure Machine Learning Part 2: Azure ML Environment

In the previous post, the main concepts of Machine Learning has been explained very briefly. However, if we want to talk about Machine Learning, it needs to read a whole book. In the second part, I am going to show the main Azure ML environment and its essential components. Azure ML has two type of Read more about Azure Machine Learning Part 2: Azure ML Environment[…]

Azure Machine Learning Part 1: Introduction

In this series, I will talk about Microsoft cloud machine learning: Azure ML. I will explain the main components and concepts of Azure ML. In the first post, I will talk about the Machine Learning concepts and Azure ML. What is Machine Learning: Machine learning according to Wikipedia is: “subfield of computer science that gives Read more about Azure Machine Learning Part 1: Introduction[…]

Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3

K Nearest Neighbour (KNN ) is one of those algorithms that are very easy to understand and it has a good level of accuracy in practice. In Part One of this series, I have explained the KNN concepts. In Part 2 I have explained the R code for KNN, how to write R code and how Read more about Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3[…]

Prediction via KNN (K Nearest Neighbours) R codes: Part 2

In the previous post (Part 1), I have explained the concepts of KNN and how it works. In this post, I will explain how to use KNN for predict whether a patient with Cancer will be Benign or Malignant. This example is get from Brett book[1]. Imagine that we have a dataset on laboratory results of some patients Read more about Prediction via KNN (K Nearest Neighbours) R codes: Part 2[…]

Prediction via KNN (K Nearest Neighbours) Concepts: Part 1

K Nearest Neighbor (KNN ) is one of those algorithms that are very easy to understand and  has a good accuracy in practice. KNN can be used in different fields from health, marketing, finance and so on [1]. KNN is easy to understand and also the code behind it in R also is too easy Read more about Prediction via KNN (K Nearest Neighbours) Concepts: Part 1[…]

Make Business Decisions: Market Basket Analysis Part 2

In the Part one I have explained the main concepts of Market basket analysis (associative Rules) and how to write the code in R studio. In this post I will explained the process of doing market basket analysis in Power BI. for doing this post I have used the data set from [1]. Power BI Desktop, is Read more about Make Business Decisions: Market Basket Analysis Part 2[…]

IF and Filter are Different! Be Careful (DAX)

DAX has many functions to write conditional expressions. For example you might want to calculate sum of sales amount for all “Red” products. you can achieve it by using SUMX or Calculate, and functions such as IF or Filter to write a conditional expression for product color to be equal to “Red”. At the first Read more about IF and Filter are Different! Be Careful (DAX)[…]

Part 4 – Live Streaming Weather Station with Cortana Analytics (Online Data Analytics with Azure ML)

In previous posts, I have showed the process of creating a live weather data streaming with Cortana. In Part 1 the process of setting up Raspberry PI3 and weather station sensor has been explained. Following, in Part 2, the process of setting up the Event Hub as a median to digest the data from Raspberry PI Read more about Part 4 – Live Streaming Weather Station with Cortana Analytics (Online Data Analytics with Azure ML)[…]

Live Streaming Weather Station with Cortana Analytics – Part 3

In previous posts (part 1 and part 2), I have explained the process of data live streaming. In the first post, I have explained the process of setting up the Raspberry PI 3 and Weather station. In the second one, I have explained the process of setting up the Event Hub that helps us to. In Read more about Live Streaming Weather Station with Cortana Analytics – Part 3[…]