## R Chart into SSRS (Show Chart in SSRS)-Part 3

Posted on May 8, 2018

In the last post, I have shown how you able to install an external package like ggplot2 in ML services and also you see how we can use data in SQL Server to create a chart in R studio. In this post, I am going to show you how to create a chart in SQL ...

## R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2

Posted on May 3, 2018

“In the last post, you have seen how we can create a chart by importing data from SQL Server 2017. By doing this, we have a reliable code for drawing chart. Now, we sure our codes work fine, we can put the codes in SQL Server 2017. In this post, I am going to show ...

## R Chart into SSRS (get data from SQL and create ggplot chart in R)-Part 1

Posted on May 1, 2018

In this and next post, I am going to show you how to connect to SQL Server to get data from there, then create a table chart using ggplot2 package inside SQL Server 2017 and then show the chart in SSRS. there are multiple steps for that we need to follow Get data and create ...

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

Posted on Oct 2, 2017

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 ...

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

Posted on Sep 25, 2017

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 ...

## Draw Slope Chart in Power BI: Part 8

Posted on Sep 5, 2017

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 ...

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

Posted on Aug 29, 2017

In the last three parts, I have explained about the time series R custom Visual we have in Power BI. as you remember we have 3 main time series chart in Power BI store (see below): Decompose of time series (trend, seasonality and irregular components). the two other custom visual help us to do forecasting ...

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

Posted on Aug 25, 2017

In the last post, I have explained how to do time series forecast using “Exponential Smoothing” approach in Power BI. I start to explain the main parameters that we need to set up. The main concepts behind of most of these parameters have been explained in previous posts (Post 4, Post 3, Post 2, and ...

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

Posted on Aug 18, 2017

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 ...