Decision Tree: Power BI- Part 2

In the last Part, I have talked about the main concepts behind the Decision Tree. In this post, I will show how to use decision tree component in Power BI with the aim of Predictive analysis in the report. in next post, I will explain how to fetch the data in Power Query to get a dynamic ...

Read More

Azure ML workbench-Data Wrangling -Part 3

In the last posts, I have explained how to install Azure ML workbench and how to run a sample and check the accuracy. In this post, I am going to show how to do data wrangling using Azure ML workbench. Just click on the left menu, on the database icon. There are 2 separate groups ...

Read More

Time series Series with Power BI- Forecast with Arima-Part 12

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle the seasonality parameters. in the last example for the age of death of the England king, ...

Read More

File Managment in Azure Data Lake Store(ADLS) using R Studio

In this post, I am going to share my experiment in how to do file management in ADLS using with R studio environment, So how it works? we able to manage ADLS from Rstudio environment using R scripts, so without accessing the ADLS we able to manage the portal, bring Data from ADLS to R ...

Read More

Time series Series with Power BI- Arima Model-Part 11

In the last post, I have explained the d value for model ARIMA (p,d,q). In this post, I am going to show how to identify the p and q values as below. one of the main difference between exponential smoothing and Arima is that Arima considers the correlation of a value at a time with ...

Read More

Time series Series with Power BI- Arima Model-Part 10

In this post, I want to explain the ARIM model (Autoregressive Integrated Moving Average). Exponential smoothing could not consider the relationship between the values in the different time span. while ARIMA able to handle these data. ARIMA Model needs three variables. ARIMA(p,d,q) First, let start with explanation of d value what is d? The first ...

Read More

Draw Slope Chart in Power BI: Part 8

Slope chart can be used for comparing data between two different time periods. it is a very easy way to depict the difference between to time, two elements or any other two attributes. The slope charts can be used to study the correlation between variables or to study the change in the same variable between ...

Read More

New Series of Time Series: Power BI Custom Visual (Part 5)

In previous posts, I have explained some basic concepts of time series. In the first post I have explained the basic concepts of time series, and in second and third posts I have explained: “Exponential Smoothing” for forecasting data without trend, and with the trend. In the last post, I have explained how we can ...

Read More

New Series of Time Series: Part 3 (Holt’s Exponential Smoothing)

In the last posts, I have explained the main concepts behind the Timeseries (Post 1) and  in the second one a simple forecasting approach name as “Exponential Smoothing” has been proposed Post 2. In this post I am going to show how to do see the error of forecasting and also how to forecast when ...

Read More