Getting Started with R in the Microsoft Data Platform

R is a popular language for statistical analysis and visualizations. This course teaches you how to install R packages on SQL Server, use functions from Microsoft’s R distribution, and execute R packages using a variety of data platform options.

The Microsoft data platform now supports the integration of analytics into your on-premises solutions by using R scripts. This course, Getting Started with R in the Microsoft Data Platform, explores the various options available across the data platform for using R. After learning how to configure your SQL Server environment to support R, you learn how to implement R scripts as stored procedures, store R predictive models in tables, and configure security for execution of R scripts. Next, you learn how to execute R scripts to get, transform, or score data using Integration Services and Power BI. Finally, you learn how to add R visualizations into Reporting Services and Power BI reports. By the end of this course, you will know how to integrate R into your Microsoft data platform workflows.

• Course Overview 2mins
• Getting Started with R in SQL Server 2016 28mins
• Exploring SQL Server Data with RevoScale R Functions 44mins
• Building Predictive Models in SQL Server with RevoScaleR Functions 43mins
• Calling R Scripts in SQL Server Integration Services 17mins
• Using R Scripts in Power BI 37mins