Abeokuta, Ogun State, Nigeria
Summary
Led a data analysis project to identify fraudulent patterns in credit card transactions, leveraging SQL and Power BI for comprehensive insights and visualization.
Highlights
Analyzed 19,643 credit card transactions using MySQL to detect fraudulent patterns based on transaction amount and time of day, enhancing risk identification.
Identified that high-value transactions (above $500) exhibited a fraud rate 3x higher than low-value transactions, utilizing SQL CASE statements and GROUP BY aggregations to pinpoint critical risk factors.
Built an interactive Power BI dashboard to visualize fraud distribution by amount bucket and time of day, providing stakeholders with clear, actionable insights for mitigation strategies.