Skip Navigation

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 Azure

Deploy to Azure

View deployed solution

Power BI SQL Database Machine 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

Power BI SQL Database Machine Learning

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
Browser Application Insights CDN SQL Database Redis Cache CMS on Web App

Simple digital marketing website

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

Learn more