Data-Analysis-Portfolio

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:

  1. Customer Segmentation by Account Balance

  2. Customer Segmentation by Credit Score

  3. Loan Value Ratio Analysis

  4. Top 10 Customers With The Highest Loan Amount

  5. Analyzing Credit Limit Utilization

  6. 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