R is a functional programming environment for business analysts and data scientists. It is a language that many non coders can work with, extending their knowledge from Excel for when analysts have a statistical, numerical, or probabilities-based problem based on real data that exceeds Excel capabilities. The course explains how R works with big data.

4 days - $2,100.00

Course taught by an expert Computer Coding Instructor.

Prerequisites:

Prior experience working with Excel or SAS and a basic knowledge of SQL are required.

Course Outline

From Excel or SAS to R 
Common challenges with Excel / SAS
The R Environment

Working with R Studio
Rshiny
Rpresentations
Rmarkdown

R Basics
Simple Math with R
Working with Vectors
Functions
Comments and Code Structure
Using Packages

Vectors
Vector Properties
Creating, Combining, and Iteratorating
Passing and Returning Vectors in Functions
Logical Vectors

Reading and Writing
Text Manipulation
Factors

Dates
Working with Dates
Date Formats and formatting
Time Manipulation and Operations

Multiple Dimensions
Adding a second dimension
Indices and named rows and columns in a Matrix
Matrix calculation
n-Dimensional Arrays
Data Frames
Lists

R in Data Science
AI Grouping Theory
K-means
Linear Regression
Logistic Regression
Elastic Net

R with MadLib
Importing and Exporting static Data (CSV, Excel)
Using Libraries with CRAN
K-means with Madlib
Regression with Madlib
Other libraries

Data Visualization
Powerful Data through Visualization: Communicating the Message
Techniques in Data Visualization
Data Visualization Tools
Examples

Databases, Data lakes & Additional Topics
Building connections to Databases and Data lakes, for both Python and R (using Hive server)
Methods to “query” data from database and data lakes, for both Python and R
Creating and passing macro variables. Specifically, R sprint, paste, paste0, and paste3 (not sure of the equivalent in Python).
Optional - Time Permitting Topics

R with Hadoop
Overview of Hadoop
Overview of Distributed Databases
Overview of Pig
Overview of Mahout
Exploiting Hadoop clusters with R
Hadoop, Mahout, and R

Business Rule Systems
Rule Systems in the Enterprise
Enterprise Service Busses
Drools & Using R with Drools