← Data
Credit Card Fraud Analysis
A SQL case study finding fraud patterns in 284,807 card transactions.
Data · 2026

Overview
The MySQL import wizard was too slow for a dataset this size, so I loaded it from the command line instead, in under 30 seconds. From there I confirmed the fraud rate (0.19%), found the hours of the day when fraud peaks, and pulled out high-value fraudulent transactions over $1,000. Data: the public Credit Card Fraud Detection dataset on Kaggle.