Integrating R code in reports and visualizations

In this section, we will delve into familiar reports and visualization Tools that are available in the Microsoft BI stack, such as SQL Server Reporting Services (SSRS), Power BI, and Mobile Reports.

There are three main use cases for integrating R graphics with SQL Server.

1. Get a dataset output representing data / statistical analysis, training model, or predictive model:

Figure 4-13 SQL Server Machine Learning Services process for data analysis in R

Execute sp_execute_external_script to run R to produce a dataset output as illustrated in (1) + (2) + (3). The data set output (3) could be from data/statistical analysis, a training model, predictive output, and so on. In SQL Server, we can optionally process the output further (4), for example, saving it into a table or passing it on to another stored procedure.

2. Get a dataset output...