Business Intelligence

SQH06 Where Does R Fit into Your SQL Server Stack?


9:30am - 10:45am

Level: Introductory to Intermediate

Stacia Varga

Microsoft Data Platform MVP

Consultant, Educator, and Author

Now that SQL Server includes support for R in the database, how does this change your BI implementation options? In this session, we start with a brief introduction to R and explain why it's increasingly popular, the typical development workflow, which tools you can use, common use cases and where it fits into the latest Microsoft stack at a high level. Then we'll review how to implement R Services so that you can use R with SQL Server data, including how to install R packages on SQL Server, how to use rx functions and how to operationalize R in SQL Server. Then we explore options for using R to prepare data for analytics using SQL Server Integration Services (SSIS) or Power BI and how to report and visualize data using SQL Server Reporting Services (SSRS) or Power BI.

You will learn:

  • How to configure SQL Server 2016 or 2017 for R
  • How to explore and prepare data for analytics by using R in the Microsoft stack
  • How to use SQL Server and R for predictive analytics