We may earn an affiliate commission when you visit our partners.
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.

Read more

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

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

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
Read more
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
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
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
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
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
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
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
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

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.
Comprehensive reference for the R programming language, covering a wide range of topics from basic syntax to advanced statistical modeling techniques.
Is the official documentation for Power BI, providing a comprehensive reference for the product.
Provides a practical introduction to R, covering a wide range of topics from data manipulation and visualization to statistical modeling and machine learning.
Provides a comprehensive introduction to the R programming language and its application to data science tasks such as data wrangling, visualization, and statistical modeling.
Provides a more advanced treatment of R, covering topics such as object-oriented programming in R, writing R packages, and advanced statistical modeling techniques.
Provides a very basic introduction to the R programming language, making it suitable for absolute beginners with no prior programming experience.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Getting Started with R in the Microsoft Data Platform.
Power BI & Power Virtual Agents
Most relevant
Data Visualization in R with ggplot2
Most relevant
Data Analysis and Visualization with Power BI
Most relevant
Analyzing and Visualizing Data with Power BI (PL-100)
Most relevant
Microsoft Power BI - The Complete Masterclass [2020...
Most relevant
Creative Designing in Power BI
Most relevant
Data Visualization Capstone
Most relevant
Data Analysis with R Programming
Most relevant
Data Engineering Capstone Project
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser