Explore advanced R analytics in SQL Server 2016 using R Tools for Visual Studio in this comprehensive presentation from PASS Data Community Summit. Dive into the world of predictive analytics, understanding its importance across industries and the challenges faced in adoption. Learn a three-step process for implementing predictive analytics and discover how R Tools for Visual Studio can enhance your workflow. Follow along with demos showcasing problem-solving techniques, data access methods, remote execution contexts, and parallelized algorithms. Gain insights into feature engineering, linear modeling, scoring, and model serialization. Understand how to integrate R code with SQL Server through stored procedures and prediction operators. Conclude with practical tips for implementing these advanced analytics techniques in your projects.
Advanced R Analytics in SS2016 Using R Tools for Visual Studio
PASS Data Community Summit via YouTube
Overview
Syllabus
Introduction
Questions
Sponsors
Explore PASS
About the speaker
Background
Why predictive analytics
Predictive analytics in every industry
Adoption of predictive analytics
Reality Bites
Four Big Challenges
Three Step Process
Problem of the Team
Performance
Tools for Visual Studio
Download
Features
Demos
Example Problem
Traditional GUI
Rich IDE
ODBC
Packages
Accessing Data
Remote Execution Context
Parallelized Algorithms
Feature Engineering
Query
Results
Histograms
Correlation Matrix
Running again
Linear models
Scoring
Graph and Model
Serialize Models
Deposit Models
Stored Procedures
Prediction Operator
R Code
Result
Screen Resolution
Summary
Practicality
Taught by
PASS Data Community Summit
