Bank loan portfolio dashboard
Personal project.
I loaded a bank loan dataset into MS SQL Server and wrote the queries behind the headline numbers: total applications, funded amount, average interest rate and the month on month movement, using DATEPART, CTEs and window functions. Loans were split into performing and non performing, and the results went into three linked Tableau dashboards covering the summary, the monthly and regional view, and a detail table. Every figure on the dashboards was checked back against the SQL.

Tools MS SQL Server, Tableau
