Expanded

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.
Course info
Rating
(20)
Level
Intermediate
Updated
Mar 8, 2018
Duration
2h 52m
Table of contents
Course Overview
Getting Started with R in SQL Server 2016
Exploring SQL Server Data with RevoScale R Functions
Building Predictive Models in SQL Server with RevoScaleR Functions
Calling R Scripts in SQL Server Integration Services
Using R Scripts in Power BI
Description
Course info
Rating
(20)
Level
Intermediate
Updated
Mar 8, 2018
Duration
2h 52m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
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
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.

More from the author
Getting Started with Power BI
Beginner
4h 56m
Sep 3, 2021
Modeling Data in Power BI
Beginner
4h 56m
May 12, 2021
Building Your First Power BI Report
Beginner
1h 31m
Mar 1, 2021
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.