Skip to content

DevCarvalhal/chargeback-risk-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 

Repository files navigation

# Chargeback Risk Analysis

## Objective

Analyze customer transaction behavior to identify high-risk profiles based on chargeback rate and financial impact.

## Context

This project simulates a real-world fraud prevention scenario, focusing on chargeback monitoring, customer risk segmentation and loss analysis.

## Technologies

- SQL

- Python

## Analysis Performed

- Chargeback rate calculation per customer

- Identification of high-risk customer profiles

- Financial loss estimation

- Risk-based segmentation

## Key Insights

- Customers with higher transaction frequency may present higher chargeback exposure

- Chargeback concentration can indicate risky behavior patterns

- Monitoring customer risk helps prioritize preventive actions

## Project Structure

- sql/analysis.sql → main analytical queries

- insights/conclusions.md → business insights and findings

## Next Steps

- Add Python analysis layer

- Create dashboard for chargeback monitoring

- Expand rules for fraud-risk prioritization

About

Chargeback risk analysis project using SQL and Python to identify high-risk customers, estimate financial losses and support fraud prevention.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors