Banking Data Analysis Project
Description:
This project contains SQL queries for analyzing banking customer data. It focuses on customer segmentation, loan analysis, credit utilization, and account type distribution.
Code
The main SQL file banking_analysis.sql contains the following analyses:
Customer Segmentation by Account Balance
Customer Segmentation by Credit Score
Loan Value Ratio Analysis
Top 10 Customers With The Highest Loan Amount
Analyzing Credit Limit Utilization
The Most Popular Account Types And Loan Products
Skills Demonstrated: SQL querying, Data aggregation, Case statements, Sorting and limiting results, Calculating percentages and ratios, Rounding functions, Data segmentation and categorization
Technology:
PostgreSQL