Alteryx integrates with Microsoft R

March 20, 2017

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

You can now use Alteryx Designer, the data science workflow tool from Alteryx, as a drag-and-drop interface for many of the big-data statistical modeling tools included with Microsoft R. Alteryx v11.0 includes expanded support for Microsoft SQL Server 2016, Microsoft R Server, Azure SQL Data Warehouse, and Microsoft Analytics Platform System (APS), with new workflow tools to access functionality without having to write R code manually.

Alteryx V11 adds a new XDF Input tool (and corresponding XDF Output tool) to bring data into Alteryx using the Microsoft R out-of-memory file format. In addition, you can use several other new tools to train statistical models on that data, without needing to bring the data into Alteryx itself (only the meta-data is passed from one node to the next). The models provided include:

  • Boosted Model
  • Count Regression
  • Decision Tree
  • Forest Model
  • Gamma Regression
  • Linear Regression
  • Logistic Regression

along with the ability to use stepwise methods to select variables, and scoring (prediction) using trained models.

Alteryx designer

To use Microsoft R with Alteryx, you will first need to download and install the version of Alteryx Predictive Tools corresponding with the version of R you have installed. Alteryx provides versions for both Microsoft R Server and the free Microsoft R Client, as well as open source R 3.3.2.

For more on the integration of Alteryx with Microsoft R, check out the blog post linked below.

Alteryx Community: Alteryx V11.0 Integrates with Microsoft

To leave a comment for the author, please follow the link and comment on their blog: Revolutions. offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)