<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/predicting-hospital-length-of-stay-using-sql-server-r-services/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2017/05/hospital-length-of-stay.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p>Last week, my Microsoft colleagues Bharath Sankaranarayan and Carl Saroufim presented a live webinar showing how you can predict a patient's length of stay at a hospital using SQL Server R Services. The recorded webinar is <a target="_blank" rel="nofollow" href="https://info.microsoft.com/predicting-hospital-stay-sql-server-r-services-ondemand.html">available for on-demand viewing</a> now. (Registration is required to view.)</p>
<p>The webinar is based on the Machine Learning Solution Template <a target="_blank" rel="nofollow" href="http://aka.ms/hospital-los">Predicting Length of Stay in Hospitals</a>, which we <a target="_blank" rel="nofollow" href="http://blog.revolutionanalytics.com/2017/03/hospital-length-of-stay.html">covered here on the blog back in March</a>. The solution is based on an instance of the <a target="_blank" rel="nofollow" href="https://azuremarketplace.microsoft.com/en-us/marketplace/apps/microsoft-ads.standard-data-science-vm">Data Science Virtual Machine</a>, which makes it easy to try it yourself. Just click the &quot;<a target="_blank" rel="nofollow" href="https://start.cortanaintelligence.com/Deployments/new/hospital">Deploy</a>&quot; button to create your own instance in Azure with all of the data and scripts preloaded.</p>
<p>In the webinar, you'll learn how to use patient admission and clinical data to predict how long a patient is likely to remain in the hospital. The data is included as a flat file in the VM, and contains the columns shown below. (Note: while the Solution is based on a real-world deployment, these data are simulated.)</p>
<p><a target="_blank" rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b8d280d87b970c-pi"><img title="Hospital variables" alt="Hospital variables" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b8d280d87b970c-800wi" border="0"></a></p>
<p>The webinar will take you through the process of using Microsoft R Server (included in the VM) to import the data and upload it to SQL Server. You'll then apply R functions to the data in SQL Server to explore the summary data, clean the data and impute missing values, and create new columns for analysis. You'll then train Random Forest and Gradient Boosted Tree models to generate predictions, storing the final model back in SQL Server.</p>
<p>These predictions are used by hospital managers and ward staff to manage patient populations. The predictions are part of a PowerBI dashboard, which you can see and interact with by clicking the &quot;Try It Now&quot; button on the <a target="_blank" rel="nofollow" href="https://gallery.cortanaintelligence.com/Solution/Predicting-Length-of-Stay-in-Hospitals-1">Solution page</a>.</p>
<p>The detailed abstract for the webinar is below, and you can launch the on-demand viewing using the link at the bottom of this post.</p>
<p>Being able to accurately estimate how long a patient is likely to need a bed is important for running an efficient hospital and delivering effective healthcare. To help the administration manage hospital resources, the Hospital Length of Stay solution estimates the number of days the patient is expected to stay before discharge. The solution shows how easy it is to develop with SQL Server with R Services and demonstrates how you can leverage Microsoft R Server in the health care domain.</p>
<p>With this Microsoft R Server Solution, we will demonstrate the short time to value and show how easy it is to build solutions by using these templates. These solutions are fully customizable and extensible and you can experience this with a few clicks and a Azure Subscription. Both the solutions leverage Cortana Intelligence Suite patterns and the <a target="_blank" rel="nofollow" href="https://info.microsoft.com/data-science-virtual-machine.html">Data Science VM</a>.</p>
<p>Microsoft webinars: <a target="_blank" rel="nofollow" href="https://info.microsoft.com/predicting-hospital-stay-sql-server-r-services-ondemand.html">Predicting Hospital Length of Stay using SQL Server with R Services</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/05/hospital-length-of-stay.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/L-zr3Ru8c2E"></a></div>