Solution architecture: Loan credit risk analyser and default modeling
Scoring credit risk is a complex process. Lenders carefully weigh a variety of quantitative indicators to determine the probability of default and approve the best candidates based on the information available to them.
This solution acts as a credit-risk analyser, helping you score credit risk and manage exposure using advanced analytics models. SQL Server 2016 with R Services equips you with predictive analytics that help assess credit or loan applications and accept only those that fall above certain criteria. For example, you might use the predicted scores to help determine whether to grant a loan, then easily visualise the guidance in a Power BI Dashboard.
Data-driven credit-risk modeling reduces the number of loans offered to borrowers who are likely to default, increasing the profitability of your loan portfolio.
Deploy to Azure
Use the following pre-built template to deploy this architecture to AzureDeploy to Azure
SQL Server R Services
|SQL Server stores the lender and borrower data. R-based analytics provide training and predicted models, as well as predicted results for consumption.|
|Machine Learning helps you easily design, test, operationalise and manage predictive analytics solutions in the cloud.|
|Power BI provides an interactive dashboard with visualisation that uses data stored in SQL Server to drive decisions on the predictions.|
Related solution architectures
Learn how to build a machine-learning model with SQL Server 2016 with R Services to optimise and manage marketing campaigns.Learn more