<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/alteryx-integrates-with-microsoft-r/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2017/03/alteryx-integrates-with-microsoft-r.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p>You can now use <a target="_blank" rel="nofollow" href="http://www.alteryx.com/products/alteryx-designer">Alteryx Designer</a>, 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 <a target="_blank" rel="nofollow" href="https://community.alteryx.com/t5/Analytics-Blog/Alteryx-V11-0-Integrates-with-Microsoft/ba-p/49085">expanded support</a> 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.</p>
<p>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:</p>
<ul>
<li>Boosted Model</li>
<li>Count Regression</li>
<li>Decision Tree</li>
<li>Forest Model</li>
<li>Gamma Regression</li>
<li>Linear Regression</li>
<li>Logistic Regression</li>
</ul>
<p>along with the ability to use stepwise methods to select variables, and scoring (prediction) using trained models.</p>
<p><a target="_blank" rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b8d26cc8ed970c-pi"><img title="Alteryx designer" alt="Alteryx designer" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b8d26cc8ed970c-800wi" border="0"></a></p>
<p>To use Microsoft R with Alteryx, you will first need to download and install the version of <a target="_blank" rel="nofollow" href="http://downloads.alteryx.com/predictive.html">Alteryx Predictive Tools</a> corresponding with the version of R you have installed. Alteryx provides versions for both <a target="_blank" rel="nofollow" href="https://www.microsoft.com/en-us/cloud-platform/r-server">Microsoft R Server</a> and the <a target="_blank" rel="nofollow" href="https://msdn.microsoft.com/en-us/microsoft-r/r-client-get-started">free Microsoft R Client</a>, as well as open source R 3.3.2.</p>
<p>For more on the integration of Alteryx with Microsoft R, check out the blog post linked below.</p>
<p>Alteryx Community: <a target="_blank" rel="nofollow" href="https://community.alteryx.com/t5/Analytics-Blog/Alteryx-V11-0-Integrates-with-Microsoft/ba-p/49085">Alteryx V11.0 Integrates with Microsoft</a></p>
</div>
<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2017/03/alteryx-integrates-with-microsoft-r.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/h6jjnsKljNw"></a></div>