This online instructor led training course provides the knowledge and skills to R, a programming language widely used among statisticians and data miners for developing statistical software and data analysis. In this course students will learn key topics including the history of R, navigating R studio, loading and maintaining packages, loading data into R, summarizing data in R, and more.

Course Instructor: Doug Perez

Course Outline

  • What is R? What is Microsoft R Open?
  • Introduction to R Studio and other R language tools
  • Loading packages
  • Loading data into R
  • Basic expressions in R
  • Basic summaries
  • Data inspection
  • Tidy data and the Tidyverse
  • Creating visualizations with R
  • Microsoft R Open visualizations
  • Exploratory data analysis
  • Sharing the data from R
  • PowerBI and R
  • SQL Server and R
  • R in Microsoft Azure

Skills Learned

After completing this online training course, students will be able to:

  • Setup the R environment
  • Load and maintain packages
  • Load data into R
  • Connect R with SQL Server
  • Summarize data in R
  • Clean and prepare data
  • Understand Tidyverse
  • Create visuals using one and two variables
  • Run R in T-SQL queries
  • Understand R and PowerBI interactions
  • Understand Azure R programming