The Banking Analysis Power BI Dashboard is a comprehensive tool designed to provide insights into various banking metrics. This dashboard is developed using four primary tables and several DAX queries to deliver a detailed analysis of banking relationships, client demographics, and financial metrics.
- Banking Relationship
This table captures the core relationship between clients and their banking services.
- Columns
- BRID: Banking Relationship ID
- Banking Relationship: Type of banking relationship
- Clients - Banking
This table holds detailed information about clients and their banking contracts.
- Columns
- Banking Contracts: Information on banking contracts
- BRID: Banking Relationship ID (Foreign Key)
- ClientID: Unique Identifier for clients
- Fee Structure: Fee structure associated with the banking services
- GenderID: Gender Identifier (Foreign Key)
- IAID: Investment Advisor ID (Foreign Key)
- Name: Client's name
- Nationality: Client's nationality
- Occupation: Client's occupation
- Gender
This table provides the gender details of clients.
- Columns
- GenderID: Unique Identifier for gender
- Gender: Gender Description
- Gender
This table contains information about investment advisors.
- Columns
- IAID: Unique Identifier for investment advisors
- Investment Advisor: Name of the investment advisor
The dashboard includes several important metrics calculated using DAX queries to provide comprehensive insights:
Saving Account Amount
SavingAccountAmount = SUM('Clients - Banking'[Savings Accounts])
Total Credit Card Amount
TotalCCAmount = SUM('Clients - Banking'[Credit Card Balance])
Total Deposit
TotalDeposit = SUM('Clients - Banking'[Bank Deposits])
Total Loan
TotalLoan = SUM('Clients - Banking'[Bank Loans])
The following DAX queries calculate the summation of various financial accounts:
- Credit Cards
TotalCreditCards = SUM('Clients - Banking'[Credit Card Balance])
- Bank Deposits
TotalBankDeposits = SUM('Clients - Banking'[Bank Deposits])
- Bank Loans
TotalBankLoans = SUM('Clients - Banking'[Bank Loans])
- Business Lending
TotalBusinessLending = SUM('Clients - Banking'[Business Lending])
- Checking Accounts
TotalCheckingAccounts = SUM('Clients - Banking'[Checking Accounts])
- Credit Card Balance
TotalCreditCardBalance = SUM('Clients - Banking'[Credit Card Balance])
- Estimated Income
TotalEstimatedIncome = SUM('Clients - Banking'[Estimated Income])
- Foreign Currency Account
TotalForeignCurrencyAccount = SUM('Clients - Banking'[Foreign Currency Account])
- Savings Accounts
TotalSavingsAccounts = SUM('Clients - Banking'[Savings Accounts])
- Superannuation Savings
TotalSuperannuationSavings = SUM('Clients - Banking'[Superannuation Savings])
The dashboard provides an intuitive interface to explore and analyze banking data. Users can filter data based on various parameters such as client demographics, banking relationships, and financial metrics. The visualizations include charts, graphs, and tables to offer a clear and concise representation of the data.
The Banking Analysis Power BI Dashboard is a powerful tool for financial analysis and decision-making. By leveraging data from multiple sources and using DAX queries to calculate key metrics, it provides valuable insights into banking relationships, client demographics, and financial performance.