We may earn an affiliate commission when you visit our partners.

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.

This course is no longer available. Find something similar by browsing:

R Programming SQL Server RevoScaleR Functions Integration Services Power BI

What's inside

Syllabus

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

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Develops professional skills or deep expertise in SQL Server data platform analytics integration

Teaches skills, knowledge, and tools that are highly relevant in an academic setting

Teaches skills, knowledge, and tools that are highly relevant to industry

Covers unique perspectives are ideas that may add color to other topics and subjects

Taught by Stacia Misner Varga, who are recognized for their work in data platform integration

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

Integrating r with microsoft data platform

According to learners, this course offers a highly practical and valuable introduction to integrating R within the Microsoft Data Platform ecosystem. Students praise the instructor's clear explanations and the step-by-step demonstrations, especially highlighting how concepts are reinforced through effective hands-on labs. The modules covering RevoScaleR functions, calling R scripts in SSIS, and storing predictive models in SQL Server tables are frequently cited as particularly insightful. This course is seen as a strong starting point for SQL professionals expanding into data science. However, a significant number of reviews note that the material can be outdated, leading to setup challenges with current software versions. Some also felt it assumes prior SQL Server administration knowledge or foundational R skills, making it less suitable for true beginners.

Provides solid introduction, but not deep expert-level insights.

"A solid course for getting started. I wish it went a bit deeper into some of the advanced RevoScaleR functions..."

"It's a good starting point, but don't expect to become an R expert from this alone. Supplemental learning will be necessary."

"Good course, though a bit niche. It's clearly for a specific audience interested in Microsoft's proprietary R integrations."

Hands-on labs effectively reinforce course concepts.

"The instructor's pacing was just right, and the hands-on labs reinforced the concepts effectively."

"The step-by-step guidance was perfect, and the labs were excellent for hands-on practice."

"The course delivers on its promise to introduce R in the MS Data Platform. I liked the focus on practical applications rather than just theory."

Offers clear, step-by-step guidance for R integration.

"This course was a fantastic introduction to integrating R within my SQL Server and Power BI workflows. The instructor explained complex concepts clearly..."

"Highly recommend for data professionals. The course is well-structured, and the instructor is knowledgeable. I especially liked the real-world examples..."

"Absolutely brilliant! The clarity of the instructor and the real-world scenarios were exceptional. I'm now confident in integrating R into my data workflows."

Assumes prior knowledge in SQL Server admin and R basics.

"The course is okay, but it assumes you're very comfortable with SQL Server administration, which I'm not."

"Decent overview, but not for true beginners in either R or SQL Server. If you're strong in one and weak in the other, you'll struggle."

"I had some issues setting up the R Services on SQL Server initially... Definitely for those who already have some SQL Server administration experience."

Course content feels dated, complicating environment setup.

"I found this course somewhat outdated. The versions of SQL Server R Services and R packages mentioned seemed to be from a few years ago."

"While the instructor is knowledgeable, the course material is clearly showing its age. Several R packages and SQL Server components have evolved..."

"A frustrating experience due to outdated content and lack of thorough setup guidance. I spent hours trying to reconcile the course material..."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Getting Started with R in the Microsoft Data Platform with these activities:

Review R Fundamentals

Show steps

Warms up your knowledge of R before delving into the course material, which assumes a certain level of familiarity with the language.

Browse courses on R

Show steps

Review the basics of R syntax and data types.
Re-familiarize with common data manipulation and analysis functions.
Practice creating visualizations with R's built-in plotting capabilities.

Read 'The R Book' by Michael J. Crawley

Show steps

Provides a solid foundation in R programming, complementing the course material with a comprehensive and authoritative reference.

View The R Book on Amazon

Show steps

Read and study selected chapters relevant to the course topics.
Work through the exercises and examples presented in the book to reinforce your understanding.
Reference the book throughout the course for clarification or additional insights.

Connect with Experienced R Practitioners

Show steps

Offers personalized guidance and support from experts in the field, accelerating your progress and deepening your understanding.

Show steps

Identify R professionals in your network or through online platforms.
Reach out and express your interest in mentorship.
Schedule regular meetings to discuss your progress and seek advice.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Attend R Community Meetups

Show steps

Connects you with other R users, fostering a sense of community and providing opportunities to learn from peers.

Show steps

Locate and attend local R community meetups.
Engage with other attendees, sharing knowledge and experiences.
Explore potential collaborations or projects.

SQL Server and R Integration Exercises

Show steps

Strengthens your understanding of how SQL Server and R interact, which is essential for integrating analytics into your on-premises solutions.

Show steps

Complete the exercises in the course module on 'Getting Started with R in SQL Server 2016'.
Practice using RevoScaleR functions to explore SQL Server data.
Implement R scripts as stored procedures and predictive models in SQL Server.

Explore Advanced R Topics

Show steps

Broadens your knowledge of R by delving into advanced topics that enhance your capabilities.

Show steps

Research and follow tutorials on topics such as machine learning, natural language processing, or time series analysis with R.
Experiment with different R packages and functions to deepen your understanding.
Apply the acquired knowledge to solve real-world data analysis or modeling problems.

Build an R Predictive Model in Power BI

Show steps

Develops your practical skills in using R to create predictive models and visualizing results in Power BI.

Show steps

Design and develop an R predictive model using the techniques learned in the course.
Integrate the R model into Power BI using the R visuals.
Create a Power BI report that leverages the R model for data visualization and insights.

Develop an R-Based Data Analysis Application

Show steps

Challenges you to apply your R skills in a meaningful project, solidifying your understanding and reinforcing your learning.

Show steps

Identify a problem or opportunity that can be addressed using R.
Design and develop an R-based solution, including data acquisition, analysis, and visualization.
Test and refine the application to ensure accuracy and usability.

Career center

Learners who complete Getting Started with R in the Microsoft Data Platform will develop knowledge and skills that may be useful to these careers:

Statistician

Statisticians collect, analyze, and interpret data. This course will help you build a foundation in R, which is a popular language for statistical analysis. You will learn how to use R to perform statistical analysis, build predictive models, and visualize data. This course will give you the skills you need to get started in a career as a Statistician.

See salaries and explore the career path for Statistician

Data Scientist

Data Scientists use their knowledge of statistics, machine learning, and programming to extract insights from data. This course will help you build a foundation in R, which is a popular language for data science. You will learn how to use R to perform data analysis, build predictive models, and visualize data. This course will give you the skills you need to get started in a career as a Data Scientist.

See salaries and explore the career path for Data Scientist

Operations Research Analyst

Operations Research Analysts use mathematical and statistical models to solve business problems. This course will help you build a foundation in R, which is a popular language for operations research. You will learn how to use R to build optimization models, simulate business processes, and analyze data. This course will give you the skills you need to get started in a career as an Operations Research Analyst.

See salaries and explore the career path for Operations Research Analyst

Data Engineer

Data Engineers design, build, and maintain data pipelines. This course will help you build a foundation in R, which is a popular language for data engineering. You will learn how to use R to extract data from various sources, clean and transform data, and load data into data warehouses. This course will give you the skills you need to get started in a career as a Data Engineer.

See salaries and explore the career path for Data Engineer

Actuary

Actuaries use mathematical and statistical models to assess risk and uncertainty. This course will help you build a foundation in R, which is a popular language for actuarial science. You will learn how to use R to build actuarial models, analyze data, and communicate insights to stakeholders. This course will give you the skills you need to get started in a career as an Actuary.

See salaries and explore the career path for Actuary

Data Architect

Data Architects design and manage data systems. This course will help you build a foundation in R, which is a popular language for data engineering. You will learn how to use R to design data pipelines, build data warehouses, and manage data quality. This course will give you the skills you need to get started in a career as a Data Architect.

See salaries and explore the career path for Data Architect

Machine Learning Engineer

Machine Learning Engineers design, develop, and deploy machine learning models. This course will help you build a foundation in R, which is a popular language for machine learning. You will learn how to use R to build predictive models, evaluate model performance, and deploy models to production. This course will give you the skills you need to get started in a career as a Machine Learning Engineer.

See salaries and explore the career path for Machine Learning Engineer

Quantitative Analyst

Quantitative Analysts use mathematical and statistical models to analyze data and make predictions. This course will help you build a foundation in R, which is a popular language for quantitative analysis. You will learn how to use R to perform data analysis, build predictive models, and visualize data. This course will give you the skills you need to get started in a career as a Quantitative Analyst.

See salaries and explore the career path for Quantitative Analyst

Database Administrator

Database Administrators manage and maintain databases. This course will help you build a foundation in R, which is a popular language for data management. You will learn how to use R to query databases, create and manage tables, and perform data analysis. This course will give you the skills you need to get started in a career as a Database Administrator.

See salaries and explore the career path for Database Administrator

Business Analyst

Business Analysts use data to help businesses make better decisions. This course will provide you with the skills you need to use R to analyze data, identify trends, and communicate insights to stakeholders. By the end of this course, you will be able to use R to help businesses improve their operations and make better decisions.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use data to make investment decisions. This course will provide you with the skills you need to use R to analyze financial data, identify trends, and communicate insights to stakeholders. By the end of this course, you will be able to use R to help businesses make better investment decisions.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers collect, analyze, and interpret data to understand consumer behavior. This course will provide you with the skills you need to use R to analyze market research data, identify trends, and communicate insights to stakeholders. By the end of this course, you will be able to use R to help businesses make better marketing decisions.

See salaries and explore the career path for Market Researcher

Risk Analyst

Risk Analysts use data to identify and assess risks. This course will provide you with the skills you need to use R to analyze risk data, identify trends, and communicate insights to stakeholders. By the end of this course, you will be able to use R to help businesses make better risk management decisions.

See salaries and explore the career path for Risk Analyst

Data Analyst

Data Analysts play a critical role in helping organizations make informed decisions by collecting, cleaning, and analyzing data. This course, Getting Started with R in the Microsoft Data Platform, will provide you with the skills you need to use R, a popular language for statistical analysis and visualizations, to get, transform, and score data. By the end of this course, you will be able to integrate R into your Microsoft data platform workflows, which will make you a more valuable asset to any organization.

See salaries and explore the career path for Data Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. This course will help you build a foundation in R, which is a popular language for data analysis and visualization. You will learn how to use R to develop software applications that can help businesses make better decisions. This course will give you the skills you need to get started in a career as a Software Engineer.

See salaries and explore the career path for Software Engineer

Reading list

We've selected nine books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Getting Started with R in the Microsoft Data Platform.

Exam 70-413 Designing and Implementing a Server...

Save

Is the official documentation for Reporting Services, providing a comprehensive reference for the product.

Getting Started with R in the Microsoft Data Platform

What's inside

Syllabus

Traffic lights

Save this course

Reviews summary

Integrating r with microsoft data platform

Activities

Career center

Reading list

Share

Similar courses