Machine Learning Templates with SQL Server 2016 R Services

Machine Learning Templates with SQL Server 2016 R Services

Microsoft recently launched SQL Server 2016, which, in addition to many other great features, offers in-database advanced analytics with R Services, allowing users to combine the power of SQL Server and Microsoft R Server (or Open Source R), without data leaving the database.

With SQL Server R Services, users can develop analytic models in a local R IDE (e.g., R Tools for Visual Studio or RStudio), while data resides in SQL Server, and computation happens on SQL Server (by setting the compute context to SQL Server).

Once the model is ready for production, it can be operationalized via SQL stored procedures (where R code is encapsulated inside), which can be run within SQL Server Management Studio or called by outside applications to make predictions.

To jump-start users on building advanced analytics applications with SQL Server R Services, Microsoft provides a few data science templates that address real-world scenarios, including: online fraud detection,predictive maintenance, and customer churn prediction.  These templates are sample advanced analytics solutions that demonstrate best practices and provide building blocks to help users implement a solution quickly. Each template is designed to solve a specific problem, and includes sample data, R code (which uses the highly scalable Microsoft R Server ScaleR APIs) and SQL stored procedure code that extends from data preparation and feature engineering to model training and scoring. The code runs in R IDE (with computation done in SQL Server) or SQL Server client (SQL Server Management Studio) respectively. A Windows PowerShell script is provided to run SQL stored procedures end-to-end. The collection of templates can be found here and more information on each is provided below.

Read Also:
Big Data Will Rule Your Home

Online Fraud Detection Template (SQL Server R Services) One of the important tasks of online businesses is to detect fraudulent transactions and identify transactions made by stolen payment instruments or credentials in order to reduce charge back losses. When fraudulent transactions are discovered, online store businesses typically take measures to block related accounts as soon as possible, to prevent further losses. In this scenario, you’ll learn how to use data from online purchase transactions to identify likely fraud.;



Sentiment Analysis Symposium

27
Jun
2017
Sentiment Analysis Symposium

15% off with code 7WDATA

Read Also:
Selling Hadoop to the C-Suite: It’s all about business value

Data Analytics and Behavioural Science Applied to Retail and Consumer Markets

28
Jun
2017
Data Analytics and Behavioural Science Applied to Retail and Consumer Markets

15% off with code 7WDATA

Read Also:
Big Data Will Rule Your Home

AI, Machine Learning and Sentiment Analysis Applied to Finance

28
Jun
2017
AI, Machine Learning and Sentiment Analysis Applied to Finance

15% off with code 7WDATA

Read Also:
How Big Data is used in Recommendation Systems to change our lives
Read Also:
Raw intelligence: how big data flows work, and why they matter

Real Business Intelligence

11
Jul
2017
Real Business Intelligence

25% off with code RBIYM01

Read Also:
Top 9 Big Data Security Issues You Should Watch For

Advanced Analytics Forum

20
Sep
2017
Advanced Analytics Forum

15% off with code Discount15

Read Also:
Making data analytics work for you--instead of the other way around

Leave a Reply

Your email address will not be published. Required fields are marked *