Getting Started with R in the Microsoft Data Platform

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

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.

About the author
Stacia Misner Varga
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Securing SSAS Models
Advanced
1h 40m
Apr 10, 2020
Tuning SSAS Models
Advanced
3h 3m
Mar 10, 2020
Building Multidimensional Models in SSAS
Beginner
3h 51m
Dec 26, 2019
More courses by Stacia Misner Varga
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Stacia Varga and welcome to my course Getting Started with R in the Microsoft Data Platform. I'm a consultant, classroom instructor, and author of several technical books, and I work at Data Inspirations, a company I founded way back in 2006. R is a popular language for business analysts and data scientists and although it's been around for 20 years, it was only relatively recently introduced into the Microsoft data platform, in 2016. This course explains how to take advantage of the features related to R that are now available in the Microsoft data platform, from the SQL Server database engine to Integration Services and Power BI. Some of the major topics that we are going to cover include getting the development and server environments ready to use with SQL Server, using the RevoScaleR functions that are provided in the Microsoft distribution of R, executing R scripts by calling T-SQL stored procedures, creating predictive models using data from SQL Server and sing them to score data, and visualizing data with R functions and reporting services and Power BI. By the end of this course you'll know how to adapt your own R scripts for obtaining, transforming, analyzing, and visualizing data for use in the SQL Server and Power BI environments. Which means, before beginning the course you should be familiar with developing R scripts. Some general familiarity with SQL Server Integration Services, Reporting Services, and Power BI is also helpful, although you do not need to be an expert in these tools. You can find many complimentary courses here at Pluralsight to fill in any gaps in your knowledge of these technologies. Now I hope you'll join me on this journey Getting Started With R in the Microsoft Data Platform at Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT