BI Project for Banking Sector
Power BI Desktop
286.78K
95.23K
1.57K
5.36K
Total Deposit
Total Customers
Priority Customers
Priority Deposit
PKR In Millions
City Name
Account Type
Total
Deposit
Select all
Lahore
CDRs
%GT Total
Deposit
Total
Customers
%GT Total
Customers
172795
60.25%
42606
44.74%
Gujranwala
91588
31.94%
17382
18.25%
Demand
Faisalabad
20055
6.99%
24095
25.30%
Saving
Sialkot
2343
0.82%
11144
11.70%
TD
Total
286781
100.00%
95227
100.00%
Total Customers by ACCOUNT_STATUS
Total Customers by ACCOUNT_TYPE
High Cost
104K (3…)
Normal
183K (63.68…)
Total Deposit by ACCOUNT_TYPE
Demand 17K (5.84%)
CDRs 5K (5.76%)
DORMANT
31K (32.8…)
High Cost Deposit
Saving
34K (35.7…)
ACTIVE 62K (65.4…)
Demand
55K (57.42%)
Saving
110K (38.21%)
TD
160K (55.81%)
Power BI Desktop
286.78K
95.23K
1.57K
5.36K
Total Deposit
Total Customers
Priority Customers
Priority Deposit
PKR In Millions
Priority
City Name
Select all
Lahore
Priority
CDRs
Demand
%GT Total Deposit
Total Customers
%GT Total Customers
172795
60.25%
42606
44.74%
Gujranwala
91588
31.94%
17382
18.25%
Faisalabad
20055
6.99%
24095
25.30%
2343
0.82%
11144
11.70%
286781
100.00%
95227
100.00%
Sialkot
Account Type
Select all
Total Deposit
Total
Total Customers by ACCOUNT_TYPE
Total Deposit by ACCOUNT_TYPE
Demand 17K (5.84%)
CDRs 5K (5.76%)
Saving
34K (35.…)
Saving
TD
Demand
55K (57.42%)
Saving
110K (38.2…)
TD
160K (55.81%)
Power BI Desktop
286.78K
95.23K
1.57K
5.36K
Total Deposit
Total Customers
Priority Customers
Priority Deposit
PKR In Millions
Sector Name
Segment
Punjab Government
%GT Total
Deposit
Total
Customers
%GT Total
Customers
152366
53.13%
6295
6.61%
NFPSE's
90588
31.59%
421
0.44%
Private Sector
41110
14.33%
87395
91.78%
1393
0.49%
61
0.06%
Federal Government
736
0.26%
44
0.05%
Foreign Constituents
466
0.16%
933
0.98%
NBFI's
122
0.04%
75
0.08%
Blochistan Government
0
0.00%
1
0.00%
KPK Government
0
0.00%
1
0.00%
PSDD
Sindh Government
0
0.00%
1
0.00%
Private
Total
286781
100.00%
95227
100.00%
Select all
Private
PSDD
Scheduled Banks
Total Deposit by Deposit Section
43K
(15.03%)
Remarks
244K
(84.97%)
Total Deposit
Power BI Desktop
95.23K
1.57K
5.36K
Total Deposit
Total Customers
Priority Customers
Priority Deposit
BRANCH
Segment
Select all
Private
PSDD
CURRE
NCY
286.78K
Actual
Currency
Deposit In
PKR
CDRs Demand Saving TD
Total
2
22
8176
18776
100491
127465
3
11
721
5512
1902
8146
4
16
888
3098
2086
6088
5
16
203
5377
7429
13025
6
48
906
5059
12058
18071
7
179
257
3389
5000
8825
8
5
3147
58508
21103
82763
9
52
788
4286
8549
13675
10
17
1027
2610
815
4469
USD
8
1976
GBP
1
203
11
27
302
1571
11
1911
EUR
0
95
12
27
332
1386
598
2343
Total
9
2274
420
16747
109572
160042
286781
Total
PKR In Millions
Term Deposit by Term
Three Months
22K (13.61%)
Six Months
18K (11.0…)
5 Y… 2K (…)
2 Years
0K (0%)
1 Year Six Months
13K (8.22%)
1 Year 101K (62.81%)
GENDER
Male
Female
Total
Total Deposit
Total Customers
10292
61212
2991
19264
13283
80476