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.

Enroll now

Or start your subscription today

And complete this course over a free trial

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

Calling R Scripts in SQL Server Integration Services

Using R Scripts in Power BI

Good to know

Know what's good

, what to watch for

, 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

Save Getting Started with R in the Microsoft Data Platform to your list so you can find it easily later:

Save

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 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

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

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

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 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

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

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

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

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

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

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

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

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

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses