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 0m
- Getting Started with R in SQL Server 1m
- Why Use R in SQL Server? 3m
- Evolution of R in SQL Server 2m
- Developer Components 1m
- Demo: Reviewing Developer Components in Visual Studio and RStudio 2m
- SQL Server Components 1m
- Demo: Installing R Services in SQL Server 2016 2m
- Demo: Installing Machine Learning Services in SQL Server 2017 1m
- Demo: Enabling External Scripting 2m
- Demo: Granting Permissions to Run R Scripts and Read or Write Data 2m
- Demo: Enabling Implied Authentication 2m
- Installing New Packages on SQL Server 1m
- Demo: Installing packages Using R Tools 3m
- Demo: Installing Packages Using miniCRAN 5m
- Summary 1m
- Exploring SQL Server Data with RevoScaleR Functions 1m
- R Script Development 1m
- RevoScaleR Functions 1m
- Demo: Introducing the RxTextData Function 4m
- Demo: Defining Column Structures Before Loading a Table 2m
- Demo: Using the RxSQLServerData and rxDataStep Functions 2m
- Demo: Exploring Data with rx Functions 3m
- Demo: Using Variations of rxSummary 2m
- Demo: Working with an XDF File 2m
- Demo: Importing from SQL Server to a Data Frame 1m
- Demo: Configuring Compute Context for SQL Server 2m
- Demo: Using rxHistogram 2m
- Demo: Visualizing SQL Server Data with R 2m
- Unhandled SQL Data Types 0m
- Demo: SQL versus R Data Types 1m
- Demo: SQL versus R Data Types 1m
- Wrapping R Code in T-SQL 1m
- Demo: Introducing sp_execute_external_script 3m
- Demo: Operationalizing an R Script for SQL Server 5m
- Demo: Generating Image Files with R in SQL Server 2m
- R Script Consumption 1m
- Demo: Displaying an R Visualization in Reporting Services 3m
- Summary 1m
- Building Predictive Models in SQL Server with RevoScaleR Functions 1m
- The Predictive Modeling Process 2m
- Demo: Preparing Data for Predictive Modeling 4m
- Demo: Preparing and Storing Train and Test Data in SQL Server 3m
- Predictive Modeling Types 2m
- Demo: Using rxDForest 4m
- Demo: Reviewing the Generated Decision Forest Model 2m
- Demo: Using the rxPredict and rxRocCurve Functions 5m
- Model Generation and Consumption 1m
- Demo: Generating and Storing a Predictive Model on SQL Server 5m
- Demo: Using a Predictive Model to Score Data on SQL Server 4m
- Native and Realtime Scoring 1m
- Demo: Creating a Model for Native Scoring on SQL Server 2017 3m
- Demo: Using the Predict Function for Native Scoring 3m
- Demo: Configuring and Executing Realtime Scoring in SQL Server 3m
- Summary 1m
- Using R Scripts in Power BI 2m
- Get and Transform Data 1m
- Demo: Configuring R Scripting in Power BI 2m
- Demo: Reviewing an R Script to Get Data for Power BI 4m
- Demo: Creating an R Query in Power BI 5m
- Visualize Data 1m
- Demo: Preparing an R Visual in Power BI 5m
- Demo: Working with R Script in Power BI 4m
- Demo: Cross-filtering R Visuals 3m
- Other Options for Using R Visuals in Power BI 1m
- Demo: Working with Showcase and Custom R Visuals 6m
- Publishing Content Containing R 2m
- Summary 1m
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.