Solution architecture: Loan credit risk analyser and default modelling

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 modelling reduces the number of loans offered to borrowers who are likely to default, increasing the profitability of your loan portfolio.

Deploying to Azure

Use the following pre-built template to deploy this architecture to Azure

Deploying to Azure
Power BI SQL Database Machine Learning

Implementation guidance

Products Documentation

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

Machine Learning helps you easily design, test, operationalise and manage predictive analytics solutions in the cloud.

Power BI

Power BI provides an interactive dashboard with visualisation that uses data stored in SQL Server to drive decisions on the predictions.

Related solution architectures

Optimise marketing with machine learning

Learn how to build a machine-learning model with SQL Server 2016 with R Services to optimise and manage marketing campaigns.

Learn more

Simple digital marketing website

Start simple with the content management system that enables you to easily maintain messaging on your website in real time, from a browser, with no coding skills.

Learn more