#SQL STUDIO TUTORIAL HOW TO#
#SQL STUDIO TUTORIAL INSTALL#

#SQL STUDIO TUTORIAL HOW TO#

The logistic regression and histogram are simple examples that will be used to show how to embed and work with your R code in SQL Server. Note the positive/right skew where most orders have fifty items or less and the rest of the bins compose a long tail to the right.ДonвЂ™t worry about analyzing this data. You could take it a step further on your own and use the rxPredict() function with new data to classify whether or not additional orders would be fulfilled same day or not.ДЇinally, run the following code to produce a histogram displaying the quantity of items per order. Note that you now use the rxLogit() function (equivalent to glm above). Otherwise, run the following code to train a logistic regression model using the SQL data object. If you wanted to bring your data into a local data frame, you can use rxImport with the in-database object. The following code using rxImport() is here for information more than function. Run the following code to build your SQL query. Run the following code to change your compute context from local to SQL Server. You will also change from traditional functions to the ScaleR вЂњ rxвЂќ-prefixed functions from the RevoScaleR package. Now that youвЂ™ve seen a quick overview of the traditional method, you will switch your compute context and process data in-database instead of locally. Fitting an accurate model is not the goal of this tutorial, but in the real world, you would go through the appropriate training and testing steps. You will now run a very basic logistic regression using the built-in glm function on the local data frame and view the coefficients. You should also notice the orders data frame in your environment window with 29913 observations and 5 variables. The other variables are unmodified key values from the Fact.Order table. SameDayFulfillment is an engineered feature with a 0/1 value noting if an order was packed the same day that it was placed.

Run the following code to load data and get the first few observations. You will create an ODBC connection and import data from SQL Server into a local data frame named orders. You will now look at one traditional method to analyze data from SQL Server. For simplicity, it does not join to any dimensions to get descriptions. The source query is a very simple query running against the WWI Fact.Order table. Once your connection string is ready, run the code to add and source.query to your R environment. You may need to change the trusted connection to Uid= and Pwd= depending on your authentication type. Replace in with your SQL Server instance. Run the setup code in sequence to reference the RODBC and RevoScaleR libraries and reset your compute context to вЂњlocalвЂќ if you have already been using a SQL compute context outside of this tutorial. RevoScaleR should already be available if you have Microsoft R Client installed.

#SQL STUDIO TUTORIAL INSTALL#

Install the RODBC package (i.e.В install.packages(вЂњRODBCвЂќ) ) if needed. In RStudio, open the RevoScaleR-vs-Traditional.R file.

Sql studio tutorial