Banking Analysis Dashboard
Originally published: 25/10/2021 12:57
Last version published: 26/10/2021 07:58
Publication number: ELQ-99115-2
View all versions & Certificate

Banking Analysis Dashboard

Banking Analysis Dashboard using Excel and pbix

This is Banking Analysis Dashboard..
In this report, we have the following 4 pages.
1. Home
2.Loan Analysis
3. Deposit Analysis
4. Summary
5. Drill Through


In this report, I have created the following KPIs.
1.Total Clients
2.Total Loan
3.Bank Loan
4.Business Lending
5.Total Deposit
6.Top Fees
7.Bank Deposit
8.Checking Account Amount
9.Total Credit Card Amount
10.Saving Account Amount
11.Foreign Currency Amount
12.Engagement Amount.
Added following Time Intelligence functions by using Calculation groups.
1.All Time
2.Last 30 Days
3.Last 90 Days
4.Last 3 Months
5.Last 6 Months
6.Last 12 Months
7.Last 24 Months
8.Current Month
9.Current Quarter
10.Current Year.
In which you will see i have also added Drill through feature by using this feature you will see detail data against all Kpi's.

Modification if Needed :

If you want any modification in background images or visualization, you can connect with me through Eloquens.

Deliverable :
I will provide you Excel dataset file and a power bi file in which all KPIs and visualization are present.

You can use this Dashboard for real time Projects.
if you want to create any other domain reports then you can also let me know.
God Bless you.

This Best Practice includes
Excel data set file. Background images, pbix file.

Acquire business license for $20.00

Add to cart

Add to bookmarks


Further information

You can use this report for learning purposes or entering into a competition or commercial use. Also for real time Projects.

0.0 / 5 (0 votes)

please wait...