Usage of R in SQL Server for better data understanding

Language R for Statistical computing is powerful language for data analysis with all great features for data import from SQL environment.

Using R with SQL server data will help data scientists and data analysts prepare, explore and validate data much easier, as well as to use wide range of statistics; from univariate to multivariate.

Session will focus mainly on:
1) on connecting R Language with SQL server using standard ODBC connectors and T-SQL procedures.
2) how to validate data with using classical statistical methods on SQL transactional data.
3) how to use R output in SSRS and bring extra information to reports.

Tomaž Kaštrun
Tomaž Kaštrun is BI developer who focuses mainly on data mining, data quality and programming in SQL and .NET. He has been working with SQL Server since version 2000.

Recorded on 13 May 2014 at PASS Data Warehousing and Business Intelligence Virtual Chapter (PASS DW/BI VC)

Follow us on Twitter @PASSBIVC