#Customer Churn Prediction Template with SQL Server 2016 R Services
In this template, we demonstrate how to develop and deploy end-to-end customer churn prediction models with SQL Server 2016 R Services.
This template demonstrates customer churn modeling in a retail store scenario, using customer demographic data and shopping activity data:
| File | Description |
|---|---|
| .\Data\Users.csv | Customer demographic data |
| .\Data\Activities.csv | User shopping activity data |
This template is the on-prem equivalent of the template in Cortana Analytics gallery.
This templates demonstrate how to use SQL stored procedures to do model development and operationalization. The data processing and feature engineering steps are implemented using pure SQL, while the model training, evaluation, and prediction scoring are done using SQL procedures calling R (Microsoft R Server) code, the capability provided by SQL Server R Services. These procedures can be run within SQL environment (such as SQL Server Management Studio) or called by applications to make predictions. A powershell script is provided to run the steps end-to-end.
The following is the directory structure for this template:
- Data This contains the provided sample data.
- SQLR This contains the Stored SQL procedures from data processing to model deployment. It runs in SQL environment. A Powershell script is provided to invoke the modeling steps end-to-end. See Readme files in each directory for detailed instructions.