This project demonstrates SQL skills for data analyst, financial analyst, fraud analyst, and risk analytics roles.
The repository uses a synthetic banking dataset to analyze customer behavior, banking KPIs, fraud indicators, customer segmentation, and transaction activity using SQL and SQLite.
The project simulates a banking environment with:
- customer profiles
- bank accounts
- transaction history
- fraud risk scenarios
- financial KPIs
The analysis focuses on identifying high-risk transactions, customer segments, and valuable customers using SQL queries.
- SQL
- SQLite
- DB Browser for SQLite
- CREATE TABLE
- INSERT INTO
- JOINs
- GROUP BY
- CASE WHEN
- CTEs
- Window Functions
- Ranking Functions
- KPI Calculations
- Fraud Detection Analysis
- Customer Segmentation
Contains customer demographic information, annual income, occupation, and credit score.
Contains account balances, account types, and account opening dates.
Contains transaction history, payment channels, merchants, and locations.
- Which customers generate the highest transaction value?
- Which transactions may indicate fraud risk?
- What customer segments exist based on income and credit score?
- What are the key banking KPIs by account type?
- Which customers should be reviewed for higher financial risk?
Analyzes account balances and account distribution by account type.
Identifies suspicious transactions based on transaction type and transaction amount.
Segments customers into financial and risk categories.
Calculates running transaction totals for customer activity monitoring.
Ranks customers by total transaction value.
Identifies high-value customers using Common Table Expressions (CTEs).
sql-data-analysis-portfolio/
│
├── README.md
├── finance_risk_portfolio.db
├── sql/
│ └── banking_analysis.sql
│
└── screenshots/
├── create_tables.png
├── fraud_detection.png
├── kpi_analysis.png
├── customer_segmentation.png
├── customer_transaction_ranking.png
├── cte_analysis.png
└── window_function_analysis.png
Agata Gabara
Data Analytics | SQL | Finance | Risk Analytics | Cybersecurity