This project presents a dynamic and interactive Banking Analytics Dashboard built using Power BI. It focuses on key banking operations such as Loan Analysis, Deposit Analysis, and Customer Summary, enabling stakeholders to gain insights into financial health, customer behavior, and institutional performance.
- Total and segmented loan amounts
- Breakdown by:
- Banking Relationship
- Occupation
- Income Band
- Nationality
- Business Lending and Credit Card Balance visualized
- Gender-wise filtering available
- Total deposits with saving/checking account splits
- Deposit segmentation:
- By Income Band
- By Occupation
- By Nationality
- By Banking Relationship
- Year, Gender, and Advisor filters for dynamic slicing
- KPIs with % changes
- Trends in deposits and loans over time
- Risk Flags:
- High credit card balance with low income
- Clients with loans but no deposits
- Unusual business lending spikes
- Built entirely using Power BI Desktop
- Responsive and filterable layout
- Designed for financial analysts and business strategists
- Visual elements include bar charts, pie charts, line trends, and KPI cards
- Power BI Desktop (.pbix)
- DAX for dynamic measures and KPIs
- Slicer filters (Year, Gender, Advisor, etc.)
- Conditional formatting for trends
- Deposit value is highest among clients in the Medium income band
- Structural Analysts and Database Admins are top loan contributors
- Positive quarterly growth in business lending (↑5.4%) and deposits (↑8.6%)
Banking Dashboard.pbit.pbix– Power BI report file
- – Screenshots of Loan/Deposit pages
README.md– You’re here 😉
