- Course
- Data
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.
What you'll learn
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.
Table of contents
- Version Check | 15s
- Getting Started with R in SQL Server | 57s
- Why Use R in SQL Server? | 2m 47s
- Evolution of R in SQL Server | 1m 36s
- Developer Components | 1m 7s
- Demo: Reviewing Developer Components in Visual Studio and RStudio | 1m 45s
- SQL Server Components | 1m 18s
- Demo: Installing R Services in SQL Server 2016 | 1m 51s
- Demo: Installing Machine Learning Services in SQL Server 2017 | 1m 18s
- Demo: Enabling External Scripting | 1m 40s
- Demo: Granting Permissions to Run R Scripts and Read or Write Data | 2m 11s
- Demo: Enabling Implied Authentication | 1m 56s
- Installing New Packages on SQL Server | 1m
- Demo: Installing packages Using R Tools | 2m 33s
- Demo: Installing Packages Using miniCRAN | 5m 10s
- Summary | 46s
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.