Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from SQL Server 2017 Machine Learning Services with R Data exploration, modeling, and advanced analytics

Product type Paperback

Published in Feb 2018

Publisher Packt

ISBN-13 9781787283572

Length 338 pages

Edition 1st Edition

Languages

Tools

R Services

Concepts

Data Analysis

Authors (2):

Julie Koesmarno

Toma≈æ Ka≈°trun Kaštrun

View More author details

Table of Contents (12) Chapters

Preface

1. Introduction to R and SQL Server FREE CHAPTER

2. Overview of Microsoft Machine Learning Server and SQL Server

3. Managing Machine Learning Services for SQL Server 2017 and R

4. Data Exploration and Data Visualization

5. RevoScaleR Package

6. Predictive Modeling

7. Operationalizing R Code

8. Deploying, Managing, and Monitoring Database Solutions containing R Code

9. Machine Learning Services with R for DBAs

10. R and SQL Server 2016/2017 Features Extended

11. Other Books You May Enjoy

Leave a review - let other readers know what you think

Data visualization in R

Good data visualization draws insights from a large amount of data and serves as a medium to communicate to the audience. Fortunately, R has powerful built-in functions as well as packages that can help you to create good data visualization. In this section, we will go through a number of built-in graphical functions and R libraries to show their capabilities. Then we'll walk through an example on how to stitch it together with T-SQL. You will also learn how to display graphics from R in SQL Operations Studio. Similar to the previous section, we will be using the orders dataset and will create a data frame d to narrow down the analysis for sales persons Amy, Jack, and Hudson.

Plot

The plot() function...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (2)

Koesmarno

Julie Koesmarno is a senior program manager in the Database Systems Business Analytics team, at Microsoft. Currently, she leads big data analytics initiatives, driving business growth and customer success for SQL Server and Azure Data businesses. She has over 10 years of experience in data management, data warehousing, and analytics for multimillion-dollar businesses as a SQL Server developer, a system analyst, and a consultant prior to joining Microsoft. She is passionate about empowering data professionals to drive impacts for customer success and business through insights.

See other products by Koesmarno

Toma≈æ Ka≈°trun Kaštrun

Toma Katrun is a SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning. He holds over 15 years of experience in data analysis, data mining, statistical research, and machine learning. He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000. He is a blogger, author of many articles, a frequent speaker at the community and Microsoft events. He is an avid coffee drinker who is passionate about fixed gear bikes.

See other products by Toma≈æ Ka≈°trun Kaštrun