Aleksei_Pr's avatar
Aleksei_Pr
Advocate I
5 months ago

Credit Risk Simulation Dashboard (Power BI + R)

Hi everyone 👋

 

I’d like to share a dashboard I built exploring credit risk analytics using Power BI with embedded statistical modeling in R.

The project focuses on two analytical components that go beyond typical reporting dashboards:

 

• Credit risk calculator – an interactive tool estimating a borrower’s probability of default based on input characteristics. The calculation is based on marginal effects from a GLM model, making the relationship between borrower attributes and default risk transparent.

 

• Portfolio simulation – a scenario engine that generates synthetic credit portfolios and estimates financial outcomes when the composition of borrowers changes. This allows users to explore how individual lending decisions scale into portfolio-level risk.

 

The goal of the project was to demonstrate how model-based analytics and simulation can be integrated directly into a BI dashboard to support exploratory decision-making, not just reporting.

 

Find the project description here:
Credit Risk Simulation Dashboard (Power BI + R) – Frequentist.org

 

Read the full in-depth explanation with R source code here:
Building a Credit Risk Dashboard with Power BI and R – Frequentist.org

 

Feedback is very welcome!