{"repo":"franklinanalytics/Bank-Segmentation-Analysis","free":true,"listed":false,"github":"https://github.com/franklinanalytics/Bank-Segmentation-Analysis","clone":"git clone https://github.com/franklinanalytics/Bank-Segmentation-Analysis.git","description":"A simulated SQL-based financial analytics project focused on customer segmentation, transaction behaviour, and regional performance within a Nigerian banking context.","language":null,"stars":29,"topics":["customer-segmentation","data-analysis","data-analytics","data-analytics-project","financial-analysis","postgresql","sql","sql-project"],"license":null,"category":"databases-storage","readme_excerpt":"🏦 Bank Segmentation Analysis (SQL Project) This project simulates a real-world banking dataset and performs a series of SQL queries to extract valuable insights about customers, transactions, and geographic activity. It showcases my skills in SQL for data analysis, with a focus on financial data and customer segmentation. --- Project Objective To analyze simulated banking data and uncover key insights that can help drive strategic decisions such as: - Identifying high-value customers - Understanding transaction behaviors - Measuring regional banking performance - Detecting dormant and underutilized accounts --- 🛠️ Tools & Technologies - PostgreSQL (via pgAdmin) - SQL (CTEs, Joins, Aggregations, Window Functions) - Data Simulation using PostgreSQL functions --- Project Structure Phase Description ------- ------------- 1. Data Modeling & Simulation Created 3 core tables: customers , accounts , transactions using realistic Nigerian names, cities, account structures, and activity patterns. 2. Data Querying Wrote 12 key SQL queries to extract insights and segment customer/account behavior. 3. Reporting Documented insights with purpose-driven explanations for each query. --- 📊 Key SQL Queries & Purposes No. Query Title Purpose ----- ------------- --------- 1 Total Spend per Customer Calculate total amount spent per customer across all accounts. 2 Salary Trend Analysis Identify salary credit trends across months. 3 Most Active Accounts (Count) Find accounts with the highest numbe","default_branch":null,"files":null,"tree":[],"storefront":"/r/franklinanalytics","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/franklinanalytics/Bank-Segmentation-Analysis/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}