- Date: January 2026
- Author: Wajahat Hussain
Overview:
This Power BI dashboard was developed to provide a centralized analytical view of deposit performance across Bank of Khyber branches. The dashboard monitors key financial and operational KPIs including:
- Total Branches: 899
- Total Accounts:50K
- Active Accounts: 7,185
- Monthly Debit Turnover: Rs 1.51bn
- Total Deposits: Rs 7.53bn
It integrates branch-level, account-level, and monthly deposit data, enabling dynamic filtering through slicers and interactive visuals for executive decision-making.
The bank required a consolidated reporting system to:
- Monitor deposit growth trends (MoM comparison)
- Analyze account activity status (Active vs Closed vs Inactive)
- Identify high-income and high-value accounts
- Compare corporate deposit contributions
- Track monthly turnover fluctuations
Without such a dashboard, financial monitoring would rely on fragmented branch reports, making it difficult for management to quickly identify performance gaps and growth opportunities.
Key Insights
Strong Deposit Base:
With Rs 7.53bn total deposits, the bank demonstrates a solid liquidity position. The Monthly Debit Turnover of Rs 1.51bn indicates healthy transaction activity.
Impact: Supports liquidity planning and credit expansion decisions.
Month-over-Month Deposit Fluctuation:
From the MoM deposit comparison:
- Deposits fluctuate between Rs 586M – Rs 662M
- Noticeable dip around February (~Rs 586M)
- Strong recovery toward December (~Rs 662M)
Insight: Seasonal or fiscal cycle impacts deposits. Management can design promotional deposit campaigns during weaker months.
Account Status Distribution:
From the account status donut chart:
Closed, Inactive, and Active accounts are nearly evenly distributed (~33% each).
Critical Insight:
Only 7,185 out of 25.50K accounts are active, meaning a large portion of accounts are inactive or closed.
Business Risk:
Low account activation rate may reduce transaction-based revenue and deposit growth.
Actionable Strategy:
Customer re-engagement campaigns and account activation drives are required.
Corporate Deposit Concentration:
From the “Top 2 Companies Deposit Comparison”:
- Significant deposit concentration exists among a few large companies.
- Corporate accounts contribute heavily to deposit spikes.
Risk Insight:
High dependency on limited corporate clients may create liquidity risk if withdrawals occur.
Growth Strategy:
Diversify corporate deposit base and strengthen SME banking.
High-Value Account Monitoring:
From “Top 5 Highest Income Accounts”:
- Certain accounts generate substantial monthly income and turnover.
- These are high-net-worth or corporate-level accounts.
Impact:
The bank can:
- Assign relationship managers
- Offer premium services
Provide cross-selling opportunities (investment products, loans)
Business Growth Impact
This dashboard enables:
This dashboard supports:
Deposit growth monitoring
Liquidity risk management
Account activation strategy.
Corporate deposit diversification
High-net-worth customer management
Executive-level financial oversight
your project into a success story.