Skip navigation

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.

Loan credit risk analyser and default modellingUsing SQL Server 2016 with R Services, lenders can predict a borrower’s credit risk and default probability to help issue fewer unprofitable loans.Power BISQL DatabaseMachine Learning

Implementation guidance

Products/Description 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 Studio

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