CLASSROOM ON DEMAND

Get the most value with On Demand Courses for technical and business professionals.

4.85

average rating

183,406 Learner reviews

On Demand Courses

Select the modules and topics that meet the needs of your organization.

Expert Instructors

Every course delivered by experts in their field.

Tailored Options

Create a customized schedule that fits your team's busy schedule.

Master the Microsoft 365 Platform

OUR COURSES

Explore Courses

0
/0 ratings
$595.00
  • 50 Students
  • 22 Lessons
0
/0 ratings
$595.00
  • 51 Students
  • 25 Lessons
0
/0 ratings
$995.00
  • 258 Students
  • 77 Lessons

CHOOSE FROM ANY THESE

Courses categories

Analyzing Data with Microsoft R-20773

SKU R-20773
$1 595.00
1
Share this product with your friends
Analyzing Data with Microsoft R-20773
Product Details

Analyzing Big Data with Microsoft R

Overview

The main purpose of the course is to give students the ability to use Microsoft R Server to create and run an analysis on a large dataset, and show how to utilize it in Big Data environments, such as a Hadoop or Spark cluster, or a SQL Server database.

Audience profile

The primary audience for this course is people who wish to analyze large datasets within a big data environment.

The secondary audience are developers who need to integrate R analyses into their solutions.

Prerequisites

In addition to their professional experience, students who attend this course should have:

• Programming experience using R, and familiarity with common R packages

• Knowledge of common statistical methods and data analysis best practices.

• Basic knowledge of the Microsoft Windows operating system and its core functionality.

Working knowledge of relational databases.

At course completion

After completing this course, students will be able to:

• Explain how Microsoft R Server and Microsoft R Client work

• Use R Client with R Server to explore big data held in different data stores

• Visualize data by using graphs and plots

• Transform and clean big data sets

• Implement options for splitting analysis jobs into parallel tasks

• Build and evaluate regression models generated from big data

• Create, score, and deploy partitioning models generated from big data

• Use R in the SQL Server and Hadoop environments

Course Outline

Module 1: Microsoft R Server and R Client

Explain how Microsoft R Server and Microsoft R Client work.

Lessons

• What is Microsoft R server

• Using Microsoft R client

• The ScaleR functions

Lab : Exploring Microsoft R Server and Microsoft R Client

• Using R client in VSTR and RStudio

• Exploring ScaleR functions

• Connecting to a remote server

Module 2: Exploring Big Data

At the end of this module the student will be able to use R Client with R Server to explore big data held in different data stores.

Lessons

• Understanding ScaleR data sources

• Reading data into an XDF object

• Summarizing data in an XDF object

Lab : Exploring Big Data

• Reading a local CSV file into an XDF file

• Transforming data on input

• Reading data from SQL Server into an XDF file

• Generating summaries over the XDF data

Module 3: Visualizing Big Data

Explain how to visualize data by using graphs and plots.

Lessons

• Visualizing In-memory data

• Visualizing big data

Lab : Visualizing data

• Using ggplot to create a faceted plot with overlays

• Using rxlinePlot and rxHistogram

Module 4: Processing Big Data

Explain how to transform and clean big data sets.

Lessons

• Transforming Big Data

• Managing datasets

Lab : Processing big data

• Transforming big data

• Sorting and merging big data

• Connecting to a remote server

Module 5: Parallelizing Analysis Operations

Explain how to implement options for splitting analysis jobs into parallel tasks.

Lessons

• Using the RxLocalParallel compute context with rxExec

• Using the revoPemaR package

Lab : Using rxExec and RevoPemaR to parallelize operations

• Using rxExec to maximize resource use

• Creating and using a PEMA class

Module 6: Creating and Evaluating Regression Models

Explain how to build and evaluate regression models generated from big data

Lessons

• Clustering Big Data

• Generating regression models and making predictions

Lab : Creating a linear regression model

• Creating a cluster

• Creating a regression model

• Generate data for making predictions

• Use the models to make predictions and compare the results

Module 7: Creating and Evaluating Partitioning Models

Explain how to create and score partitioning models generated from big data.

Lessons

• Creating partitioning models based on decision trees.

• Test partitioning models by making and comparing predictions

Lab : Creating and evaluating partitioning models

• Splitting the dataset

• Building models

• Running predictions and testing the results

• Comparing results

Module 8: Processing Big Data in SQL Server and Hadoop

Explain how to transform and clean big data sets.

Lessons

• Using R in SQL Server

• Using Hadoop Map/Reduce

• Using Hadoop Spark

Lab : Processing big data in SQL Server and Hadoop

• Creating a model and predicting outcomes in SQL Server

• Performing an analysis and plotting the results using Hadoop Map/Reduce

• Integrating a sparklyr script into a ScaleR workflow

ON DEMAND LEARNING

Classroom experience in the cloud

Hours of Video Demonstrations & Lectures

Step by step video demonstrations and explanations from our professional certified instructors.

Work through each topic step by step with our downloadable lab exercises.

Quizzes help students retain what they have learned during the module.

Stay connected for continuous anywhere learning with our native mobile app.

Our team of instructors are available to assist with questions as you work through the training.

Our AI Learning Assistant is always available to help answer questions from anywhere in the learning platform.

Our instructors conduct live workshops covering specific topics and areas of interest related to our course offerings.

Student enrolled
50 K
Class completed
30 K
Satisfaction rate
90 %
Top instructors
200 K

STUDENTS SAY

Satisfaction is their top priority

testimonial-01
Craig Winters
MS 365 Students

Very interesting course. I loved the module-topic approach. I learned a a lot about Microsoft 365 and all of it's capabilities. I'm looking forward to taking me new knowledge back to my company.  Thank you!

testimonial-02
Sandra Li
MS Project Student

"I recommend Classroom On Demand to anyone looking to learn and upskill...If you are in the job market, you might want to add a new skill or improve your existing knowledge."

testimonial-03

Cindy McCarthy

Copilot Student

"COD courses are always covering the latest software and technologies.  I appreciated the live workshops and that the instructors were available to answer questions."

100's of students trust and study at COD