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.
Overview
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
This data analysis training course is meant for individuals seeking to understand and learn R, as well as those who are looking to expand their data analysis knowledge.
None, but we recommend that students have experience working with statistics and probability, as well as hands-on working knowledge of Excel.
01.
- 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
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
WHO SHOULD ATTEND
This data analysis training course is meant for individuals seeking to understand and learn R, as well as those who are looking to expand their data analysis knowledge.
PREREQUISITES
None, but we recommend that students have experience working with statistics and probability, as well as hands-on working knowledge of Excel.
COURSE OUTLINE
01.
- 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
