📈 Total Customers 
📈 Active Customers 
📈 Active Accounts 
📈 Total Deposits 
📈 Total Withdrawals 
📈 Net Transaction Value 
📈 Average Transaction Value 
📈 Transaction Volume 
📈 Customer Average Balance 
📈 Total Deposits by Branch 
📈 Branch-wise Transaction Volume 
📈 Customer Segment Analysis 
📈 Premium Customer Contribution 
📈 High-Value Customers 
📈 Monthly Transaction Growth 
📈 Account Growth 
📈 Loan Portfolio Value 
📈 Average Loan Amount 
📈 Loan Distribution by Type 
📈 Active vs Closed Loans 
📈 Customer Loan Exposure 
📈 Deposit-to-Withdrawal Ratio 
📈 Transaction Success Rate 
📈 Dormant Account Analysis 
📈 Unusual Transaction Detection 
📈 Customer Profitability 
📈 Executive Banking Dashboard 

💡 Example 1: Total Deposits 
SELECT SUM(amount) AS total_deposits 
FROM transactions 
WHERE transaction_type = 'Deposit' AND transaction_status = 'Success'; 

💡 Example 2: Customer Transaction Summary 
SELECT c.customer_id, c.customer_name, COUNT(t.transaction_id) AS total_transactions, SUM(t.amount) AS total_transaction_value 
FROM customers c 
JOIN accounts a ON c.customer_id = a.customer_id 
JOIN transactions t ON a.account_id = t.account_id 
WHERE t.transaction_status = 'Success' 
GROUP BY c.customer_id, c.customer_name 
ORDER BY total_transaction_value DESC; 

💡 Example 3: Branch-wise Deposits 
SELECT b.branch_name, SUM(t.amount) AS total_deposits 
FROM branches b 
JOIN accounts a ON b.branch_id = a.branch_id 
JOIN transactions t ON a.account_id = t.account_id 
WHERE t.transaction_type = 'Deposit' AND t.transaction_status = 'Success' 
GROUP BY b.branch_name 
ORDER BY total_deposits DESC; 

💡 Example 4: Identify High-Value Customers 
SELECT c.customer_id, c.customer_name, SUM(a.current_balance) AS total_balance 
FROM customers c 
JOIN accounts a ON c.customer_id = a.customer_id 
GROUP BY c.customer_id, c.customer_name 
HAVING SUM(a.current_balance) > 500000 
ORDER BY total_balance DESC; 

💡 Example 5: Monthly Transaction Trend 
SELECT DATE_TRUNC('month', transaction_date) AS month, COUNT(*) AS transaction_count, SUM(amount) AS transaction_value 
FROM transactions 
WHERE transaction_status = 'Success' 
GROUP BY DATE_TRUNC('month', transaction_date) 
ORDER BY month; 

💡 Example 6: Rank Customers by Balance 
SELECT c.customer_name, SUM(a.current_balance) AS total_balance, DENSE_RANK() OVER (ORDER BY SUM(a.current_balance) DESC) AS balance_rank 
FROM customers c 
JOIN accounts a ON c.customer_id = a.customer_id 
GROUP BY c.customer_id, c.customer_name; 

💡 Example 7: Identify Potentially Unusual Transactions 
SELECT account_id, transaction_id, transaction_date, amount 
FROM transactions 
WHERE amount > 100000 AND transaction_status = 'Success' 
ORDER BY amount DESC; 

🎯 Key Insights You Can Derive 

🔹 Which branches generate the highest transaction volume? 
🔹 Which customer segments hold the most deposits? 
🔹 Who are the highest-value customers? 
🔹 Which account types have the highest activity? 
🔹 How are deposits and withdrawals trending? 
🔹 Which customers have significant loan exposure? 
🔹 Which transactions may require additional investigation? 

💼 Double Tap ❤️ For More