Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
03-16-2026 04:27 AM
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!
eyJrIjoiNTkzOTc5OTQtYmQxNS00YzlmLWE3OWYtY2JjYWUwNTI3MGEzIiwidCI6ImZmYzg3OTVlLTAxODUtNDg5Yi05ZGE2LTQ5MDI0MTJmMDNhMCIsImMiOjl9
Here's another my dashboard: Consumer Financial Complaints Dashboard in this gallery. Comments and questions welcome!